[2.0.6] Log Actions MOD

The cleanup is complete. This forum is now read only.

Rating:

Excellent!
128
50%
Very Good
47
18%
Good
35
14%
Fair
9
3%
Poor
39
15%
 
Total votes: 258

mstrmitch
Registered User
Posts: 31
Joined: Tue Sep 03, 2002 6:19 am
Location: phoenix, az
Contact:

Post by mstrmitch » Wed May 18, 2005 6:51 am

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

Mitch
I would rather die on My feet than live on My knees

happypappy
Registered User
Posts: 463
Joined: Wed Apr 27, 2005 1:44 am

Post by happypappy » Wed May 25, 2005 8:09 pm

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
Registered User
Posts: 1
Joined: Fri May 27, 2005 8:29 pm

Post by Nexphen » Fri May 27, 2005 8:33 pm

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

shasd
Registered User
Posts: 1
Joined: Sat May 28, 2005 8:36 pm

Post by shasd » Sat May 28, 2005 8:39 pm

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

Hercanic
Registered User
Posts: 40
Joined: Wed Jun 26, 2002 7:15 pm

Post by Hercanic » Mon May 30, 2005 11:12 pm

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
Registered User
Posts: 283
Joined: Thu Jul 15, 2004 1:52 am
Contact:

Post by MrDSL » Wed Jun 01, 2005 6:10 pm

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
Registered User
Posts: 9
Joined: Thu Jun 02, 2005 1:40 pm

Post by Froggo » Thu Jun 02, 2005 1:47 pm

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
Registered User
Posts: 305
Joined: Sat Feb 15, 2003 1:07 am
Location: NJ, USA
Contact:

Post by mushy » Fri Jun 03, 2005 2:20 pm

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
Registered User
Posts: 25
Joined: Wed Sep 01, 2004 3:09 pm

Post by Mr.Lupo » Sun Jun 05, 2005 8:00 am

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

mushy, yeah, really it will be useful.
Last edited by Mr.Lupo on Sun Jun 05, 2005 8:50 am, edited 1 time in total.

TMB
Registered User
Posts: 474
Joined: Sat Sep 18, 2004 8:07 am

Post by TMB » Sun Jun 05, 2005 8:10 am

The MOD does work with 2.0.15.

Mr.Lupo
Registered User
Posts: 25
Joined: Wed Sep 01, 2004 3:09 pm

Post by Mr.Lupo » Sun Jun 05, 2005 8:49 am

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?

drpoodle
Registered User
Posts: 18
Joined: Mon May 16, 2005 11:05 am

Post by drpoodle » Mon Jun 06, 2005 12:01 pm

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
Registered User
Posts: 1
Joined: Wed Jun 01, 2005 11:57 pm
Location: England
Contact:

Post by v0xx » Mon Jun 06, 2005 6:28 pm

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
Registered User
Posts: 45
Joined: Fri Nov 07, 2003 2:48 am

Post by MTO » Tue Jun 07, 2005 4:46 pm

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
Registered User
Posts: 748
Joined: Wed May 15, 2002 1:16 pm
Location: Paralia

Post by chatasos » Tue Jun 07, 2005 6:41 pm

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

Post Reply

Return to “[2.0.x] MOD Database Cleanup”