Acquisitions error : Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2054
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
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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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 On Wed, Jan 25, 2017 at 12:03 AM, Jonathan Druart < jonathan.druart@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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@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@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@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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Jane Chang -
Jonathan Druart