Hi,
I received this error right after installing modules. and drupal still shows it on every page. would you please help me?

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 'LEFT JOIN common_i18n_node i18n ON n.nid = i18n.nid WHERE (i18n. query: select linked_seo from common_seo_checklist where id=1 LEFT JOIN common_i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) in D:\Developing\Projects\Web\Sites\Ace Rainbow\site\weblog\includes\database.mysql.inc on line 172.

Comments

sinasalek’s picture

sinasalek commented

it's a conflict between SEO and i18n module. and i don't know how to fix it. i had to disable SEO module for getting rid of this error.

jose reyero’s picture

jose reyero commented
Project: Internationalization » SEO Checklist
Version: 5.x-2.2 » 6.x-2.x-dev
Component: User interface » Code
Priority: Critical » Minor

This looks like the SEO module is not making a good use of db_rewrite_sql()

It should use a table alias, 'n' by default if it is a table containing nid field, or pass other parameters as table as primary table and primary key if they're not node queries....

Moving this to SEO Checklist (?) module.

wayland76’s picture

wayland76 commented

Actually, I don't think "n" is a very good alias. I've had problems before with two different modules that wanted to use the same alias.

ben finklea’s picture

ben finklea commented

Any help getting this resolved would be much appreciated. Anyone want to create a patch for this?

eclipsegc’s picture

eclipsegc commented
Version: 6.x-2.x-dev » 5.x-1.3-1

Changing module version.

ben finklea’s picture

ben finklea commented
Status: Active » Closed (fixed)

Fixed in 2.0.