* Sonia P. (sossola...@hotmail.com) wrote: > > 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. > Yes, that is because its a hugely dangerous thing to allow someone to type a delete into the web interface. Imagine, delete from issues;
For doing these kind of operations, you should do it in the mysql prompt on the commandline. After backing up the database of course. Chris > (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: sossola...@hotmail.com > > To: koha@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@lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha