i got the followin message

user warning: Unknown column 'i18n.language' in 'where clause' query: SELECT COUNT(*) FROM node n LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language IS NULL) AND type = 'blog' AND n.uid = 1 AND n.status = 1 in /www/lc8.it/drupal-4.7.0-WaitingFor/includes/database.mysql.inc on line 120.
user warning: Unknown column 'i18n.language' in 'where clause' query: SELECT DISTINCT(n.nid), n.sticky, n.created FROM node n LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language IS NULL) AND type = 'blog' AND n.uid = 1 AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in /www/lc8.it/drupal-4.7.0-WaitingFor/includes/database.mysql.inc on line 120.

hence i put a look to db and saw

mysql> select * from i18n_node ;
+------+-----+--------+
| trid | nid | status |
+------+-----+--------+
| 1000 | 0 | 0 |
+------+-----+--------+
1 row in set (0.00 sec)

mysql>

hence verified CVS repository ...

Revision 1.4 - (view) (download) (annotate) - [select for diffs]
Sat Aug 20 12:08:57 2005 UTC (8 months ago) by jareyero
Branch: MAIN

The question is ... is i18n.mysql HEAD version file updated?
Many thanks

Comments

jose reyero’s picture

jose reyero commented

The install file should handle database updates now.
Try running update.php

profix898’s picture

profix898 commented
Status: Active » Fixed

As far as I can see the update path for mysql look good now. All tables correctly altered and updated.

3B’s picture

3B commented

Jose, many many thanks for the word your doing ... i really appreciate your effort. I'll hope to be one of the good case history of your work. i'll let you know as soon as released new site.

kind regads
alberto

3B’s picture

3B commented

oooops "work" not "word" ... sorry :-)

svetlin’s picture

svetlin commented
Status: Fixed » Active

First I'd like to thank you for your work, great job.

I'm working on an english/bulgarian site.
On a clean 4.7 install I receive the following error when trying to edit a translated node.

user warning: Unknown column 'language' in 'field list' query: SELECT language FROM node WHERE nid=8 in /opt/lampp/htdocs/d47/includes/database.mysql.inc on line 120.

i18n.mysql isn't creating the language column in the node table.
This query from 4.6 version fixes the problem.

ALTER TABLE `node`
ADD `language` varchar(12) NOT NULL default '';

Is this the right thing to do?

belio’s picture

belio commented

I think this is not used anymore. There is a language field in the i18n_node table though.

Sure you have the latest cvs version?

svetlin’s picture

svetlin commented
Status: Active » Closed (fixed)

I've installed drupal and latest i18n and now it's ok