[eGroupWare-tracker] #1937 - Subprojects are displayed as mainprojects

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

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