Package: egroupware-projectmanager Version: 1.4.002.dfsg-2.1 Severity: important
Hi, on a fresh install with postgres 8.3.1-1 i get this error when opening the projectmanager Database error: Invalid SQL: SELECT *,role_acl,egw_pm_projects.pm_id AS pm_id FROM egw_pm_projects LEFT JOIN +egw_pm_members ON (egw_pm_projects.pm_id=egw_pm_members.pm_id AND member_uid=9) LEFT JOIN egw_pm_roles ON +egw_pm_members.role_id=egw_pm_roles.role_id LEFT JOIN egw_links ON link_app2='projectmanager' AND +link_app1='projectmanager' AND link_id2=egw_pm_projects.pm_id WHERE pm_status='active' AND (pm_access='anonym' +OR pm_access='public' AND pm_creator IN (9) OR pm_access='private' AND pm_creator IN (9) OR +egw_pm_roles.role_acl!=0) AND link_id2 IS NULL ORDER BY pm_modified DESC pgsql Error: -1 (ERROR: operator does not exist: character varying = integer at character 325 HINT: No operator +matches the given name and argument type(s). You might need to add explicit type casts.) File: /usr/share/egroupware/etemplate/inc/class.so_sql.inc.php Line: 730 Function: egw_db::select / so_sql::search / soprojectmanager::search / so_sql::get_rows / +uiprojectmanager::get_rows / nextmatch_widget::pre_process / boetemplate::extensionPreProcess / +etemplate::show_cell / etemplate::show_grid / etemplate::show_cell / etemplate::show / etemplate::exec / +uiprojectmanager::index / ExecMethod(projectmanager.uiprojectmanager.index) Session halted. Everything else seems to work fine. regards --lars -- System Information: Debian Release: 4.0 APT prefers stable APT policy: (998, 'stable'), (90, 'testing') Architecture: amd64 (x86_64) Shell: /bin/sh linked to /bin/dash Kernel: Linux 2.6.18-5-xen-vserver-amd64 Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Versions of packages egroupware-projectmanager depends on: ii egroupware-core 1.4.002.dfsg-2.1 web-based groupware suite - core m ii egroupware-etemplate 1.4.002.dfsg-2.1 web-based groupware suite - widget ii php5-gd 5.2.0-8+etch10 GD module for php5 egroupware-projectmanager recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
