Bugzilla – Attachment 25154 Details for
Bug 11384
Koha should not use "ctid" as a column name
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[3.14.x]Bug 11384: (follow-up) test if table exists in update database
Bug-11384-follow-up-test-if-table-exists-in-update.patch (text/plain), 1.22 KB, created by
Fridolin Somers
on 2014-02-08 08:54:54 UTC
(
hide
)
Description:
[3.14.x]Bug 11384: (follow-up) test if table exists in update database
Filename:
MIME Type:
Creator:
Fridolin Somers
Created:
2014-02-08 08:54:54 UTC
Size:
1.22 KB
patch
obsolete
>From 7261b1c0ad27a17c5b81e66e9bdb2a60d59bab77 Mon Sep 17 00:00:00 2001 >From: Fridolin Somers <fridolin.somers@biblibre.com> >Date: Sat, 8 Feb 2014 09:52:07 +0100 >Subject: [PATCH] Bug 11384: (follow-up) test if table exists in update > database > >Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com> >--- > installer/data/mysql/updatedatabase.pl | 8 +++++--- > 1 file changed, 5 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 3d8307e..01a33da 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -7827,9 +7827,11 @@ if ( CheckVersion($DBversion) ) { > > $DBversion = "3.14.01.002"; > if ( CheckVersion($DBversion) ) { >- $dbh->do(q{ >- ALTER TABLE collections_tracking CHANGE ctId collections_tracking_id integer(11) NOT NULL auto_increment; >- }); >+ if ( TableExists('collections_tracking') ) { >+ $dbh->do(q{ >+ ALTER TABLE collections_tracking CHANGE ctId collections_tracking_id integer(11) NOT NULL auto_increment; >+ }); >+ } > print "Upgrade to $DBversion done (Bug 11384) - change name of collections_tracker.ctId column)\n"; > SetVersion ($DBversion); > } >-- >1.8.3.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 11384
:
23434
|
23435
|
23769
|
23770
|
23776
|
23777
| 25154