[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

comeonthen
Registered User
Posts: 11
Joined: Sat Jan 07, 2006 8:52 pm
Contact:

Post by comeonthen »

also, is the MOD supposed to log post edits? because it doesn't work :oops:
Madis
Registered User
Posts: 1
Joined: Mon Jan 16, 2006 11:05 am

Post by Madis »

Can't delete the log:
Could not delete Logs

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,' at line 3

DELETE FROM phpbb_logs WHERE id_log IN (, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , )

Line : 471
File : admin_logs.php
User avatar
ZombieSlayer
Registered User
Posts: 951
Joined: Sun May 02, 2004 3:18 am
Location: California
Contact:

Post by ZombieSlayer »

I had to reinstall this mod when I installed full version .19.

I keep getting this error
You have not yet delete the file install_tables.php : do it before trying to see this page.


I did delete it. It is not on my server anywhere.
balkanst
Registered User
Posts: 33
Joined: Fri Sep 19, 2003 2:15 pm

HELP

Post by balkanst »

I'have installed the MOD but it doesn't work.

Nothing is happening at admin panel.

My phpBB version is 2.17

Image
woode
Registered User
Posts: 3
Joined: Sun Jan 08, 2006 4:09 am

Worked perfectly after manually running SQL statements

Post by woode »

Installed this MOD on phpBB 2.0.19 with EasyMOD. Couldn't get log_actions_db_update.php to run, so executed SQL statements posted here.

Works perfectly for me now!

Just wanted to give a little positive feedback.
funfair97
Registered User
Posts: 44
Joined: Sun Oct 27, 2002 10:35 pm

Post by funfair97 »

Hi

I get an error when running the log_actions_db_update.php file-

Warning: mysql_connect(): Access denied for user: 'newfair_phpbb1@localhost' (Using password: NO) in /home/newfair/public_html/forum/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/newfair/public_html/forum/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/newfair/public_html/forum/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

Any suggestions please?????

Cheers
balkanst
Registered User
Posts: 33
Joined: Fri Sep 19, 2003 2:15 pm

Post by balkanst »

funfair97 wrote: Hi

I get an error when running the log_actions_db_update.php file-

Warning: mysql_connect(): Access denied for user: 'newfair_phpbb1@localhost' (Using password: NO) in /home/newfair/public_html/forum/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/newfair/public_html/forum/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/newfair/public_html/forum/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

Any suggestions please?????

Cheers


I had the same problem when I upgraded to 2.19.

Here is what you do, go to phpmyadmin, find the database for your forum, click on SQL and run this code.

Code: Select all

CREATE TABLE phpbb_logs ( 
        log_id mediumint(10) NOT NULL auto_increment, 
        mode VARCHAR(50) DEFAULT '', 
        topic_id mediumint(10) DEFAULT '0', 
        user_id mediumint(8) DEFAULT '0', 
        username VARCHAR(25) DEFAULT NULL, 
        user_ip VARCHAR(8) NOT NULL DEFAULT '0', 
        time int(11) DEFAULT '0', 
        post_title VARCHAR(60) NOT NULL DEFAULT '', 
        bbcode_uid VARCHAR(10) NOT NULL DEFAULT '', 
        post_text text, 
            PRIMARY KEY (log_id)); 

         CREATE TABLE phpbb_logs_config ( 
            config_name VARCHAR(255) NOT NULL, 
            config_value VARCHAR(255) NOT NULL, 
            PRIMARY KEY (config_name)); 

         INSERT INTO phpbb_logs_config ( 
            config_name, config_value) 
            VALUES ('all_admin', 0); 

         ALTER TABLE phpbb_users 
            ADD user_view_log TINYINT NOT NULL DEFAULT '0';
Make sure you delete the log_actions_db_update.php because you manually did it.

good luck
Robert_Nit
Registered User
Posts: 16
Joined: Tue Jan 17, 2006 1:09 pm

Post by Robert_Nit »

I have done all what I should, uploaded the files, installed them with easymod, deleted log_actions_db_update.php and ran the sql manually. But still I have some problems and I think that the reason why I have these problems is = I have Save Posts As Drafts installed. When I post a normal topic there is no problems, but when I have a draft and I post it then the problems begins. I hope someone here can help me out.

Post draft without Attachment:

Code: Select all

Warning: Missing argument 14 for prepare_post() in /usr/home/dan10842/public_html/forumdk/includes/functions_post.php on line 124

Warning: Missing argument 21 for submit_post() in /usr/home/dan10842/public_html/forumdk/includes/functions_post.php on line 221

Warning: Missing argument 22 for submit_post() in /usr/home/dan10842/public_html/forumdk/includes/functions_post.php on line 221

Warning: Missing argument 23 for submit_post() in /usr/home/dan10842/public_html/forumdk/includes/functions_post.php on line 221

Warning: Missing argument 24 for submit_post() in /usr/home/dan10842/public_html/forumdk/includes/functions_post.php on line 221

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/dan10842/public_html/forumdk/includes/functions_post.php:124) in /usr/home/dan10842/public_html/forumdk/includes/page_header.php on line 506

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/dan10842/public_html/forumdk/includes/functions_post.php:124) in /usr/home/dan10842/public_html/forumdk/includes/page_header.php on line 508

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/dan10842/public_html/forumdk/includes/functions_post.php:124) in /usr/home/dan10842/public_html/forumdk/includes/page_header.php on line 509
Post draft with Attachment:

Code: Select all

Warning: Missing argument 14 for prepare_post() in /usr/home/dan10842/public_html/forumdk/includes/functions_post.php on line 124

Warning: Missing argument 21 for submit_post() in /usr/home/dan10842/public_html/forumdk/includes/functions_post.php on line 221

Warning: Missing argument 22 for submit_post() in /usr/home/dan10842/public_html/forumdk/includes/functions_post.php on line 221

Warning: Missing argument 23 for submit_post() in /usr/home/dan10842/public_html/forumdk/includes/functions_post.php on line 221

Warning: Missing argument 24 for submit_post() in /usr/home/dan10842/public_html/forumdk/includes/functions_post.php on line 221

Fatal error: Cannot redeclare clean_words() (previously declared in /usr/home/dan10842/public_html/forumdk/includes/functions_search.php:22) in /usr/home/dan10842/public_html/forumdk/includes/functions_search.php on line 22
I am not sure....but I think that the problem is that log actions mod don't know the "draft" rule or something like that.
sbbama
Registered User
Posts: 4
Joined: Fri Jan 20, 2006 6:56 am

Post by sbbama »

Ok, got it installed with no problem, or atleast I thought. I can see the Logs section and click on it and see the main Logs Action but no data is being logged. any Idea?

CLICK TO ENLARGE

Image
tvq
Registered User
Posts: 1
Joined: Fri Jan 20, 2006 9:21 am
Contact:

Post by tvq »

help

I added the mod and the forum is ok

but when i went to the admin panel, nothing appear and it says :
Warning: Cannot modify header information - headers already sent by (output started at /usr301/home/n/e/netmark/public_html/forumtp/language/lang_english/lang_admin.php:1) in /usr301/home/n/e/netmark/public_html/forumtp/includes/functions.php on line 764

my forum is at : http://netmark.addr.com/forumtp

thank you
paul-collins
Registered User
Posts: 38
Joined: Tue Mar 01, 2005 2:17 pm

Post by paul-collins »

balkanst wrote:
funfair97 wrote:Hi

I get an error when running the log_actions_db_update.php file-

Warning: mysql_connect(): Access denied for user: 'newfair_phpbb1@localhost' (Using password: NO) in /home/newfair/public_html/forum/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/newfair/public_html/forum/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/newfair/public_html/forum/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

Any suggestions please?????

Cheers


I had the same problem when I upgraded to 2.19.

Here is what you do, go to phpmyadmin, find the database for your forum, click on SQL and run this code.

Code: Select all

CREATE TABLE phpbb_logs ( 
        log_id mediumint(10) NOT NULL auto_increment, 
        mode VARCHAR(50) DEFAULT '', 
        topic_id mediumint(10) DEFAULT '0', 
        user_id mediumint(8) DEFAULT '0', 
        username VARCHAR(25) DEFAULT NULL, 
        user_ip VARCHAR(8) NOT NULL DEFAULT '0', 
        time int(11) DEFAULT '0', 
        post_title VARCHAR(60) NOT NULL DEFAULT '', 
        bbcode_uid VARCHAR(10) NOT NULL DEFAULT '', 
        post_text text, 
            PRIMARY KEY (log_id)); 

         CREATE TABLE phpbb_logs_config ( 
            config_name VARCHAR(255) NOT NULL, 
            config_value VARCHAR(255) NOT NULL, 
            PRIMARY KEY (config_name)); 

         INSERT INTO phpbb_logs_config ( 
            config_name, config_value) 
            VALUES ('all_admin', 0); 

         ALTER TABLE phpbb_users 
            ADD user_view_log TINYINT NOT NULL DEFAULT '0';
Make sure you delete the log_actions_db_update.php because you manually did it.

good luck

Correct me if I'm wrong, but this could be added directly to the mod, yes?
eno123
Registered User
Posts: 78
Joined: Tue Sep 20, 2005 9:07 pm

Post by eno123 »

Hm, it says 2.0.6 in the topic title and 1.x.x something in the first post. Is this still being updated/maintained? I don't feel like reading 100+ pages of suggested fixes and finding out which ones have made it into the MOD (i.e. finding out that after page 53 I'm on my own adding stuff manually).
Merlin Sythove
Registered User
Posts: 2339
Joined: Tue Mar 16, 2004 7:42 am

Post by Merlin Sythove »

Just checking back, you may consider switching to this upgraded version:

[BETA] MOD Logbook
http://www.phpbb.com/phpBB/viewtopic.php?t=350367
eno123
Registered User
Posts: 78
Joined: Tue Sep 20, 2005 9:07 pm

Post by eno123 »

Well, I do know about your 'upgraded' version, Merlin. :) I've seen ads for it all over this board.

Thing is, I'm not sure which one is safer: An old (unmaintained?) MOD or a beta MOD. :)
Beerice
Registered User
Posts: 10
Joined: Mon Feb 09, 2004 6:44 am

Post by Beerice »

This is the error I get when I try to moderator a forum.


Fatal error: Cannot redeclare log_action() (previously declared in /home/wildcat/public_html/mboard/includes/functions_log.php:28) in /home/wildcat/public_html/mboard/includes/functions_log.php on line 28

Edit: Got it... Somehow got a double call to for the include... All fixed..
Post Reply

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