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

[Christopher White]

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 at sage.edu



---------------------------------------
Original E-mail
From: Chris Cormack [chris at bigballofwax.co.nz]
Date: 08/10/2010 10:58 PM
To: whitec2 at 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 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