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

[Jane Chang]

yeah, the table exists.  but just couldn't find out what was wrong.

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

On Tue, Jan 31, 2017 at 12:28 AM, Jonathan Druart <
jonathan.druart at bugs.koha-community.org> wrote:

> 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
> >
> >
> >
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>