Page 98 of 149

Posted: Wed May 18, 2005 6:51 am
by mstrmitch
will this mod allow me to see which admin/moderator has approved or denied activation to a user?

Mitch

Posted: Wed May 25, 2005 8:09 pm
by happypappy
mod is installed perfectly with ezmod.....but now when i clcik "logs actions" in acp i get this messege

Code: Select all

You have not yet delete the file install_tables.php : do it before trying to see this page.
and when i click "logs config" i get this

Code: Select all

phpBB : Critical Error

Could not query log config informations

DEBUG MODE

SQL Error : 1146 Table 'coastco_phpb1.phpbb_logs_config' doesn't exist

SELECT config_value AS all_admin FROM phpbb_logs_config WHERE config_name = 'all_admin'

Line : 51
File : admin_logs_config.php
please help me out here im a newbie....thanx a bunch!!!!

Posted: Fri May 27, 2005 8:33 pm
by Nexphen

Code: Select all

Running query :: CREATE TABLE phpbb_logs ( id_log MEDIUMINT(10) NOT NULL DEFAULT '' AUTO_INCREMENT, mode VARCHAR(50) NULL DEFAULT '', topic_id MEDIUMINT(10) NULL DEFAULT '0', user_id MEDIUMINT(8) NULL DEFAULT '0', username VARCHAR(255) NULL DEFAULT '', user_ip CHAR(8) DEFAULT '0' NOT NULL, time INT(11) NULL DEFAULT '0', PRIMARY KEY (id_log)) -> ERROR - QUERY FAILED ----> Valeur par défaut invalide pour 'id_log'
I get that... i've read that:
morpheus2matrix wrote: Remove the default value of id_log in the installer
but what do i do?

Is it here?

Code: Select all

	$sql[] = "CREATE TABLE " . LOGS_TABLE . " (
				id_log MEDIUMINT(10) NOT NULL DEFAULT '0' AUTO_INCREMENT,
				mode VARCHAR(50) NULL DEFAULT '', 
				topic_id MEDIUMINT(10) NULL DEFAULT '0',
				user_id MEDIUMINT(8) NULL DEFAULT '0',
				username VARCHAR(255) NULL DEFAULT '',
				user_ip CHAR(8) DEFAULT '0' NOT NULL,
				time INT(11) NULL DEFAULT '0',
				PRIMARY KEY (id_log))";
?

Thanx for the replies :D

Posted: Sat May 28, 2005 8:39 pm
by shasd
i dont have a program that will support the .php files can someone tell me a program that supports these?

Posted: Mon May 30, 2005 11:12 pm
by Hercanic
Dear shasd:
i dont have a program that will support the .php files can someone tell me a program that supports these?

You can open a *.php file with Notepad and Wordpad. To actually see the result, you need a server to put the various PHP files together and process them into an HTML document.

Posted: Wed Jun 01, 2005 6:10 pm
by MrDSL
This would be an excellent mod if it actually worked and was being supported. I have some of the same errors posted above on a fresh 2.0.15 install.

Does anyone know of a mod like this that actually works and is still supported?

Posted: Thu Jun 02, 2005 1:47 pm
by Froggo
Hey!

I have installed this mod to. And i got some errors. But i dont understand much of it, i am not long using this forum.
I have also red most of this posts but i couldnt find a answer to it.

This are the errors:

In the Administration Panel:

Logs Actions:
You have not yet delete the file install_tables.php : do it before trying to see this page

But i cant find a file with that name :?

Logs Config:
phpBB : Critical Error

Could not query log config informations

DEBUG MODE

SQL Error : 1146 Table 'workshop.phpbb_logs_config' doesn't exist

SELECT config_value AS all_admin FROM phpbb_logs_config WHERE config_name = 'all_admin'

Line : 51
File : admin_logs_config.php


On the forum:
When editing:
Could not insert data into logs table

DEBUG MODE

SQL Error : 1146 Table 'workshop.phpbb_logs' doesn't exist

INSERT INTO phpbb_logs (mode, topic_id, user_id, username, user_ip, time) VALUES ('edit', '199', '2', 'Froggo', '54195778', '1117719995')

Line : 52
File : functions_log.php


I hope someone can help me plz

Ty in advance

Froggo

Posted: Fri Jun 03, 2005 2:20 pm
by mushy
I have installed merge mod by prithik. Can we make this mod workable for that mod too... I mean when some mod merge some topic then can we see such logs too... This will be an excelent addon...Also have an option to log actions if we have added ModCP Merge Hack by Sko22

Posted: Sun Jun 05, 2005 8:00 am
by Mr.Lupo
This mod doesn't work on 2.0.15 and there is no support?

mushy, yeah, really it will be useful.

Posted: Sun Jun 05, 2005 8:10 am
by TMB
The MOD does work with 2.0.15.

Posted: Sun Jun 05, 2005 8:49 am
by Mr.Lupo
MrDSL wrote: This would be an excellent mod if it actually worked and was being supported. I have some of the same errors posted above on a fresh 2.0.15 install.

Does anyone know of a mod like this that actually works and is still supported?
TMB wrote: The MOD does work with 2.0.15.

So... who is right?

Posted: Mon Jun 06, 2005 12:01 pm
by drpoodle
This mod does work with 2.0.15. I have it on my forum and it works well, apart from the fact that it only shows 1 page of logs, and not them all!

BTW, this mod is very fiddly to put on!

Posted: Mon Jun 06, 2005 6:28 pm
by v0xx
Hey folks..

I'm also experiencing the same problem as a few others on this page..

Code: Select all

phpBB : Critical Error

Could not query log config informations

DEBUG MODE

SQL Error : 1146 Table 'sirinus_phpb1.phpbb_logs_config' doesn't exist

SELECT config_value AS all_admin FROM phpbb_logs_config WHERE config_name = 'all_admin'

Line : 51
File : admin_logs_config.php
This error is fairly self explanatory, and I tried my hand at manually imputting the table, but I don't have all the information required. Can anyone advise a fix?

log_actions_db_update.php would be the obvious fix - but it instead throws out a bunch of errors :/

many thanks,
v0xx

Posted: Tue Jun 07, 2005 4:46 pm
by MTO
Exactly the same problem here...
Also phpBB 2.0.15, no mods, this was the first one I was installing.
The table it is looking for does not exist. I guess there is missing a sql query with the create table info, but it's not in the package.

Posted: Tue Jun 07, 2005 6:41 pm
by chatasos
These are my tables, which are working fine in 2.0.15...

Code: Select all

-- 
-- Table structure for table `phpbb_logs`
-- 

CREATE TABLE `phpbb_logs` (
  `id_log` mediumint(10) NOT NULL auto_increment,
  `mode` varchar(50) default '',
  `topic_id` mediumint(10) default '0',
  `user_id` mediumint(8) default '0',
  `username` varchar(255) default '',
  `user_ip` varchar(8) NOT NULL default '0',
  `time` int(11) default '0',
  PRIMARY KEY  (`id_log`)
) TYPE=MyISAM ;

-- 
-- Table structure for table `phpbb_logs_config`
-- 

CREATE TABLE `phpbb_logs_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `phpbb_logs_config`
-- 

INSERT INTO `phpbb_logs_config` VALUES ('all_admin', '0');