Warning when submitting spam checked blog entry

bradsw57 - January 22, 2007 - 02:12
Project:Akismet
Version:5.x-1.2
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed
Description

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.

#1

evanssd - February 14, 2007 - 17:36

Same problem here - little help?

#2

evanssd - February 20, 2007 - 18:01

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

bkoen - May 31, 2007 - 05:15

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

Thanks....

#4

drewish - June 1, 2007 - 21:15
Status:active» needs review

give this a try.

AttachmentSize
akismet_111508.patch 695 bytes

#5

drewish - June 1, 2007 - 22:03
Status:needs review» fixed

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

#6

Anonymous - June 15, 2007 - 22:19
Status:fixed» closed
 
 

Drupal is a registered trademark of Dries Buytaert.