Вопросы Разработчикам Скриптов с SQL, вопросы по скриптам (мелкие вопросы)

assert(con:execute(("UPDATE `TextSeach` SET '%s' = '%s' + 1 WHERE `Seach` = '%s'"):format("S"..tostring(iNumber), "S"..tostring(iNumber), sSeach)))

[16:55] Синтаксис TopSeach.lua:106: LuaSQL: Error executing query. MySQL: Unknown column 'test1' in 'where clause'

con:execute(("UPDATE `TextSeach` SET `S%s` = `S%s` + 1 WHERE `Seach` = '%s'"):format(tostring(iNumber), tostring(iNumber), sSeach))

function IsScriptRun()
  for k,v in ipairs(ScriptMan.GetScripts()) do
    if v.sName == "abc" and v.bEnabled == true then
      return true
    end
  end
end

function ShowTopSeachDay(sDate)
    local tTemp = {}
    local sMsg = ""
    local sStr = string.rep("=",40)
    local cur = con:execute(("SELECT `id_Seach` FROM `S1` WHERE `date_Seach` = '%s'"):format(sDate))
    local row = cur:fetch({}, "a")
    while row do
        local cur2 = con:execute(("SELECT `Seach` FROM `TextSeach` WHERE `id` = '%s'"):format(row.id_Seach))
        local row2 = cur2:fetch({}, "a")
        while row2 do
            if not tTemp[row2.Seach] then
                tTemp[row2.Seach] = 1
            else
                tTemp[row2.Seach] = tTemp[row2.Seach] + 1
            end    
            row2 = cur2:fetch(row, "a")
        end    
        row = cur:fetch(row, "a")
    end
    for i,v in pairs(tTemp) do
        Core.SendToAll(i.."     "..v)
    end    
    cur:close()
        cur2:close()
  --  return ("%s\t%s\r\n"):format(sMsg,sStr)
end

function UserDisconnected(tUser)
    con:execute(("UPDATE `NicksIPs` SET `out` = %s WHERE `id` = '(SELECT id FROM `NicksIPs` WHERE (`Nick` = '%s' && `IP` = '%s') ORDER BY id DESC LIMIT 1)'"):format(os.date("%Y-%m-%d"), tUser.sNick, tUser.sIP))     
end
OpDisconnected = UserDisconnected
RegDisconnected = UserDisconnected

assert(con:execute[[CREATE TABLE IF NOT EXISTS `NicksIPs`(`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,`Nick` VARCHAR(64) NOT NULL, `IP` VARCHAR(64) NOT NULL,`in` DATE NOT NULL, `out` DATE NOT NULL,PRIMARY KEY(`id`))]])

"UPDATE `NicksIPs` SET `out` = '%s' WHERE `Nick` = '%s' AND `IP` = '%s' LIMIT 1"

UNIQUE(`Nick`, `IP`)