I have a probleme with my sql request

[IparazzHD]

Hello !

I have a problem when i run this code

local QUERY_CREATE_SQLITE = [[
CREATE TABLE IF NOT EXISTS fr_players (
_steamID int PRIMARY KEY,
_money int,
_inventory mediumtext
);

CREATE TABLE IF NOT EXISTS fr_items (
_key int PRIMARY KEY,
_data mediumtext,
);

CREATE TABLE IF NOT EXISTS fr_licenses (
_uniqueID mediumtext unique,
_name mediumtext,
_price int
);

CREATE TABLE IF NOT EXISTS fr_jailpos (
_map mediumtext,
_vector mediumtext
);

CREATE TABLE IF NOT EXISTS fr_doordata (
_entid int PRIMARY KEY,
_map mediumtext,
_title mediumtext,
_hidden boolean,
_owner mediumtext
);

CREATE TABLE IF NOT EXISTS fr_entities (
_map mediumtext,
_id int,
_class mediumtext,
_vector mediumtext,
_angle mediumtext,
_data mediumtext
);
]]

In the console, the message is : * Error: near ")": syntax error

Sorry for my bad english, i'm french

Thanks you ;)

[SteppuFIN]

[QUOTE=IparazzHD;48598564]Hello !

I have a problem when i run this code

local QUERY_CREATE_SQLITE = [[
CREATE TABLE IF NOT EXISTS fr_players (
_steamID int PRIMARY KEY,
_money int,
_inventory mediumtext
);

CREATE TABLE IF NOT EXISTS fr_items (
_key int PRIMARY KEY,
_data mediumtext,
);

CREATE TABLE IF NOT EXISTS fr_licenses (
_uniqueID mediumtext unique,
_name mediumtext,
_price int
);

CREATE TABLE IF NOT EXISTS fr_jailpos (
_map mediumtext,
_vector mediumtext
);

CREATE TABLE IF NOT EXISTS fr_doordata (
_entid int PRIMARY KEY,
_map mediumtext,
_title mediumtext,
_hidden boolean,
_owner mediumtext
);

CREATE TABLE IF NOT EXISTS fr_entities (
_map mediumtext,
_id int,
_class mediumtext,
_vector mediumtext,
_angle mediumtext,
_data mediumtext
);
]]

In the console, the message is : * Error: near ")": syntax error

Sorry for my bad english, i'm french

Thanks you ;)[/QUOTE]

Shouldn't you query them after one is done? I dont think mysql supports multi querying.

[IparazzHD]

I have try, but again this message : * Error: near ")": syntax error

[CGHippo]

[QUOTE=IparazzHD;48598625]I have try, but again this message : * Error: near ")": syntax error[/QUOTE]

Wait what? I don't understand what you're trying to do.

[Alig96]

2nd table, 2nd line, remove the comma before the )

[tzahush]

Query it one by one and locate the source of the error.

[IparazzHD]

I try to execute the query one by one in different variables but it does not work

[_nonSENSE]

There's an extra comma at line 9 (near "_data mediumtext,").

[IparazzHD]

Thanks you very much ;)