[Help] Item Mall Error 1

10/22/2014 22:21 AuronCrow#1
Hi guys, this evening when i tried to edit my item mall, i modified it with ShStudio, deleted RowID column, and executed the file into the database, and it works very well, but when i tried to buy the package into the game, i got DC and "Disconneted for the server, ERROR 1"

the DB_Agent_system log is:

2014-10-22 21:56:19 PS_DBAGENT__system log start (DBAgent01)
2014-10-22 21:56:26 connect game, Name=

2014-10-22 21:56:26 connect game, Name=

2014-10-22 21:58:50 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-22 21:58:50 SaveBuyPointItem 18 Aveltar qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(2,18,0,'PK_primm 0001','2014-10-22 21:58:50')}


I Saw some guides here on epvp but i still can't buy from the item mall, i already used the searche botton but i didn't solved my problem, that's why i'm opening this topic, hope someone can help me
10/23/2014 10:31 Falium#2
This question has been already asked a lot of times, but i'm feel happy today so i will help you. This archive contain two sql script, just run these and your item mall will work.

This error is caused by convertion of varchar data in datetime data so on these scripts datetime is remplaced by varchar using this convertion method :

PHP Code:
ALTER Proc [dbo].[usp_Save_User_BuyPointItems_NCash]
...

@textDate varchar(120)

AS

DECLARE @UseTime datetime
set @UseTime=CONVERT(datetime, @textDate, 120) 
Credits goes to [Only registered and activated users can see links. Click Here To Register...] who has posted it.
10/23/2014 15:34 AuronCrow#3
Hi, mmh i ran both scripts into the database, i didn't get errors, but when i'm triyng to buy something from the item mall, i get DC, still error 1
10/23/2014 17:22 Falium#4
Have you again some thing in your logs ?
check Gamelog and db agent
10/23/2014 21:21 AuronCrow#5
Quote:
Originally Posted by Falium View Post
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
10/23/2014 21:43 beetols#6
Download a english version from SQL server:

-detach your databases
-unistall SQL server
-reinstall same or more advanced sql server version.