Unknown column 'rep' in 'field list'

[Devil_Abdo]

[28/01/2015 14:50:13] [Error - CreatureScript Interface]
[28/01/2015 14:50:13] buffernLook
[28/01/2015 14:50:13] Description:
[28/01/2015 14:50:13] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[28/01/2015 14:50:13] stack traceback:
[28/01/2015 14:50:13] [C]: in function 'error'
[28/01/2015 14:50:13] data/lib/004-database.lua:60: in function 'getDataInt'
[28/01/2015 14:50:13] [string "rep = {..."]:16: in function 'getPoints'
[28/01/2015 14:50:13] [string "loadBuffer"]:4: in function <[string "loadBuffer"]:2>
[28/01/2015 14:50:14] mysql_real_query(): SELECT `rep` FROM `players` WHERE `id` = 3; - MYSQL ERROR: Unknown column 'rep' in 'field list' (1054)
when i look to anyone when i use mysql when i use sqlite there is no bug

 

[Breed]

Sql is pretty straight forward you have no column named rep in your mysql database, but you do have one in your sqlite database and this is why you don't get the error when you use sqlite.

Goto your phpmyadmin page select your database and then the sql tab clear anything the box and paste this in

ALTER TABLE `players` ADD `rep` INT NOT NULL DEFAULT 0;

click the go button and this should fix the error