SubHelper

[LikeToMove]

Hi guys, I wanna ask if any1 has got this error on subhelper:

2014/02/03 06:37:38 :: SYSTEM_RANKING_EX ERROR: RankingEX_RefreshDate()_1 >

This output string appears when any player try to open ingame ranking list, and the ranking list dont load any data.

 

You know a solution?

[maxig]

you need add Titles for ex-rogue and ex-mage  for ranking?

[LikeToMove]

Titles for EX chars added and work fine.

But all my chars are like lvl 100

[Nymphetamine]

Mmm from what i can read theres a problem with the refresh date of it

Did u set it?

[luoo]

the error appears if this query fails

INSERT INTO t_ranking_date(a_date) VALUES(%s)

 

so check the table and try again.

And it is important that you start subhelper before gameserver

[LikeToMove]

the error appears if this query fails

INSERT INTO t_ranking_date(a_date) VALUES(%s)

 

so check the table and try again.

And it is important that you start subhelper before gameserver

 

Yeah I start SubHelper before all GameServers!

This is the content of my a_date:

2

 

 

All 3 fields with todays date: a /rankrefresh0831 after SubHelper restart (I tried more /rankrefresh commands before subhelper restart but nothing happens!)

[CDWriter]

Try just Emptying the tables with navicat if your running it ... Dont Truncate them then, do the refresh command from game...

[CDWriter]

So is this Topic closed ? and if it is who our how did you fix it ?  Thanks 

[LikeToMove]

Tried with all your suggestions but nothing, this trouble still alive.

Waiting for more helps (if any1 want)

[CDWriter]

first empty all ranking tables then add a date to t_ranking_date ...just add todays date, reset subhelper.

then go in game hit ranking then reset, then do the gm command rankrefresh0831....

 

 

done