[Koha] Acquisitions error : Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2054

[Jane Chang]

Hi,

After several days of chatting with KOHA on IRC and looking at the problem,
there's still not a definite solution to this acquisitions issue.  The
advice I received is to upgrade to Debian 8 and upgrade to 16.11.  I know
that eventually Debian upgrade is a must, but since the problem exits
internally in my database, would it be carried over when we do the upgrade?
Do you think it's possible that we can downgrade from current 16.05 to 3.22
and maybe find some hints there? Our IT kinda tried to dig into the
problem. He went to /usr/lib/perl5/DBI.pm line 2054, and guessing that
there's something wrong in the "$sth" that's not pulling out the command
when running. Hopefully I'm making sense here. Any input or help is much
appreciated.

Thanks!

Jane Chang
Christian Witness Theological Seminary
1975 Concourse Dr.
San Jose, CA 95131
(408)433-2280 x109

On Wed, Jan 25, 2017 at 9:08 AM, Jane Chang <jane.chang at cwts.edu> wrote:

> Hi Jonathan and all,
>
> Currently using 16.05.07, an upgrade from 3.18.  It was working fine
> before the upgrade.
> I was trying to search for a vendor in acquisitions.  I typed in the
> vendor name, pressed submit, and this error returned:
>
> Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2054.
>
> Then I tried just leaving the search blank and pressed submit. Same error.
>
> I also have funds listed in the acquisitions page.  Tried to click on the dollar amount on the "ordered"  and "spent" columns, and the follow error returned:
>
> An error occurred fetching records: Table 'kohadb.aqorders' doesn't exist at /usr/share/koha/intranet/cgi-bin/acqui/spent.pl line 88.
>
> It would be great if these errors can be fixed.
>
>
> Thanks!
>
>
> Jane Chang
> Christian Witness Theological Seminary
> 1975 Concourse Dr.
> San Jose, CA 95131
> (408)433-2280 x109 <(408)%20433-2280>
>
> On Wed, Jan 25, 2017 at 12:03 AM, Jonathan Druart <
> jonathan.druart at bugs.koha-community.org> wrote:
>
>> Hi Jane,
>>
>> We need more information to help you.
>> What is the version of Koha you are using? How did you install it?
>> Is it a new error you get (after an upgrade) or just after you installed
>> Koha?
>> Then give us a step by step plan to recreate the issue, and if possible
>> the
>> error you get in the Koha log file.
>>
>> Regards,
>> Jonathan
>>
>> On Tue, 24 Jan 2017 at 23:15 Jane Chang <jane.chang at cwts.edu> wrote:
>>
>> > Hi all,
>> >
>> > I need some urgent help on this following error:
>> >
>> > Can't use an undefined value as an ARRAY reference at
>> > /usr/lib/perl5/DBI.pm line 2054
>> >
>> > I was trying to look for a vendor in Acquisitions, and the above error
>> > showed up.  Please help.
>> >
>> > Thanks!
>> >
>> > Jane Chang
>> > Christian Witness Theological Seminary
>> > 1975 Concourse Dr.
>> > San Jose, CA 95131
>> > (408)433-2280 x109
>> > _______________________________________________
>> > Koha mailing list  http://koha-community.org
>> > Koha at lists.katipo.co.nz
>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>> >
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>