Error while using Acquisition Module vendors search (Koha 18.11.05 on Ubuntu 18.04 LTS)
Dear All Ref to Bug: 22869 I got the following error message while searching a vendor (which is available) or adding a new vendor: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081. I've migrated database from an old version to 18.11.05 (Ubuntu 18.04 LTS). Intranet Error log says: [Thu May 09 01:31:31.751639 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: DBD::mysql::st execute failed: Out of sort memory, consider increasing server sort buffer size [for Statement ": /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.752809 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SELECT aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753108 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(aqorders.quantity) AS total_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753281 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753555 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF ( aqorders.orderstatus = 'cancelled', aqorders.quantity, 0 ): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753784 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS total_items_cancelled,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754027 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: COUNT(DISTINCT aqorders.biblionumber) AS total_biblios,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754164 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754361 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754741 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754920 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755064 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755235 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS expected_items: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755404 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: FROM aqbasket: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755786 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.756914 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: WHERE booksellerid = ? GROUP BY aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items HAVING (closedate IS NULL OR (: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757067 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757268 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757644 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757851 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757993 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762276 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) > 0))" with ParamValues: 0=1] at /usr/share/koha/lib/C4/Acquisition.pm line 705.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762667 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.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.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl Screenshot may please be found at: https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89479 Any help/advice would be appreciated, pl. Regards, Ata ur Rehman NCP - Islamabad
Dear Ata ur Rehmann, I have seen this error message in Koha 18.05 as well. In our case the problem was solved increasing the "sort_buffer_size" configuration parameter of mysql. Adding/changing the parameter sort_buffer_size = 2M to/in the [mysqld]-section of the mysql-server configuration (typically /etc/mysql/my.cnf) solved the problem. After the change mysql must be restarted to make use of the parameter change. Best regards, Roger -- LMSCloud GmbH Roger Großmann - Geschäftsführer Konrad-Zuse-Platz 8 - D-81829 München t +49 (0)89 207042-620 m +49 (0)171-2194775 f +49 (0)89 207042-623 e roger.grossmann@lmscloud.de w www.lmscloud.de
Am 12.05.2019 um 13:19 schrieb Ata ur Rehman <ata.rehman@gmail.com>:
Dear All
Ref to Bug: 22869
I got the following error message while searching a vendor (which is available) or adding a new vendor:
Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081.
I've migrated database from an old version to 18.11.05 (Ubuntu 18.04 LTS). Intranet Error log says:
[Thu May 09 01:31:31.751639 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: DBD::mysql::st execute failed: Out of sort memory, consider increasing server sort buffer size [for Statement ": /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.752809 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SELECT aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753108 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(aqorders.quantity) AS total_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753281 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753555 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF ( aqorders.orderstatus = 'cancelled', aqorders.quantity, 0 ): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753784 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS total_items_cancelled,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754027 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: COUNT(DISTINCT aqorders.biblionumber) AS total_biblios,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754164 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754361 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754741 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754920 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755064 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755235 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS expected_items: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755404 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: FROM aqbasket: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755786 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.756914 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: WHERE booksellerid = ? GROUP BY aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items HAVING (closedate IS NULL OR (: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757067 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757268 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757644 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757851 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757993 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762276 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) > 0))" with ParamValues: 0=1] at /usr/share/koha/lib/C4/Acquisition.pm line 705.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762667 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.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.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
Screenshot may please be found at: https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89479
Any help/advice would be appreciated, pl.
Regards,
Ata ur Rehman
NCP - Islamabad _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Ata, I think the key to your issue is the first error on your list. Mysql is lacking of memory; therefore it is unable to run your queries. You can use these two script to verify this condition: https://www.geeek.org/mysqltuner-outil-optimisation-mysql-155.html https://github.com/major/MySQLTuner-perl And/or mtop Regards, Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com Le dim. 12 mai 2019 à 06:20, Ata ur Rehman <ata.rehman@gmail.com> a écrit :
Dear All
Ref to Bug: 22869
I got the following error message while searching a vendor (which is available) or adding a new vendor:
Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081.
I've migrated database from an old version to 18.11.05 (Ubuntu 18.04 LTS). Intranet Error log says:
[Thu May 09 01:31:31.751639 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: DBD::mysql::st execute failed: Out of sort memory, consider increasing server sort buffer size [for Statement ": /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.752809 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SELECT aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753108 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(aqorders.quantity) AS total_items,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753281 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753555 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF ( aqorders.orderstatus = 'cancelled', aqorders.quantity, 0 ): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.753784 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS total_items_cancelled,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754027 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: COUNT(DISTINCT aqorders.biblionumber) AS total_biblios,: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754164 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754361 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754741 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.754920 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755064 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755235 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) AS expected_items: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755404 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: FROM aqbasket: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.755786 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.756914 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: WHERE booksellerid = ? GROUP BY aqbasket.basketno, aqbasket.basketname, aqbasket.note, aqbasket.booksellernote, aqbasket.contractnumber, aqbasket.creationdate, aqbasket.closedate, aqbasket.booksellerid, aqbasket.authorisedby, aqbasket.booksellerinvoicenumber, aqbasket.basketgroupid, aqbasket.deliveryplace, aqbasket.billingplace, aqbasket.branch, aqbasket.is_standing, aqbasket.create_items HAVING (closedate IS NULL OR (: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757067 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: SUM(: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757268 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: IF(aqorders.datereceived IS NULL: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757644 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00'): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757851 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , aqorders.quantity: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.757993 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: , 0): /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762276 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.pl: ) > 0))" with ParamValues: 0=1] at /usr/share/koha/lib/C4/Acquisition.pm line 705.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl [Thu May 09 01:31:31.762667 2019] [cgi:error] [pid 18056] [client 192.168.8.104:55296] AH01215: [Thu May 9 01:31:31 2019] booksellers.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.: /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl, referer: http://192.168.8.106:8001/cgi-bin/koha/acqui/acqui-home.pl
Screenshot may please be found at: https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89479
Any help/advice would be appreciated, pl.
Regards,
Ata ur Rehman
NCP - Islamabad _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Alvaro Cornejo -
Ata ur Rehman -
Roger Grossmann