2009/7/16 Bob Birchall @ Calyx <b...@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
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha.org
http://lists.koha.org/mailman/listinfo/koha-devel

Reply via email to