I am using Drupal 4.6.5 for site in English and 6 languages (Hangul, Japanese, Chinese, Portuguese, Spanish, Tagalog). Creating "new translations" for terms in "administer/categories/translations" always works fine, but whenever I try to edit the translated terms, I get the following error:

user error: You have an error in your SQL syntax near 'USING(tid) WHERE i.trid=22' at line 1
query: SELECT t.*,i.trid FROM term_data t JOIN i18n_taxonomy_term i USING(tid) WHERE i.trid=22

"current translation" column is --
and "change translation" dropdown is empty.

Comments

midori’s picture

midori commented

MySQL used to produce the error is version 3.23.58. If I replace JOIN to LEFT JOIN in function i18n_taxonomy_get_translations then everything looks fine.

$result = db_query('SELECT t.*,i.trid FROM {term_data} t LEFT JOIN {i18n_taxonomy_term} i USING(tid) WHERE i.trid=%d',$trid);

I don't know but I guess before MySQL 4.0 only LEFT JOIN can be used with USING.

jose reyero’s picture

jose reyero commented
Status: Active » Fixed

I think this was fixed some time ago.

Please, reopen if not.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)