[Fmsystem-commits] [6531] bkbooking: bug fix sqlstatement in setup

[Kjell Arne Espedal]

Revision: 6531
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=6531
Author:   kjell
Date:     2010-11-02 07:29:35 +0000 (Tue, 02 Nov 2010)
Log Message:
-----------
bkbooking: bug fix sqlstatement in setup

Modified Paths:
--------------
    trunk/booking/setup/tables_update.inc.php

Modified: trunk/booking/setup/tables_update.inc.php
===================================================================
--- trunk/booking/setup/tables_update.inc.php   2010-11-02 07:24:51 UTC (rev 
6530)
+++ trunk/booking/setup/tables_update.inc.php   2010-11-02 07:29:35 UTC (rev 
6531)
@@ -2372,7 +2372,7 @@
 
                $GLOBALS['phpgw_setup']->oProc->m_odb->transaction_begin();
                $GLOBALS['phpgw_setup']->oProc->m_odb->query("ALTER TABLE 
bb_application ADD COLUMN building_name varchar(50) NOT NULL DEFAULT 
'changeme'");
-               $GLOBALS['phpgw_setup']->oProc->m_odb->query("UPDATE 
bb_application SET building_name = b2.name FROM bb_building b2 WHERE EXISTS 
(SELECT 1 FROM bb_building b, bb_application a, bb_application_resource 
ar,bb_resource r WHERE a.activity_id = ar.application_id AND ar.resource_id = 
r.id AND r.building_id = b.id AND b2.id=b.id AND bb_booking.id=bo.id)");
+               $GLOBALS['phpgw_setup']->oProc->m_odb->query("UPDATE 
bb_application SET building_name = b2.name FROM bb_building b2 WHERE EXISTS 
(SELECT 1 FROM bb_building b, bb_application a, bb_application_resource 
ar,bb_resource r WHERE a.activity_id = ar.application_id AND ar.resource_id = 
r.id AND r.building_id = b.id AND b2.id=b.id AND bb_application.id=a.id)");
 
                if($GLOBALS['phpgw_setup']->oProc->m_odb->transaction_commit())
                {