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.

CommentFileSizeAuthor
#4 akismet_111508.patch695 bytesdrewish

Comments

evanssd’s picture

evanssd commented

Same problem here - little help?

evanssd’s picture

evanssd commented

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.

bkoen’s picture

bkoen commented

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

Thanks....

drewish’s picture

drewish commented
Status: Active » Needs review
StatusFileSize
new akismet_111508.patch695 bytes

give this a try.

drewish’s picture

drewish commented
Status: Needs review » Fixed

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

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)