[Koha-devel] corrupt record in issues table

[Chris Cormack]

2009/7/16 Bob Birchall @ Calyx <bob at calyx.net.au>:
> We have an entry in the issues table with a NULL itemnumber.  This is
> causing the 'holds to pull' report to fail.
> Is it safe to simply delete the corrupt row from the issues table?
> We're using Koha 3.00.01.005 on Debian.
>
Yes it should be safe.

You could do
SELECT * FROM issues WHERE itemnumber is NULL INTO OUTFILE '/tmp/corruptissues';

Then copy that file somewhere, just so you have a record of them
(including the borrowernumber) in case you ever need them.

then delete them.

Chris