• 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!

[Help] I got bug when trying import to the database..

Galgula

New Member
Joined
Nov 15, 2007
Messages
28
Reaction score
0
Hello,
I am new in TFS nor SQL and all that database thing.
I usually used evo for my servers and then i realized that its sux.

Anyway when im creating the database and try to import theforgottenserver.sql in it it says:

Error
SQL query:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `account` = OLD.`id` ;



MySQL said:

#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 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR ' at line 1
Anyone knows how to fix it 0.o?

Sorry for my bad english xP

Edit:
Fixed it i had to use Phpmyadmin ver 2.11

Another question:
I need to import the aac database.sql to my database either?
 
Last edited:
Back
Top