[Mysql] save account problem

[elking]

Hello people of OTLand.

I get this problem when I try to login with anycharacter or hit enter only
It might delay , it also happened during play in Ot

I use TFS 0.4 trunk 3884

BUMP

 

[Cronox]

Ohhh!! what version TFS are you using

 

[elking]

Ohhh!! what version TFS are you using

I use TFS 0.4 trunk 3884

 

[Cronox]

You script it works
are you sure have added in your 050-functions ,the functions
getPlayerVipDays ? post your 050-functions
data/lib/050-functions.lua

 

[Cronox]

are you have query added on your phpmyadmin

ALTER TABLE `players` ADD
`vipdays` int(11) NOT NULL DEFAULT 0;

 

[elking]

are you have query added on your phpmyadmin

ALTER TABLE `players` ADD
`vipdays` int(11) NOT NULL DEFAULT 0;

Yes Its already exist

#1060 - Duplicate column name 'vipdays'

 

[Cronox]

how you have added in your globalevents.xml
the script ,I test and works fine

 

[Limos]

Already tried to readd the column? Maybe it's not added correct.

 

[Cronox]

Yes.. try remove your column and added again ,how you need enter SQL
Use - Structure in Players..
and search your vipdays (put in X) to remove and remove.
and back added your vipdays (Query exactly)

ALTER TABLE `players` ADD
`vipdays` int(11) NOT NULL DEFAULT 0;

 

[elking]

Yes.. try remove your column and added again ,how you need enter SQL
Use - Structure in Players..
and search your vipdays (put in X) to remove and remove.
and back added your vipdays (Query exactly)

ALTER TABLE `players` ADD
`vipdays` int(11) NOT NULL DEFAULT 0;

I tried but I think there is problem with mysql.sql because it was work fine when I was try it with Sqlite.sql
now give this error

 

[Cronox]

why u use sqlite.sql
? is bad

 

[elking]

why u use sqlite.sql
? is bad

I use mysql.sql I was said that when I was work with sqlite.sql wasn't give this error

 

[elking]

@Cronox BUMP

 

[Cronox]

You need use mysql ,i think don't follow step for step to added vvip system and get Error On getvipdays

 

[elking]

You need use mysql ,i think don't follow step for step to added vvip system and get Error On getvipdays

I already use mysql

BUMP

BUMP
Help me guys

@Limos @Cronox Help

 

[Cronox]

Ok well.. listen
explain 100% what is your problem and how u added your sistem.
and what u want fix

 

[Limos]

Or just do the MySQL setup again from the start (so delete what you have now), you probable did something wrong.
Follow this tutorial.
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

Make sure you import the mysql schema from your server.

 

[elking]

Ok well.. listen
explain 100% what is your problem and how u added your sistem.
and what u want fix

My problem is getting error and kick when I try to create account or character by vip effect

and this happend when I try to login after getting problem
its didn't open any account however there is account in phpmyadmin

I added vipdays which you was made it to me in other thread

Or just do the MySQL setup again from the start (so delete what you have now), you probable did something wrong.
Follow this tutorial.
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

Make sure you import the mysql schema from your server.

Ok I will try now