Solved TFS 0.4 - MySql Error

[pierroth]

Hey everyone,

I have an error when I import schema.sql into database.

This is the error I get

Error

SQL query:

EATE 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: 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 'EATE TABLE `groups` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARC' at line 1

Could anyone help me get past this error to upload the database please?

I'm using Windows, Uniform Server program for apache and sql. The same thing happened when using XAMPP.

Thank you!

 

[Tarek]

It says "EATE" instead of "CREATE" try this

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;

 

[pierroth]

Thank you!

But how can I fix it? is it in the schema.mysql, the error shows up when I import the .sql into the database. Anyway to fix it?

Thank you again!

 

[Tarek]

Thank you!

But how can I fix it? is it in the schema.mysql, the error shows up when I import the .sql into the database. Anyway to fix it?

Thank you again!

Open the file in notepad++ and find

EATE 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;

And replace it with

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;

 

[pierroth]

Sir,

You deserve a lot of cookies!

This has been solved! Thank you very much to Tarek!

 

[Tarek]

Sir,

You deserve a lot of cookies!

This has been solved! Thank you very much to Tarek!

no, I want to have alot of kebab.