Quote:
Originally Posted by Falium
Have you again some thing in your logs ?
check Gamelog and db agent
|
Gamelog
2014-10-23 17:09:30 PS_GAMELOG__system log start (Shaiya Aveltar)
2014-10-23 17:09:39 connect game
2014-10-23 17:12:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:12:47 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 81.622414,1.891644,43.527649, '2014-10-23 17:12:46' ,107, 255,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '127.0.0.1','money=2000000, bank=0, cash=7','level=70,skp=9958,stp=630','s=10,d=9,i=10 ,w=10,r=71,l=14'
2014-10-23 17:12:47 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:12:47 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 81.622414,1.891644,43.527649, '2014-10-23 17:12:46' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Enter',NULL,NULL,NULL
2014-10-23 17:13:27 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:13:27 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 0,0,42, 81.223930,1.847319,43.703876, '2014-10-23 17:13:27',180, 1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'VisibleOn',NULL,NULL,NULL
2014-10-23 17:14:03 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:03 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 81.973236,1.847319,41.937759, '2014-10-23 17:14:03' ,111, 4228620028485894144,6100,1,NULL,NULL,NULL,NULL,NUL L,NULL,NULL,'Calibre of Wind','ItemCreate','0,0,0,0,0,0 (Option:00090004001400000000)','2014-10-23 17:14:03'
2014-10-23 17:14:03 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:03 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 0,0,42, 81.973236,1.847319,41.937759, '2014-10-23 17:14:03',180, 1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'It emCreate','','name=Calibre of Wind,count=1',NULL
2014-10-23 17:14:08 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:08 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 82.161156,1.847319,41.320518, '2014-10-23 17:14:08' ,112, 4228620028485894144,6100,NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,'Calibre of Wind','0,0,0,0,0,0 (Option:00090004001400000000)','2014-10-23 17:14:03','bag=1,slot=2,Count=1'
2014-10-23 17:14:26 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:26 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 75.508690,1.847319,39.471298, '2014-10-23 17:14:26' ,111, 4228620127270141952,100100,1,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,'Mana Remedy Lv3','ItemCreate','0,0,0,0,0,0 (Option

','2014-10-23 17:14:26'
2014-10-23 17:14:26 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:26 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 0,0,42, 75.508690,1.847319,39.471298, '2014-10-23 17:14:26',180, 1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'It emCreate','','name=Mana Remedy Lv3,count=1',NULL
2014-10-23 17:14:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:29 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 67.898315,1.847319,42.401184, '2014-10-23 17:14:29' ,112, 4228620127270141952,100100,NULL,NULL,NULL,NULL,NUL L,NULL,NULL,NULL,'Mana Remedy Lv3','use_item','0,0,0,0,0,0 (Option

-2014-10-23 17:14:26','bag=1,slot=2'
2014-10-23 17:14:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:37 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 65.583893,1.847319,44.954830, '2014-10-23 17:14:37' ,113, 4228620174514782208,31212,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Treffers Cap','PointItem','0,0,0,0,0,0 (Option

','2014-10-23 17:14:37'
2014-10-23 17:14:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:37 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 65.583893,1.847319,44.954830, '2014-10-23 17:14:37' ,113, 4228620174514847744,32212,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Treffers Protector','PointItem','0,0,0,0,0,0 (Option

','2014-10-23 17:14:37'
2014-10-23 17:14:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:37 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 65.583893,1.847319,44.954830, '2014-10-23 17:14:37' ,113, 4228620174514913280,32212,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Treffers Protector','PointItem','0,0,0,0,0,0 (Option

','2014-10-23 17:14:37'
2014-10-23 17:14:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:37 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 65.583893,1.847319,44.954830, '2014-10-23 17:14:37' ,113, 4228620174514978816,33212,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Treffers Leggings','PointItem','0,0,0,0,0,0 (Option

','2014-10-23 17:14:37'
2014-10-23 17:14:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:37 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 65.583893,1.847319,44.954830, '2014-10-23 17:14:37' ,113, 4228620174515044352,35212,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Treffers Muffler','PointItem','0,0,0,0,0,0 (Option

','2014-10-23 17:14:37'
2014-10-23 17:14:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:37 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 65.583893,1.847319,44.954830, '2014-10-23 17:14:37' ,113, 4228620174515109888,36212,NULL,1,NULL,NULL,NULL,NU LL,NULL,NULL,'Treffers Walker','PointItem','0,0,0,0,0,0 (Option

','2014-10-23 17:14:37'
2014-10-23 17:14:38 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:38 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 65.583893,1.847319,44.954830, '2014-10-23 17:14:38' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=2000000, bank=0, cash=7, firstmoney=2000000','level=70,skp=9958,stp=630','s =10,d=9,i=10,w=10,r=71,l=14'
2014-10-23 17:14:38 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:14:38 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186750,42, 65.583893,1.847319,44.954830, '2014-10-23 17:14:38' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Leave',NULL,NULL,NULL
2014-10-23 17:16:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:16:43 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186749,42, 81.622414,1.891644,43.527649, '2014-10-23 17:16:43' ,107, 255,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '127.0.0.1','money=2000000, bank=0, cash=7','level=70,skp=9958,stp=630','s=10,d=9,i=10 ,w=10,r=71,l=14'
2014-10-23 17:17:10 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:17:10 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 0,0,42, 81.622414,1.891644,43.527649, '2014-10-23 17:17:10',180, 1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'It emCreate','','name=Craft Lapis LV6,count=1',NULL
2014-10-23 17:17:10 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:17:10 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186749,42, 81.622414,1.891644,43.527649, '2014-10-23 17:17:10' ,111, 4228620883184386048,30006,1,NULL,NULL,NULL,NULL,NU LL,NULL,NULL,'Craft Lapis LV6','ItemCreate','0,0,0,0,0,0 (Option

','2014-10-23 17:17:10'
2014-10-23 17:17:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:17:30 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186749,42, 81.548248,1.891644,43.128925, '2014-10-23 17:17:30' ,111, 4228620969083731968,100075,1,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,'Double Warehouse','ItemCreate','0,0,0,0,0,0 (Option

','2014-10-23 17:17:30'
2014-10-23 17:17:30 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:17:30 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 0,0,42, 81.548248,1.891644,43.128925, '2014-10-23 17:17:30',180, 1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'It emCreate','','name=Double Warehouse,count=1',NULL
2014-10-23 17:17:36 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:17:36 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186749,42, 81.548248,1.891644,43.128925, '2014-10-23 17:17:35' ,111, 4228620990558568448,100165,1,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,'30 day Continuous Res Rune...','ItemCreate','0,0,0,0,0,0 (Option

','2014-10-23 17:17:35'
2014-10-23 17:17:36 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:17:36 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 0,0,42, 81.548248,1.891644,43.128925, '2014-10-23 17:17:35',180, 1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'It emCreate','','name=30 day Continuous Res Rune...,count=1',NULL
2014-10-23 17:17:38 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:17:38 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186749,42, 82.138626,1.891644,38.798325, '2014-10-23 17:17:38' ,112, 4228620990558568448,100165,NULL,NULL,NULL,NULL,NUL L,NULL,NULL,NULL,'30 day Continuous Res Rune...','use_item','0,0,0,0,0,0 (Option

-2014-10-23 17:17:35','bag=1,slot=4'
2014-10-23 17:17:40 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:17:40 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186749,42, 82.138626,1.891644,38.798325, '2014-10-23 17:17:39' ,112, 4228620969083731968,100075,NULL,NULL,NULL,NULL,NUL L,NULL,NULL,NULL,'Double Warehouse','use_item','0,0,0,0,0,0 (Option

-2014-10-23 17:17:30','bag=1,slot=3'
2014-10-23 17:18:04 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Errore durante la conversione del tipo di dati da varchar a datetime., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2014-10-23 17:18:04 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'cosmin',2,18,'Aveltar', 70,7186749,42, 75.828415,1.891644,36.154720, '2014-10-23 17:18:04' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=2000000, bank=0, cash=7, firstmoney=2000000','level=70,skp=9958,stp=630','s =10,d=9,i=10,w=10,r=71,l=14'
how you can see i still have the problem with the conversion, but i executed bot scrits into the database
and this is the DB agent log
2014-10-23 17:09:32 PS_DBAGENT__system log start (DBAgent01)
2014-10-23 17:09:39 connect game, Name=
2014-10-23 17:09:39 connect game, Name=
2014-10-23 17:14:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]La conversione del tipo di dati da char a datetime ha generato un valore di tipo datetime non compreso nell'intervallo dei valori consentiti., SQL STATE: 22007, NATIVE ERROR: 242 (0xF2)
2014-10-23 17:14:37 SaveBuyPointItem 18 Aveltar qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(2,18,0,'B1_etain 0001','2014-10-23 17:14:37')}
on the first post, the log said that the conversion from varchar to datatime failed, now it said that the conversion generated a wrong datatime