• 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] Unknown column in field list

sharpy

New Member
Joined
Jan 4, 2010
Messages
77
Reaction score
0
I am trying to use Rohan-Ots Fastfingers script and I found one thread were someone else had the same problem as me,
However when i tried to use the fix posted i got a different error...

here is the error i am getting in the console:

Code:
mysql_real_query(): INSERT INTO `global_storage_strings`(`key`, `world_id`, `stringz`) VALUES (1337, 0, TXVHMQLXHK); - MYSQL ERROR: Unknown column 'TXVHMQLXHK' in 'field list' (1054

and here is the line in 050-function.lua that is causing the error:

Lua:
function setGlobalStorageString(key, string)
    return db.executeQuery("INSERT INTO `global_storage_strings`(`key`, `world_id`, `stringz`) VALUES (".. key ..", 0, ".. string ..");")
end

I think this is the problem with it: setGlobalStorageString(key, string)

but i do not know what to change string too or if that is really even the problem...

If anyone could help me with this i would greatly appreciate it!!!
 
Last edited:
Lua:
function setGlobalStorageString(key, value)
    return db.executeQuery("INSERT INTO `global_storage_strings` (`key`, `world_id`, `stringz` VALUES (" .. key .. 
        "), 0, \"" .. value .. "\"")
end


_
Regards,
sn3ejk
 
Back
Top