Shaiya dont save changes

11/07/2012 23:58 Sh1nra#1

Hello epvp,

Shaiya don't save my changes :confused:

Logs:

Code:

--<begin>2012-11-07 23:53:12,Shinra,10245,[ADM]Shinra,5024

{?=call usp_Save_Char_Info_E(5024,65535, 0,5, 7,9,9,17,14,9, 3891,4078,552, 2,250, 20062681,0, 174.876587,117.044655,394.379028, 0,200,0,0,0, 0,0,0,0)}

EXEC usp_Save_User_StoredMoney_E 1,10245,52427420

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275284138688512, 0,0, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275284138950656, 0,1, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275284139016192, 0,2, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275284139081728, 0,3, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275284139147264, 0,4, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275361448099840, 0,5, 1700, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275202534309888, 0,7, 0, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275520362020864, 0,8, 0, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275520361889792, 0,9, 0, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661275520361955328, 0,10, 0, 0,0,0,0,0,0,'00000000000000000000',1)}

{?=call Usp_Save_Char_Item_Del_E(5024,'3661282783151587328',0)}

{?=call Usp_Save_Char_Item_Add_E(5024,3661282783151587328, 1,1, 40255,40,255, 0, 0,0,0,0,0,0,'', 1, '2012-11-07 23:53:11', 'S')}

{?=call Usp_Save_Char_Item_Del_E(5024,'3661282783151652864',0)}

{?=call Usp_Save_Char_Item_Add_E(5024,3661282783151652864, 1,2, 40255,40,255, 0, 0,0,0,0,0,0,'', 1, '2012-11-07 23:53:11', 'S')}

{?=call Usp_Save_Char_Item_Mod_E(5024,3661271912589361152, 1,14, 1200, 0,0,0,0,0,0,'�ao???��??',1)}

{?=call Usp_Save_Char_ApplySkill_Del_E(5024,0,0,1)}

EXEC usp_Save_Char_QuickSlot_Del_E 5024

--<end>2012-11-07 23:53:12,Shinra,10245,[ADM]Shinra,5024

I tried to repair the Procedures but it was not helpful >.<

What can i do now ? o_O

11/08/2012 06:06 nephren#2

usp_save_char_Item_add_e auch schon gefixed?
Oder andere Stored Procedures ?

Spoiler

11/08/2012 10:28 Sh1nra#3

Ja habe alle gefixxt die mir die logs anzeigen.

Habe sie von ner anderen Datenbank genommen wo ich mir sicher bin das es klappt..

Ok habs problem gefunden sry ^^

2012-11-08 10:55:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 65535., SQL STATE: 22003, NATIVE ERROR: 220 (0xDC)

2012-11-08 10:55:20 ::SaveCharacter 5024 [ADM]Shinra ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(5024,65535, 0,5, 7,9,9,17,14,9, -18528,-24373,31609, 2,297, 20062681,0, 189.547272,115.245277,388.143799, 0,200,0,0,0, 0,0,0,0, 0,0)}

2012-11-08 10:55:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type smallint, value = 65535., SQL STATE: 22003, NATIVE ERROR: 220 (0xDC)

2012-11-08 10:55:20 ::SaveCharacter 5024 [ADM]Shinra ret=1, qerr=-1, {?=call usp_Save_Char_Info_E(5024,65535, 0,5, 7,9,9,17,14,9, -18528,-24373,31609, 2,297, 20062681,0, 189.547272,115.245277,388.143799, 0,200,0,0,0, 0,0,0,0, 0,0)}

11/08/2012 15:59 Shaiya-Raze#4

hat sich erledigt^^