Windows SQLite Studio Error Tibia 8.60 TFS 0.4_DEV rev3884

[samuel157]

columns name, deleted are not unique ?

/\​

Unknown​

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "mage": syntax error (UPDATE "players" SET "name" = '[Vip] Lord'mage' WHERE `id` = 4598

because of that = '

You have any query I do not know who can solve?

My 004-Database

if(result ==nil)thenprint("> WARNING: Couldn't load database lib.")returnend

Result= createClass(nil)Result:setAttributes({
id =-1,
query =""})

functionResult:getID()returnself.idend

functionResult:setID(_id)self.id = _idend

functionResult:getQuery()returnself.queryend

functionResult:setQuery(_query)self.query = _queryend

functionResult:create(_query)self:setQuery(_query)local _id = db.storeQuery(self:getQuery())if(_id)thenself:setID(_id)end

returnself:getID()end

functionResult:getRows(free)local free = free orfalseif(self:getID()==-1)then
error("[Result:getRows] Result not set!")end

local c =0
repeat
c = c +1untilnotself:next()

local _query =self:getQuery()self:free()if(not free)thenself:create(_query)end

return cend

functionResult:getDataInt(s)if(self:getID()==-1)then
error("[Result:getDataInt] Result not set!")end

return result.getDataInt(self:getID(), s)end

functionResult:getDataLong(s)if(self:getID()==-1)then
error("[Result:getDataLong] Result not set!")end

return result.getDataLong(self:getID(), s)end

functionResult:getDataString(s)if(self:getID()==-1)then
error("[Result:getDataString] Result not set!")end

return result.getDataString(self:getID(), s)end

functionResult:getDataStream(s)if(self:getID()==-1)then
error("[Result:getDataStream] Result not set!")end

return result.getDataStream(self:getID(), s)end

functionResult:next()if(self:getID()==-1)then
error("[Result:next] Result not set!")end

return result.next(self:getID())end

functionResult:free()if(self:getID()==-1)then
error("[Result:free] Result not set!")end

self:setQuery("")local ret = result.free(self:getID())self:setID(-1)return retend

Result.numRows =Result.getRowsfunction db.getResult(query)if(type(query)~='string')thenreturnnilend

local ret =Result:new()
ret:create(query)return ret
end