My SQL Error

[MisterQuestions]

Hi i got an error from the script and says 'unexpected symbol near ';'

Code:

mysqlconnect = {user=; connect=; password=; database=;} 
  
dbConnectTable = { 
    connect = false, 
    user = "user", 
    password = "", 
    ip = "thehost", 
    table = "table", 
} 
  

whats wrong??

Edited August 22, 2014 by Guest

[./BlackBird#]

mysqlconnect = {user="", connect="", password="", database=""} 
  
dbConnectTable = { 
    connect = false, 
    user = "user", 
    password = "", 
    ip = "thehost", 
    table = "table", 
} 
  

[MisterQuestions]

Now say's Unexpected symbol near ','

[./BlackBird#]

try it again, i edited it

[MisterQuestions]

Mmm work's ! no errors now, but what was the error?

[./BlackBird#]

you haven't defined user, connect, password, database in table

[MisterQuestions]

I got a new error..... And say's attempt to index global 'infoDatabase' (a nil value) lua:15:

function onResourceInfoStart() 
    dbConnectTable.connect = dbConnect("mysql","dbname="..dbConnectTable.table..";host="..dbConnectTable.ip, dbConnectTable.user, dbConnectTable.password) 
    if dbConnectTable.connect then 
        checkMySQLTable(dbConnectTable.connect,infoDatabase.tableName,infoDatabase.tableStructure) 
        commandSystemMySQLInit() 
        likeSystemDatabaseInit() 
    end 
end 

[#DRAGON!FIRE]

u defineded the infoDatabase table ?

[MisterQuestions]

its by a separated resource and this is the table...

local infoDatabase = { 
    tableName = "TC_Map_info", 
    tableStructure = { 
        {"mapName","TEXT DEFAULT '' NOT NULL"}, 
        {"author","TEXT DEFAULT '' NOT NULL"}, 
        {"created","TEXT DEFAULT '' NOT NULL"}, 
        {"lastTimePlayed","INT(6) DEFAULT 0 NOT NULL"}, 
        {"playedCount","INT(6) DEFAULT 0 NOT NULL"}, 
        {"toptimes","INT(6) DEFAULT 0 NOT NULL"}, 
        {"hunters","INT(6) DEFAULT 0 NOT NULL"}, 
        {"kills","INT(6) DEFAULT 0 NOT NULL"}, 
        {"assists","INT(6) DEFAULT 0 NOT NULL"}, 
    } 
} 

[xXMADEXx]

Can you please post the following functions:

checkMySQLTable 
commandSystemMySQLInit 
likeSystemDatabaseInit 

Thanks.

[#DRAGON!FIRE]

put the table in this resource .. and u don't have to use table to get the table name .. u can put it in your code without call table to get table name