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
-
- Software error:
- 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.
-
-
- For help, please send mail to the webmaster (mailto:[no
address given]">[no address given]), giving this error message
- and the time and date of the error.
-
-
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.blo...@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.blo...@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.orgk...@lists.katipo.co.nzhttps://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
--
Dept. of Software Services Staff
University of Guyana
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
