'add basket group' bug in Koha 3.14.6
Hello Koha community! We were trying out the Acquisitions module of Koha ILS, the version as you can see in subject post is 3.14.6, and is installed in Debian 6.x. Whenever I close a basket wherein we're notified to create a basket group for it with the same name as the Basket name, there is no basket group created. I'm also trying to create a new Basket Group but to no avail. Can anybody confirm this too? Are we missing something? I was able to do this in Koha 3.14.5. Thanks in advance! -- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... Sent from the Koha-general mailing list archive at Nabble.com.
It works here on 3.14.6 and master. Do you have some warnings/errors in the Koha logs? 2014-05-20 12:56 GMT+02:00 schnydszch <eugenegf@yahoo.com>:
Hello Koha community! We were trying out the Acquisitions module of Koha ILS, the version as you can see in subject post is 3.14.6, and is installed in Debian 6.x. Whenever I close a basket wherein we're notified to create a basket group for it with the same name as the Basket name, there is no basket group created. I'm also trying to create a new Basket Group but to no avail. Can anybody confirm this too? Are we missing something? I was able to do this in Koha 3.14.5. Thanks in advance!
-- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi! Where do I see the koha error log? Thanks! On Wednesday, May 21, 2014 6:37 AM, Jonathan Druart <jonathan.druart@biblibre.com> wrote: It works here on 3.14.6 and master. Do you have some warnings/errors in the Koha logs? 2014-05-20 12:56 GMT+02:00 schnydszch <eugenegf@yahoo.com>:
Hello Koha community! We were trying out the Acquisitions module of Koha ILS, the version as you can see in subject post is 3.14.6, and is installed in Debian 6.x. Whenever I close a basket wherein we're notified to create a basket group for it with the same name as the Basket name, there is no basket group created. I'm also trying to create a new Basket Group but to no avail. Can anybody confirm this too? Are we missing something? I was able to do this in Koha 3.14.5. Thanks in advance!
-- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
I don't know, it's depend on how you installed Koha. 2014-05-21 16:31 GMT+02:00 eugene jose espinoza <eugenegf@yahoo.com>:
Hi! Where do I see the koha error log? Thanks!
On Wednesday, May 21, 2014 6:37 AM, Jonathan Druart <jonathan.druart@biblibre.com> wrote:
It works here on 3.14.6 and master. Do you have some warnings/errors in the Koha logs?
2014-05-20 12:56 GMT+02:00 schnydszch <eugenegf@yahoo.com>:
Hello Koha community! We were trying out the Acquisitions module of Koha ILS, the version as you can see in subject post is 3.14.6, and is installed in Debian 6.x. Whenever I close a basket wherein we're notified to create a basket group for it with the same name as the Basket name, there is no basket group created. I'm also trying to create a new Basket Group but to no avail. Can anybody confirm this too? Are we missing something? I was able to do this in Koha 3.14.5. Thanks in advance!
-- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Okay, got the error log. it's in /var/log/koha. We're using the debian package. It seems this is the culprit: [Wed May 21 08:35:02 2014] [error] [client 58.71.18.113] [Wed May 21 08:35:02 2014] basket.pl: Use of uninitialized value in subroutine entry at /usr/share/koha/intranet/cgi-bin/acqui/basket.pl line 322., referer: http://hreplib.infosolutionphilippines.com:8080/cgi-bin/koha/acqui/bookselle... [Wed May 21 08:35:34 2014] [error] [client 58.71.18.113] [Wed May 21 08:35:34 2014] basketgroup.pl: DBD::mysql::st execute failed: Unknown column 'billingplace' in 'field list' at /usr/share/koha/lib/C4/Acquisition.pm line 875., referer: http://hreplib.infosolutionphilippines.com:8080/cgi-bin/koha/acqui/basketgroup.pl?op=add&booksellerid=8 [Wed May 21 08:35:34 2014] [error] [client 58.71.18.113] [Wed May 21 08:35:34 2014] basketgroup.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_hreplib`.`aqbasket`, CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE) at /usr/share/koha/lib/C4/Acquisition.pm line 881., referer: But don't know what to do next On Wednesday, May 21, 2014 8:10 AM, Jonathan Druart [via Koha] <ml-node+s1045719n5798836h45@n5.nabble.com> wrote: It works here on 3.14.6 and master. Do you have some warnings/errors in the Koha logs? 2014-05-20 12:56 GMT+02:00 schnydszch <[hidden email]>:
Hello Koha community! We were trying out the Acquisitions module of Koha ILS, the version as you can see in subject post is 3.14.6, and is installed in Debian 6.x. Whenever I close a basket wherein we're notified to create a basket group for it with the same name as the Basket name, there is no basket group created. I'm also trying to create a new Basket Group but to no avail. Can anybody confirm this too? Are we missing something? I was able to do this in Koha 3.14.5. Thanks in advance!
-- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org [hidden email] http://lists.katipo.co.nz/mailman/listinfo/koha_____________________________... Koha mailing list http://koha-community.org [hidden email] http://lists.katipo.co.nz/mailman/listinfo/koha
________________________________ If you reply to this email, your message will be added to the discussion below:http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... To unsubscribe from 'add basket group' bug in Koha 3.14.6, click here. NAML -- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... Sent from the Koha-general mailing list archive at Nabble.com.
[Wed May 21 08:35:34 2014] [error] [client 58.71.18.113] [Wed May 21 08:35:34 2014] basketgroup.pl: DBD::mysql::st execute failed: Unknown column 'billingplace' in 'field list' at /usr/share/koha/lib/C4/Acquisition.pm line 875., referer: http://hreplib.infosolutionphilippines.com:8080/cgi-bin/koha/acqui/basketgroup.pl?op=add&booksellerid=8
This error is raised by mysql. It means that the aqbasketgroup.billingplace field does not exist in your DB. This field has been introduced in 3.01.00.097. In the mysql CLI, you can execute the following query to show the structure of the aqbasketgroups table: show create table aqbasketgroups; If the field exists, try to restart mysql. 2014-05-21 17:19 GMT+02:00 schnydszch <eugenegf@yahoo.com>:
Okay, got the error log. it's in /var/log/koha. We're using the debian package. It seems this is the culprit: [Wed May 21 08:35:02 2014] [error] [client 58.71.18.113] [Wed May 21 08:35:02 2014] basket.pl: Use of uninitialized value in subroutine entry at /usr/share/koha/intranet/cgi-bin/acqui/basket.pl line 322., referer: http://hreplib.infosolutionphilippines.com:8080/cgi-bin/koha/acqui/bookselle... [Wed May 21 08:35:34 2014] [error] [client 58.71.18.113] [Wed May 21 08:35:34 2014] basketgroup.pl: DBD::mysql::st execute failed: Unknown column 'billingplace' in 'field list' at /usr/share/koha/lib/C4/Acquisition.pm line 875., referer: http://hreplib.infosolutionphilippines.com:8080/cgi-bin/koha/acqui/basketgroup.pl?op=add&booksellerid=8 [Wed May 21 08:35:34 2014] [error] [client 58.71.18.113] [Wed May 21 08:35:34 2014] basketgroup.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_hreplib`.`aqbasket`, CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE) at /usr/share/koha/lib/C4/Acquisition.pm line 881., referer: But don't know what to do next
On Wednesday, May 21, 2014 8:10 AM, Jonathan Druart [via Koha] <ml-node+s1045719n5798836h45@n5.nabble.com> wrote:
It works here on 3.14.6 and master. Do you have some warnings/errors in the Koha logs?
2014-05-20 12:56 GMT+02:00 schnydszch <[hidden email]>:
Hello Koha community! We were trying out the Acquisitions module of Koha ILS, the version as you can see in subject post is 3.14.6, and is installed in Debian 6.x. Whenever I close a basket wherein we're notified to create a basket group for it with the same name as the Basket name, there is no basket group created. I'm also trying to create a new Basket Group but to no avail. Can anybody confirm this too? Are we missing something? I was able to do this in Koha 3.14.5. Thanks in advance!
-- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org [hidden email] http://lists.katipo.co.nz/mailman/listinfo/koha_____________________________... Koha mailing list http://koha-community.org [hidden email] http://lists.katipo.co.nz/mailman/listinfo/koha
________________________________
If you reply to this email, your message will be added to the discussion below:http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... To unsubscribe from 'add basket group' bug in Koha 3.14.6, click here. NAML
-- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
It seems I'm missing some columns, where do I get an sql file for this? thanks and cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... Sent from the Koha-general mailing list archive at Nabble.com.
The column existed in 3.14.5 but not in 3.14.6? 2014-05-22 10:55 GMT+02:00 schnydszch <eugenegf@yahoo.com>:
It seems I'm missing some columns, where do I get an sql file for this? thanks and cheers!
-- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
I have two Koha instances, and just compared them, it seems, I'll just copy the aqbasketgroups structure of the working Koha instance into the offending Koha instance. Cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798... Sent from the Koha-general mailing list archive at Nabble.com.
participants (3)
-
eugene jose espinoza -
Jonathan Druart -
schnydszch