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:
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.
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;
#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: