Page 1 of 10

Full Tilt Update July 8, 2009

PostPosted: Wed Jul 08, 2009 4:24 pm
by 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:

Re: Full Tilt Update July 8, 2009

PostPosted: Wed Jul 08, 2009 8:37 pm
by 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>

Re: Full Tilt Update July 8, 2009

PostPosted: Wed Jul 08, 2009 8:57 pm
by 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

Re: Full Tilt Update July 8, 2009

PostPosted: Wed Jul 08, 2009 9:00 pm
by ptrack mike
Where you using a beta patch before or just a regular version (no letter at the end of the version)?

Re: Full Tilt Update July 8, 2009

PostPosted: Wed Jul 08, 2009 9:07 pm
by ninjasinc
I was just using the regular 1.13.04 before.

Re: Full Tilt Update July 8, 2009

PostPosted: Wed Jul 08, 2009 9:07 pm
by ptrack mike
Are you using a PostgreSQL database or Access?

Re: Full Tilt Update July 8, 2009

PostPosted: Wed Jul 08, 2009 9:16 pm
by ninjasinc
I'm using PostgreSQL.

Re: Full Tilt Update July 8, 2009

PostPosted: Wed Jul 08, 2009 10:12 pm
by 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.

Re: Full Tilt Update July 8, 2009

PostPosted: Wed Jul 08, 2009 10:51 pm
by ninjasinc
Ahh, crap, I was wrong -- I'm using an Access db after all.

Any ideas?

Re: Full Tilt Update July 8, 2009

PostPosted: Thu Jul 09, 2009 6:21 am
by 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.