Thanks for your feedback. Please see below the errors from updatedatabase.pl Regards, Sekhar Mallampati +++++++++++++++++++++++++++++++++++++++ Updating database structure Update report : - Status: 500 - Content-type: text/html - - <h1>Software error:</h1> - <pre>DBD::mysql::db do failed: Can't DROP 'patronimage_fk1'; check that column/key exists [for Statement " - ALTER TABLE patronimage DROP FOREIGN KEY patronimage_fk1 - "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/ updatedatabase.pl line 7291. - </pre> - <p> - For help, please send mail to the webmaster (<a href="mailto:[no address given]">[no address given]</a>), giving this error message - and the time and date of the error. - - </p> Update errors : - [Thu May 24 16:08:16 2018] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'borrowernumber' [for Statement " - [Thu May 24 16:08:16 2018] updatedatabase.pl: ALTER TABLE patronimage ADD borrowernumber INT( 11 ) NULL FIRST - [Thu May 24 16:08:16 2018] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7272. - [Thu May 24 16:08:16 2018] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'patronimage_fk1'; check that column/key exists [for Statement " - [Thu May 24 16:08:16 2018] updatedatabase.pl: ALTER TABLE patronimage DROP FOREIGN KEY patronimage_fk1 - [Thu May 24 16:08:16 2018] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7291. - [Thu May 24 16:08:16 2018] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'patronimage_fk1'; check that column/key exists [for Statement " - [Thu May 24 16:08:16 2018] updatedatabase.pl: ALTER TABLE patronimage DROP FOREIGN KEY patronimage_fk1 - [Thu May 24 16:08:16 2018] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7291. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ On Thu, May 24, 2018 at 4:44 PM, Philippe Blouin < philippe.blouin@inlibro.com> wrote:
Hi Sekhar,
Upgrading from 3.12 is usually ok. Could you detail the errors you encounter?
Exporting/importing the biblios also theoratically works fine, but some versions have had glitches preventing it. Still, updatedatabase.pl should work unless you have customized the DB.
Philippe Blouin, Responsable du développement informatique
Tél. : (888) 604-2627 philippe.blouin@inLibro.com inLibro | pour esprit libre | www.inLibro.com On 05/24/2018 04:38 PM, Help Desk DSS, UG wrote:
Hi,
This is Sekhar from University of Guyana. I had sent an email few years back.
We are trying to upgrade from Koha 3.12 to Koha 17.11 and encountering problems in updating database schema. These SQL errors are reported fromupdatedatabase.pl
I am wondering why can't we export the biblios and items data in MARC format and import them back into new Koha installation using MARC Management.
The only issue with this approach is circulation data. I am hoping that we can get around this by using Koha Offline Circulation tool.
Your feedback is much appreciated.
Thanks, Sekhar Mallampati University of Guyana _______________________________________________ Koha mailing list http://koha-community.orgKoha@lists.katipo.co.nzhttps://lists.katipo.co.nz/m...
-- Dept. of Software Services Staff University of Guyana