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