SQLite Error

[Mann56]

Hey there guys,

I have a little syntax error with Sqlite :

Here's my sql code :

Server side error script :

addEvent("deleteTheGroup",true) 
addEventHandler("deleteTheGroup",root, 
  
function (thePlayer,groupByName) 
        local rankq = getElementData(client,"rank") 
       if rankq == "owner" then 
          local check = dbPoll(dbQuery(connect, "SELECT * FROM groups WHERE column1 = ?",tostring(groupByName)), -1) 
              if type(check) == "table" and #check == 0 or not check then 
              dbExec(connect, "DELETE FROM groups VALUES (?)",tostring(groupByName)) 
    
              end 
          outputChatBox("Group System : Successfully deleted the group!",client,255,255,0) 
       else 
          outputChatBox("You are not the owner!!",client,255,0,0) 
end 
end) 

Thanks....

[Baseplate]

dbExec(connect, "DELETE FROM groups WHERE column1=?",tostring(groupByName)) 

"VALUES" is used in INSERT syntax, use WHERE for conditions.

[Mann56]

Oh,

Thanks mate <3

[Baseplate]

You're welcome mate.