Home » Internationalization » Translation2 » Bug #2711

[2004-11-07 16:27 UTC] ylf at xung dot org

Description:
------------
* With MySQL 4.0.18, when trying to run the CVS version of Translation2_example.sql I get a :

ERROR 1170 at line 11: BLOB column 'id' used in key specification without a key length

This issue gets fixed by by specifying a index length at line 11 with : (id(16))

* Then :

ERROR 1054 at line 13: Unknown column 'pageID' in 'field list'

Which gets fixed by substituting all pageID field names by page_id.

* Then :

ERROR 1062 at line 38: Duplicate entry 'prova_conflitto' for key 1

Which comes from a faulty index definition. One has to write at line 11 :

CREATE UNIQUE INDEX mytable_i18n_id_index ON mytable_i18n (page_id,id(16));

[2004-11-07 18:25 UTC] ylf at xung dot org

You're welcome.

Additionally, if changing pageID to page_id you need to modify the settings.php file used by Translation2_example.php, with :

'string_page_id_col' => 'page_id',