R32056 - /trunk/projectmanager/inc/class.projectmanager_elements_so.inc.php

Old eGW-svn
1

Author: ralfbecker
New Revision: 32056

URL: http://www.egroupware.org/viewvc/egroupware?rev=32056&view=rev
Log:
fix for PostgreSQL bug #2727 - Project Manager - Can’t add more than 9 projects

Modified:
trunk/projectmanager/inc/class.projectmanager_elements_so.inc.php

Modified: trunk/projectmanager/inc/class.projectmanager_elements_so.inc.php
URL: http://www.egroupware.org/viewvc/egroupware/trunk/projectmanager/inc/class.projectmanager_elements_so.inc.php?rev=32056&r1=32055&r2=32056&view=diff

— trunk/projectmanager/inc/class.projectmanager_elements_so.inc.php (original)
+++ trunk/projectmanager/inc/class.projectmanager_elements_so.inc.php Tue Sep 14 08:19:32 2010
@@ -38,8 +38,8 @@
*/
var $links_extracols = array(
// 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

  •   "CASE WHEN link_app1='projectmanager' AND link_id1=CAST(pm_id AS CHAR) THEN link_app2 ELSE link_app1 END AS pe_app",

  •   "CASE WHEN link_app1='projectmanager' AND link_id1=CAST(pm_id AS CHAR) THEN link_id2 ELSE link_id1 END AS pe_app_id",

  •   "CASE WHEN link_app1='projectmanager' AND link_id1=pm_id THEN link_app2 ELSE link_app1 END AS pe_app",

  •   "CASE WHEN link_app1='projectmanager' AND link_id1=pm_id THEN link_id2 ELSE link_id1 END AS pe_app_id",
  'link_remark AS pe_remark',
    );
    /**
    @@ -76,6 +76,10 @@
    {
    if ($this->read($pe_id)) $this->pm_id = $this->data[‘pm_id’];
    }
  •   }

  •   if ($this->db->Type == 'pgsql')	// PostgreSQL needs cast to varchar (MySQL does NOT allow varchar)

  •   {

  •   	$this->links_extracols = str_replace('pm_id','CAST(pm_id AS VARCHAR)',$this->links_extracols);
  }
    }

Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev

eGroupWare-cvs mailing list
eGroupWare-cvs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-cvs