I get various errors related to i18n_strings when I update i18n from 6.x-1.0-beta4 to beta5

Update.php shows only one update was required: i18n strings module - 5900

After clicking to perform this update, Update.php shows this warning message:

user warning: Table 'i18n_strings' already exists query: CREATE TABLE i18n_strings ( `lid` INT NOT NULL DEFAULT 0, `objectid` INT NOT NULL DEFAULT 0, `type` VARCHAR(255) NOT NULL DEFAULT '', `property` VARCHAR(255) NOT NULL DEFAULT 'default', PRIMARY KEY (lid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/[PATH]/includes/database.inc on line 515.
...
The following queries were executed
i18nstrings module
Update #5900
* No queries
Update #6001
* No queries

After this, every page is displaying these warnings:

* user warning: Unknown column 'i.objectid' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'menu' AND s.location = 'item:235:title' in /home/[PATH]/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 326.
* user warning: Unknown column 'i.objectid' in 'field list' query: SELECT s.*, i.type, i.objectid, i.property FROM locales_source s LEFT JOIN i18n_strings i ON s.lid = i.lid WHERE s.textgroup = 'menu' AND s.source = 'Content' AND i.lid IS NULL in /home/[PATH]/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 331.
* user warning: Unknown column 'objectid' in 'field list' query: INSERT INTO i18n_strings (lid, type, objectid, property) VALUES(3284, 'item', 235, 'title') in /home/[PATH]/sites/all/modules/i18n/i18nstrings/i18nstrings.module on line 305.

I've tried restoring the db from a backup, replacing beta5 with beta4, and repeating the upgrade/update, but get the same results. (Strangely, if I replace i18n b5 with b4 (but don't restore the database), the errors stop).

Just to check I'm not doing anything stupid... My update procedure is: 1) site off line, 2) disable all i18n module components, 3) remove beta4 and unpack beta5 in place, 4) renable i18n module components, 5) run update.php

In case it is relevant, I have these modules installed: advanced_help, fckeditor, i18n, imce, plugin_manager, translation_status, views

If anyone else is seeing the same problem, please post a comment. Thanks.

Comments

jose reyero’s picture

jose reyero commented
Status: Active » Fixed

My fault, messed up the updates, sorry

Go to update, and select manually 18nstrings update 6001, skip the other one

bsimon’s picture

bsimon commented

OK, it's working fine now. I updated again with the backed up db. Many thanks - I'm just glad the problem was so simple to solve :)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

myDRU’s picture

myDRU commented

It seems I have this problem after upgrading from i18n 6.x-1.0-beta4 to 6.x-1.2 (D16.14). Could somebody tell me in more detail how to "Go to update, and select manually 18nstrings update 6001"?

myDRU’s picture

myDRU commented

I manually ran the following query on the DB (i.e. update 6001), and this solved the problem:
ALTER TABLE i18n_strings CHANGE COLUMN oid objectid INTEGER NOT NULL DEFAULT 0;

momo18’s picture

momo18 commented

Ditto. Fix worked for me also. Now drush up worked as advertised.

bug273’s picture

bug273 commented
bug273’s picture

bug273 commented

"#5
ALTER TABLE i18n_strings CHANGE COLUMN oid objectid INTEGER NOT NULL DEFAULT 0;"
I was the same problem and your post was my salvation! thanks