trigger defined in phpMyAdmin has cpses_XXX DEFINER

TomKu

Member
Oct 10, 2011
18
0
51
Chicago
cPanel Access Level
Root Administrator
...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 | | [email protected] | 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

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
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.