::
Code: Select all
[Err] 1235 - This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
[Err] CREATE TRIGGER char_delete
BEFORE DELETE ON chars
FOR EACH ROW
BEGIN
DELETE FROM `char_effects` WHERE `charid` = OLD.charid;
DELETE FROM `char_equip` WHERE `charid` = OLD.charid;
DELETE FROM `char_exp` WHERE `charid` = OLD.charid;
DELETE FROM `char_inventory` WHERE `charid` = OLD.charid;
DELETE FROM `char_jobs` WHERE `charid` = OLD.charid;
DELETE FROM `char_look` WHERE `charid` = OLD.charid;
DELETE FROM `char_pet` WHERE `charid` = OLD.charid;
DELETE FROM `char_points` WHERE `charid` = OLD.charid;
DELETE FROM `char_profile` WHERE `charid` = OLD.charid;
DELETE FROM `char_skills` WHERE `charid` = OLD.charid;
DELETE FROM `char_stats` WHERE `charid` = OLD.charid;
DELETE FROM `char_storage` WHERE `charid` = OLD.charid;
DELETE FROM `char_vars` WHERE `charid` = OLD.charid;
DELETE FROM `char_weapon_skill_points` WHERE `charid` = OLD.charid;
DELETE FROM `auction_house` WHERE `seller` = OLD.charid;
DELETE FROM `delivery_box` WHERE `charid` = OLD.charid;
END ;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
All of this started after R3948, so just a heads up.
