2026-03-08 15:42:02
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END */' at line 1
STATEMENT:
END */;

2026-03-08 15:49:29
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END */' at line 1
STATEMENT:
END */;

2026-03-08 15:52:02 | SQL Error: Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation
Query: /*!50003 CREATE*/ /*!50017 DEFINER=`admin`@`%`*/ /*!50003 TRIGGER `before_insert_customers` BEFORE INSERT ON `customers` FOR EACH ROW BEGIN
  SET NEW.state_code = CASE NEW.state
    WHEN 'Johor' THEN '01'
    WHEN 'Kedah' THEN '02'
    WHEN 'Kelantan' THEN '03'
    WHEN 'Melaka' THEN '04'
    WHEN 'Negeri Sembilan' THEN '05'
    WHEN 'Pahang' THEN '06'
    WHEN 'Pulau Pinang' THEN '07'
    WHEN 'Perak' THEN '08'
    WHEN 'Perlis' THEN '09'
    WHEN 'Selangor' THEN '10'
    WHEN 'Terengganu' THEN '11'
    WHEN 'Sabah' THEN '12'
    WHEN 'Sarawak' THEN '13'
    WHEN 'Wilayah Persekutuan Kuala Lumpur' THEN '14'
    WHEN 'Wilayah Persekutuan Labuan' THEN '15'
    WHEN 'Wilayah Persekutuan Putrajaya' THEN '16'
    ELSE '17'
  END;
END */;

2026-03-08 15:52:02 | SQL Error: Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation
Query: /*!50003 CREATE*/ /*!50017 DEFINER=`admin`@`%`*/ /*!50003 TRIGGER `before_update_customers` BEFORE UPDATE ON `customers` FOR EACH ROW BEGIN
  SET NEW.state_code = CASE NEW.state
    WHEN 'Johor' THEN '01'
    WHEN 'Kedah' THEN '02'
    WHEN 'Kelantan' THEN '03'
    WHEN 'Melaka' THEN '04'
    WHEN 'Negeri Sembilan' THEN '05'
    WHEN 'Pahang' THEN '06'
    WHEN 'Pulau Pinang' THEN '07'
    WHEN 'Perak' THEN '08'
    WHEN 'Perlis' THEN '09'
    WHEN 'Selangor' THEN '10'
    WHEN 'Terengganu' THEN '11'
    WHEN 'Sabah' THEN '12'
    WHEN 'Sarawak' THEN '13'
    WHEN 'Wilayah Persekutuan Kuala Lumpur' THEN '14'
    WHEN 'Wilayah Persekutuan Labuan' THEN '15'
    WHEN 'Wilayah Persekutuan Putrajaya' THEN '16'
    ELSE '17'
  END;
END */;

2026-03-08 15:52:03 | SQL Error: Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation
Query: /*!50003 CREATE*/ /*!50017 DEFINER=`admin`@`%`*/ /*!50003 TRIGGER `trg_after_insert_equivalent_parts` AFTER INSERT ON `equivalent_parts` FOR EACH ROW BEGIN
  UPDATE branch_stock_control
  SET equivalent_id = NEW.group_id
  WHERE product_id = NEW.product_id;
END */;

2026-03-08 15:52:03 | SQL Error: Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation
Query: /*!50003 CREATE*/ /*!50017 DEFINER=`admin`@`%`*/ /*!50003 TRIGGER `trg_after_update_equivalent_parts` AFTER UPDATE ON `equivalent_parts` FOR EACH ROW BEGIN
  UPDATE branch_stock_control
  SET equivalent_id = NEW.group_id
  WHERE product_id = NEW.product_id;
END */;

2026-03-08 15:52:03 | SQL Error: Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation
Query: /*!50003 CREATE*/ /*!50017 DEFINER=`admin`@`%`*/ /*!50003 TRIGGER `trg_after_delete_equivalent_parts` AFTER DELETE ON `equivalent_parts` FOR EACH ROW BEGIN
  UPDATE branch_stock_control
  SET equivalent_id = NULL
  WHERE product_id = OLD.product_id;
END */;

