When creating an instance from an older DB and running koha-upgrade-schema, the following error occurs. >[…] >Upgrade to 16.12.00.030 done (Bug 16344 - Add a circ rule to limit the auto renewals given a specific date) >Upgrade to 16.12.00.031 done (Bug 15108: OAI-PMH provider improvements) >DBD::mysql::st execute failed: Unknown column 'me.item_level_hold' in 'field list' [for Statement "SELECT `me`.`reserve_id`, `me`.`borrowernumber`, `me`.`reservedate`, `me`.`biblionumber`, `me`.`branchcode`, `me`.`notificationdate`, `me`.`reminderdate`, `me`.`cancellationdate`, `me`.`reservenotes`, `me`.`priority`, `me`.`found`, `me`.`timestamp`, `me`.`itemnumber`, `me`.`waitingdate`, `me`.`expirationdate`, `me`.`lowestPriority`, `me`.`suspend`, `me`.`suspend_until`, `me`.`itemtype`, `me`.`item_level_hold` FROM `reserves` `me` WHERE ( ( `found` = ? AND `priority` = ? ) )" with ParamValues: 0='W', 1=0] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. >DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.item_level_hold' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 209
Please link the bugs in cases like this - I didn't find this one :) Closing my duplicate.
*** Bug 23267 has been marked as a duplicate of this bug. ***
(In reply to Katrin Fischer from comment #1) > Please link the bugs in cases like this - I didn't find this one :) > Closing my duplicate. I did, but as "See also" as I was not 100% sure 9834 is to blame. ;)
(In reply to Mirko Tietgen from comment #3) > (In reply to Katrin Fischer from comment #1) > > Please link the bugs in cases like this - I didn't find this one :) > > Closing my duplicate. > > I did, but as "See also" as I was not 100% sure 9834 is to blame. ;) Might just be my morning me is not very awake yet :)
It comes from bug 12063 that is using Koha:: modules in updatedatabase.pl
Created attachment 92029 [details] [review] Bug 23265: (bug 12063 follow-up) Remove Koha::Holds from updatedatabase Test plan: Have a DB that fail the 16.12.00.032 update, then apply this patch and verify the expiration dates RM: Please inforce this rule, no use of Koha:: in updatedatabase!
Created attachment 92576 [details] [review] Bug 23265: (bug 12063 follow-up) Remove Koha::Holds from updatedatabase Test plan: Have a DB that fail the 16.12.00.032 update, then apply this patch and verify the expiration dates RM: Please inforce this rule, no use of Koha:: in updatedatabase! Signed-off-by: Victor Grousset <victor.grousset@biblibre.com>
Thanks, I just stumbled on this issue :)
Created attachment 92612 [details] [review] Bug 23265: (bug 12063 follow-up) Remove Koha::Holds from updatedatabase Test plan: Have a DB that fail the 16.12.00.032 update, then apply this patch and verify the expiration dates RM: Please inforce this rule, no use of Koha:: in updatedatabase! Signed-off-by: Victor Grousset <victor.grousset@biblibre.com> Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Nice work! Pushed to master for 19.11.00
Pushed to 19.05.x for 19.05.04
backported to 18.11.x for 18.11.10
My apologies if this doesn't belong here, but I seem to be having an issue relating to this same section of code. I'm upgrading from a dev install of 3.22, slightly customized so maybe this is unique to me. I've imported the database into a fresh install on 19.05.04 using mariadb 10.1 on ubuntu 18.04, and I get this error and the database update halts when running koha-upgrade-schema: Upgrade to 16.12.00.031 done (Bug 15108: OAI-PMH provider improvements) Not a HASH reference at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 14371. My reserves table doesn't contain anything in expirationdate other than NULL.
Nevermind, I found https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23809 which is the same issue I'm having. I applied that patch and my problem is resolved. Sorry for the noise!