[Koha] Error when returning and checking out books

[ed c]

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

> From: ed c <terrapin44 at yahoo.com>
> Subject: Re: [Koha] Error when returning and checking out books
> To: "Koha List" <koha at 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 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
> > 
> > 
> 
> 
>       
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>