(Database independance?) postgres7 error: operator does not exist
Hi all!
I am building a tiki in italian, english, german, french and spanish (not published yet).
My development environment:
- XAMPP 2.5 for Windows
- Apache/2.2.8 (Win32) DAV/2 mod_ssl/2.2.8 OpenSSL/0.9.8g mod_autoindex_color PHP/5.2.5
- PHP Version 5.2.5
- DBMS Postgres 8.3.1 (running remotely on an Ubuntu box)
tikiwiki version: 1.9.10.1
I'm having a problem using the i18n feature: if I activate "Multilingual" and I select "Italiano (it)", and then I try to update my homepage, I get the following error message: Warning: postgres7 error: ERROR: operator does not exist: bigint = character varying (...)
Here the complete error message:
Warning: postgres7 error: ERROR: operator does not exist: bigint = character varying LINE 1: ...cts as t2 LEFT JOIN tiki_pages p ON p.page_id=t2.objId...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in query: s elect t2.objId, t2.lang, p.pageNameas objName from tiki_translated_objects as t1, tiki_translated_objects as t2 LEFT JOIN tiki_pages p ON p.page_id=t2.objId where t1.traId=t2.traId and t2.objId!= t1.objId and t1.type=? and t1.objId=?
in tikidblib.php on line 134
Context:
File tiki-index.php
Url tiki-index.php
Query:
s elect t2.objId, t2.lang, p.pageNameas objName from tiki_translated_objects as t1, tiki_translated_objects as t2 LEFT JOIN tiki_pages p ON p.page_id=t2.objId where t1.traId=t2.traId and t2.objId!= t1.objId and t1.type=? and t1.objId=?
Values:
0 wiki page
1 2
Message:
Error Message ERROR: operator does not exist: bigint = character varying LINE 1: ...cts as t2 LEFT JOIN tiki_pages p ON p.page_id=t2.objId...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
The some operation, running on a MySql5 based installation, doesn't happen.
Which is my fault ? What another thing I must check and where ?
Thanks in advance !
Giuseppe