* 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