Unrecognized Token

[undefined]

local database = dbConnect("sqlite", "parchement.db") 
dbExec(database, "CREATE TABLE IF NOT EXISTS parchement (account_name TEXT, parchement TEXT DEFAULT "..toJSON({})..")") 

WARNING: system\save\save.lua:2: dbExec failed; (1) unrecognized token: "]"

Where is the problem?

[xXMADEXx]

Try putting the toJSON in single quotes.

local database = dbConnect("sqlite", "parchement.db") 
dbExec(database, "CREATE TABLE IF NOT EXISTS parchement (account_name TEXT, parchement TEXT DEFAULT '"..toJSON({}).."')") 

I'm honestly not sure if this will fix the problem though.

[Noki]

You can't set defaults for text fields in MySQL.

Edit: didn't see it was SQLite. Silly me.

Edited June 26, 2016 by Guest

[undefined]

Try putting the toJSON in single quotes.

local database = dbConnect("sqlite", "parchement.db") 
dbExec(database, "CREATE TABLE IF NOT EXISTS parchement (account_name TEXT, parchement TEXT DEFAULT '"..toJSON({}).."')") 

I'm honestly not sure if this will fix the problem though.

Solved, thank you.