Shaiya Private Server - Instructions - English

Actual Problem: Game in GameGroups01 stay stopped. None of the others stop. All working except these.

C:\SHAIYA_SERVER\Server\PSM_Client\Bin\Log\PS_GAME __system.log_20120911_153409.log:


2012-09-11 15:34:17 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_DEFINEDB' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-09-11 15:34:17 CGameData::LoadItemLimit: err=-1, query=exec usp_Read_ItemCount_ByServer_R

2012-09-11 15:34:17 DB table load error item limit

2012-09-11 15:34:17 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-09-11 15:34:17 Call save all waiting...

2012-09-11 15:34:17 Call save all failed dbagent disconnected(user count = 0)...

2012-09-11 15:34:17 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0

2012-09-11 15:34:17 Save MobID=1963109

2012-09-11 15:34:17 PS_GAME__system log end (Game01)

2012-09-11 15:34:17 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Plz help idk what to do atm.

2012-09-11 15:34:17 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_DEFINEDB' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-09-11 15:34:17 CGameData::LoadItemLimit: err=-1, query=exec usp_Read_ItemCount_ByServer_R

2012-09-11 15:34:17 DB table load error item limit




ur error read in ur loggs and u will figure it out next time ur self instead of posting them without having read them....

Am totally noob n dobt understand. Can u help?

Quote:

Originally Posted by zarazagan 2012-09-11 15:34:17 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_DEFINEDB' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

That is all the help you need, the error itself is telling you how to fix this issue.

sry but didnt work yet.....ill post my text located in C:\SHAIYA_SERVER\Server\PSM_Client\Bin\Config\ps_g ame.ini:

[SERVER]
ServerName=Game01
ServerPort=
MaxConnection=10
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
DBAgent=127.0.0.1
GameLog=127.0.0.1
[DB]
GameDef=127.0.0.1, PS_GameDefs, Shaiya, D0F4D4A488131AD5FF3E02A94E2B0E4425C56B923C436C928E 022FBCDC640DFF95B8EF920CDC68FE17309FA0B0CD5F24E4BF 51F1F2858FC0E3A40A5C24A7F782FA60C33F5E9C2237F49A78 F6AE5B4CAE63B0FA263BB3F02B96D96B13386B137AA97DE2EA 9B840AE4E9B648DDB21F137222FCE5EFC4A288519D230FC77E 30162D
GameData=127.0.0.1, PS_GameData, Shaiya, D0F4D4A488131AD5FF3E02A94E2B0E4425C56B923C436C928E 022FBCDC640DFF95B8EF920CDC68FE17309FA0B0CD5F24E4BF 51F1F2858FC0E3A40A5C24A7F782FA60C33F5E9C2237F49A78 F6AE5B4CAE63B0FA263BB3F02B96D96B13386B137AA97DE2EA 9B840AE4E9B648DDB21F137222FCE5EFC4A288519D230FC77E 30162D
[GAMEINFO]
GameName=Game
GamePublicIP=85.242.81.239
GameVersion=0x08022100
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000


ild like to know why not working already did all the steps of sv 10x´+ n always give error to some of this part stop in server patch config.

You are showing some irrelevant information there, read what I marked on the quote and execute what it is telling you to execute...

what requirement does my computer need to be able to make and play the pserver?????

I did my first login today. But when i was in character screen and clicked Start Game i just got dc. Any1 may help? Tyvm for reading

Hey, I have a problem with step 5 of the setup, when i click start all server service all the icons start and then stop again... When i look in the ps_session file in : C:\ShaiyaServer\SERVER\PSM_Client\Bin\Log
It says "userlog connect failed"
How can I fix this?

After that my screen "X" are red what do I do?

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

Each time i come here i try get helped bbut no! What do U get? One more fail. Well can someone REALLY help me for once????? Well if u do add me on skype:bluevengeace ty for who read and understand!

elitepvpers never helps in what i need. Am sick of this! 2 years and nothing.

Well, first you are asking to be pmed over Skype, we are not Skype, and some of us don't like doing anything through Skype unless it is with someone we already know, and second, no one is forcing you to stay if you don't like the community, we help, but when someone starts saying that they dislike the community, people simply stop helping them

Quote:

Originally Posted by zarazagan elitepvpers never helps in what i need. Am sick of this! 2 years and nothing.

i admit not all in epvpers are nice ppl but there are still alot helpfull and good ppl here around which do alot for the comunity and which done alot. epvpers is like a big book go read it urself without asking for several aspects out of it like all the other admins does!

ok so i've done everything to try to work this out.....

[SQL Native Client] VIA Provider: The specified module could not be found.
[SQL Native Client] Login timeout expired
[SQL Native Client] An error has occurred while establishing a connection two
the server. When connecting to SQL Server 2005, this failure may be caused by
the fact that under the default settings SQL Server does not allow remote
connections.
Press any key to continue ...

i keep getting this message even if i allowed the remote control and everything done.. please any help? try answearing on pms :) ty