Bug 23267

Summary: Database change from bug 9834 breaks database update from older versions
Product: Koha Reporter: Katrin Fischer <katrin.fischer>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: critical    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 9834    
Bug Blocks:    

Description Katrin Fischer 2019-07-05 06:01:11 UTC
Mirko posted on bug 9834:

(In reply to Mirko Tietgen from comment #21)
> I assume this breaks upgrading the Koha DB schema at DB revision 16.12.00.032
> 
> >[…]
> >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
Comment 1 Katrin Fischer 2019-07-05 06:07:32 UTC

*** This bug has been marked as a duplicate of bug 23265 ***