Error 0 after select server help !

PP & R Hi, I have a problem with my server: /
The problem is:
When I select the game server's puts me "unable to connect to the game server !!!"
I'm sure I put the right ip my fps in ps_game.ini, disable my firewall (test) try this:
1) Open your database with SQL
2) Expand PS_GameData > Programabilitys > Stored Producers
3) Find "usp_Read_Char_Product_Item_E"
4) Right click and "Modify" (should open a page)
5) Change the last line saying:

SELECT Slot,ItemID,ItemCount FROM PS.DB01 PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID

INTO THIS:

SELECT Slot,ItemID,ItemCount FROM PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID

6) Execute (Press F5)
7) You are done, try opening game now.

Help me, :'(

Quote:
Originally Posted by abrasive
Failed to connect to game server, after selecting server and clicking ok
May be caused by Windows Firewall blocking the client trying to connect to the server.
Can also be caused by the incorrect IP address entered in D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config\ps_g ame.ini on the line that starts with GamePublicIP=
It could possibly also be from incorrect IP addresses in other .ini files.

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

There are so many threads about this problem. Sometimes it's useful to use the search function. Although you may have tested that already, you could have changed the wrong values.

[Only registered and activated users can see links. Click Here To Register...]

Thanks to abrasive.