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