| |
The time now is Thu Sep 09, 2010 12:03 pm |
 Posted: Tue Jul 28, 2009 7:19 pm Post subject: [solved] Unable to approve posts - 'General Error' message |
 |
 |
 |
|
sgraber
Joined: 28 Jul 2009
Posts: 3
|
Hi, I'm using phpbb2antispam Database v1.3.1/File Version 1.3.1 on PHPBB2 v2.0.21 and I really love the way it has reduced the number of spam postings to exactly ZERO from the dozens and hundreds of spams before I installed it. Thank you very much!
I do have a problem where a real user (not spam) is making the first post and antispam tags their message as spam. When I try to approve their post I get the following error message.
| Quote: | General Error
Error in posting
DEBUG MODE
INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES (1931, 14, 973, 'beyondredline', 1248792073, '66.152.58.11', 1, 0, 1, )
Line : 134
File : functions_insert_post.php
|
When I return to spam management screen I see
| Quote: | Notice: a previous attempt to load this page failed. Running in limited/recovery mode
Switch to normal mode |
I'm sorry that I do not know much about MySql or the structure of the phpbb2 tables. It appears that maybe the INSERT is missing a value for enable_sig but I don't know why this is happening.
_________________
Steve Graber
www.grabercars.com
Build a lightweight mid-engine sports car from plans! |
|
|
| Posted: Tue Jul 28, 2009 7:21 pm Post subject: |
|
|
|
|
|
|
|
| Posted: Wed Jul 29, 2009 9:43 pm Post subject: |
|
|
|
|
ramon fincken
Site Admin
Joined: 11 Dec 2006
Posts: 274
Location: A'dam/Diemen, The Netherlands
|
Hmm interesting ... my syntax looks allright ...
could you try this?
OPEN
| Code: | | /admin/admin_antispam_database.php |
FIND
# line 155
| Code: | // GOGOGO !
if ($tmparray['mode'] === 'newtopic') {
$post_details = insert_post($tmparray['message'], $tmparray['subject'], $tmparray[POST_FORUM_URL], $user_id, $profiledata['username'], $profiledata['user_attachsig']);
}
// GOGOGO !
if ($tmparray['mode'] === 'reply') {
// Reply, normal
$post_details = insert_post($tmparray['message'], $tmparray['subject'], topic2forum($tmparray[POST_TOPIC_URL]), $user_id, $profiledata['username'], $profiledata['user_attachsig'], $tmparray[POST_TOPIC_URL], POST_NORMAL, true);
} |
REPLACE WITH
| Code: | // GOGOGO !
if ($tmparray['mode'] === 'newtopic') {
$post_details = insert_post($tmparray['message'], $tmparray['subject'], $tmparray[POST_FORUM_URL], $user_id, $profiledata['username'], intval($profiledata['user_attachsig']));
}
// GOGOGO !
if ($tmparray['mode'] === 'reply') {
// Reply, normal
$post_details = insert_post($tmparray['message'], $tmparray['subject'], topic2forum($tmparray[POST_TOPIC_URL]), $user_id, $profiledata['username'], intval($profiledata['user_attachsig']), $tmparray[POST_TOPIC_URL], POST_NORMAL, true);
}
|
_________________
Phpbbantispam founder, available for freelance phpBB2 coding.
Get it while it's hot ! http://www.phpbbantispam.com/viewtopic.php?t=1
Project files & mailinglist: https://sourceforge.net/projects/phpbbantispam/ |
|
|
| Posted: Thu Jul 30, 2009 12:03 am Post subject: |
|
|
|
|
sgraber
Joined: 28 Jul 2009
Posts: 3
|
That did the trick! Thank you very much. I have to say again, your mod is the best thing for phpbb2! It really works, it was easy to install, and you have given me top quality support.
Steve Graber
www.grabercars.com
_________________
Steve Graber
www.grabercars.com
Build a lightweight mid-engine sports car from plans! |
|
|
| Posted: Thu Jul 30, 2009 7:29 pm Post subject: |
|
|
|
|
|
|
|
 
|
All times are GMT + 1 Hour
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in 
