Full Tilt Update July 8, 2009

[ptrack mike]

Full Tilt updated their software today and as a result PT Omaha will not import any hands.

- Played hands: EDIT: Please get this patch:
<beta patch link removed - official patch is here: viewtopic.php?f=32&t=21618>

- Observed Hands: these are not being created anymore. Please contact Full Tilt about this since it's out of my control.

NOTE: Make sure you are using the Full Tilt Auto-Import window in PTO to import Full Tilt hands. The Generic auto-import and Manual import windows will not work with the new FTP hands.

EDIT - workarounds are not needed with the official patch which in linked above:

[ptrack mike]

Here is the latest PTO beta patch which allows you to import hands played after July 8 again using the Full Tilt auto-import window:

EDIT:
The previous patches were removed due to issues - please get the "m" patch above:
<link removed>

[ninjasinc]

No dice. I keep getting this error...

*********************************
PTO Version: 1.13.04g
Error Date: 07/08/2009 18:50
Database Error: -1507
Error Text: SQLSTATE = S0022
[Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement contains the following unknown field name: 'ante_amt'. Make sure you have typed the name correctly, and try the operation again.

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, played_hand, final_hand, hand_rank_id, connector_hand, pair_hand, won_hand, session_id, off_the_button, number_of_players, big_blind_n, small_blind_n, pre_flop_raise_n, flop_raise_n, flop_ck_raise_n, turn_bet_raise_n, turn_bet_ck_raise_n, river_bet_raise_n, river_bet_ck_raise_n, went_to_showdown_n, saw_flop_n, saw_flop_blind_n, attempted_steal, chance_to_steal, steal_attempted, folded_to_steal_attempt, raised_first_pf, vol_put_money_in_pot, limp_with_prev_callers, ppossible_actions, pfold, pcheck, praise, pcall, limp_call_reraise_pf, pfr_check, pfr_call, pfr_fold, pfr_bet, pfr_raise, folded_to_river_bet, fpossible_actions, ffold, fcheck, fbet, fraise, fcall, tpossible_actions, tfold, tcheck, tbet, traise, tcall, rpossible_actions, rcheck, rfold, rbet, rraise, rcall, blind_amt, real_player_id, cold_call_pf, steal_hu_chance, steal_hu_fold, chip_count, hole_card_1, hole_card_2, hole_card_3, hole_card_4, suited, hole_cards, card_order1, card_order2, card_order3, card_order4, connector_hand2, connector_hand2g, connector_hand3, pair_hand2, trip_hand, ante_amt ) VALUES ( 7, 9, 57984, 7, 0.2500, 0.0000, 0.0000, 0.0000, 0.2500, 0.0000, 'Pre-flop', 'Y', 'a pair of fours', 2, 1, 1, 0, 17142, 6, 8, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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.2500, 2035, 0, 0, 0, 25.0000, 'Ks', 'Qc', '4s', '4d', 'xyxz', 'KQ44', 13, 12, 4, 4, 0, 0, 0, 0, 0, 0.0000 )
DataObject: d_game_players

[ptrack mike]

Where you using a beta patch before or just a regular version (no letter at the end of the version)?

[ninjasinc]

I was just using the regular 1.13.04 before.

[ptrack mike]

Are you using a PostgreSQL database or Access?

[ninjasinc]

I'm using PostgreSQL.

[ptrack mike]

The error says [Microsoft][ODBC Microsoft Access Driver] which indicates you are using an Access database, but the error is still strange. In a prior beta patch I had to add code in support of FTP adding ante Omaha tables. That code is also in this beta so the new ante_amt column should get created when you start the program.

Are you sure you are using a PostgreSQL database? Look at File > Maintain Database Names... and make sure the PostgreSQL database has a "X" in the Dflt box. Then close PTO, restart your computer and try running PTO and importing FTP hands again. Does that work? Also, before you import go to the Observed Hands tab on the auto-import window and check the box that says "Do not get observed hands" since FTP doesn't create them anymore.

[ninjasinc]

Ahh, crap, I was wrong -- I'm using an Access db after all.

Any ideas?

[ptrack mike]

Close PTO, restart your computer and try running PTO and importing FTP hands again. Does that work? Also, before you import go to the Observed Hands tab on the auto-import window and check the box that says "Do not get observed hands" since FTP doesn't create them anymore.