[Koha] Staff login problems after upgrading from Koha 3.18 to 19.11

[Quỳnh Vũ Đỗ]

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