[Koha] Error when returning and checking out books

[Joe Atzberger]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090811/e2c76619/attachment.htm