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

Error while importing database - TFS 0.2, Mystic Spirit

Archez

'
Senator
Joined
Jun 26, 2008
Messages
6,589
Solutions
1
Reaction score
73
Location
Mexico
I got an error while I was importing the SQL file to my database.

This is a picture:

error-1.jpg


And this is in text:

Code:
[B]Error[/B]

[U]SQL query:[/U]

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

[B]MySQL said:[/B] Documentation
#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 |

[B]CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
' at line 1[/B]

I hope someone can help me, thank you.

:)
 
It happens when you are using the newest xammp, i had this problem too and i upgrade my xammp to Version 1.6.4 and all is now perfect ^^

It will works too if your update you phpmyadmin.

If you need links to download it, just say it.

Greatings
DX~
 
Last edited:
Back
Top