[Koha] Deleting all records in Koha

2017-05-15 Thread Davian Cooper
I want to get rid of all the records in koha, not all the records had accession numbers when they were imported so the batch delete is not effective. Tried truncating the tables in MySql but when I search the OPAC, the records still appear as if nothing was done to remove them. Can anyone assist on

Re: [Koha] Deleting all records in Koha

2017-05-15 Thread Pedro Amorim
Hey Davian, Your zebra index is probably with the records still indexed, because when you run a query directly in the database, there's nothing telling zebra it needs to remove said records from the index. What happens if you actually select a record from the search? Reindex zebra and check again.

Re: [Koha] Deleting all records in Koha

2017-05-15 Thread Michael Kuhn
Hi Davian I want to get rid of all the records in koha, not all the records had accession numbers when they were imported so the batch delete is not effective. Tried truncating the tables in MySql but when I search the OPAC, the records still appear as if nothing was done to remove them. Can any

Re: [Koha] Deleting all records in Koha

2017-05-15 Thread Michael Kuhn
Hi Davian Sorry, the following two lines are not necessary when using script "koha-rebuild-zebra" (but they won't hurt either): $ export KOHA_CONF=/etc/koha/sites/YOURINSTANCE/koha-conf.xml $ export PERL5LIB=/usr/share/koha/lib So you can just execute the following as your usual Koha user.

Re: [Koha] Deleting all records in Koha

2017-05-16 Thread Pedro Amorim
ra –f –v > instancename as shown in the attached file and the same problem occurs. > > > > DC > > > > *From:* Pedro Amorim [mailto:pjamori...@gmail.com] > *Sent:* Monday, May 15, 2017 11:01 AM > *To:* Davian Cooper > *Cc:* Koha list > *Subject:* Re: [Koha

Re: [Koha] Deleting all records in Koha

2017-05-16 Thread Davian Cooper
[mailto:pjamori...@gmail.com] Sent: Tuesday, May 16, 2017 6:13 AM To: Davian Cooper Cc: Koha list Subject: Re: [Koha] Deleting all records in Koha If I select the record from the search I get an error 404 stating that the requested page is not available. That's the expected behavior, mean