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

--- Comment #310 from David Cook <[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to