Project Manager error under Ebox 1.5 clean install

[tom345]

Hi,
I get this error when clicking "ProjectManager" in Egroupware. I have created a couple of users under "Users and Groups" Ebox utility. I can reproduce the same error under a clean install of Ebox 1.5 platform and also under Ubuntu 10.4 with the Ebox 1.5 package:

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=2002)  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 (2002) OR pm_access='private' AND pm_creator IN (2002) OR egw_pm_roles.role_acl!=0) AND link_id2 IS NULL ORDER BY pm_modified DESC:

ERROR:  operator does not exist: character varying = integer
LINE 1: ...nager' AND link_app1='projectmanager' AND link_id2=egw_pm_pr...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

Click here to resume your eGroupWare Session.



Am I doing something wrong?

Packages installed:

ii  ebox-antivirus                       1.5.1-0ubuntu1~ppa1~lucid1              eBox - Antivirus
ii  ebox-ca                              1.5.3-0ubuntu1~ppa1~lucid1              eBox - Certification Authority
ii  ebox-ebackup                         1.5-0ubuntu1~ppa1~lucid1                eBox - Backup
ii  ebox-egroupware                      1.5-0ubuntu1~ppa1~lucid1                eBox - Groupware
ii  ebox-firewall                        1.5.3-0ubuntu1~ppa1~lucid1              eBox - Firewall
ii  ebox-mail                            1.5.2-0ubuntu1~ppa1~lucid1              eBox - Mail Service
ii  ebox-monitor                         1.5.3-0ubuntu1~ppa1~lucid1              eBox - Monitor
ii  ebox-network                         1.5.5-0ubuntu1~ppa1~lucid1              eBox - Network Configuration
ii  ebox-objects                         1.5.1-0ubuntu1~ppa1~lucid1              eBox - Network Objects
ii  ebox-office                          1.5-0ubuntu1~ppa1~lucid1                eBox - Office Suite
ii  ebox-openvpn                         1.5.3-1ubuntu1~ppa1~lucid1              eBox - VPN Service
ii  ebox-printers                        1.5-0ubuntu1                            eBox - Printer Sharing
ii  ebox-remoteservices                  1.5.4-0ubuntu1~ppa1~lucid1              eBox - Control Center Client
ii  ebox-samba                           1.5.6-0ubuntu1~ppa1~lucid1              eBox - File Sharing
ii  ebox-services                        1.5.3-0ubuntu1~ppa1~lucid1              eBox - Network Services
ii  ebox-software                        1.5.2-0ubuntu1~ppa1~lucid1              eBox - Software Management
ii  ebox-usersandgroups                  1.5.3-0ubuntu1~ppa1~lucid1              eBox - Users and Groups
ii  ebox-webmail                         1.5.1-0ubuntu1~ppa1~lucid1              eBox - Web Mail Service
ii  ebox-webserver                       1.5.3-0ubuntu1~ppa1~lucid1              eBox - Web Server

[qqwwong]

I got the same error in my freshly installed server with ebox 1.5.1 installer with ebox-groupware 1.5.1-0ubuntu1~ppa1~lucid1.

Does anyone know what I can do to fix it?

Wai

[viktor.biysk]

I found part of code I have written in replay and I faund this:

// postgres 8.3 requires cast as link_idx is varchar and pm_id an
integer, the cast should be no problem for other DB's
        if ($this->db->Type == 'postgres') $pm_id = "CAST($pm_id AS VARCHAR)";
        $join .= " JOIN $this->links_table ON link_app2='projectmanager' AND
link_app1='projectmanager' AND link_id2=$pm_id";

As you can see there is condition: if ($this->db->Type == 'postgres'). After I
have changed to: if ($this->db->Type == 'pgsql') everything works fine.

[tom345]

Hi Viktor, thanks a lot for your answer. I am now familiarized with ebox/egroupware config files so, Could you please tell us which file are you editing?
Thanks!

[viktor.biysk]

Hi, I made changes /usr/share/egroupware/projectmanager/inc/class.projectmanager_so.inc.php

[MOSAiX]

I know this topic is old, but thanks for this badass help!