[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [6531] bkbooking: bug fix sqlstatement in setup
From: |
Kjell Arne Espedal |
Subject: |
[Fmsystem-commits] [6531] bkbooking: bug fix sqlstatement in setup |
Date: |
Tue, 02 Nov 2010 07:29:35 +0000 |
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())
{
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [6531] bkbooking: bug fix sqlstatement in setup,
Kjell Arne Espedal <=