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. Bob Birchall CALYX
2009/7/16 Bob Birchall @ Calyx <bob@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
participants (2)
-
Bob Birchall @ Calyx -
Chris Cormack