Hi, Please below errors when I try upgrading my database to the most current of KOHA then advise what could be the issue. Thanks in advance.
Update report : - Status: 500 - Content-type: text/html - - <h1>Software error:</h1> - <pre>Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081. - </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 Feb 20 14:40:34 2020] updatedatabase.pl: DBD::mysql::db do failed: Table 'aqinvoices' already exists [for Statement " - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: CREATE TABLE aqinvoices ( - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: invoiceid int(11) NOT NULL AUTO_INCREMENT, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: invoicenumber mediumtext NOT NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: booksellerid int(11) NOT NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: shipmentdate date default NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: billingdate date default NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: closedate date default NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: shipmentcost decimal(28,6) default NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: shipmentcost_budgetid int(11) default NULL, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: PRIMARY KEY (invoiceid), - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE, - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: ) ENGINE=InnoDB DEFAULT CHARSET=utf8 - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5916. - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: DBD::mysql::st execute failed: Unknown column 'aqorders.booksellerinvoicenumber' in 'field list' [for Statement " - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: SELECT aqorders.booksellerinvoicenumber AS invoicenumber, aqbasket.booksellerid, aqorders.datereceived - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: FROM aqorders - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: LEFT JOIN aqbasket ON aqorders.basketno = aqbasket.basketno - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: WHERE aqorders.booksellerinvoicenumber IS NOT NULL - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: AND aqorders.booksellerinvoicenumber != '' - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: GROUP BY aqorders.booksellerinvoicenumber - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5941. - [Thu Feb 20 14:40:34 2020] updatedatabase.pl: 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 https://lists.katipo.co.nz/mailman/listinfo/koha
