Anyone ever had this issue?

[coolgirlpwns]

[MentaL]

[Zorno]

This is a weird problem that i keep having. I think i know what the problem is, but how do i fix it?

The issue is, it takes about like 40+ seconds to login to the game(about 75% of the server cant even login they get server network error) But for th epeople who can login everything is weird and if you had GM you lost it o.o But i noticed that this happend when i had more than 2,000 jaden entrys in the mysql database thing, so i just cleard them and everything was fine back to normal. But now every table is at 0 besides auth table and users table. But the users table is at about 5,000 >< Does this mean im screwed? Is it time to just move on to mssql and do a server wipe? Or has anybody goten a fix for this? =) Please let me know thanks

Jaden ? Whats that ? Sounds like the wrong game or you changed the name of cubies

MSSQL sucks. MySQL is the better choice.

Check your tables. Maybe you have something in there which causes an error and the server hangs there. Also check the connections. I once had someone trying hundrets of connections to my MySQL and that blocked the whole login. ( i guess it was just a broken program which caused an endless loop because i dont think someone is that stupid attacking a Server from just 1 IP )

[pastime4u]

try to find if any tables is broken

[coolgirlpwns]

Jaden ? Whats that ? Sounds like the wrong game or you changed the name of cubies

MSSQL sucks. MySQL is the better choice.

Check your tables. Maybe you have something in there which causes an error and the server hangs there. Also check the connections. I once had someone trying hundrets of connections to my MySQL and that blocked the whole login. ( i guess it was just a broken program which caused an endless loop because i dont think someone is that stupid attacking a Server from just 1 IP )

the tables arnt broken, and my server is only avalible for my GMs right now, nobody can connect cause i changed the ip and stuff. I planed to release it today but we came into this problem. And by jadens i did mean cubies sorry. Ummm but if theres to much cubi in the server can this error happen? Soemone told me if theres more than 20mil cubi then this happens? Is there anyway to delete all cubi off of every single account?? and what happens if i play around with usr/rain/uniquenamed/dbhomewdb/dblogs theres like literally thousands of little things called log.4c82163 things

[xAtticusx]

coolgirl is asking about Jade Dynasty btw, this is why some names and file directories may differ. But the files are practically the same.

Jaden = Cubi
/usr/rain/ = /PWServer/

Just thought I might clear that up [:

[coolgirlpwns]

ive figured out the problem. Now all i need is a way to delete all cubi/jaden off everyones account. Is there a way to do this? like a log file i can clear somewhere?

[germania]

There iss a table in your database usecashlog and usecash now ;)
make all 0 so i think it should work

[coolgirlpwns]

There iss a table in your database usecashlog and usecash now ;)
make all 0 so i think it should work

i need to remove it from the game, not the phpmyadmin. that only removes the entry.

[Zorno]

i need to remove it from the game, not the phpmyadmin. that only removes the entry.

you need to clear it out of the gamedbd. Go into that folder of your server and use the database tools inside it. Dunno if its possible but im pretty sure there is a way with that. And i guess its the only way. Or try to find the database files and check for the tabled but i guess thats hard.

[Romulan]

Issue that concern JD servers only cuz I never heard that for PW servers...

Btw, maybe it's possible by a JSP script to clear the jadens of every accounts, but it will stress the GameDB a lot and maybe corrupt it...

PW and JD are similar but not exactly the same. Like the issue about the ptemplate.conf for rates (don't works on JD but works on PW).