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 mbar...@birzeit.edu | www.birzeit.edu<http://www.birzeit.edu/> ________________________________ From: Koha <koha-boun...@lists.katipo.co.nz> on behalf of DHIM IT <itmana...@dhi-moskau.org> Sent: Thursday, May 18, 2023 10:48 AM To: koha@lists.katipo.co.nz <koha@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@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. ~~~~~~~~~~~~~~~~~~~~~~~~~~ _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
