[Koha-bugs] [Bug 15516] Allow to place a hold on first available item from a group of titles

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15516

--- Comment #310 from David Cook <dcook at prosentient.com.au> ---
Comment on attachment 120368
  --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=120368
Bug 15516: Database and installer updates

Review of attachment 120368:
 --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=15516&attachment=120368)
-----------------------------------------------------------------

::: installer/data/mysql/kohastructure.sql
@@ +4350,3 @@
>    CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
>    CONSTRAINT `reserves_ibfk_5` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE,
>    CONSTRAINT `reserves_ibfk_6` FOREIGN KEY (`desk_id`) REFERENCES `desks` (`desk_id`) ON DELETE SET NULL ON UPDATE CASCADE

There is a missing comma here which causes this error:

Something went wrong loading file
/kohadevbox/koha/installer/data/mysql/kohastructure.sql ([SQL ERROR]: CREATE
TABLE `reserves` (

-- 
You are receiving this mail because:
You are watching all bug changes.