Error when returning and checking out books
Hello all, On my Koha install I am receiving errors when I check in a book. The error when I have it set to debug mode I am sent to an error page that reads: Koha error The following fatal error has occurred: Can't use an undefined value as an ARRAY reference at /usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm line 226. Apache Server version: Apache/2.2.8 (Ubuntu) Server built: Mar 10 2009 18:09:05 Koha 3.00.02.012 Koha DB 3.0002012 MySQL mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 OS Linux cassidy 2.6.24-23-server #1 SMP Wed Apr 1 22:22:14 UTC 2009 i686 Perl 5.008008 In production mode, I get a Web site that says: "production mode - trapped fatal error" The return and or check out actually does go through but obviously I can't have library staff seeing this error every time they check in or out a book. I don't remember seeing these earlier, but I am not sure. However, nothing has changed recently that could have caused this. I did try temporarily copying the latest ItemCirculationAlertPreference.pm from the git repository, but that didn't do anything but change the line number in the error. Any ideas? Edward Edward
I should have thought to include the log gile entries. In /var/log/koha/koha-error_log I am getting the following: [Tue Aug 11 17:44:19 2009] [error] [client 128.226.37.18] [Tue Aug 11 17:44:19 2009] circulation.pl: DBD::mysql::db selectall_arrayref failed: Table 'koha.item_circulation_alert_preferences' doesn't exist at /usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm line 251., referer: http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl [Tue Aug 11 17:44:19 2009] [error] [client 128.226.37.18] [Tue Aug 11 17:44:19 2009] circulation.pl: Can't use an undefined value as an ARRAY reference at /usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm line 261., referer: http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl This seems to me that I need to create the table "koha.item_circulation_alert_preferences" Does anyone have an idea about the best way to do this? Edward --- On Tue, 8/11/09, ed c <terrapin44@yahoo.com> wrote:
From: ed c <terrapin44@yahoo.com> Subject: [Koha] Error when returning and checking out books To: "Koha List" <koha@lists.katipo.co.nz> Date: Tuesday, August 11, 2009, 4:36 PM
Hello all,
On my Koha install I am receiving errors when I check in a book. The error when I have it set to debug mode I am sent to an error page that reads:
Koha error
The following fatal error has occurred:
Can't use an undefined value as an ARRAY reference at /usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm line 226.
Apache Server version: Apache/2.2.8 (Ubuntu) Server built: Mar 10 2009 18:09:05 Koha 3.00.02.012 Koha DB 3.0002012 MySQL mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 OS Linux cassidy 2.6.24-23-server #1 SMP Wed Apr 1 22:22:14 UTC 2009 i686 Perl 5.008008
In production mode, I get a Web site that says:
"production mode - trapped fatal error"
The return and or check out actually does go through but obviously I can't have library staff seeing this error every time they check in or out a book. I don't remember seeing these earlier, but I am not sure. However, nothing has changed recently that could have caused this.
I did try temporarily copying the latest ItemCirculationAlertPreference.pm from the git repository, but that didn't do anything but change the line number in the error.
Any ideas?
Edward
Edward
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On Tue, Aug 11, 2009 at 5:05 PM, ed c <terrapin44@yahoo.com> wrote:
I should have thought to include the log gile entries. In /var/log/koha/koha-error_log I am getting the following:
[Tue Aug 11 17:44:19 2009] [error] [client 128.226.37.18] [Tue Aug 11 17:44:19 2009] circulation.pl: DBD::mysql::db selectall_arrayref failed: Table 'koha.item_circulation_alert_preferences' doesn't exist at /usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm line 251., referer: http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl
[Tue Aug 11 17:44:19 2009] [error] [client 128.226.37.18] [Tue Aug 11 17:44:19 2009] circulation.pl: Can't use an undefined value as an ARRAY reference at /usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm line 261., referer: http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl
This seems to me that I need to create the table "koha.item_circulation_alert_preferences" Does anyone have an idea about the best way to do this?
Refer to the SQL in installer/data/mysql/kohastructure.sql (or updatedatabase.pl) for that table: CREATE TABLE item_circulation_alert_preferences ( id int(11) AUTO_INCREMENT, branchcode varchar(10) NOT NULL, categorycode varchar(10) NOT NULL, item_type varchar(10) NOT NULL, notification varchar(16) NOT NULL, PRIMARY KEY (id), KEY (branchcode, categorycode, item_type, notification) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; You might scan updatedatabase to see what other tables or operations apparently failed or were skipped on your installation. -- Joe Atzberger LibLime - Open Source Library Solutions
Thank you Joe. I didn't have anything relating to koha.item_circulation_alert_preferences in either kohastructure.sql or updatedatabase.pl. Entering the command you gave me fixed this problem but now I have another relating to the circulation alerts. When I return on check out something I get the following error (from the logs, the onscreen error is similar): [Wed Aug 12 09:14:35 2009] [error] [client 128.226.37.18] [Wed Aug 12 09:14:35 2009] returns.pl: Undefined subroutine &C4::Members::Messaging::GetMessagingPreferences called at /usr/share/koha/lib/C4/Circulation.pm line 2433., referer: http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl It appears that somehow my circulation alerts were not installed/are not functioning properly. Is this Messaging functionality a new feature or maybe there was something missing in the version of Koha I downloaded? I had an issue early relating renewal dates (bug 2770) that caused me to install a new C4_Circulation.pm on July 29. At that point I installed Messages.pm because I didn't have one previously. Maybe I just need to back out the C4_Circulation.pm I put in but bug 2770 was a major issue for the library going live with Koha. What does this messaging even do? Can I just disable it? I notice if I have to override something (for example when I try to check out a book I already have checked out) I do not get this error so this subroutine must no be called in all cases. Edward --- On Tue, 8/11/09, Joe Atzberger <ohiocore@gmail.com> wrote:
From: Joe Atzberger <ohiocore@gmail.com> Subject: Re: [Koha] Error when returning and checking out books To: "ed c" <terrapin44@yahoo.com> Cc: "Koha List" <koha@lists.katipo.co.nz> Date: Tuesday, August 11, 2009, 5:22 PM
On Tue, Aug 11, 2009 at 5:05 PM, ed c <terrapin44@yahoo.com> wrote:
I should have thought to include the log gile entries. In
/var/log/koha/koha-error_log I am getting the following:
[Tue Aug 11 17:44:19 2009] [error] [client 128.226.37.18] [Tue Aug 11 17:44:19 2009] circulation.pl: DBD::mysql::db selectall_arrayref failed: Table 'koha.item_circulation_alert_preferences' doesn't exist at /usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm line 251., referer: http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl
[Tue Aug 11 17:44:19 2009] [error] [client 128.226.37.18] [Tue Aug 11 17:44:19 2009] circulation.pl: Can't use an undefined value as an ARRAY reference at /usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm line 261., referer: http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl
This seems to me that I need to create the table "koha.item_circulation_alert_preferences" Does anyone have an idea about the best way to do this?
Refer to the SQL in installer/data/mysql/kohastructure.sql (or updatedatabase.pl) for that table:
CREATE TABLE item_circulation_alert_preferences ( id int(11) AUTO_INCREMENT,
branchcode varchar(10) NOT NULL, categorycode varchar(10) NOT NULL,
item_type varchar(10) NOT NULL, notification varchar(16) NOT NULL,
PRIMARY KEY (id), KEY (branchcode, categorycode, item_type, notification)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
You might scan updatedatabase to see what other tables or operations apparently failed or were skipped on your installation.
-- Joe Atzberger LibLime - Open Source Library Solutions
Just as an update, thanks to the IRC channel I figured out that I had the wrong Circulation.pm. Thanks everyone for there help. Edward --- On Wed, 8/12/09, ed c <terrapin44@yahoo.com> wrote:
From: ed c <terrapin44@yahoo.com> Subject: Re: [Koha] Error when returning and checking out books To: "Koha List" <koha@lists.katipo.co.nz> Date: Wednesday, August 12, 2009, 8:51 AM Thank you Joe. I didn't have anything relating to koha.item_circulation_alert_preferences in either kohastructure.sql or updatedatabase.pl. Entering the command you gave me fixed this problem but now I have another relating to the circulation alerts. When I return on check out something I get the following error (from the logs, the onscreen error is similar):
[Wed Aug 12 09:14:35 2009] [error] [client 128.226.37.18] [Wed Aug 12 09:14:35 2009] returns.pl: Undefined subroutine &C4::Members::Messaging::GetMessagingPreferences called at /usr/share/koha/lib/C4/Circulation.pm line 2433., referer: http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl
It appears that somehow my circulation alerts were not installed/are not functioning properly. Is this Messaging functionality a new feature or maybe there was something missing in the version of Koha I downloaded?
I had an issue early relating renewal dates (bug 2770) that caused me to install a new C4_Circulation.pm on July 29. At that point I installed Messages.pm because I didn't have one previously. Maybe I just need to back out the C4_Circulation.pm I put in but bug 2770 was a major issue for the library going live with Koha.
What does this messaging even do? Can I just disable it? I notice if I have to override something (for example when I try to check out a book I already have checked out) I do not get this error so this subroutine must no be called in all cases.
Edward
--- On Tue, 8/11/09, Joe Atzberger <ohiocore@gmail.com> wrote:
From: Joe Atzberger <ohiocore@gmail.com> Subject: Re: [Koha] Error when returning and checking out books To: "ed c" <terrapin44@yahoo.com> Cc: "Koha List" <koha@lists.katipo.co.nz> Date: Tuesday, August 11, 2009, 5:22 PM
On Tue, Aug 11, 2009 at 5:05 PM, ed c <terrapin44@yahoo.com> wrote:
I should have thought to include the log gile entries. In
/var/log/koha/koha-error_log I am getting the following:
[Tue Aug 11 17:44:19 2009] [error] [client 128.226.37.18] [Tue Aug 11 17:44:19 2009] circulation.pl: DBD::mysql::db selectall_arrayref failed: Table 'koha.item_circulation_alert_preferences' doesn't exist at
/usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm
line 251., referer: http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl
[Tue Aug 11 17:44:19 2009] [error] [client 128.226.37.18] [Tue Aug 11 17:44:19 2009] circulation.pl: Can't use an undefined value as an ARRAY reference at
/usr/share/koha/lib/C4/ItemCirculationAlertPreference.pm
line 261., referer: http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl
This seems to me that I need to create the table "koha.item_circulation_alert_preferences" Does anyone have an idea about the best way to do this?
Refer to the SQL in installer/data/mysql/kohastructure.sql (or updatedatabase.pl) for that table:
CREATE TABLE item_circulation_alert_preferences ( id int(11) AUTO_INCREMENT,
branchcode varchar(10) NOT NULL, categorycode varchar(10) NOT NULL,
item_type varchar(10) NOT NULL, notification varchar(16) NOT NULL,
PRIMARY KEY (id), KEY (branchcode, categorycode, item_type, notification)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
You might scan updatedatabase to see what other tables or operations apparently failed or were skipped on your installation.
-- Joe Atzberger LibLime - Open Source Library Solutions
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
ed c -
Joe Atzberger