> [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 <eugen...@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/booksellers.pl > [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+s1045719n5798836...@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-tp5798519.html >> 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-tp5798519p5798836.html > 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-tp5798519p5798843.html > 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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
