|
From: <tr...@eg...> - 2009-02-22 13:04:01
|
Ticket modified by Wojciech Pieczara at 2009/02/22 14:06 Tracking System: Bugs Category: Projectmanager Version: Version 1.6.001 Status: Open Completed: 0% Priority: 5 - medium Created By: Wojciech Pieczara Assigned to: Ralf Becker Summary: #1937 - Subprojects are displayed as mainprojects eGW on openSuSE 11.0 with PostgreSQL 8.3 After creating more than 10 projects (sub or main), next subprojects were recognized as mainprojects. It happens because of wrong CAST in file class.projectmanager_so.inc.php: // 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 $join .= " JOIN $this->links_table ON link_app2='projectmanager' AND link_app1='projectmanager' AND link_id2=CAST($this->table_name.pm_id AS CHAR)"; In PostgreSQL above cast will make 44(int) => "4"(char). When I changed cast to TEXT it works fine. ---------------------------------------------------------------- > Comment by Wojciech Pieczara at 2009/02/22 14:06: My solution works for project tree view, but I have noticed, that it made mess in subproject links (from project elements list). Finally I have changed DBMS to mysql and now works fine. Linked entries: http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=1937&no_popup=1 |