Merge Errors

[zachvac]

I keep getting this message when I attempt to auto-import hands while playing on merge. Let me know if you need further info.

11:07:46 pm: Error: Merge: Unable to import hand (#65093911-2161). Reason: Unable to execute query: EXECUTE cash_cache_insert(1152,1,7,4,0,false,false,false,201301,0.00000000000000000000,3.00,3.0000000000,0.00000000000000000000,0.00,0.0000000000,0,0,0.0000000000000000000000,0.000000000000000000000000000000,0.50,0.5000000000,2.00,2.0000000000,0.0049627791563275434200,0.004962779156327543420000000000,0.00,0.0000000000,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,1,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,2,0,0,0,0,1,0,1,0,0,1,0,1,0,0,0,0,0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,1,1,0,0,1,1,1,0,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,0,0,0,0,0,'USD',0,0,0);; Reason: Fatal Error (ERROR: invalid input syntax for integer: "USD" LINE 1: ...0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,0,0,0,0,0,'USD',0,0,... ^ )

[zachvac]

Oh and version is 4.05.9 beta I think that's the latest version.

[WhiteRider]

That suggests a problem in your database. Please go to Database > Database Management and click the Rebuild Cache option, which should be able to repair things. Note that this could take some considerable time if you have a large database so please schedule it when you're going to be away from your computer for a while, or at least not using PT4.

For future reference, please post PT4 issues in the PT4 section of the forum - thanks.

[zachvac]

Thanks, I rebuilt the cache and am still getting what I think is the same error:

Error: Merge: Unable to import hand (#65900512-8). Reason: Unable to execute query: EXECUTE cash_cache_insert(1699,1,6,2,1,true,false,false,201304,-2.5000000000000000,2.00,2.0000000000,-2.5000000000000000,-5.00,-5.0000000000,0,0,0.0000000000000000000000,0,0.25,0.2500000000,0.50,0.5000000000,0.2500000000000000000000,0.250000000000000000000000000000,-5.00,-5.0000000000,1,0,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'USD',0,0,0);; Reason: Fatal Error (ERROR: invalid input syntax for integer: "USD" LINE 1: ...0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'USD',0,0,... ^ )
11:48:15 am: Merge: Hand Imported (#65900512-9) from Mississippi (65900512)
11:48:16 am: Error: Merge: Unable to import hand (#65900512-9). Reason: Unable to execute query: EXECUTE cash_cache_insert(1699,1,6,2,1,true,false,false,201304,-2.5000000000000000,2.00,2.0000000000,-2.5000000000000000,-5.00,-5.0000000000,0,0,0.0000000000000000000000,0,0.25,0.2500000000,0.50,0.5000000000,0.2500000000000000000000,0.250000000000000000000000000000,-5.00,-5.0000000000,1,0,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'USD',0,0,0);; Reason: Fatal Error (ERROR: invalid input syntax for integer: "USD" LINE 1: ...0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'USD',0,0,... ^ )
11:48:16 am: Merge: Hand Imported (#65900512-10) from Mississippi (65900512)
11:48:16 am: Error: Merge: Unable to import hand (#65900512-10). Reason: Unable to execute query: EXECUTE cash_cache_insert(1699,1,6,2,1,true,false,false,201304,-2.5000000000000000,2.00,2.0000000000,-2.5000000000000000,-5.00,-5.0000000000,0,0,0.0000000000000000000000,0,0.25,0.2500000000,0.50,0.5000000000,0.2500000000000000000000,0.250000000000000000000000000000,-5.00,-5.0000000000,1,0,1,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'USD',0,0,0);; Reason: Fatal Error (ERROR: invalid input syntax for integer: "USD" LINE 1: ...0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'USD',0,0,... ^ )
11:48:16 am: Merge: Hand Imported (#65900512-11) from Mississippi (65900512)

...

This repeats for what looks to be every hand I played on Merge that it's trying to import.

[kraada]

Please attach the original hand history file to a support ticket and we'll look into this further for you.