>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #369800. --> Reported by: [bakr](https://www.drupal.org/user/194056) >>> <p>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</p> <p>I suspect the table creation syntax is not respecting the table prefix namespace that is allowed by by shared hosting account.<br> ==============</p> <p>upon enabling the module, i get this error:</p> <p> * 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.<br> * 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.</p> <p>==============</p> <p>when trying to access the trans. Overview from the content-managemtn section: i get the following:</p> <p>===============================<br> q=admin/content/translation_overview_manage</p> <p> * 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.<br> * 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.<br> * 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.<br> * 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.</p> <p>===============================</p> <p>Notice the explicit "moonmans_drp01"</p> <p>--------------------------------------</p> <p>Please help...</p>