Column not found: 1054 Unknown column 'base.i18n_tsid' in 'field list' [#1066886]

Allright,

I've updated my module from 7.x.-1.0-alpha2 to 7.x.-1.0-alpha3 and i've recieved the following error in nearly every single content page;

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base.i18n_tsid' in 'field list': SELECT base.tid AS tid, base.vid AS vid, base.name AS name, base.description AS description, base.format AS format, base.weight AS weight, base.language AS language, base.i18n_tsid AS i18n_tsid, v.machine_name AS vocabulary_machine_name FROM {taxonomy_term_data} base INNER JOIN {taxonomy_vocabulary} v ON base.vid = v.vid WHERE (base.tid IN (:db_condition_placeholder_0)) AND (base.language IN (:db_condition_placeholder_1, :db_condition_placeholder_2)) ; Array ( [:db_condition_placeholder_0] => 34 [:db_condition_placeholder_1] => tr [:db_condition_placeholder_2] => und ) in DrupalDefaultEntityController->load() (line 196 of D:\......\includes\entity.inc).

It seems there are several conflicts in the upgrade path of both i18n and variable releases.

Possible solution for solving this issue is as follows;

- Disable taxonomy translation module,
- Uninstall taxonomy translation module,
- Install and enable taxonomy translation module.

Waiting reply and review.

Comments

Comment #1

Goulou CreditAttribution: Goulou commented 22 February 2011 at 08:44

I got the same problem.
The point is that I just get the error now, nothing more on the pages : I cannot got to the administration and remove/disable the module as you said... I tried to manually change the "system" table to disable them, but that does nothing, I think I'm missing something...

I hope there is an easy solution (and it will be fixed soon!)

Goulou

Comment #2

Goulou CreditAttribution: Goulou commented 22 February 2011 at 08:57

I temporarily solved the problem by manually adding the "i18n_tsid" column to the table...
This is not very beautiful, I have to admit, but at least my website works again (except the taxonomy translation module, which I disabled anyway).

Comment #3

Jose Reyero CreditAttribution: Jose Reyero commented 22 February 2011 at 13:57

Status:

Active

» Closed (works as designed)

Alpha versions won't include update scripts so I'm afraid you'll need to do the changes manually or reinstall the module (i18n_taxonomy).

Comment #4

Goulou CreditAttribution: Goulou commented 23 February 2011 at 09:57

do you mean "adding the column by yourself" when you say "do the changes manually" ?

Comment #5

Goulou CreditAttribution: Goulou commented 25 February 2011 at 19:17

For those of you that may have had the same problem as me, this line may help you :
$schema['taxonomy_term_data']['fields']['i18n_tsid'] = array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0);

This is the column you have to add manually...

Comment #6

droshani CreditAttribution: droshani commented 10 March 2011 at 14:51

I have the same problem, so do you mean I should insert that into my DB?

I tried to do this but I get error massage

#1064 - 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 '$schema['taxonomy_term_data']['fields']['i18n_tsid'] = array('type' => 'int', 'u' at line 1

Is this something to do with MYSQL version?

Do you think this will work with MySQL client version: 5.0.45?