Sql error after installing module
sinasalek - November 18, 2007 - 17:27
| Project: | SEO Checklist |
| Version: | 5.x-1.3-1 |
| Component: | Code |
| Category: | bug report |
| Priority: | minor |
| Assigned: | sinasalek |
| Status: | closed |
Jump to:
Description
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.
#1
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.
#2
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.
#3
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.
#4
Any help getting this resolved would be much appreciated. Anyone want to create a patch for this?
#5
Changing module version.
#6
Fixed in 2.0.