[Koha] Unable to upgrade to Koha 3.14 due to database version upgrade errors

[Chris Cormack]

* sheldon_tappin (thecarterii at 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 at 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