Akismet Spam Protection

[bigfish589]

Hmhmmh

Database Error
Column count doesn't match value count at row 1
File: /home/www/*****.********.com/forum/Sources/Subs-Post.php
Line: 1604

Help pl0px

[Daniel15]

Could you please attach your Subs-Post.php file here?

[mrselnombre]

I've uninstalled it, so do you still want my subs-post.php

i can't leave it installed as it will stop people posting

[Daniel15]

A small issue crept into the install.xml file for version 1.1.1 of this mod, which was what was causing the error. Upgrades from 1.1 to 1.1.1 are not affected by this issue.

To fix this issue, open Subs-Post.php, and find the code around the line that's causing the error. It will look a bit like:

Code Select Expand


// Insert a new topic (if the topicID was left empty.
if ($new_topic)
{
db_query("
INSERT INTO {$db_prefix}topics
(ID_BOARD, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_FIRST_MSG, ID_LAST_MSG, spam, locked, isSticky, numViews, ID_POLL)
VALUES ($topicOptions[board], $posterOptions[id], $posterOptions[id], " . ($spam == true ? '1' : '0') . ",
" . ($topicOptions['lock_mode'] === null ? '0' : $topicOptions['lock_mode']) . ', ' .
($topicOptions['sticky_mode'] === null ? '0' : $topicOptions['sticky_mode']) . ", 0, " . ($topicOptions['poll'] === null ? '0' : $topicOptions['poll']) . ')', __FILE__, __LINE__);
$topicOptions['id'] = db_insert_id();


Replace that code with:

Code Select Expand


// Insert a new topic (if the topicID was left empty.
if ($new_topic)
{
db_query("
INSERT INTO {$db_prefix}topics
(ID_BOARD, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_FIRST_MSG, ID_LAST_MSG, spam, locked, isSticky, numViews, ID_POLL)
VALUES ($topicOptions[board], $posterOptions[id], $posterOptions[id], $msgOptions[id], $msgOptions[id], " . ($spam == true ? '1' : '0') . ",
" . ($topicOptions['lock_mode'] === null ? '0' : $topicOptions['lock_mode']) . ', ' .
($topicOptions['sticky_mode'] === null ? '0' : $topicOptions['sticky_mode']) . ", 0, " . ($topicOptions['poll'] === null ? '0' : $topicOptions['poll']) . ')', __FILE__, __LINE__);
$topicOptions['id'] = db_insert_id();

I'll be uploading a fixed package as soon as possible (the mods site isn't working correctly at present), but for now a fixed package is attached to this post

[Daniel15]

OK, the new archive has been uploaded.

[DaBoROE09]

when i do the test with the subject of "akismet-test-123" it does not clasify that as spam

[Alenônimo]

when i do the test with the subject of "akismet-test-123" it does not clasify that as spam

Have you made the changes on all templates? Here worked.

[DaBoROE09]

what changes should i have made to the template.  umm i uninstalled it and reinstalled it.

thanks

[Daniel15]

when i do the test with the subject of "akismet-test-123" it does not clasify that as spam

Please check that your Sources/Post.php and Sources/Subs-Post.php files were edited correctly. If you search in the file, there should be an Akismet section.
If you attach your Post.php and Subs-Post.php files here, I'll have a look and see if I can find what's wrong.

[thelastkiss]

I've upgraded to 1.1.1 last night, and all was working fine and dandy today up until about two hours ago - suddenly everything is getting flagged as spam.  Before, only a post or two a day would be flagged, but now all posts are.  Is there any particular reason for this, or is it something on Akismet's part? :/

[Daniel15]

suddenly everything is getting flagged as spam.  Before, only a post or two a day would be flagged, but now all posts are.  Is there any particular reason for this, or is it something on Akismet's part?

It's most likely a glitch with Akismet (these things happen very rarely, but they do occasionally happen).
Are the posts regular posts, or are they spam-like posts (very short, lots of links, etc.)?

[thelastkiss]

They're all regular posts, no links, 2-3 sentences.  These posts used to get by Akismet fine but now everything is going up as spam :/

[Alenônimo]

I've upgraded to 1.1.1 last night, and all was working fine and dandy today up until about two hours ago - suddenly everything is getting flagged as spam.  Before, only a post or two a day would be flagged, but now all posts are.  Is there any particular reason for this, or is it something on Akismet's part? :/

I've uninstalled this extension because that. I quit.

[Scooby]

I removed it because of the problems today, but I will put it back, when the problem is fixed. It would be nice to have an alert feature added, so I don't have to keep going into admin to see if there are any trapped posts.
Also I note that when releasing non spam, the index page is not updated. Only when you view the thread does it show as a new post

[Daniel15]

Sorry about the problems guys, I've contacted the creators of Akismet so I can see if there's any known problems at the moment.

[thelastkiss]

Thanks, Daniel

I use Akismet on my blog though, and nothing unusual has happened (just a tidbit, don't know if that will help).

[EdwinK]

I'm having the same problem now. Going to un-install this mod till problems are fixed
After uninstalling this, I'm getting problems

Database Error
Unknown column 't.spam' in 'where clause'
File: /home/dungeons/public_html/CR/Sources/MessageIndex.php
Line: 490

and this one:

Fatal error: Cannot redeclare class akismet in /home/dungeons/public_html/CR/Sources/Akismet.class.php on line 55

[nolageek]

Hmmm akismet-test-123 didn't work for me either.  Also, the Akismet configuration link doesn't appear in my admin....

I really hate that if you don't use the Default theme, you have to code everything by hand.. there really be a way to fix that.

[DaBoROE09]

i agree nolageek.  it is easy for the creators to do it just for one theme but it would be awesome if they could do it for all. 

[Daniel15]

I'm having the same problem now. Going to un-install this mod till problems are fixed
After uninstalling this, I'm getting problems

Delete all related code from MessageIndex.php, Post.php and Subs-Post.php

it is easy for the creators to do it just for one theme but it would be awesome if they could do it for all.

It's impossible to do, as I'd need to include code for every single theme available (the code of most themes is slightly different). There's no easy way for a package to know what theme a user has installed.