[Koha] 'add basket group' bug in Koha 3.14.6

[Jonathan Druart]

> [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 at 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+s1045719n5798836h45 at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha