By jazzitup on

Hello!

I had my site up and running and suddenly, after migrating from MySQL server v5.0.45 (Linux) to MySQL 5.0.51a (Windows), I'm getting this warning message:

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT(n.nid) FROM node n, content_field_slider_display s LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='hr' OR i18n.language ='' OR i18n.language IS NULL) AND ( n.nid = s.nid AND n.promote = 1 AND n.status = 1 AND s.field_slider_display_value = 'YES') in database.mysql.inc on line 172.

If I change 'ON n.nid = i18n.nid' to 'ON s.nid = i18n.nid', everything works ok.

I tried to look for an answer on drupal.org, but unfortunately I couldn't find anything useful.

Thanks for any help!

⋅ Categories: Drupal 5.x

Comments

jazzitup’s picture

jazzitup commented

The answer to this issue was in my template.php (with i18n module enabled): http://phpfi.com/298233?lang=php
I just had to remove 'db_rewrite_sql' part.

--
www.jazzit.hr

summit’s picture

summit commented

Subscribing, having following error:

Unknown column 'n.nid' in 'on clause' query: SELECT description FROM vocabulary INNER JOIN node_access na ON na.nid = n.nid

Could may be also be the db_rewrite_sql somewhere...

greetings,
Martijn