I am not able to install the translation module as a whole into latest fresh drupal 6.9 installation which has been provided via simplescripts from hostmonster.com

I suspect the table creation syntax is not respecting the table prefix namespace that is allowed by by shared hosting account.
==============

upon enabling the module, i get this error:

* 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 'is (is), INDEX id (id), INDEX it (it), INDEX ja (ja), INDEX kn (kn), INDEX ' at line 94 query: CREATE TABLE drup_translation_overview_priority ( `tnid` INT unsigned NOT NULL, `af` TINYINT unsigned NOT NULL DEFAULT 1, `sq` TINYINT unsigned NOT NULL DEFAULT 1, `ar` TINYINT unsigned NOT NULL DEFAULT 1, `eu` TINYINT unsigned NOT NULL DEFAULT 1, `bn` TINYINT unsigned NOT NULL DEFAULT 1, `dz` TINYINT unsigned NOT NULL DEFAULT 1, `bs` TINYINT unsigned NOT NULL DEFAULT 1, `bg` TINYINT unsigned NOT NULL DEFAULT 1, `my` TINYINT unsigned NOT NULL DEFAULT 1, `km` TINYINT unsigned NOT NULL DEFAULT 1, `ca` TINYINT unsigned NOT NULL DEFAULT 1, `zhhans` TINYINT unsigned NOT NULL DEFAULT 1, `zhhant` TINYINT unsigned NOT NULL DEFAULT 1, `hr` TINYINT unsigned NOT NULL DEFAULT 1, `cs` TINYINT unsigned NOT NULL DEFAULT 1, `da` TINYINT unsigned NOT NULL DEFAULT 1, `nl` TINYINT unsigned NOT NULL DEFAULT 1, `en` TINYINT unsigned NOT NULL DEFAULT 1, `eo` TINYINT unsigned NOT NULL DEFAULT 1, `et` TINYINT unsigned NOT NULL DEFAULT 1, `fo` TINYINT unsigned NOT NULL DEFAULT 1, `fi` TINYINT unsigned NOT NULL DEFAULT 1, `fr` TINYINT unsigned NOT NULL DEFAULT 1, `gl` TINYINT unsigned NOT NULL DEFAULT 1, `de` TINYINT unsigned NOT NULL DEFAULT 1, `el` TINYINT unsigned NOT NULL DEFAULT 1, `gu` TINYINT unsigned NOT NULL DEFAULT 1, `he` TINYINT unsigned NOT NULL DEFAULT 1, `hi` TINYINT unsigned NOT NULL DEFAULT 1, `hu` TINYINT unsigned NOT NULL DEFAULT 1, `is` TINYINT unsigned NOT NULL DEFAULT 1, `id` TINYINT unsigned NOT NULL DEFAULT 1, `it` TINYINT unsigned NOT NULL DEFAULT 1, `ja` TINYINT unsigned NOT NULL DEFAULT 1, `kn` TINYINT unsigned NOT NULL DEFAULT 1, `ko` TINYINT unsigned NOT NULL DEFAULT 1, `lv` TINYINT unsigned NOT NULL DEFAULT 1, `lt` TINYINT unsigned NOT NULL DEFAULT 1, `mk` TINYINT unsigned NOT NULL DEFAULT 1, `ms` TINYINT unsigned NOT NULL DEFAULT 1, `mr` TINYINT unsigned NOT NULL DEFAULT 1, `ne` TINYINT unsigned NOT NULL DEFAULT 1, `nb` TINYINT unsigned NOT NULL DEFAULT 1, `nn` TINYINT unsigned NOT NULL DEFAULT 1, `fa` TINYINT unsigned NOT NULL DEFAULT 1, `pl` TINYINT unsigned NOT NULL DEFAULT 1, `ptbr` TINYINT unsigned NOT NULL DEFAULT 1, `ptpt` TINYINT unsigned NOT NULL DEFAULT 1, `ro` TINYINT unsigned NOT NULL DEFAULT 1, `ru` TINYINT unsigned NOT NULL DEFAULT 1, `sr` TINYINT unsigned NOT NULL DEFAULT 1, `sk` TINYINT unsigned NOT NULL DEFAULT 1, `sl` TINYINT unsigned NOT NULL DEFAULT 1, `es` TINYINT unsigned NOT NULL DEFAULT 1, `sv` TINYINT unsigned NOT NULL DEFAULT 1, `th` TINYINT unsigned NOT NULL DEFAULT 1, `tr` TINYINT unsigned NOT NULL DEFAULT 1, `uk` TINYINT unsigned NOT NULL DEFAULT 1, `uz` TINYINT unsigned NOT NULL DEFAULT 1, `vi` TINYINT unsigned NOT NULL DEFAULT 1, PRIMARY KEY (tnid), INDEX af (af), INDEX sq (sq), INDEX ar (ar), INDEX eu (eu), INDEX bn (bn), INDEX dz (dz), INDEX bs (bs), INDEX bg (bg), INDEX my (my), INDEX km (km), INDEX ca (ca), INDEX zhhans (zhhans), INDEX zhhant (zhhant), INDEX hr (hr), INDEX cs (cs), INDEX da (da), INDEX nl (nl), INDEX en (en), INDEX eo (eo), INDEX et (et), INDEX fo (fo), INDEX fi (fi), INDEX fr (fr), INDEX gl (gl), INDEX de (de), INDEX el (el), INDEX gu (gu), INDEX he (he), INDEX hi (hi), INDEX hu (hu), INDEX is (is), INDEX id (id), INDEX it (it), INDEX ja (ja), INDEX kn (kn), INDEX ko (ko), INDEX lv (lv), INDEX lt (lt), INDEX mk (mk), INDEX ms (ms), INDEX mr (mr), INDEX ne (ne), INDEX nb (nb), INDEX nn (nn), INDEX fa (fa), INDEX pl (pl), INDEX ptbr (ptbr), INDEX ptpt (ptpt), INDEX ro (ro), INDEX ru (ru), INDEX sr (sr), INDEX sk (sk), INDEX sl (sl), INDEX es (es), INDEX sv (sv), INDEX th (th), INDEX tr (tr), INDEX uk (uk), INDEX uz (uz), INDEX vi (vi) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home1/moonmans/public_html/cms/includes/database.inc on line 515.
* user warning: Table 'moonmans_drp01.drup_translation_overview_priority' doesn't exist query: INSERT INTO drup_translation_overview_priority (tnid) SELECT DISTINCT(nid) FROM drup_node WHERE nid = tnid OR tnid = 0 OR tnid IS NULL in /home1/moonmans/public_html/cms/sites/all/modules/translation_overview/translation_overview.install on line 11.

==============

when trying to access the trans. Overview from the content-managemtn section: i get the following:

===============================
q=admin/content/translation_overview_manage

* user warning: Table 'moonmans_drp01.drup_translation_overview_priority' doesn't exist query: SELECT * FROM drup_translation_overview_priority WHERE tnid = 2 in /home1/moonmans/public_html/cms/sites/all/modules/translation_overview/translation_overview.module on line 173.
* 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 'is, id, it, ja, kn, ko, lv, lt, mk, ms, mr, ne, nb, nn, fa, pl, ptbr, ptpt, ro, ' at line 1 query: INSERT INTO drup_translation_overview_priority (tnid, af, sq, ar, eu, bn, dz, bs, bg, my, km, ca, zhhans, zhhant, hr, cs, da, nl, en, eo, et, fo, fi, fr, gl, de, el, gu, he, hi, hu, is, id, it, ja, kn, ko, lv, lt, mk, ms, mr, ne, nb, nn, fa, pl, ptbr, ptpt, ro, ru, sr, sk, sl, es, sv, th, tr, uk, uz, vi) VALUES (2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1) in /home1/moonmans/public_html/cms/includes/common.inc on line 3425.
* user warning: Table 'moonmans_drp01.drup_translation_overview_priority' doesn't exist query: SELECT * FROM drup_translation_overview_priority WHERE tnid = 1 in /home1/moonmans/public_html/cms/sites/all/modules/translation_overview/translation_overview.module on line 173.
* 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 'is, id, it, ja, kn, ko, lv, lt, mk, ms, mr, ne, nb, nn, fa, pl, ptbr, ptpt, ro, ' at line 1 query: INSERT INTO drup_translation_overview_priority (tnid, af, sq, ar, eu, bn, dz, bs, bg, my, km, ca, zhhans, zhhant, hr, cs, da, nl, en, eo, et, fo, fi, fr, gl, de, el, gu, he, hi, hu, is, id, it, ja, kn, ko, lv, lt, mk, ms, mr, ne, nb, nn, fa, pl, ptbr, ptpt, ro, ru, sr, sk, sl, es, sv, th, tr, uk, uz, vi) VALUES (1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1) in /home1/moonmans/public_html/cms/includes/common.inc on line 3425.

===============================

Notice the explicit "moonmans_drp01"

--------------------------------------

Please help...

Comments

bakr’s picture

Apparently, some special character is failing the SQL statement...

bakr’s picture

It worked,

The following queries were executed
translation_overview module
Update #6000

* CREATE TABLE {translation_overview_priority} ( `tnid` INT unsigned NOT NULL, `ar` TINYINT unsigned NOT NULL DEFAULT 1, `en` TINYINT unsigned NOT NULL DEFAULT 1, `ru` TINYINT unsigned NOT NULL DEFAULT 1, PRIMARY KEY (tnid), INDEX ar (ar), INDEX en (en), INDEX ru (ru) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* INSERT INTO {translation_overview_priority} (tnid) SELECT DISTINCT(nid) FROM {node} WHERE nid = tnid OR tnid = 0 OR tnid IS NULL ORDER BY tnid

========

Solution, I have deleted unwanted languages..

Conclusion, some special characters for some languages was not supported on the DB.

drewish’s picture

are you doing pgsql? if so it might be a duplicate of #322796: PostgreSQL DISTINCT ORDER BY CLAUSE causes break during installation

bakr’s picture

it is based on mysql

bakr’s picture

Title: Table name does not respect table prefix value (Possibly) » Special Character for Language X, makes error in MYsql SQL stament
drewish’s picture

Status: Active » Needs review
StatusFileSize
new6.08 KB

here's a patch that changes the names of the fields to make them safer.

i'd love some testing before i commit this.

drewish’s picture

Title: Special Character for Language X, makes error in MYsql SQL stament » Rename the language columns in {translation_overview_priority} so they don't conflict with SQL reserved words
Status: Needs review » Fixed

did some more testing and it looks good. i'll put out a beta release so people can test it.

bakr’s picture

Thanks drewish.

Good work.

drewish’s picture

StatusFileSize
new869 bytes

missed one when adding a new language. committing this to HEAD.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.