Register for your free account! | Forgot your password?

You last visited: Today at 01:46

  • Please register to post and access all features, it's quick, easy and FREE!


Problems with shaiya ep 4.5

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2015
Posts: 4
Received Thanks: 0
Problems with shaiya ep 4.5

Hi guys,

I have some problems with my server...in a few days i can't see monsters and npcs and i can't use adm commands and I only can use /kick command.

Those are the errors in my bin \ log:

Quote:
2016-05-05 14:30:08 PS_GAMELOG__system log start (GameLog01)

2016-05-05 14:30:11 connect game

2016-05-05 14:32:10 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2016-05-05 14:32:10 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,1879116320,'
@
 ', 79,1953719668,0, 0.000000,0.000000,0.000000, '2000-00-00 00:00:00' ,107, 0,1117614245,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL, '0.10.0.9','money=0, bank=1095428106, cash=255','level=2560,skp=0,stp=0','s=0,d=0,i=512, w=0,r=1280,l=0'

2016-05-05 14:32:56 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2016-05-05 14:32:56 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,-33531849,'', 79,17440792,8304, 623371543058807260000000.000000,0.000000,0.000000, '2000-00-00 00:00:00' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=2641405184, bank=66, cash=1256732416, firstmoney=167774464','level=2560,skp=65,stp=0','s =1280,d=0,i=512,w=0,r=1280,l=0'

2016-05-05 16:13:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2016-05-05 16:13:30 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'admin',1,-33531849,'', 79,17440792,8304, 623371543058807260000000.000000,0.000000,0.000000, '2000-00-00 00:00:00' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=0, bank=0, cash=1258511872, firstmoney=134220800','level=3584,skp=65,stp=0','s =11008,d=33832,i=627,w=0,r=1280,l=0'
and

Quote:
2016-05-05 14:30:12 PS_LOGIN__system log start (Login01)

2016-05-05 14:31:37 <Console input> /vchkoff

2016-05-05 14:31:37 <Console output> cmd version chk off ok

2016-05-05 15:30:24 cmd_auto server info log

user = 0 (0/5000)

2016-05-05 15:30:24 T=001:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=2,CReq=2,CCnt=2,DCCnt=2, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=407,RBS=0,RBSC=14,SBT=563,SBS=0,SBSC=19

2016-05-05 15:30:24 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2016-05-05 16:30:25 cmd_auto server info log

user = 0 (0/5000)

2016-05-05 16:30:25 T=002:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=795,RBS=0,RBSC=13,SBT=1117,SBS=0,SBSC=18

2016-05-05 16:30:25 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
sorry guys i just solve the problem... i have the wrong database and now with other database all go better



MrStunner is offline  
Old 05/06/2016, 09:55   #2
 
elite*gold: 0
Join Date: Apr 2015
Posts: 420
Received Thanks: 107
Read your logs :
err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime., SQL STATE


SkuulCandy is offline  
Old 05/06/2016, 14:55   #3
 
elite*gold: 0
Join Date: Jan 2015
Posts: 4
Received Thanks: 0
ty but I have resolved the problem because was the wrong database...now i'm working on it but ty for the answer ^_^
MrStunner is offline  
Old 05/15/2016, 18:54   #4
Moderator




 
elite*gold: 83
Join Date: May 2011
Posts: 11,014
Received Thanks: 6,003
Arrow Shaiya Private Server -> Shaiya PServer De…

#moved…
Arby is offline  
Reply



« [HELP] F11 - target bar stays | errors in ep 6 servers »

Similar Threads
[Help]I'm have two problems|Shaiya PServer
07/10/2014 - Shaiya PServer Development - 2 Replies
Em Portugus: Problemas: - Quando eu aperto a tecla T para abrir a tela de Status, meu ATK = 0-0, Magia = 0-0, Def = 0, Resist = 0, mas esses mesmos atributos funcionam normalmente no jogo, somente aparecem como 0 nessa tela. http://i.imgur.com/O4BjyOA.png - O outro problema no item mall, quando coloco points na DB, os pontos no aparecem no jogo, eles continuam no 0.
Shaiya Killcount Problems
11/09/2013 - Shaiya PServer Development - 3 Replies
Hey guys, how can i change the killcount to 100+ i found some tools but they are only 99... there must be a way because i saw a lot of servers they are using it. I'm using a ep5 ps_game.exe I need help pls.
Shaiya server problems
05/30/2013 - Shaiya Private Server - 6 Replies
ok so i have explored the site and have been unsuccessful at finding help with this i am trying to make a private server for me and my friends the problem is the server when i try and start them they start at first in server patch config but then go back to pausing i have restarted my PC and have the correct SQL i believe plus its on a seperate D drive i seperated the D Drive off of my main drive i cannot seem to figure out the problem i am having for the server and why it will not stay...
Problems with SQL and shaiya server
02/08/2011 - Shaiya Private Server - 1 Replies
My things just go back to pause, what can that cause? My PS_Session_system 2011-02-07 19:48:22 PS_SESSION__system log start (Session) 2011-02-07 19:48:23 userlog connect failed 2011-02-07 19:48:23 initserver() failed 2011-02-07 19:48:23 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()



All times are GMT +1. The time now is 01:46.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.