[eGroupWare-tracker] Bugs #2956: SQL Error (on PostgreSQL)

[<tr...@eg...>]

Ticket modified by Lars Boegild Thomsen at 2011/05/09 06:40
Tracking System: Bugs
Category: SiteMgr
Version: Trunk
Status: Open
Resolution: None
Completed: 0%
Priority: 5 - medium
Created By: Lars Boegild Thomsen
Created on: 2011/05/06 09:43
Assigned to: Ralf Becker
Summary: #2956 - SQL Error (on PostgreSQL)
The following SQL error when trying to add a "login" module:

Invalid SQL: SELECT t1.block_id AS id,area,cat_id,page_id,area,t1.module_id,module_name,sort_order,title,viewable AS view FROM egw_sitemgr_blocks AS t1 LEFT JOIN egw_sitemgr_modules as t2 ON t1.module_id=t2.module_id LEFT JOIN egw_sitemgr_blocks_lang AS t3 ON (t1.block_id=t3.block_id AND t3.lang=false) WHERE t1.block_id=3:
ERROR:  operator does not exist: character varying = boolean
LINE 1: ...lang AS t3 ON (t1.block_id=t3.block_id AND t3.lang=false) WH...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

The ^  appear below the last t3.lang=false statement.
----------------------------------------------------------------
> Comment by Lars Boegild Thomsen at 2011/05/09 06:40:
Sorry - think I had this one added in the wrong category.



linked entries:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2956&no_popup=1