Database contains objects with a nonexistent definer

hosterbyte

Verified User
Joined
Jul 25, 2019
Messages
12
Hi everyone

After restore backup user data. Site unable to access with eror HTTP 500.
When we check on database have error

Database contains objects with a nonexistent definer
Each database object, such as VIEW, TRIGGER, EVENT, FUNCTION or PROCEDURE has an associated user account, that is considered an object definer. If object is associated with non-existing user, any action or query using it fails.This can happen if user account that originally created the VIEW, TRIGGER, etc. is removed. To make all database objects usable again, they need to be updated to belong to one of the existing database user accounts.


2024-07-26 11 11 57.jpg

Anyone can help?

Thank's
 
Problem solved
Repair user definder from phpmyadmin with da_admin user then edit table/view definer

2024-07-26 16 44 17.jpg

problem solved
 
Back
Top