Wierd EP6 glitch

07/23/2018 18:14 ShFanatic#1
Hello,

As I took a break and just resumed working on a server, I noticed that several things are very wrong.

When I log in, character names are not showing in the character selection nor in-game. When I create a new character, I get disconnected while checking the names availability.

I read that this is due to linked servers missing, but my linked servers are installed.

Literally, everything worked perfectly fine months ago when I last worked on it, now I come back to these strange issues.

I made new DB logins to see if maybe that is connected to the problem, this did not fix it either.

I did not change or edit any executables, the ps_game is still original as per Traynes release. I also use Europes client, which is suggested to use with his server files.
Even a clean extracted client causes the same problem, so I am clueless.

It's not the ps_game, it's not the game.exe, linked servers are installed and the configs are in order as well.
07/25/2018 06:27 nick4ever#2
Linked servers installed but was it the correct one?

What did the logs throw, sir?

Try to create new character using sql first.
07/25/2018 10:47 ShFanatic#3
I reinstalled the linked servers, but I still have the same issue.

Cannot create characters due to name check DC. Manually created a char through the DB and it still doesn't show the character name.
07/25/2018 16:25 [DEV]Wan#4
Quote:
Originally Posted by ShFanatic View Post
I reinstalled the linked servers, but I still have the same issue.

Cannot create characters due to name check DC. Manually created a char through the DB and it still doesn't show the character name.
check your sql and Logs
07/25/2018 21:03 ShFanatic#5
Logs don't show any errors, everything is fine.

Something that comes to mind is maybe a OS setting causing the problem? I remember having to do all recent Windows Updates in order to be able to connect with RDP due to the recent security update that came in May.

What is the Windows Service called that is required for Item Mall to work? Maybe it got disabled with the update and need to enable it again.
07/26/2018 01:55 sominus#6
For itemmall: MSDTC service On

And sometimes also need RPC OUT enabled in MSSQL
Code:
EXEC master.dbo.sp_serveroption [MENTION=485444]server[/MENTION]=N'MYSERVER', [MENTION=1489981]opt[/MENTION]name=N'rpc out', [MENTION=1489981]opt[/MENTION]value=N'true'
GO
But in both cases, if you don't have them, you'll get error msgs in your logs

Now for your DC issue, be sure to be using the correct DB for the server files you have, and also be sure to have all the SQL PROCs your server need.
07/26/2018 06:52 nick4ever#7
I asked you if you installed the corrected linked server, not ask for reinstalling it.

Please post your linked server query here.

Also post your creating account and character insert query.

What happens when you execute creating account and character query? Some screenshot should help.
07/31/2018 11:03 killer2p#8
For the names not showing its a visual bug that is in episode 6. It's a bug in the game.exe for the check availability it's a missing procedure. It has nothing to do with linked servers.

Both of these are known bugs however I'm unsure how to fix the name bug. But the check availability is actually released on evp