<br><br><div class="gmail_quote">On Tue, Aug 11, 2009 at 5:05 PM, ed c <span dir="ltr"><<a href="mailto:terrapin44@yahoo.com">terrapin44@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I should have thought to include the log gile entries. In<br>
/var/log/koha/koha-error_log I am getting the following:<br>
<br>
<br>
[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: <a href="http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl" target="_blank">http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl</a><br>
<br>
[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: <a href="http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl" target="_blank">http://cassidy.binghamton.edu:8080/cgi-bin/koha/circ/circulation.pl</a><br>
<br>
<br>
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?<br></blockquote><div><br>Refer to the SQL in installer/data/mysql/kohastructure.sql (or updatedatabase.pl) for that table:<br>
<br><span style="font-family: courier new,monospace;"> CREATE TABLE item_circulation_alert_preferences (</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> id int(11) AUTO_INCREMENT,</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> branchcode varchar(10) NOT NULL,</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> categorycode varchar(10) NOT NULL,</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> item_type varchar(10) NOT NULL,</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> notification varchar(16) NOT NULL,</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> PRIMARY KEY (id),</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"> KEY (branchcode, categorycode, item_type, notification)</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;</span><br><br>You might scan updatedatabase to see what other tables or operations apparently failed or were skipped on your installation.<br>
<br></div></div>-- <br>Joe Atzberger<br>LibLime - Open Source Library Solutions<br>