【战神引擎】商城购买报错 系统错误修复教程

[Exception]: doError: SQL Error: Unknown column 'jl' in 'NEW'
[Exception]: Update gamedata.yb_user_data set PTID = 'ptc86e7bc016108917fc', ChrName = '小仙源码网', YBNum = 9999998, LastModifyYBNumTime = Now() where (UserID = 180001000000012);
   [SQL Failed] Update gamedata.yb_user_data set PTID = 'ptc86e7bc016108917fc', ChrName = '小仙源码网', YBNum = 9999998, LastModifyYBNumTime = Now() where (UserID = 180001000000012);

DROP TRIGGER IF EXISTS gamedata.hmd;

DELIMITER $$

CREATE TRIGGER gamedata.hmd
BEFORE UPDATE ON yb_user_data
FOR EACH ROW
BEGIN
    -- 假设这里原本想判断的是PTID列的值
    IF NEW.PTID = 'special_value' THEN
        SET NEW.YBNum = 0;
    END IF;
END$$

DELIMITER ;

DROP TRIGGER IF EXISTS gamedata.hmd;

DELIMITER $$

CREATE TRIGGER gamedata.hmd
BEFORE UPDATE ON yb_user_data
FOR EACH ROW
BEGIN
    -- 保留触发器功能，但使用实际存在的列
    IF NEW.YBNum > 1000000 THEN  -- 这里用YBNum列作为示例
        SET NEW.YBNum = 0;
    END IF;
END$$

DELIMITER ;

UPDATE gamedata.yb_user_data 
SET PTID = 'ptc86e7bc016108917fc', 
    ChrName = '小仙源码网', 
    YBNum = 9999998, 
    LastModifyYBNumTime = NOW() 
WHERE UserID = 180001000000012;