[Koha] How to run batchRebuildBiblioTables.pl

[library at ssst.edu.ba]

Hi all,

I have been trying to find out how to run the batchRebuildBiblioTables.pl after Koha to MARC mapping errors were resolved, but couldn't figure out how exactly to execute this command in the terminal. After some googling it looked like /usr/share/koha/bin/batchRebuildBiblioTables.pl -c is what I needed to type, but I got this result:


Can't locate Koha/Script.pm in @INC (you may need to install the Koha::Script module) (@INC contains: /usr/share/koha/bin/ /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.34.0 /usr/local/share/perl/5.34.0 /usr/lib/x86_64-linux-gnu/perl5/5.34 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.34 /usr/share/perl/5.34 /usr/local/lib/site_perl) at /usr/share/koha/bin/batchRebuildBiblioTables.pl line 9.
BEGIN failed--compilation aborted at /usr/share/koha/bin/batchRebuildBiblioTables.pl line 9.


When that didn't work I tried searching the archive for batchRebuildBiblioTables.pl and found this message: https://lists.katipo.co.nz/public/koha/2021-July/056487.html, which suggested using sudo koha-shell -c '/usr/share/koha/bin/batchRebuildBiblioTables.pl -c' your_koha_name

So I tried sudo koha-shell -c '/usr/share/koha/bin/batchRebuildBiblioTables.pl -c' library

The result was:


DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::st execute failed: Table 'koha_library.biblio' doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/share/koha/lib/Koha/Database.pm line 152.


Can someone help with how to resolve these please? Will I need to install Koha::Script module  and how?

My Koha version is 22.11.01, and MARC flavor is UNIMARC. I had recently run Koha to MARC mapping and my MARC Bibliographic framework test returned all OK after correcting the errors, but the message at the top of the page says If you make any change to the mappings, you must ask your administrator to run misc/batchRebuildBiblioTables.pl. Since our IT is dealing with other things and I'm the only one handling Koha installation, setup and eventual usage (god help me) I need to figure out many things that could seem obvious to more experienced users here. I only just started using Linux this month.

Thank you in advance!


Best regards

Aida Đikić