In the Akismet moderation queue (i.e. admin/content/akismet) I see this error:

* user warning: Unknown column 'COMMENT_NOT_PUBLISHED' in 'where clause' query: SELECT COUNT(*) AS cnt FROM comments c LEFT JOIN akismet_spam_marks s ON s.content_id = c.cid AND s.content_type = 'comment' WHERE (c.status = COMMENT_NOT_PUBLISHED) in /var/www/DRUPAL-5/html/includes/database.mysql.inc on line 167.
* user warning: Unknown column 'COMMENT_PUBLISHED' in 'where clause' query: SELECT COUNT(*) AS cnt FROM comments c LEFT JOIN akismet_spam_marks s ON s.content_id = c.cid AND s.content_type = 'comment' WHERE (c.status = COMMENT_PUBLISHED) in /var/www/DRUPAL-5/html/includes/database.mysql.inc on line 167.

CommentFileSizeAuthor
#1 akismet-query-errors.patch.txt1004 bytessillygwailo

Comments

sillygwailo’s picture

sillygwailo
Location Toronto, ON
commented
Status: Active » Needs review
StatusFileSize
new akismet-query-errors.patch.txt1004 bytes

The attached patch fixes (or rather, avoids) the above error and another one, quoted below:

* user warning: Query was empty query: in /var/www/DRUPAL-5/html/includes/database.mysql.inc on line 167.
* user warning: Query was empty query: in /var/www/DRUPAL-5/html/includes/database.mysql.inc on line 167.
* user warning: Query was empty query: in /var/www/DRUPAL-5/html/includes/database.mysql.inc on line 167.

drewish’s picture

drewish commented
Status: Needs review » Fixed

great, simple fix for it. i've committed it to DRUPAL-5 and HEAD.

Anonymous’s picture

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