SQLite syntax error

[xyzii]

Hello, I have a problem with my vehicle system and logging systems that are based on account names.

So when someone registers an account that has symbols like @, - etc in it, the databases give syntax errors

[xyzii]

Okay.

[JamieSA]

the error...?

[xyzii]

logged in as '$ ad 12-@dd'

dbExec failed; (1) near "ad": syntax error

[pa3ck]

And your code that shows us where to problem is?

[xyzii]

con:exec("CREATE TABLE IF NOT EXISTS ´"..player.account.name.."´ ('num', 'veh', 'x', 'y', 'z', 'rot', 'bp', 'ups', 'plate', 'hp', 'fuel', 'lock', 'r', 'g', 'b', 'r2', 'g2', 'b2', 'paintjob')")

[Snow-Man]

i think correct syntax of SQL creating table is like this

local connection = dbConnect("sqlite", "test.db")
dbExec(connection,"CREATE TABLE IF NOT EXISTS table(numberone TEXT, numbertwo TEXT)")

 

[3aGl3]

17 hours ago, xyzii said:

con:exec("CREATE TABLE IF NOT EXISTS ´"..player.account.name.."´ ('num', 'veh', 'x', 'y', 'z', 'rot', 'bp', 'ups', 'plate', 'hp', 'fuel', 'lock', 'r', 'g', 'b', 'r2', 'g2', 'b2', 'paintjob')")

The entire way you do it is the error. You shouldn't create a new table for every player that registers...
Also you should never use .. to create SQL querys...like this your database is very open to SQL injections.

The proper way to do it would be a table with vehicles and a column with the account name to identify the vehicle owner.

 

[xyzii]

Did it the way you told me to and it's fixed now, thanks 3aGl3!