Dear Community,I am trying to upgrade koha 3.09.00050. Since it's very old version, I installed Koha 16.05 and run upgrade command. It shows failed message like mentioned at the bottom of this message. I have manually deleted 'aqinvoices' table and inserted 'booksellerinvoicenumber' under 'aqorders' table. It works fine and upgraded successfully to 16.05 version. But while exporting to marc file, a number of record is found missing. Now, what is the best way to upgrade this ancient version of Koha 3.0.00050? And if my way was correct, how to export all marc data? Thank you. Nurul Alam Failed message:sudo koha-upgrade-schema library Upgrading database schema for library DBD::mysql::db do failed: Table 'aqinvoices' already exists [for Statement " CREATE TABLE aqinvoices ( invoiceid int(11) NOT NULL AUTO_INCREMENT, invoicenumber mediumtext NOT NULL, booksellerid int(11) NOT NULL, shipmentdate date default NULL, billingdate date default NULL, closedate date default NULL, shipmentcost decimal(28,6) default NULL, shipmentcost_budgetid int(11) default NULL, PRIMARY KEY (invoiceid), CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5915. DBD::mysql::st execute failed: Unknown column 'aqorders.booksellerinvoicenumber' in 'field list' [for Statement " SELECT aqorders.booksellerinvoicenumber AS invoicenumber, aqbasket.booksellerid, aqorders.datereceived FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno = aqbasket.basketno WHERE aqorders.booksellerinvoicenumber IS NOT NULL AND aqorders.booksellerinvoicenumber != '' GROUP BY aqorders.booksellerinvoicenumber "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5940. Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081. _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
