Database query error

[Ryan2233]

I have a housing script, and this is the lines 

The error is database query failed: no such table: housingdata

local queryResult = executeSQLQuery("INSERT INTO `housingdata`(`name`, `address`, `type`, `interior`, `intlock`, `owner`, `price`, `value`, `income`, `status`, `x`, `y`, `z`, `csX`, `csY`, `csZ`, `csrX`, `csrY`, `csrZ`) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", name ,  address ,  typeint ,  intint ,  "0" ,  "SAHousing" ,  tonumber(price) ,  tonumber(price) ,  tonumber(income) , tonumber(status) , tonumber(x) ,  tonumber(y) ,  tonumber(z) ,  tonumber(csx) ,  tonumber(csy) ,  tonumber(csz) ,  tonumber(csrx) ,  tonumber(csry) ,  tonumber(csrz))

 What can I do?

 

(I've used this script many times before and it normally just creates the table on it's own or there was already one created. I don't know what to do here)

[NeXuS™]

Are you sure the table is called "housingdata"?

[Ryan2233]

36 minutes ago, NeXuS™ said:

Are you sure the table is called "housingdata"?

Yes

39 minutes ago, NeXuS™ said:

Are you sure the table is called "housingdata"?

Btw, I just saw, debug also says "database query failed near: VALUES syntax error if this helps. 

[Ryan2233]

bump