SA-MP Forums Archive
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: MySQL help. (/showthread.php?tid=462889)



MySQL help. - sampmark05 - 09.09.2013

Hello Everyone.

Im having this problem on phpMyAdmin when i uploaded my SQL file.

Error

Код:
Error

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 '11670_hello'@'localhost' for table 'accounts'



Re: MySQL help. - Sithis - 09.09.2013

Don't know why you would need a trigger for such a basic table, but it seems your user doesn't have the permissions to create triggers in your database. Ask your hoster, or if you host it yourself, assign the permission.