Wow!!! That's it!!! I just looked at an earier saved koha database and it is "wthdrawn" but our current iteration has it as "withdrawn." I am perplexed. We did add the authority values to add SUPPRESS, but I don't think we touched any other values. Is "withdrawn " with an "i" a default auhtority value? I guess I could just edit the SQL structure the table. Christopher J White Systems Librarian The Sage Colleges Troy, New York (518)244-4521 (518)858-8563 (cell) whitec2@sage.edu --------------------------------------- Original E-mail From: Chris Cormack [chris@bigballofwax.co.nz] Date: 08/10/2010 10:58 PM To: whitec2@sage.edu Subject: Re: [Koha] Inability to Add/Edit Items 'withdrawn' vs 'wthdrawn' in Items.pm On 11 August 2010 12:51, Christopher White <whitec2@sage.edu> wrote:
We have been unable to add or edit items. The problem only started recently.
First question then is ... what changed recently?
In the error log, it points to an "unknown column" 'wthdrawn' in Items.pm. I changed the string to 'withdrawn' which corresponds to the field in the items table.
Looking at the kohastructure.sql document for the master branch, the column is called wthdrawn `wthdrawn` tinyint(1) NOT NULL default 0, Also looking in the 3.0.x branch http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mys... It is `wthdrawn` tinyint(1) NOT NULL default 0, There too.
I am still however getting the error. Do I have to restart something? Is there any reason the perl script would use a different field name than the table?
Here is the error message:
additem.pl: DBD::mysql::st execute failed: Unknown column 'wthdrawn' in 'field list' at /usr/share/koha/lib/C4/Items.pm line 1915
The following is the intallation info:
The installation info is below. Any help would be greatly appreciated.
Are you running Koha, ... not Harley, or whatever name Liblime Enterprise Koha has now morphed into. Because in Koha, the column is called wthdrawn. Chris