SQLite Problem! [Solved]

[undefined]

Hi guys. Im work on my save system. But I have a problem.

I get this error:

ERROR: mas\DB\hud_option.lua:29: Database query failed: no such table: hud_option 
ERROR: mas\DB\hud_option.lua:29: attempt to index field '?' (a nil value) 

Here is my DB:(Empty)

And here is my code:

Code Removed 

Help pls...

Edited February 6, 2015 by Guest

[WASSIm.]

i don't see tablr called hud_option

[undefined]

Is not it?

dbQuery(connectDB, "CREATE TABLE IF NOT EXISTS hud_option (hudColor STRING, hudOption STRING") 

[WASSIm.]

i mean database server not database on custom file bcs you'r use executeSQLQuery if you see it in line 31

[undefined]

Here is my new code:

Code Removed 

And Error:

ERROR: mas\DB\hud_option.lua:43: attempt to index a userdata value 

Edited February 6, 2015 by Guest

[WASSIm.]

you forget to use

dbPoll 

[undefined]

What is this?

I read this on wiki but I don't understand.

[TAPL]

It's return the result of the query. Also for update and insert use dbExec because there's no result will be returned.

[undefined]

local query = dbQuery(connectDB, "SELECT hudColor FROM hud_option WHERE account_name=?", tostring(account_name))[1].hudColor -- Line 42 
local result = dbPoll(query, -1) 
if result then 
    return fromJSON(query) 
end 

I'm make this but it's not work!

ERROR: mas\DB\hud_option.lua:42: attempt to index a userdata value

[TAPL]

You should return the result not the query. And the close bracket at line 1 is missing.

[undefined]

local query = dbQuery(connectDB, "SELECT hudColor FROM hud_option WHERE account_name=?", tostring(account_name)) 
local result = dbPoll(query, -1) 
if result then 
    return result 
end 

And the close bracket at line 1 is missing.

Where? I can't see. Can you show me?

[TAPL]

local query = dbQuery(connectDB, "SELECT hudColor FROM hud_option WHERE account_name=?", tostring(account_name)) 
local result = dbPoll(query, -1) 
if result then 
    return result 
end 

And the close bracket at line 1 is missing.

Where? I can't see. Can you show me?

Nothing in this code, have you tried it?

[undefined]

Yes, I tried it. It's not give error or warning. And it's not work. The result table is empyt.

Here is my new all code:

Code Removed 

Edited February 6, 2015 by Guest

[WASSIm.]

dbPoll: for get result from dbQuery

dbQuery: for get data from database

dbExec: for edit database

[undefined]

So?

[Noki]

Pseudo code:

Query from the database

Poll the query

If query poll returned a table

Do what you want

[WASSIm.]

SO... look at your code again

[undefined]

I'm new on SQLite. I can't see my mistake

Please show me my mistake

[undefined]

Up!

[WASSIm.]

try this

REMOVE

Edited February 6, 2015 by Guest

[undefined]

@Wassim

I already solved this problem. But thank you nevertheless.

Code Removed 

OK. I understand now . Now, return is not work. Look at the line 11

It must say; [ [ true, true, true, true, false, 255, 190, true, true ] ]

But it say; [ [ { "hudOption": false } ] ]

Where is the problem?

Edit:

return dbPoll(dbQuery(connectDB, "SELECT hudOption FROM hud_option WHERE account_name=?", tostring(account_name)), -1)[1].hudOption-- Line 63 

outputChatBox said: [ false ]

Edited February 6, 2015 by Guest

[undefined]

SOLVED!