• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

MYSQL ERROR: Unknown column 'cast' in 'where clause' (1054)

mackowiaq

New Member
Joined
Dec 9, 2013
Messages
6
Reaction score
0
Hi guys Please help me about this problem

Code:
[2:16:03.834] mysql_real_query(): UPDATE `players` SET cast=0, castViewers=0, castDescription='' WHERE `world_id` = 0 AND cast > 0; - MYSQL ERROR: Unknown column 'cast' in 'where clause' (1054)
 
u can help me again ? :D

Code:
 [Error - GlobalEvent Interface]
[2:39:42.949]                   domodlib('achievements_config')

[2:39:42.949]                   function onThink(interval)
[2:39:42.964]                           for _, cid in ipairs(getPlayersOnline()) do
[2:39:42.964]                                   if not isPlayer(cid) then
[2:39:42.964]                                           return true
[2:39:42.980]                                   end
[2:39:42.980]
[2:39:42.980]                                   if getCreatureStorage(cid, achievements['no_lifer'].doneStorage) < 1 and getPlayerStamina(cid) < achievements['no_lifer'].hours*60 then
[2:39:42.980]                                           doCreatureSetStorage(cid, achievements['no_lifer'].doneStorage, 1)
[2:39:42.980]                                           doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'Your stamina is lower than '..achievements['no_lifer'].hours..' hours. You obtain [no lifer] achievement.')
[2:39:43.069]                                   end

[2:39:43.079]                                   if getCreatureStorage(cid, achievements['quest_maker'].doneStorage) < 1 then
[2:39:43.103]                                           local n = 0
[2:39:43.111]                                           for _, s in ipairs(quests) do
[2:39:43.118]                                                   if getCreatureStorage(cid, s) > 0 then
[2:39:43.119]                                                           n = n+1
[2:39:43.120]                                                   end

[2:39:43.121]                                                   if #quests*achievements['quest_maker'].percent/100 < n then
[2:39:43.122]                                                           doCreatureSetStorage(cid, achievements['quest_maker'].doneStorage, 1)
[2:39:43.123]                                                           doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'You done more than '..achievements['quest_maker'].percent..'% quests and you get [quest maker] achievement.')
[2:39:43.124]                                                   end
[2:39:43.127]                                           end
[2:39:43.136]                                   end

[2:39:43.177]                                   if getCreatureStorage(cid, achievements['addon_maker'].doneStorage) < 1 then
[2:39:43.193]                                           n = 0
[2:39:43.219]                                           for _, s in ipairs(addons) do
[2:39:43.227]                                                   if not canPlayerWearOutfitId(cid, s, 2) then
[2:39:43.323]                                                           break
[2:39:43.339]                                                   end
[2:39:43.384]                                                   n = n + 1
[2:39:43.404]                                           end

[2:39:43.447]                                           if #addons == n then
[2:39:43.449]                                                   doCreatureSetStorage(cid, achievements['addon_maker'].doneStorage, 1)
[2:39:43.482]                                                   doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'You can wear all addons and you get [addon maker] achievement.')
[2:39:43.502]                                           end
[2:39:43.509]                                   end

[2:39:43.540]                                   if getCreatureStorage(cid, achievements['vip'].doneStorage) < 1 and getCreatureStorage(cid, achievements['vip'].vipStorage) > 0 then
[2:39:43.542]                                           doCreatureSetStorage(cid, achievements['vip'].doneStorage, 1)
[2:39:43.542]                                           doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'You are vip and you get [vip] achievement.')
[2:39:43.589]                                   end

[2:39:43.740]                                   if getCreatureStorage(cid, achievements['vocation_quest'].doneStorage) < 1 and getCreatureStorage(cid, achievements['vip'].questStorage) > 0 then
[2:39:43.743]                                           doCreatureSetStorage(cid, achievements['vocation_quest'].doneStorage, 1)
[2:39:43.800]                                           doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'You\'ve done a vocation quest and you obtain new [vocation_quest] achievement.')
[2:39:43.832]                                   end

[2:39:43.907]                                   if getCreatureStorage(cid, achievements['lucker'].doneStorage) < 1 then
[2:39:43.941]                                           local q = db.getResult("SELECT COUNT(*) as c FROM events WHERE winner_name='"..getPlayerName(cid).."'")
[2:39:43.943]                                           if q:getID() ~= -1 then
[2:39:43.958]                                                   if q:getDataInt("c") >= achievements['lucker'].wins then
[2:39:44.071]                                                           doCreatureSetStorage(cid, achievements['lucker'].doneStorage, 1)
[2:39:44.075]                                                           doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, 'You\'ve won 2 times in events and you obtain new [lucker] achievement.')
[2:39:44.091]                                                   end
[2:39:44.102]                                                   q:free()
[2:39:44.138]                                           end
[2:39:44.141]                                   end
[2:39:44.160]                           end
[2:39:44.238]                           return true
[2:39:44.256]                   end
[2:39:44.258]           :onThink
[2:39:44.258] Description:
[2:39:44.324] [string "LuaInterface::loadBuffer"]:48: attempt to compare number with string
[2:39:44.327] stack traceback:
[2:39:44.374]   [string "LuaInterface::loadBuffer"]:48: in function <[string "LuaInterface::loadBuffer"]:3>
[2:39:44.404] [Error - GlobalEvents::think] Couldn't execute event: achiv_check_badges
 
Back
Top