MySQL help.
#1

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'
Reply
#2

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)