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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha