ps_gamelog

[Big_]

can sum 1 please help me fix this error its filing my logs up please help

 Spoiler

2015-06-19 15:42:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '252091083084266790000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2015-06-19 15:42:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '252091083084266790000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2015-06-19 15:42:45 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'XXXXX',1,80,'', 11304,-2083872703,44356, -252091083084266790000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Enter',NULL,NULL,NULL

2015-06-19 15:42:45 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'XXXXXX',1,80,'', 11304,-2083872703,44356, -252091083084266790000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,107, 160,-117440122,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '0.0.0.0','money=1577058338, bank=134220802, cash=184551168','level=0,skp=2816,stp=49152','s=42 4,d=15361,i=0,w=0,r=0,l=0'

i made the username XXXX so dosent revel any info on sum 1 account but i would realy like to fix this log please

[[Alcatraz]]

here are a few links I found looking for a fix for your problem not sure if they will help you are not being because I have never had this problem before but some might be useful to you





from what I read its a error given from the procedures when a player uses the item mall it happens when the database tries to convert the int datatype to the tinyint datatype which should in turn cause a dc and a rollback if im not mistaken

along with needed to Start (Service) Distributed Transaction Coordinator which I think there is a example of how to do this on google search I think

hope this is helpful I know I never have much luck with the search function here but google search works wonders for me