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

[Sonia P.]

Hello

It seems that we can't use 'delete' commands in the Koha admin website (build SQL reports or so).  How can I do that?
I need to delete these records, I know the proper command, I just want to be allowed to do it.

(I am now down to 20 faulty records, so I will just delete them from the database one by one, I know they are only present in the 'biblio' table)

Cheers,

Sonia.


> From: sossolapro at hotmail.com
> To: koha at lists.katipo.co.nz
> Date: Sun, 22 Jul 2012 00:00:42 +0200
> Subject: [Koha] SQL queries to delete records from the database?
> 
> 
> 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
>  		 	   		  
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha