Error In MYSQL Help: - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Error In MYSQL Help: (
/showthread.php?tid=462909)
Error In MYSQL Help: -
jasonsmith - 09.09.2013
Well I Don't know what this mean any help would be good.:
Код:
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 12
STR: //
SQL:
DELIMITER //
CREATE TRIGGER `accounts_insert` BEFORE INSERT ON `accounts`
FOR EACH ROW BEGIN
SET new.RegiDate = now();
SET new.UpdateDate = now();
END
//
SQL query:
DELIMITER // CREATE TRIGGER `accounts_insert` BEFORE INSERT ON `accounts` FOR EACH ROW BEGIN SET new.RegiDate = now(); SET new.UpdateDate = now(); END //
MySQL said: Documentation
#1142 - TRIGGER command denied to user '11071_hello'@'localhost' for table 'accounts'
Re: Error In MYSQL Help: -
Vince - 09.09.2013
It's a pretty obvious message that says you don't have permission to use triggers. I reckon only the host will have the ability to edit privileges, so ask them.