The title says most of it.

I turned i18 off in Drupal 4.7, turned it back on in drupal 5.7 after uploading the latest 5.x version.

I had a couple of Unknown column 'm.language' in 'where clause' query: SELECT m.mid, m.* FROM menu m WHERE (m.language ='en' OR m.language ='' OR m.language IS NULL) ORDER BY m.mid ASC error messages when I turned the module back on.

After I ran the update script, I end up with three of each menu items for the admin content.

I've got copies of eveything, so I can revert back to any point in the process, but I'd like to get some advice regarding this issue, maybe a pointer to some i18 upgrade guidelines - my searches were not giving me any useful results.

Comments

jmlavarenne’s picture

jmlavarenne commented

I am trying again - I noticed that the module admin page will let me activate sub-modules even before "internationalization" is ennabled - the checkboxes are selectable.

After ennabling internationalization, I get this MySQL warning:

user warning: Unknown column 'm.language' in 'where clause' query: SELECT m.mid, m.* FROM menu m WHERE (m.language ='en' OR m.language ='' OR m.language IS NULL) ORDER BY m.mid ASC in /MYSITE/www/includes/database.mysql.inc on line 172.

I get this warning three times (I have two languages enabled including English).

Once I run the update script, each admin menu is now printed twice, both with /en/ prefix.

jmlavarenne’s picture

jmlavarenne commented
Status: Active » Closed (duplicate)

http://drupal.org/node/176022