开发者

MySQL error code 1017

I'm creating a trigger on one table to insert after on another table. The trigger query seems to be okay to the best of my knowledge, but I'm getting the error:

Error Code : 1017

Can't find file: '.\rtasys\@003cozekimessagein@003e.frm' (errno: 22)

My trigger query is:

DELIMITER $$ CREATE
/*开发者_如何学运维[DEFINER = { user | CURRENT_USER }]*/
TRIGGER `rtasys`.`on_insert_ozekimessagein` AFTER INSERT
ON `rtasys`.`<ozekimessagein>`
FOR EACH ROW BEGIN

INSERT INTO ozekimessageout SET ozekimessageout.`receiver`=NEW.sender;
INSERT INTO ozekimessageout SET ozekimessageout.`msg`=NEW.msg;
INSERT INTO ozekimessageout SET ozekimessageout.`status`=NEW.sender;

END$$ DELIMITER ;


MySQL can't find ozekimessageout table definition file (.frm). Try to:

REPAIR TABLE ozekimessageout;

or recreate table ozekimessageout. It's also possible that the file exists but MySQL does not have privieleges to read it. Check that the file rtasys\@003cozekimessagein@003e.frm exists and MySQL has rights to read/write/update it.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜