From: <tr...@eg...> - 2011-05-09 04:39:29
|
Ticket modified by Lars Boegild Thomsen at 2011/05/09 06:39 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. linked entries: http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2956&no_popup=1 |