trigger defined in phpMyAdmin has cpses_XXX DEFINER
...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
-
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. 0
Please sign in to leave a comment.
Comments
1 comment