UPGRADING FROM KOHA 3.09 TO 19.11 UPGRADE ISSUES

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

UPGRADING FROM KOHA 3.09 TO 19.11 UPGRADE ISSUES

Josh Getanda
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
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: UPGRADING FROM KOHA 3.09 TO 19.11 UPGRADE ISSUES

Doug Dearden
Hey Josh,

Did you do koha-upgrade-to-3.4 ?

See this wiki entry: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Upgrade_Instructions 

Just a guess.

Doug

-----Original Message-----
From: Koha [mailto:[hidden email]] On Behalf Of Josh Getanda
Sent: Thursday, February 20, 2020 10:39 PM
To: Koha <[hidden email]>
Subject: [Koha] UPGRADING FROM KOHA 3.09 TO 19.11 UPGRADE ISSUES

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
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha