mysql_real_query(): SELECT `rep` FROM `players` LIMIT 1; - MYSQL ERROR: Unknown column 'rep' in 'field list' (1054)
>> [REP_SYSTEM] Installing Reputation System...
>> [REP_SYSTEM] System successfully installed.
[Error - GlobalEvent Interface]
buffer:onStartup
Description:
data/lib/004-database.lua:100: [Result:free] Result not set!
stack traceback:
[C]: in function 'error'
data/lib/004-database.lua:100: in function 'free'
[string "loadBuffer"]:15: in function <[string "loadBuffer"]:2>
dont worry that only happens once, once you save your server that won't show up ever
query:free()
if(query:getID() ~= -1) then query:free() end
you didn't add the custom function to your gesior, as is explained at main threadFatal error: Call to undefined function getReputation() in /var/www/characters.php on line 100
executeFatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rep' in 'field list'' in /var/www/rep.php:7 Stack trace: #0 /var/www/rep.php(7): PDO->query('SELECT name, re...') #1 /var/www/index.php(69): include('/var/www/rep.ph...') #2 {main} thrown in /var/www/rep.php on line 7
ALTER TABLE `players` ADD COLUMN `rep` INT( 11 ) NOT NULL DEFAULT '0' COMMENT 'Cyber''s REPSystem © OTLand.net';
wat?
[29/08/2010 14:23:19] > Loading rep_system.xml...[Error - ScriptingManager::loadFromXml] Cannot load mod mods/rep_system.xml
[29/08/2010 14:23:19] Line: 114, Info: Input is not proper UTF-8, indicate encoding !
[29/08/2010 14:23:19] Bytes: 0xA9 0x20 0x4F 0x54
you did not copy the xml mod fineit works on tfs 0.3.6 sql? or just mysql?
I am getting this error:
Lua:[29/08/2010 14:23:19] > Loading rep_system.xml...[Error - ScriptingManager::loadFromXml] Cannot load mod mods/rep_system.xml [29/08/2010 14:23:19] Line: 114, Info: Input is not proper UTF-8, indicate encoding ! [29/08/2010 14:23:19] Bytes: 0xA9 0x20 0x4F 0x54
I have a problem. if you have players with rep on the server the images do not appear. LOOK
SELECT name, rep FROM players WHERE rep > 0 AND name NOT LIKE "%Sample" AND name != "Account Manager" AND deleted = 0 AND group_id = 1 ORDER BY rep DESC LIMIT 10;
SELECT name, rep FROM players WHERE rep < 0 AND name NOT LIKE "%Sample" AND name != "Account Manager" AND deleted = 0 AND group_id = 1 ORDER BY rep ASC LIMIT 10;
SELECT name, rep FROM players WHERE rep > 0 AND name NOT LIKE "%Sample" AND name != "Account Manager" AND deleted = 0 AND group_id = 1 ORDER BY rep DESC LIMIT 10;
SELECT name, rep FROM players WHERE rep < 0 AND name NOT LIKE "%Sample" AND name != "Account Manager" AND deleted = 0 AND group_id = 1 ORDER BY rep ASC LIMIT 10;