Problem installing / updating translations aka. "Incorrect string value: '\xAB none..." [Win2008]

Do_Checkor
Do_Checkor's picture

Joined: 2012-02-13
Posts: 8
Posted: Thu, 2013-10-31 18:50
Quote:
Update translations Failed #1366: Incorrect string value: '\xAB none...' for column 'status' at row 1 [ UPDATE `G3_tasks` SET `state` = 'error', `done` = TRUE, `status` = '#1366: Incorrect string value: \'\\xAB none...\' for column \'message\' at row 1 [ INSERT INTO `G3_incoming_tr

....when trying to add "German" language (or any other language) to the gallery.

I solved this by:

Dropping the incoming_translations table and recreating it from the latest (3.0.9) source:

Quote:

use "GALLERY";

DROP TABLE IF EXISTS 'g3_incoming_translations';

CREATE TABLE 'g3_incoming_translations' (
`id` int(9) NOT NULL AUTO_INCREMENT,
`key` char(32) NOT NULL,
`locale` char(10) NOT NULL,
`message` text NOT NULL,
`revision` int(9) DEFAULT NULL,
`translation` text,
PRIMARY KEY (`id`),
UNIQUE KEY `key` (`key`,`locale`),
KEY `locale_key` (`locale`,`key`)
) DEFAULT CHARSET=utf8;

Next step:

checking the logs, copying the SQL statement in question to the MySQL work bench (would be phpmyadmin for the most users), removing PHP related tags execute:

Quote:
INSERT INTO `G3_incoming_translations`
(`key`, `message`, `locale`)
VALUES ('aa99a9a09b6d3a8629628a389827d1ec', 's:8:\\\"« none »\\\";', 'root');

Then on the webinterface of the gallery again, clicked the "Update Translations" from the index.php/admin/languages and then it ran through fine.

So if you are running into the same issue: make sure to make a backup of your database first, and make sure you are running on the same G3 version 3.0.9, also make sure to change your database name after the "USE" statment, and the "g3_" reflects your own table prefixes.

BTW: Many people claim Gallery would not work on Win 2008 with IIS7.5 - I can assure you: It IS possible. Kudos to "Ranger187". It is even possible to get URL rewrite going by installing Helicon Ape. It is NOT easy to get it to run, though. Make sure you follow all the steps in the tutorial of Ranger and it will work.

Cheers!

checky