[Koha] How to run batchRebuildBiblioTables.pl

[Katrin Fischer]

Hi,

running the script in koha-shell is the right thing to do. This applies
to all scripts you might want to run apart from the koha- ones.

Are you sure library is the right instance? The message looks like
coming from an empty instance where the database structure hasn't been
created yet. You can list all instances on your server using: sudo koha-list

Hope this helps,

Katrin

On 23.02.23 10:57, library at ssst.edu.ba wrote:
> 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ć
>
>
>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha