Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I upgraded to 6-2.1 and I encountered failed queries for languages which include a dash. Those which failed:
# Failed: ALTER TABLE {translation_overview_priority} CHANGE zh-hant `lang_zhhant` TINYINT unsigned NOT NULL DEFAULT 1
# Failed: ALTER TABLE {translation_overview_priority} CHANGE pt-br `lang_ptbr` TINYINT unsigned NOT NULL DEFAULT 1
# Failed: ALTER TABLE {translation_overview_priority} CHANGE pt-pt `lang_ptpt` TINYINT unsigned NOT NULL DEFAULT 1
The correct queries should be:
ALTER TABLE {translation_overview_priority} CHANGE zhhant `lang_zhhant` TINYINT unsigned NOT NULL DEFAULT 1
ALTER TABLE {translation_overview_priority} CHANGE ptbr `lang_ptbr` TINYINT unsigned NOT NULL DEFAULT 1
ALTER TABLE {translation_overview_priority} CHANGE ptpt `lang_ptpt` TINYINT unsigned NOT NULL DEFAULT 1
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | translation_overview_471464.patch | 893 bytes | drewish |
Comments
Comment #1
drewish commentedDarn, wish I could have caught that while it was still in beta. Here's a patch to rename the correct columns. Could you apply this and then re-run update 6001?
Comment #2
drewish commentedOh, it shouldn't cause any problems but to be safe, make a backup of your database before re-running the database.
Comment #3
toemaz commentedThanks for the quick update drewish. I applied the patch and reran the update. Flawless.
Comment #4
drewish commentedgreat, well thank you for the clear bug report and quick testing. i'm going to roll a 2.2 release.