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