[Koha] Inability to Add/Edit Items 'withdrawn' vs 'wthdrawn' in Items.pm

[Chris Cormack]

On 11 August 2010 12:51, Christopher White <whitec2 at 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/mysql/kohastructure.sql;h=3759d5cef68ae812eb02630b68433cfae5172964;hb=refs/heads/3.0.x#l1173
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