Koha Croatian user group
Brisanje biblio zapisa bez primjeraka: Revision 6

Skripta

scrub_orphaned_biblios.pl

ne radi!

može i ovako:

$ mysql -u _kohauser_ -p  koha

mysql> SELECT biblio.biblionumber, biblioitems.itemtype, items.biblionumber as items_biblionumber from biblio RIGHT JOIN biblioitems ON biblio.biblionumber = biblioitems.biblionumber LEFT JOIN items ON biblio.biblionumber = items.biblionumber WHERE items.biblionumber IS NULL ;
mysql> begin ;
mysql> delete biblio.* from biblio LEFT JOIN items ON biblio.biblionumber = items.biblionumber WHERE items.biblionumber IS NULL ;
mysql> select count(*) from biblio ;
mysql> commit;

nakon toga treba rebuld zebra indeksa:

koha@koha-dev:/usr/share/koha/bin/migration_tools$ ./rebuild_zebra.pl -b -a -v -r