Download & Extend

Warning when submitting spam checked blog entry

Project:Akismet
Version:5.x-1.2
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

I get the following error on 2 drupal 5.0 production sites, with different installed modules. Both use the same Wordpress API key atm.

"user warning: Unknown column 'n.body' in 'where clause' query: SELECT 1 FROM node n INNER JOIN node_revisions r ON r.nid = n.nid INNER JOIN akismet_spam_marks s ON s.content_type = 'node' AND s.content_id = n.nid WHERE (s.hostname = '202.86.32.41' OR n.body = '

\r\nLorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam varius nunc non \r\njusto. Morbi at sapien aliquam lacus dignissim pretium. Mauris feugiat tellus ac \r\npurus. Integer faucibus lacinia metus. Nam ultrices semper nunc. In hac \r\nhabitasse platea dictumst. Proin nisl justo, luctus at, interdum a, eleifend \r\nvel, orci. Cras id. \r\n

\r\n' OR s.mail = 'brad@bradmarg.homeip.net') in /var/www/drupal/includes/database.mysqli.inc on line 151."

The node is created and published fine.

Comments

#1

Same problem here - little help?

#2

My users are getting same error message even when "post with no akismet checking" is selected. Post goes through fine, but error message is scaring folks.

#3

I am getting a similar message. Is there an update or workaround?

Thanks....

#4

Status:active» needs review

give this a try.

AttachmentSize
akismet_111508.patch 695 bytes

#5

Status:needs review» fixed

I've committed this to DRUPAL-5 and HEAD.

#6

Status:fixed» closed (fixed)