Hoping someone can help me
I use a mysql trigger to update a table. The problem is that every time the creator(me) of the trigger logs out and then logs back in again, I am greeted with this message when adding a record which then tries to activate the trigger:
"The user specified as a definer ('_EU_39b60bba9bee6181'@'%') does not exist"
I guess appgini assigns some random token to a user for each session, but I'm just guessing. The token value changes and therefore the trigger no longer works because the original creator must remain on the database.
Does anyone have any more insight into this? A fix/workaround? Or am I going to have to place the trigger in the relevant table hooks folder?
Triggers in MySQL error
Triggers in MySQL error
Roses are red, Violets are blue, unexpected '}' on line 32
Re: Triggers in MySQL error
As an update to this, I have replaced my trigger with equivalent code in function_after_insert. Problem solved.
Roses are red, Violets are blue, unexpected '}' on line 32