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

[Jonathan Druart]

No, do not downgrade Koha, it is not supported.
You should definitely try to upgade to Debian 8.
It is not very clear for me what happened on IRC, did you manage to know if
this aqorders table finally exists?

On Fri, 27 Jan 2017 at 19:09 Jane Chang <jane.chang at cwts.edu> wrote:

> 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
>
>
>
>