Heya, here is the answer:
Disconnect after selecting game server and clicking ok
Most likely you have incorrect or missing data in your database. There could be many causes of this. I'd suggest using the SQL profiler to trace what happens in this case and look for error messages in the logs. If there is an error message present in the logs try to find which SQL query that you traced with the profiler caused it.
I've ran into this specific cause of the above many times now, and it always happens to me when I set up a fresh server. Never have I seen anyone else mention it before though. I decided to add it here just in case it would be useful to someone.
Inside of PS_GameData.dbo.usp_Read_Char_Product_Item_E there is this query:
Code:
SELECT Slot,ItemID,ItemCount FROM PS_USERDB01.PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID
Since PS_USERDB01 does not exist, it causes my client to disconnect after selected the server and clicking ok.
To fix it, I remove PS_USERDB01 from the stored procedure so the query looks like this:
Code:
SELECT Slot,ItemID,ItemCount FROM PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID
It took 1minute to find it:
i Just did a copy/paste.
Credits go to Abrasive.
Crash client when select server
Shaiya PServer Development -> Shaiya Private Server
