Problems with shaiya ep 4.5

[MrStunner]

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:

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

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

[SkuulCandy]

Read your logs :
err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime., SQL STATE

[MrStunner]

ty but I have resolved the problem because was the wrong database...now i'm working on it but ty for the answer ^_^

[Arby]

#moved…