[Koha] Failed to upgrade koha 3.09.00050

A.K.M. Nurul Alam nalamapu at aim.com
Fri Nov 11 21:19:09 NZDT 2022


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.


More information about the Koha mailing list