[Koha] SQL queries to delete records from the database?

[Sonia P.]

Hi there

(re:  rebuild-zebra stops working very often, which is not a proper title any more... :p)

I tried to edit a few records from these non-indexed records.  As we speak another language, we have accent issues.  So I need to make sure (again) that our librarians doesn't use any accent on the letters.  So all the records which I have found from that list of non-indexed records have accent problems.  

On some records, I can edit the content and remove the accents.


But for some records, I can't even edit the content, because then there 
is an error with Koha, the page doesn't show anything with something 
like that:  << Software error: Can't call method "field" on an 
undefined value at /usr/share/koha/lib/C4/Items.pm line 1421.>> 
which is just a random error because it can't find the record anymore 
(it finds the records on certain pages, for instance if I want to see 
its history, but it can't find the record on any page where it should 
show its title).  So no way to solve the problem using the Koha 
interface...


 I guess I need a sql query to delete these records from the 
database, but something that would really delete everything related to 
that item (history, etc). Do you have any idea about that?


But then I just don't understand why these problem records prevent zebra from reindexing the newly entered records... :/

Anyway, I have done the koha-rebuild-zebra -v -f library command to reindex everything. 
See below the new report from that new perl script, we moved from 138 non-indexed records to 56 non-indexed records,  just because I have modified a few records (5?) and because I have rerun rebuild-zebra (so it indexed the newly entered records which had no accent problems anyway).

Many thanks for your help!
Would greatly appreciate your expertise about SQL queries to delete everything for faulty records.

Sonia.

############

1000 done
2000 done
biblionumber 2315 not indexed
3000 done
4000 done
biblionumber 5230 not indexed
biblionumber 5234 not indexed
5000 done
6000 done
7000 done
8000 done
9000 done
10000 done
11000 done
12000 done
13000 done
14000 done
15000 done
16000 done
17000 done
biblionumber 19992 not indexed
biblionumber 20030 not indexed
18000 done
biblionumber 20177 not indexed
biblionumber 20234 not indexed
biblionumber 20316 not indexed
biblionumber 20317 not indexed
biblionumber 20397 not indexed
biblionumber 20398 not indexed
biblionumber 20399 not indexed
biblionumber 20400 not indexed
biblionumber 20418 not indexed
biblionumber 20446 not indexed
biblionumber 20448 not indexed
biblionumber 20491 not indexed
biblionumber 20494 not indexed
biblionumber 20495 not indexed
biblionumber 20499 not indexed
biblionumber 20500 not indexed
biblionumber 20501 not indexed
biblionumber 20502 not indexed
biblionumber 20505 not indexed
biblionumber 20590 not indexed
biblionumber 20614 not indexed
biblionumber 20615 not indexed
biblionumber 20616 not indexed
biblionumber 20617 not indexed
biblionumber 20618 not indexed
biblionumber 20626 not indexed
biblionumber 20627 not indexed
biblionumber 20628 not indexed
biblionumber 20648 not indexed
biblionumber 20677 not indexed
biblionumber 20686 not indexed
biblionumber 20849 not indexed
biblionumber 20917 not indexed
biblionumber 20921 not indexed
biblionumber 21016 not indexed
biblionumber 21039 not indexed
biblionumber 21045 not indexed
biblionumber 21097 not indexed
biblionumber 21138 not indexed
biblionumber 21141 not indexed
biblionumber 21142 not indexed
biblionumber 21145 not indexed
19000 done
biblionumber 21810 not indexed
biblionumber 21811 not indexed
20000 done
biblionumber 22320 not indexed
biblionumber 22338 not indexed
biblionumber 22386 not indexed
biblionumber 22583 not indexed
21000 done
biblionumber 23506 not indexed
biblionumber 23507 not indexed
biblionumber 23508 not indexed
22000 done
23000 done
24000 done
25000 done
26000 done
27000 done
28000 done
29000 done
30000 done
31000 done
32000 done
56 bibliorecords not indexed