Hi,
I downloaded and installed "i18n-5.x-2.1.tar.gz" it on drupal 5.2. I use Postgresql 8.1.
I have followed all instructions contained in INSTALL.TXT file and I read the Internazionalization handbook, but..

When I enable the Translations Block, and I use it on my web site, I get back an a Postgresql error! It seems that a type's field in a table is an integer insted of a boolean..

-----------------------------

* warning: pg_query() [function.pg-query]: Query failed: ERROR: argument of AND must be type boolean, not type integer in /usr/share/drupal5/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT n.nid FROM i18n_node n INNER JOIN i18n_node a ON n.trid = a.trid AND n.nid != a.nid WHERE a.nid = 3 AND n.language = 'en' AND n.trid in /usr/share/drupal5/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: argument of AND must be type boolean, not type integer in /usr/share/drupal5/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT n.nid FROM i18n_node n INNER JOIN i18n_node a ON n.trid = a.trid AND n.nid != a.nid WHERE a.nid = 3 AND n.language = 'it' AND n.trid in /usr/share/drupal5/includes/database.pgsql.inc on line 144.

---------------------------

Can someone help me to correct this problem, please?

Thanks and regard
Lorenzo

Comments

Lorenzo01’s picture

Lorenzo01 commented

First of all sorry for my english..

I read various issues posts, and I found this:

http://drupal.org/node/171835

and it looks like the problem I'm experimenting..
It seem they found a way to "solve" the problem, now I go to test it.

bye
Lorenzo

Lorenzo01’s picture

Lorenzo01 commented

The solution found by Klance works..Thanks Klane!
Below is what I have done:

-----------
Klane text
-----------
#3 submitted by klance on August 31, 2007 - 14:31
I'm going to change this last bit to "AND n.trid != 0" for now, because that gets rid of the error log entries and accomplishes what I think this query is trying to do implicitly. The column trid in i18n_node is set to NOT NULL DEFAULT '0', so zero is the only false/invalid value it can have.

-----------

Bye
Lorenzo

jose reyero’s picture

jose reyero commented
Status: Active » Closed (duplicate)