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

mysql error loading schema

tozikrulz

New Member
Joined
Jun 10, 2009
Messages
46
Reaction score
1
Hello good people,
I decided to try a new distro today (otserv 0.6.4) but i have fallen at the first hurdle, this is the error i get when importing schema.mysql to the database:

Code:
CREATE TABLE `groups` (
   `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
   `name` VARCHAR(255) NOT NULL COMMENT 'group name',

   `flags` BIGINT UNSIGNED NOT NULL DEFAULT 0,
   `access` INT NOT NULL DEFAULT 0,
   `violation` INT NOT NULL DEFAULT 0,
   `maxdepotitems` INT NOT NULL,
   `maxviplist` INT NOT NULL,

   PRIMARY KEY (`id`)
) ENGINE = InnoDB;
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 'EATE TABLE `groups` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARC' at line 1

I am a novice OT enthusiast and would like to get this more stable distro started up, can someone help me with this problem, thank you in advance.
 
Last edited:
Please read the rules; Rules for the Support board
#7

How to display CODE properly in your post

SQL:
CREATE TABLE `groups` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL COMMENT 'group name',

`flags` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`access` INT NOT NULL DEFAULT 0,
`violation` INT NOT NULL DEFAULT 0,
`maxdepotitems` INT NOT NULL,
`maxviplist` INT NOT NULL,

PRIMARY KEY (`id`)
) ENGINE = InnoDB;
 
Back
Top