postgres7 error: operator does not exist
- 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
- 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:
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...
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: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 (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 1672
- Created
- Thursday 03 April, 2008 18:24:36 GMT-0000
by Unknown - LastModif
- Saturday 08 August, 2009 20:03:32 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- fresh opening of tiki home page tiki-index (I removed a warning) is it OK
- Tracker with field type "Numeric" won't
- tiki 25.1 Database 'xxxx'. Unable to connect to database (when 25.0 will connect)
- Kanban plugin; the Swimlane field throw an error if using a category field type
- Kanban plugin: Error if the fields Description and Swimlane are empty
;){kind=link}
;){kind=link}