[Koha] Error when returning and checking out books

[ed c]

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 at gmail.com> wrote:

> From: Joe Atzberger <ohiocore at gmail.com>
> Subject: Re: [Koha] Error when returning and checking out books
> To: "ed c" <terrapin44 at yahoo.com>
> Cc: "Koha List" <koha at lists.katipo.co.nz>
> Date: Tuesday, August 11, 2009, 5:22 PM
> 
> 
> On Tue, Aug 11, 2009 at 5:05 PM,
> ed c <terrapin44 at 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
> 
>