Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN ('content_restaurant')) AND (.tid IN ('14','15','16','17','18','19','20','21'' at line 1 query: views_build_view SELECT node.nid, node.title AS node_title FROM node node LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='ja' OR i18n.language ='' OR i18n.language IS NULL) AND (.type IN ('content_restaurant')) AND (.tid IN ('14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40',&# in /home/chibabea/public_html/includes/database.mysql.inc on line 120

This error comes up when I switch languages on my frontpage to Japanese. The specific part of the page that is affected is a views block with a list view of restaurants. I really have no idea what is causing this error because I have other list views on the frontpage and they all seem to be working fine with the language transition. To see the error you can go to http://chibabeat.com and then click on Japanese in the upper right corner. Can somebody please help me with this problem?

Comments

lor’s picture

lor commented

hi !

I have the same problem with my views !
I've read the posts about views and i18n, and I've seen that the patch of M. Lesieur has been implemented in the new release of i18n but without results for me (http://drupal.org/node/64004 or http://drupal.org/node/65722).
Somebody could help, please ???

Warning: Unknown column 'term_node_4.name' in 'field list' query: SELECT node.nid, term_node_4.name AS term_node_4_name, node.title AS node_title, node.changed AS node_changed, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, node_data_field_date.field_date_timezone AS node_data_field_date_field_date_timezone, node_data_field_lieu.field_lieu_value AS node_data_field_lieu_field_lieu_value, node_data_field_programme.field_programme_value AS node_data_field_programme_field_programme_value FROM node node LEFT JOIN node_content_actualit node_data_field_date ON node.vid = node_data_field_date.vid LEFT JOIN node_content_actualit node_data_field_lieu ON node.vid = node_data_field_lieu.vid LEFT JOIN node_content_actualit node_data_field_programme ON node.vid = node_data_field_programme.vid LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND (node.status = '1') AND (node in /homepages/4/d177075794/htdocs/includes/database.mysql.inc on line 121

my website : www.pascalecriton.og
pb with : www.pascalecriton.og/en/catalogue for example

ThanX

jose reyero’s picture

jose reyero commented
Status: Active » Closed (won't fix)

This has been addressed in newer versions (5.x, 6.x) and Drupal 4.7 is not supported anymore. Please, consider upgrading

mincevv’s picture

mincevv commented
Version: 4.7.x-1.x-dev » 5.x-2.2

I am using Drupal 5.7. I have i18n 2.2 and views 1.6 installed... After creating articles with translations I get following message:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN ('179')) ) ORDER BY node_created_created DESC LIMIT 0, 1' at line 1 query: SELECT node.nid, node.created AS node_created_created FROM node node LEFT JOIN i18n_node i18n ON node.nid = i18n.nid WHERE (i18n.language ='sr' OR i18n.language ='' OR i18n.language IS NULL) AND ( (.tid IN ('179')) ) ORDER BY node_created_created DESC LIMIT 0, 1 in /www/webvol5/rf/zbs68gvsdc23buk/timct.co.yu/public_html/includes/database.mysql.inc on line 172.

Rebuilding views helped but for a while, then after few new articles warning appears again! Please ask for further explanations so I could help you in solving this metter...