[2.0.6] Log Actions MOD

[mstrmitch]

will this mod allow me to see which admin/moderator has approved or denied activation to a user?

Mitch

[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!!!!

[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:

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

[shasd]

i dont have a program that will support the .php files can someone tell me a program that supports these?

[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.

[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?

[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

[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

[Mr.Lupo]

This mod doesn't work on 2.0.15 and there is no support?

mushy, yeah, really it will be useful.

[TMB]

The MOD does work with 2.0.15.

[Mr.Lupo]

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?

The MOD does work with 2.0.15.

So... who is right?

[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!

[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

[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.

[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');