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...
| Comment | File | Size | Author |
|---|---|---|---|
| #9 | translation_overview_369800.patch | 869 bytes | drewish |
| #6 | translation_overview_369800.patch | 6.08 KB | drewish |
Comments
Comment #1
bakr commentedApparently, some special character is failing the SQL statement...
Comment #2
bakr commentedIt 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.
Comment #3
drewish commentedare you doing pgsql? if so it might be a duplicate of #322796: PostgreSQL DISTINCT ORDER BY CLAUSE causes break during installation
Comment #4
bakr commentedit is based on mysql
Comment #5
bakr commentedComment #6
drewish commentedhere's a patch that changes the names of the fields to make them safer.
i'd love some testing before i commit this.
Comment #7
drewish commenteddid some more testing and it looks good. i'll put out a beta release so people can test it.
Comment #8
bakr commentedThanks drewish.
Good work.
Comment #9
drewish commentedmissed one when adding a new language. committing this to HEAD.