problem plz help

[jlskelin]

hi i always get an error like this does any1 know how to fix it ?

[Error - CreatureScript Interface]
[17/07/2012 15:15:08] data/creaturescripts/scripts/templeteleport.luanLogin
[17/07/2012 15:15:08] Description:
[17/07/2012 15:15:08] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!
[17/07/2012 15:15:08] stack traceback:
[17/07/2012 15:15:08] [C]: in function 'error'
[17/07/2012 15:15:08] data/lib/004-database.lua:60: in function 'getDataInt'
[17/07/2012 15:15:08] data/lib/150-VIP.lua:5: in function 'getPlayerVipDays'
[17/07/2012 15:15:08] data/creaturescripts/scripts/templeteleport.lua:2: in function <data/creaturescripts/scripts/templeteleport.lua:1>
[17/07/2012 15:15:08] mysql_real_query(): SELECT `vipdays` FROM `accounts` WHERE `id` = 2 LIMIT 1 - MYSQL ERROR: Unknown column 'vipdays' in 'field list' (1054)

 

[xspree]

you have the "vipdays" table in your db?

 

[Vendeliko]

Why did you pm me?:/

 

[jlskelin]

no i dont idk how to put it

- - - Updated - - -

sorry vendeliko idk how to fic this prob so im hoping you will but u dont need to help me just ignore

 

[Shockah]

Take all the VIP scripts you have from actions.xml and movements.xml - By the looks of it your console is trying to find the table in your database because of certain scripts, but if you dont have the tables it won't find it so removing these scripts should fix it.

 

[xspree]

i suspect that he wants to continue with the scripts... just want to fix this errors, right?

 

[jlskelin]

yes

 

[Shockah]

If you want to keep the vip scripts then search around on how to add a vip table to your database, there will be threads on it I've done it before. Sorry but I can't remember how to do it, was about a year ago.

 

[City]

something like this

alter table accounts add column vipdays int(11) ;

 

[jlskelin]

something like this

alter table accounts add column vipdays int(11) ;

ty so much it works rep