[MySQL] Error in consile

[mesosot]

i have multi servers / 2 servers in 1 PC and same database , so i have only 1 Acc for two servers , but when i log in the second server it give me this sql error

mysql_real_query<>: select "vip_time"from "accounts" where "name" = "123456" ; - MYSQL Error : unknown colume "vip_time" in field list" <1054 >

so how i solve dat

sorry for english

 

[Don Daniello]

You should import MySQL schema for your VIP system.
If you can't find it, try this:

ALTER TABLE `accounts` ADD `vip_time` BIGINT NOT NULL DEFAULT 0;

 

[mesosot]

what you mean ? can u make it more clear ...

 

[Don Daniello]

Execute the query I posted above and check if it works then.

 

[mesosot]

okay i will test

 

[mesosot]

worked no error =) thanks brother rep+++ but i wanna ask it may make any change on the other server ?

 

[Sonical]

It really doesn't matter if you don't use Vip system cuz this was an error of it This solved the error but if someone gets vip somehow and your server has somekind of vip script which will give special advantages for them without your premission
I suggest you to search your creaturescripts/mods if there is something to do with vip system, also search in actions.xml/movements.xml with keyword "vip", it shows you if it has any vip scripts, at least if they'r named with vip XXXX.lua