Loading...
 
Multilingual/i18n

Multilingual/i18n

Forum List Topic List

Forums » Multilingual/i18n » postgres7 error: operator does not exist
 
Thread actions
PDF Print this page
  • Print all pages

    • postgres7 error: operator does not exist

    Posted by gsorce posts: 3 ☆

    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 (...)

    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

    Reads: 947
    Link
    Posted by gsorce posts: 3 ☆

    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.

    Link