* sheldon_tappin (thecarterii@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... 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-data... 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