* sheldon_tappin (thecarte...@hotmail.com) wrote: > Hi All, > > We are trying to upgrade our Koha version from Koha 3.10.00 to 3.14. > > We have Koha 3.14 installed on a test server and we the production > installation with the older database online-- > Koha 3.10.00. > > During the web installation on the test server, whenever Koha reaches the > update database page , it is generating an error message: > > "Update errors : > > [Tue Jan 21 15:37:05 2014] updatedatabase.pl: DBD::mysql::db do failed: > Duplicate column name 'borrowernumber' at > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line > 7224. > [Tue Jan 21 15:37:05 2014] updatedatabase.pl: DBD::mysql::db do failed: > Error on rename of './koha/patronimage' to './koha/#sql2-646b-96' (errno: > 152) at > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line > 7243. > [Tue Jan 21 15:37:05 2014] updatedatabase.pl: DBD::mysql::db do failed: > Error on rename of './koha/patronimage' to './koha/#sql2-646b-96' (errno: > 152) at > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line > 7243. > " > > As a result, we are unable to proceed to the log in page. > > Any help in fixing the above issue, will be most welcomed.
https://stackoverflow.com/questions/5343406/sql-foreign-key-constraint-error-1025-152 Looks like there is a foreign key issue, I would log a bug about this at bugs.koha-community.org Chris > > Best Regards, > Sheldon > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Unable-to-upgrade-to-Koha-3-14-due-to-database-version-upgrade-errors-tp5785293.html > Sent from the Koha-general mailing list archive at Nabble.com. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
