[Koha] database upgrade errors (3.0.5-->3.4.x)

Christopher Chagal chagal at amphilsoc.org
Wed Jun 1 01:58:57 NZST 2011

Hello all,

Just looking for reassurance that the errors I'm seeing in my database
upgrade output are nothing to worry about. Most of them are messages about
tables, columns and entries already existing in the database. There is one
that I've highlighted below that looks more worrisome.


Line 161:

DBD::mysql::db do failed: Cannot add or update a child row: a foreign key
constraint fails (`koha/#sql-755_1d`, CONSTRAINT
`subscriptionroutinglist_ibfk_2` FOREIGN KEY (`subscriptionid`) REFERENCES
`subscription` (`subscriptionid`) ON DELETE CASCADE ON UPDATE CASCADE) at
installer/data/mysql/updatedatabase.pl line 3835.

1. Am I correct about the duplicate tables, columns & entries errors not
being a concern?
2. We don't use the serials routing list; can I ignore this error?

Thanks for your time!


Christopher Chagal
Assistant Technical Librarian / Assistant IT Officer

American Philosophical Society - Library Hall
105 South Fifth Street
Philadelphia, PA 19106-3386
Tel. (215) 599-4299

chagal at amphilsoc.org

Main Library number: (215) 440-3400
APS website: www.amphilsoc.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20110531/bceceb63/attachment.htm 

More information about the Koha mailing list