• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

SQL Triggers = ERROR!

M

mamon_2

Banned User
Joined
Jul 2, 2007
Messages
424
Reaction score
0
phpMyAdmin - 2.11.4

Code: 
Error
consulta SQL: 

DROP TRIGGER IF EXISTS `oncreate_players` ;



MySQL ha dicho:  

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER IF EXISTS `oncreate_players`' at line 1


Anyone knows?
 
Sort by date Sort by votes
What is your MySQL version?
Mine is MySQL client version: 5.0.51a.
It seems after that upgrade, there was a bit of a problem with the "DROP TRIGGER IF EXISTS", you could try updating to MySQL version 5.1.14 if yours differs (that statement seems to be working just fine with that version, I can test it out in a few minutes if you would like).
[Edit]
Well nvm, what I was talking about was the server edition (misread the article), MySQL client version: 5.0.51a is the latest one out O.o. You could try redownloading the XAMMP system.
 
Last edited:
Upvote 0 Downvote
I think you need to download the newest version of it

Webserv does not Include triggers, But if u are using xampp then u need to download newest version as i said :P
 
Upvote 0 Downvote
Back
Top