gmstrikker
Well-Known Member
- Joined
- Jul 30, 2014
- Messages
- 458
- Solutions
- 1
- Reaction score
- 50
I need to run:
To install a lib i found here on forum, but when i try, returns this error:
What should i do?
Code:
CREATE TRIGGER `guilds_update`
AFTER UPDATE OF rank_id ON players
BEGIN
UPDATE players
SET guild_id = IFNULL( (
SELECT guild_id
FROM guild_ranks
WHERE id = rank_id
)
, 0 );
END;
To install a lib i found here on forum, but when i try, returns this error:
Code:
SQL query:
CREATE TRIGGER `guilds_update`
AFTER UPDATE OF rank_id ON players
BEGIN
UPDATE players
SET guild_id = IFNULL( (
SELECT guild_id
FROM guild_ranks
WHERE id = rank_id
)
, 0 )
MySQL said: [IMG alt="Documentation"]http://localhost/phpmyadmin/themes/dot.gif[/IMG]
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OF rank_id ON players
BEGIN
UPDATE players
' at line 2
What should i do?