Yes, I did. And actually it looks like I didn't mess anything with my deletions this morning. I thought it was strange, but after reloading the back-up it looks the same. I guess I just didn't pay attention what the search results look like (in the item column). Anyway, I didn't delete these records for fun, I thought it would help solve our problem with reindexing, and it didn't. Just after uploading the database, I run a reindex and then I created a new record and then waited for zebra to reindex (every 15 minutes on the cronjob). But it didn't. I didn't check if it has run at all or if it hasn't reached the last records. I thought these faulty records were preventing zebra from reaching the last records... So, after that I just put back the old database (as I thought my SQL things were messing up with the search results).
Yes, Bob, I guess a professional would solve the problem... I am doing this as a voluntary job, but it's taking too much time for me now and I am no good. We are paying someone for the server, so he helps me with all the technical things, but he doesn't know Koha especially. Very disappointing situation for me... Especially because I pushed them (when I was working for them) to change from their old library software to Koha. I feel responsible, though I still believe in Koha of course. Our organisation used to work with a Koha support company, but that wasn't working greatly. That's when I took over... (you will know everything :)) Thanks for your help! Cheers, Sonia. > Date: Tue, 24 Jul 2012 10:26:58 +0200 > From: [email protected] > To: [email protected] > Subject: Re: [Koha] SQL queries to delete records from the database? > > Op 24-07-12 00:57, Sonia P. schreef: > > OK, I guess it wasn't a good idea... I all messed up the indexes or I > > don't know what (strange links in search results) and we need to restore > > the last back-up. > > No drama but very disappointed as it was my last idea. I am ready to > > resign or commit harakiri. > > Did you run a full re-index? It's always very important to rebuild zebra > after modifying the database directly. > > Very important. > > -- > Robin Sheat > Catalyst IT Ltd. > ✆ +64 4 803 2204 > GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D > > > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
