MySQL Database

[Ahead]

I found this error when i import my server database.sql.

Error
consulta SQL:

INSERT INTO [server_config](

[config],
[value]
)
VALUES(
'db_version', 38
);



MySQL ha dicho:

#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 '[server_config] ([config], [value]) VALUES ('db_version', 38)' at line 1

 

[Ahead]

BUMP

 

[Ahead]

Sorry for the second BUMP but i really need help on this, nobody can help me out of here... u.u

 

[Ahead]

If i try to import this:

https://github.com/otland/forgottenserver/blob/master/schema.sql

It works, but everything is empty (obviously, it is a free and public scheme). So i need to import mine but i do not know what can cause the #1064 error here.

And it seems that the problem comes from here (inside my .sql file):

-- Table: server_config
CREATE TABLE server_config (
    config VARCHAR( 35 )   NOT NULL
                           DEFAULT '',
    value  VARCHAR( 255 )  NOT NULL
                           DEFAULT '',
    UNIQUE ( config )
);

INSERT INTO [server_config] ([config], [value]) VALUES ('db_version', 38);
INSERT INTO [server_config] ([config], [value]) VALUES ('encryption', 2);

I am trying to give you as much as posibles details to solve it better.

QUESTION: My server is almost brand-new. I mean, i have just tested map things inside, so i have not created accounts neither touched another table. So, it would mean that should i import the scheme which works for me (although it is empty)??????

Thank you.

 

[dominique120]

You realize that the schema on github is for TFS 1.0, it will not work well with TFS 0.3.7

 

[Ahead]

You realize that the schema on github is for TFS 1.0, it will not work well with TFS 0.3.7

Are you saying that although it lets me import the scheme, it would produce me an error then?

 

[dominique120]

Are you saying that although it lets me import the scheme, it would produce me an error then?

I am saying that once you run your server you will get problems regarding queries and errors about missing columns and what not because the TFS 1.0 schema is different compared to the 0.3.7 schema

 

[Ahead]

Yes dominique, i am really pleased for you comment, i already corrected it.