Bugzilla – Attachment 9542 Details for
Bug 5795
Missing ReservesControlBranch system pref in database installer
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 5795 Update the database as follow-up If sys pref ReservesControlBranch has null then update the table to insert a ItemHomeLibrary as value
Bug-5795-Update-the-database-as-follow-up-If-sys-p.patch (text/plain), 2.22 KB, created by
Chris Cormack
on 2012-05-14 00:13:01 UTC
(
hide
)
Description:
Bug 5795 Update the database as follow-up If sys pref ReservesControlBranch has null then update the table to insert a ItemHomeLibrary as value
Filename:
MIME Type:
Creator:
Chris Cormack
Created:
2012-05-14 00:13:01 UTC
Size:
2.22 KB
patch
obsolete
>From 3b20cc89a1ac998cafadce649783bb3b5123a79a Mon Sep 17 00:00:00 2001 >From: Amit Gupta <amit.gupta@osslabs.biz> >Date: Tue, 8 May 2012 16:50:04 +0530 >Subject: [PATCH] Bug 5795 Update the database as follow-up If sys pref > ReservesControlBranch has null then update the table to > insert a ItemHomeLibrary as value > >To Test: >1) Go to mysql use koha database >2) select * from systempreferences where variable = 'ReservesControlBranch'; Check if value set to ItemHomeLibrary. >+-----------------------+-----------------+-------------------------------+-------------------------------------------------+--------+ >| variable | value | options | explanation | type | >+-----------------------+-----------------+-------------------------------+-------------------------------------------------+--------+ >| ReservesControlBranch | ItemHomeLibrary | ItemHomeLibrary|PatronLibrary | Branch checked for members reservations rights. | Choice | >+-----------------------+-----------------+-------------------------------+-------------------------------------------------+--------+ > >Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz> >--- > installer/data/mysql/updatedatabase.pl | 10 ++++++++++ > 1 file changed, 10 insertions(+) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 035e1e6..ab61677 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -5239,6 +5239,16 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { > SetVersion($DBversion); > } > >+$DBversion = "3.09.00.XXX"; >+if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { >+ unless(C4::Context->preference('ReservesControlBranch')){ >+ $dbh->do("INSERT INTO `systempreferences` (variable,value,options,explanation,type) VALUES ('ReservesControlBranch','ItemHomeLibrary','ItemHomeLibrary|PatronLibrary','Branch checked for members reservations rights.','Choice')"); >+ } >+ print "Upgrade to $DBversion done (Insert ReservesControlBranch systempreference into systempreferences table )\n"; >+ SetVersion($DBversion); >+} >+ >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >-- >1.7.9.5
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 5795
:
9193
|
9320
|
9397
|
9451
|
9541
|
9542
|
9695