trigger defined in phpMyAdmin has cpses_XXX DEFINER

[TomKu]

...so it cannot be used

mysql> show triggers;
+----------+--------+--------+---------------------------------------+--------+---------+----------+----------------------------+----------------------+----------------------+--------------------+
| Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation |
+----------+--------+--------+---------------------------------------+--------+---------+----------+----------------------------+----------------------+----------------------+--------------------+
| trigger1 | UPDATE | table1 | BEGIN
SET NEW.ts2 = OLD.ts1;
END | BEFORE | NULL | | cpses_fr2zcKiKlF@localhost | utf8 | utf8_general_ci | latin1_swedish_ci |
+----------+--------+--------+---------------------------------------+--------+---------+----------+----------------------------+----------------------+----------------------+--------------------+

Because the trigger is 'Before UPDATE' any update statement cannot be executed:
ERROR 1449 (HY000): The user specified as a definer ('cpses_fr2zcKiKlF'@'localhost') does not exist

MySQL 5.1.73
WHM 11.42.0 21

 

[cPanelMichael]

Hello

Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

Thank you.