Loading...
 
Skip to main content

postgres7 error: operator does not exist

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
postgres7 error: operator does not exist
Version
1.9.x
Category
  • Error
Feature
i18n (Multilingual, l10n, Babelfish)
Database independence (Non-Mysql, ADOdb Postgres, Oracle, etc)
Resolution status
Out of Date
Submitted by
gsorce
Lastmod by
Kissaki
Rating
(0)
Description

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 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: select t2."objId", t2."lang", p."pageName"as "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 C:\xampp\htdocs\tikiwiki\lib\tikidblib.php on line 134

Context:
File tiki-index.php
Url tiki-index.php
Query:
select t2."objId", t2."lang", p."pageName"as "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

Solution

Please upgrade to a recent version of tiki.
If the problem persists, please add a new tracker item.

Importance
5
Priority
25
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
1672
Created
Thursday 03 April, 2008 18:24:36 UTC
by Unknown
LastModif
Saturday 08 August, 2009 20:03:32 UTC


Show PHP error messages