takan bhatt <takan.bhatt@gmail.com> Sat, Nov 9, 5:32 PM (2 days ago) to koha Sir /Madam During upload of marc file, I have made some mistake and my barcode is not showing as it should be.. I followed following procedure. *udo su* *mysql -uroot -p* *use koha_library;* *SET FOREIGN_KEY_CHECKS=0;* *TRUNCATE items; * *TRUNCATE deleteditems;* *TRUNCATE biblioitems; * *TRUNCATE biblio; * *TRUNCATE deletedbiblioitems; * *TRUNCATE deletedbiblio;* *SET FOREIGN_KEY_CHECKS=1;* *quit* However, all the biblio are still in catalogue ? How to overcome this? If not possible then show me how to uninstall KOHA. Rajesh Bhatt Librarian, GRIMS VAPI
yes as I said you deleted them from the database but in the search index they are still there so just do a zebra reindex: I'm not so sure how the commandline options are but try that: sudo koha-rebuild-zebra -f mylibrary cheers Am 11.11.19 um 06:59 schrieb takan bhatt:
takan bhatt <takan.bhatt@gmail.com> Sat, Nov 9, 5:32 PM (2 days ago) to koha Sir /Madam During upload of marc file, I have made some mistake and my barcode is not showing as it should be.. I followed following procedure.
*udo su* *mysql -uroot -p* *use koha_library;*
*SET FOREIGN_KEY_CHECKS=0;*
*TRUNCATE items; * *TRUNCATE deleteditems;*
*TRUNCATE biblioitems; * *TRUNCATE biblio; * *TRUNCATE deletedbiblioitems; * *TRUNCATE deletedbiblio;*
*SET FOREIGN_KEY_CHECKS=1;*
*quit*
However, all the biblio are still in catalogue ?
How to overcome this? If not possible then show me how to uninstall KOHA.
Rajesh Bhatt Librarian, GRIMS VAPI _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi, I was facing similar issue sometime back. I deleted all the imported records, but can still view in the catalogue. I have although added new records which are also visible in the OPAC. Is it safe to do a zebra indexing? Will my new records be safe? Best regards, Sugandha On Mon, 11 Nov 2019 at 13:22, Franz Dietrich <dietrich@teilgedanken.de> wrote:
yes as I said you deleted them from the database but in the search index they are still there so just do a zebra reindex:
I'm not so sure how the commandline options are but try that: sudo koha-rebuild-zebra -f mylibrary
cheers
Am 11.11.19 um 06:59 schrieb takan bhatt:
takan bhatt <takan.bhatt@gmail.com> Sat, Nov 9, 5:32 PM (2 days ago) to koha Sir /Madam During upload of marc file, I have made some mistake and my barcode is not showing as it should be.. I followed following procedure.
*udo su* *mysql -uroot -p* *use koha_library;*
*SET FOREIGN_KEY_CHECKS=0;*
*TRUNCATE items; * *TRUNCATE deleteditems;*
*TRUNCATE biblioitems; * *TRUNCATE biblio; * *TRUNCATE deletedbiblioitems; * *TRUNCATE deletedbiblio;*
*SET FOREIGN_KEY_CHECKS=1;*
*quit*
However, all the biblio are still in catalogue ?
How to overcome this? If not possible then show me how to uninstall KOHA.
Rajesh Bhatt Librarian, GRIMS VAPI _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Sugandha, the indexing process doesn't make any changes to the records in your database, it just makes them searchable. So yes, it's safe to reindex. Hope this helps, Katrin On 11.11.19 09:34, Sugandha Bajaj wrote:
Hi,
I was facing similar issue sometime back.
I deleted all the imported records, but can still view in the catalogue.
I have although added new records which are also visible in the OPAC.
Is it safe to do a zebra indexing? Will my new records be safe?
Best regards, Sugandha
On Mon, 11 Nov 2019 at 13:22, Franz Dietrich <dietrich@teilgedanken.de> wrote:
yes as I said you deleted them from the database but in the search index they are still there so just do a zebra reindex:
I'm not so sure how the commandline options are but try that: sudo koha-rebuild-zebra -f mylibrary
cheers
Am 11.11.19 um 06:59 schrieb takan bhatt:
takan bhatt <takan.bhatt@gmail.com> Sat, Nov 9, 5:32 PM (2 days ago) to koha Sir /Madam During upload of marc file, I have made some mistake and my barcode is not showing as it should be.. I followed following procedure.
*udo su* *mysql -uroot -p* *use koha_library;*
*SET FOREIGN_KEY_CHECKS=0;*
*TRUNCATE items; * *TRUNCATE deleteditems;*
*TRUNCATE biblioitems; * *TRUNCATE biblio; * *TRUNCATE deletedbiblioitems; * *TRUNCATE deletedbiblio;*
*SET FOREIGN_KEY_CHECKS=1;*
*quit*
However, all the biblio are still in catalogue ?
How to overcome this? If not possible then show me how to uninstall KOHA.
Rajesh Bhatt Librarian, GRIMS VAPI _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi, If your Koha is 17.11 or more, you have biblio datas in table 'biblio_metadata'. But is whould be more clean to delete and recreat the entire database. Regards, Le 11/11/2019 à 06:59, takan bhatt a écrit :
takan bhatt <takan.bhatt@gmail.com> Sat, Nov 9, 5:32 PM (2 days ago) to koha Sir /Madam During upload of marc file, I have made some mistake and my barcode is not showing as it should be.. I followed following procedure.
*udo su* *mysql -uroot -p* *use koha_library;*
*SET FOREIGN_KEY_CHECKS=0;*
*TRUNCATE items; * *TRUNCATE deleteditems;*
*TRUNCATE biblioitems; * *TRUNCATE biblio; * *TRUNCATE deletedbiblioitems; * *TRUNCATE deletedbiblio;*
*SET FOREIGN_KEY_CHECKS=1;*
*quit*
However, all the biblio are still in catalogue ?
How to overcome this? If not possible then show me how to uninstall KOHA.
Rajesh Bhatt Librarian, GRIMS VAPI _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Fridolin SOMERS <fridolin.somers@biblibre.com> BibLibre, France - software and system maintainer
participants (5)
-
Franz Dietrich -
Fridolin SOMERS -
Katrin Fischer -
Sugandha Bajaj -
takan bhatt