[Koha] Error while editing item on migrated instance

[Mohamad F Barham]

in your koha conf file

check your database connection settings , and make sure the user have access to koha database


hence: create new db user with  access and edit the following,  the user not created as migrated not installed


<db_scheme>mysql</db_scheme>
 <database></database>
 <hostname></hostname>
 <port></port>
 <user></user>
 <pass></pass>



Mohamad Barham

System Engineer | Information Technology Department

Birzeit University

P.O.Box. 14, Birzeit, Palestine

Tel: + 970 22982012 | Mob: +970 597 861929 | Ext: 5616

mbarham at birzeit.edu | www.birzeit.edu<http://www.birzeit.edu/>





________________________________
From: Koha <koha-bounces at lists.katipo.co.nz> on behalf of DHIM IT <itmanager at dhi-moskau.org>
Sent: Thursday, May 18, 2023 10:48 AM
To: koha at lists.katipo.co.nz <koha at lists.katipo.co.nz>
Subject: [Koha] Error while editing item on migrated instance

Dear colleagues,

I migrated koha db to a new server with fresh installed instance. Everything working fine. I have only one error while editing items:


[WARN] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: The user specified as a definer ('root'@'%') does not exist at /usr/share/koha/lib/Koha/Object.pm line 170

Does anybody know what can I do to solve it?

KOHA 22.05
Debian 11

Mit besten Grüßen
IT-Manager
Eugen Bastron

_______________________________________________

Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
~~~~~~~~~~~~~~~~~~~~~~~~~~
The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. The University is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.
~~~~~~~~~~~~~~~~~~~~~~~~~~