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

Problem on setting up (MySQL)

Flaepru

New Member
Joined
Feb 22, 2008
Messages
3
Reaction score
0
Well I've just tryied to install TFS in my MySQL database and got this error:

consulta SQL:

DELIMITER;

Mensagens do MySQL : Documentação
#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' at line 1

(SQL Query/MySQL says: docs)

I'm familiar to PHP/MySQL, but I can't find out how to fix this. Any tips?
Ah, btw, phpMyAdmin 2.11.4.

Another thing, I noticed this is the last code block that is executed (all tables are created correctly, but they are left empty):

Code:
CREATE TABLE `tile_items`
(
	`tile_id` INT NOT NULL,
	`sid` INT NOT NULL,
	`pid` INT NOT NULL DEFAULT 0,
	`itemtype` INT NOT NULL,
	`count` INT NOT NULL DEFAULT 0,
	`attributes` BLOB NOT NULL,
	FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

See ya.
 
Last edited:
Back
Top