Hello Katrin Thanks for the info.
Indeed I was able to solve the staff login problem because in the borrowers table there was a duplicate in the field 'userid' which should not have been. I edited the duplicate userid (same student but with a different student card number). There were also problems with the old field 'privacy' as 128 rows had a value of '2' instead of either '0' or '1'. I did an update sql query to put all those '2' values to '1' and after that upgrading was OK. Instead of using the web interface to do the database upgrade, I followed the advice of (sorry, I forgot the name) of running the upgrade in a terminal (koha-upgrade-schema library) which pointed at the two problems met above. The problem of searching the OPAC (an other post I made) after the upgrade was solved by running in a terminal 'koha-rebuild-zebra -v -f library), which is something that should be done after each upgrade from an older database to a newer version of Koha. Best regards Quynh ================= M. Vũ Đỗ Quỳnh (Ph.D) Trường Đại học Thăng Long - Université de Thang Long - Thang Long University (Hanoi, Vietnam) Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération internationale - Vice-Rector in charge of International Cooperation Web: http://thanglong.edu.vn/ Vào Th 2, 18 thg 5, 2020 vào lúc 04:31 Katrin Fischer < katrin.fischer...@web.de> đã viết: > Hi, > > misc/batchRebuildBiblioTables.pl has to be run from command line, there > is no option to make this change from the GUI. > > The database user and the superlibrarian accounts are separate things. > If you don't remember the password for the superlibrarian, you can > create another with a different userid/cardnumber and use that to get > back into the system. > > Then you can also use it to reset the password on your old > superlibrarian account or to delete it. > > Hope that helps, > > Katrin > > On 16.05.20 10:19, Quỳnh Vũ Đỗ wrote: > > Hi Jason > > I did it as you instructed to note all the information output to the > > terminal. > > I was able to fix the main errors (two actually) and at the second run, > all > > went rather smoothly and I could display the login window. > > Still some issues to be fixed through library maintenance with some perl > > scripts, which I believe might be the source of the OPAC still not > > returning search results on the catalog. > > For example I had messages like this one: > > Upgrade to 19.06.00.018 done (Bug 11529: Add medium, subtitle and part > > information to biblio table) > > NOTE: misc/batchRebuildBiblioTables.pl should be run to populate the > fields > > introduced in bug 11529. It may take some time for larger databases. > > > > I understand that either I should be able to log in as staff > administrator > > to perform that task OR get into a koha shell to run that script. Is that > > correct? > > > > I am now trying to find how to reset the superlibrarian password to be > able > > to log in to perform that maintenance. > > > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha