user warning: Unknown table 'n' in on 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' LEFT JOIN localizernode loc ON loc.nid=n.nid WHERE (loc.locale IN ('en','cpp','de','pt','-') OR loc.locale IS NULL) AND ( (s.content_id IS NOT NULL)) in /home/www/doc/11111/mysite.com/www/includes/database.mysql.inc on line 121.

According to: http://drupal.org/node/82513 it's all about using "n.type" in

$sql_where = 'WHERE n.type IN ('. $sql_nodetypes .') AND (%cond)'; in akismet_admin.inc, Line 418.

Could someone provide a patch? Or am I wrong? Could be because I'm no developer...

Comments

Paul Adler’s picture

Paul Adler commented

I had a similar issue to you with 5.x-1.2 which I think I have resolved. I created a new issue over at http://drupal.org/node/121611. I'd be interested to know if it fixes your problem.

Paul Adler’s picture

Paul Adler commented

I had a similar issue to you with 5.x-1.2 which I think I have resolved. I created a new issue over at http://drupal.org/node/121611. I'd be interested to know if it fixes your problem.

drewish’s picture

drewish commented
Status: Active » Closed (duplicate)

i'm marking it as a duplicate of http://drupal.org/node/113498 (even though this predates the other issue, the other has a patch)

drewish’s picture

drewish commented

actually that was the wrong issue. it's a duplicate of this one: http://drupal.org/node/111508