Error when tryin to log in to the Staff Interface
Hi, My name is Tomasz and I am new to Koha community. I have run into a problem when installing Koha for the first time. I have failed on step when after initial setup, web installer and on-boarding tool I tried to log in to the Staff Interface. This is the error I get: Software error: DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_rasuwacommunity.library_groups' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 129 I did koha-upgrade-schema, koha-rebuild-zebra, but nothing worked. I am using Ubuntu19.10, stable latest Koha and mysql 8.0.18. Can you please help? Thank you in advance. Happy Christmas all!!! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Hi Tomasz, I have no answer to the issue, but maybe some questions that can get us a step closer to a solution: - What is the exact version of Koha you installed? - Which instructions did you use? - What is your DBMS and which version is it? - Did you see any errors in the web installer when running it? - If you can: did you check that the table was really not created in your database? For the last if you are not comfortable with command line tools, you could create an SQL report in Koha like: select * from library_groups Hope this helps, Katrin On 23.12.19 16:19, Tomasz wrote:
Hi, My name is Tomasz and I am new to Koha community. I have run into a problem when installing Koha for the first time. I have failed on step when after initial setup, web installer and on-boarding tool I tried to log in to the Staff Interface. This is the error I get: Software error: DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_rasuwacommunity.library_groups' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 129
I did koha-upgrade-schema, koha-rebuild-zebra, but nothing worked. I am using Ubuntu19.10, stable latest Koha and mysql 8.0.18. Can you please help?
Thank you in advance. Happy Christmas all!!!
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
- Koha 19.05 - I have followed https://wiki.koha-community.org/wiki/debian - I am using mysql 8.0.18 - The only 'strange' thing was updating the database to the same version (don't remember the number) - I was able to create 'superlibrarian' user, so I do think the 'table' exist. koha-list says library exist. Thank you, Katrin, for your help. -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
I have checked mysql for existing databases. My library database exist with many tables in it. The 'library_groups' table doesn't exist. Many (but not all) of the tables existing in the database are empty. Any thoughts? -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
Hello, I have figured out that there is something wrong with the database I was using (mysql). So I have decided to remove it and try Mariadb instead. I have ended up with braking my system totally. I have rebuild it at installed Koha with Mariadb without any issues. All works as a charm. Looks like Mysql on Ubuntu 19.10 doesn't cooperate too well. (needs additional setting up?) Thanks for all help. Happy New Year! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
participants (2)
-
Katrin Fischer -
Tomasz