PDOException

Thanks for the bug report. I will fix it with the next release. (to be released within a few days).

Until then, please apply the attached patch and use it. It has several other minor bug fixes too.
This patch should fix your issue.

Thanks,

i use akismet.
=
PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 'FROM antispam_spam_marks s INNER JOIN comment c ON s.content_id = c.cid WHERE ' at line 1: SELECT FROM {antispam_spam_marks} s INNER JOIN {comment} c ON s.content_id = c.cid WHERE (s.content_type = :db_condition_placeholder_0) AND (s.hostname = :db_condition_placeholder_1) AND (c.comment = :db_condition_placeholder_2) LIMIT 1 OFFSET 0; Array ( [:db_condition_placeholder_0] => comment [:db_condition_placeholder_1] => 82.146.37.23 [:db_condition_placeholder_2] => йфйф ) in antispam_comment_presave() (line 1014 of /home/user375875/data/www/sabini.ch/sites/all/modules/antispam/antispam.module).
=

I'm also having this problem. The patch doesn't help it.

* subscribe *

I will look into it. Give me some time. Thanks,

I haven't tried the patch, but want to report:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 'FROM antispam_spam_marks s INNER JOIN comment c ON s.content_id = c.cid WHERE ' at line 1: SELECT FROM {antispam_spam_marks} s INNER JOIN {comment} c ON s.content_id = c.cid WHERE (s.content_type = :db_condition_placeholder_0) AND (s.hostname = :db_condition_placeholder_1) AND (s.mail = :db_condition_placeholder_2) AND (c.comment = :db_condition_placeholder_3) LIMIT 1 OFFSET 0; Array ( [:db_condition_placeholder_0] => comment [:db_condition_placeholder_1] => 206.248.191.99 [:db_condition_placeholder_2] => conman@incompetence.com [:db_condition_placeholder_3] => Some nonsense here. ) in antispam_comment_presave() (line 1013 of /DRUPAL7/sites/all/modules/contrib/antispam/antispam.module).

When trying to approve a comment.

Please try the attached patch. This patch includes all the fixes in the previous patch in the post #1.

Thanks,

Downloaded it, patched it:
patch -p0 < antispam_module_2011_02_17.patch

Seems to work. But I nixed some bad comments so more testing is needed on it for sure.

I just applied antispam_module_2011_02_17.patch to version 7.x-1.1, but it still gives me the following error whenever I go into my user profile and click the Save button:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.drupal_antispam_moderator_email_for' doesn't exist: SELECT * FROM {antispam_moderator_email_for} WHERE uid=:uid; Array ( [:uid] => 1 ) in antispam_user_insert() (line 1574 of ... antispam.module).

Having this same issue with editing my user account as well.

Comment #9 is a different issue and was fixed in #1356974: PDOException when removing admin role

I believe the patch in #7 still needs review.

Patch doesn't apply, and I suspect this is not even an issue anymore, since it is so old. Setting it to postponed until someone can confirm it exists with the current -dev verision, and can provide steps to reproduce.