Unable to import HH's after prima update

[88keyz]

Thanks for the file. This wasn't as I expected it so the patch didn't take long. You can download the patch file, 2.17.03 here...

http://s217900936.onlinehome.us/patch21703.exe

I had the same problem today and this patch FIXED it! Thanks. Great service.

Also, PAHUD works fine.

[Corey]

I saw this error too. I think I know what happened. They must be using signed 32 bit integers in the hand history. The default in C or C++ is if you have "int handnum;", it is an SIGNED integer. It should have been "unsigned int handnum;" So since it is signed, when the hand # goes above ~2,147,000,000 (2.147 billion), it gets into negative number territory.

Interestingly, their hand history function no longer works! Go play or watch a table and click on the Hand History link in the bottom left! You'll get a blank table with a negative number in the upper left!

So is this patch only going to work until the hand history reaches 2^32 = 4294967296 ? Or will the hand #s will roll back to 0?

Time to switch to 64 bit integers? That would take a long ass time to overflow. It'd be interesting to see how many hands Microgaming goes through each day and try to extrapolate when a 64 bit int would overflow.

Typical bad / sloppy planning in software engineering. "We'll never have more than 2 / 4 billion hands. Just stick it in an int. " DUH!

Excellent work on the patch! It even grabbed 372 hands from a few days ago when those hands wouldn't import and I got the same errors about negative numbered hand histories.

[rivered]

I just updated to 2.17.03 and now I'm getting this error message -

DBCode: -1003 Error Text: SQLSTATE = S1093
[Miccrosoft][ODBC Microsoft Accest Driver] Invalid argument.

No changes made to database.

What's the rest of the error???

PT Version: 2.17.03
Error Date: 08/25/2008 22:24
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, flop_1, flop_2, flop_3, turn, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_game_number, ub_kill_game ) VALUES ( 748171, 748171, 6, {ts '2008-08-25 05:20:46'}, 9, '2h', 'Kd', '4d', '8h', 323.0000, 3.0000, 11635, {ts '2008-08-25 22:24:00'}, 'Luce', '(did not show hand)', 11635, 2, 7, '2148767804', 0 )
DataObject: d_game
Syntax In Error: INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, flop_1, flop_2, flop_3, turn, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_game_number, ub_kill_game ) VALUES ( 748171, 748171, 6, {ts '2008-08-25 05:20:46'}, 9, '2h', 'Kd', '4d', '8h', 323.0000, 3.0000, 11635, {ts '2008-08-25 22:24:00'}, 'Luce', '(did not show hand)', 11635, 2, 7, '2148767804', 0 )
*********************************

[ptrack pat]

I just updated to 2.17.03 and now I'm getting this error message -

DBCode: -1003 Error Text: SQLSTATE = S1093
[Miccrosoft][ODBC Microsoft Accest Driver] Invalid argument.

No changes made to database.

What's the rest of the error???

PT Version: 2.17.03
Error Date: 08/25/2008 22:24
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, flop_1, flop_2, flop_3, turn, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_game_number, ub_kill_game ) VALUES ( 748171, 748171, 6, {ts '2008-08-25 05:20:46'}, 9, '2h', 'Kd', '4d', '8h', 323.0000, 3.0000, 11635, {ts '2008-08-25 22:24:00'}, 'Luce', '(did not show hand)', 11635, 2, 7, '2148767804', 0 )
DataObject: d_game
Syntax In Error: INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, flop_1, flop_2, flop_3, turn, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_game_number, ub_kill_game ) VALUES ( 748171, 748171, 6, {ts '2008-08-25 05:20:46'}, 9, '2h', 'Kd', '4d', '8h', 323.0000, 3.0000, 11635, {ts '2008-08-25 22:24:00'}, 'Luce', '(did not show hand)', 11635, 2, 7, '2148767804', 0 )
*********************************

See the FAQ, issue #2
viewtopic.php?f=30&t=1377

[FelixLeiter]

Interestingly, their hand history function no longer works! Go play or watch a table and click on the Hand History link in the bottom left! You'll get a blank table with a negative number in the upper left!

It was driving me crazy that I couldn't see the Prima in-skin hand histories. :x
so THAT'S what happened! Thanks for this explanation, Corey.

[Lighto]

Prima HH's still dont work for me. I never had an error to begin with, just that it wouldn't import any hands anymore saying 'There are no new hands in the database.' After installing this new patch I still have the same problem, it just says there are no new hands. The Gamehistory.dat file gets bigger when I play so the hands should be there.

[Random Guest]

After installing 2 patches I found while searching I got it to get all my hands up until 8/26, but none from today.

How about a trouble-shooting guide for newbs?

[Random Guest]

I'm also freezing when my Auto-Import fires for the 2nd time.

I might be better off starting from scratch.

I have gotten this error many times:

c:\program files\poker tracker v2\PRIMA_HH_39_20080831_142359.txt
Error getting the player summary information for End of game for game #-2137557367.

[Lighto]

It worked fine for me until the 24th. It's just so strange cause i downloaded the new update and started playing that day, and it worked fine in the beginning. Then all of a sudden it didn't work anymore saying there's no new hands, and it was at the same time their view hand history stopped working. Now they have fixed the hand hand history thing so I was hoping PT would start to work again, but still have the same problem.

[Random Guest]

Just reinstalled the Patch21703 (I think I had PT open the first time) and I have hands from today.