So something like that? mysqldump -u kohauser -p kohalibrary > savedatabase230712.sql mysql -u username -p[password]use kohalibrary;DELETE FROM biblio WHERE biblionumber='2315'; (never done mysql things in commandline before...) Cheers, Sonia.
Date: Mon, 23 Jul 2012 15:42:59 +1200 From: chrisc@catalyst.net.nz To: sossolapro@hotmail.com CC: koha@lists.katipo.co.nz Subject: Re: [Koha] SQL queries to delete records from the database?
* Sonia P. (sossolapro@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: sossolapro@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