-

SQL Error (spam log file)with 2.0.8

General phpBB2 Discussion and Support
Forum rules
To receive support you must become a donor unless otherwise specified in the release topic.

Please read these topics for more information:
Web Services/Support/Private Mod Access

SQL Error (spam log file)with 2.0.8

Postby Pstephens » Mon Feb 18, 2008 1:46 pm

I installed Anti-Spam 2.0.8 today and all went well with the installation. I was able to set preferences and the log-in screen looks good. I even tested it with a dummy account and it works like a charm. However, when I am in the Admin console within phpBB, I cannot view the Spam Log. When I click on the link I get this error message:

phpBB : Critical Error

Could not query log information

DEBUG MODE

SQL Error : 1146 Table 'forum_data.spam_log_table' doesn't exist

SELECT * FROM SPAM_LOG_TABLE ORDER BY log_id DESC LIMIT 0, 12

Line : 206
File : admin_anti_spam_acp_log.php

Any idea what happened or how to fix it? I really don't want to have to reload the entire board to fix this (as was suggested by someone I won't mention...)
While this is not critical to the operation of the board, I am not sure if it affects other areas of the Administrative capabilities of the forum, and I surely don't want to find out the hard way...

Thanks in advance for any help you may be able to provide. GREAT Program BTW!
Pstephens
Member
Member
 
Posts: 3
Joined: Mon Feb 18, 2008 1:32 pm
Blog: View Blog (0)

Re: SQL Error (spam log file)with 2.0.8

Postby EXreaction » Mon Feb 18, 2008 2:09 pm

Make sure the edits are in place in the constants.php file.
Grateful for the mods I've built? Then donate!
User avatar
EXreaction
Site Owner
Site Owner
 
Posts: 4988
Joined: Wed Jun 28, 2006 5:08 pm
Blog: View Blog (53)

Re: SQL Error (spam log file)with 2.0.8

Postby Pstephens » Mon Feb 18, 2008 10:02 pm

:?: Huh? That went right over my head... What exactly am I looking for in the .php file?
I am kind of a newb to phpBB and this is the first mod I have attempted to install.
Sorry to sound so stupid. I am trying to learn this as fast as I can.

I am using EasyMod (latest version), btw. Is there a way to completely uninstall and reinstall this Mod? I assume that if I reload from backup I will lose the phpBB update, but then I could install the Anti-Spam Mod from scratch (after doing the phpBB update again of course). Would this be a better idea than having me (a newb) poking around in the config files?
Pstephens
Member
Member
 
Posts: 3
Joined: Mon Feb 18, 2008 1:32 pm
Blog: View Blog (0)

Re: SQL Error (spam log file)with 2.0.8

Postby EXreaction » Tue Feb 19, 2008 5:47 pm

If you have no other mods installed, delete all of the installed mod history for EasyMod.

Then follow these instructions:
http://www.lithiumstudios.org/forum/vie ... f=44&t=255

Then you can re-install the mod.
Grateful for the mods I've built? Then donate!
User avatar
EXreaction
Site Owner
Site Owner
 
Posts: 4988
Joined: Wed Jun 28, 2006 5:08 pm
Blog: View Blog (53)

Re: SQL Error (spam log file)with 2.0.8

Postby Pstephens » Tue Feb 19, 2008 9:06 pm

I'll give it a shot. Thanks.
Pstephens
Member
Member
 
Posts: 3
Joined: Mon Feb 18, 2008 1:32 pm
Blog: View Blog (0)


Return to phpBB2



Who is online

Users browsing this forum: Magpie Crawler and 0 guests