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

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

Ticket modified by Birgit Becker at 2011/09/20 15:18: 
Tracking System: Bugs
Category: SiteMgr
Version: Trunk
> Status: Closed
Resolution: Fixed
Completed: 100%
Priority: 5 - medium
Created by: Lars Boegild Thomsen
Created on: 2011/05/06 09:43
Assigned to: Ralf Becker, Klaus Leithoff
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 Birgit Becker at 2011/09/20 15:18:
Ticket gets closed, as there haven't been any comments in more than the last 14 days.
----------------------------------------------------------------
: Comment by Klaus Leithoff at 2011/08/23 17:22:
This bug is fixed in our subversion repository now. 
(for all branches down to 1.8)

You can update via subversion with the following commands:
cd /path/to/egroupware 
svn update *  # mind the */asterisk

To check if you have svn installed try running svn version. To install the svn command under Linux install the package "subversion". For Windows you can use eg. TortoiseSVN (http://tortoisesvn.tigris.org).
----------------------------------------------------------------
: Comment by Lars Boegild Thomsen at 2011/05/09 06:40:
Sorry - think I had this one added in the wrong category.



Linked entries:
https://community.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2956&no_popup=1