[Koha] Deleting all records in Koha

Davian Cooper davian.cooper at nlj.gov.jm
Wed May 17 04:00:10 NZST 2017


What happens if you create a test biblio record and run the same command again?

I did just that and it worked.

Thank you.

It seems as if in order to get the records out completely without the 404 error you must add new records and reindex zebra.

 

Davian Cooper

 

From: Pedro Amorim [mailto:pjamorim91 at 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, means the original removal from the database worked as intended.

 

I also reindex zebra with the command #: sudo koha-rebuild-zebra –f –v instancename as shown in the attached file and the same problem occurs.

Now this is weird. In the attached file everything seems in order and running with '-f' means it will clean the original index and run through the whole records table. 

What happens if you create a test biblio record and run the same command again?

 

Pedro Amorim

 

2017-05-15 19:32 GMT+00:00 Davian Cooper <davian.cooper at nlj.gov.jm>:

Hello Pedro,

 

If I select the record from the search I get an error 404 stating that the requested page is not available.

I also reindex zebra with the command #: sudo koha-rebuild-zebra –f –v instancename as shown in the attached file and the same problem occurs.

 

DC

 

From: Pedro Amorim [mailto:pjamorim91 at gmail.com] 
Sent: Monday, May 15, 2017 11:01 AM
To: Davian Cooper
Cc: Koha list
Subject: Re: [Koha] Deleting all records in Koha

 

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.

 

GL,

 

Pedro Amorim

 

2017-05-15 15:43 GMT+00:00 Davian Cooper <davian.cooper at nlj.gov.jm>:

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 how to truly delete all the records from koha?



Regards,

Davian Cooper

_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

 

 



More information about the Koha mailing list