What needs to be fixed here?

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

What needs to be fixed here?

Postby jeppish » Thu Apr 17, 2008 6:54 am

Im using 2.17.01g. Problem started when trying to import hands from ipoker..

PT Version: 2.17.01g
Error Date: 04/17/2008 00:42
Database Error: 7
Error Text: SQLSTATE = 22001
ERROR: value too long for type character varying(2);
Error while executing the query

No changes made to database.

INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, played_hand, hole_cards, card_order1, card_order2, card_order3, 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 ) VALUES ( 4, 8, 966746, 3, '9 C3 S6d', '8h', 'o', 6.0000, 0.0000, 0.0000, 0.0000, 6.0000, 0.0000, 'Pre-flop', 'Y', '98o', 9, 8, 0, 1, 0, 0, 88851, 3, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6.0000, 19829, 0, 0, 0, 664.0000 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, hole_card_1, hole_card_2, suited, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, when_folded, played_hand, hole_cards, card_order1, card_order2, card_order3, 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 ) VALUES ( 4, 8, 966746, 3, '9 C3 S6d', '8h', 'o', 6.0000, 0.0000, 0.0000, 0.0000, 6.0000, 0.0000, 'Pre-flop', 'Y', '98o', 9, 8, 0, 1, 0, 0, 88851, 3, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6.0000, 19829, 0, 0, 0, 664.0000 )
*********************************


/thanks
jeppish
 
Posts: 2
Joined: Thu Apr 17, 2008 6:48 am

Re: What needs to be fixed here?

Postby ptrack pat » Thu Apr 17, 2008 8:47 am

Install the latest PATCH, version 2.17.02 from this link (MAKE SURE YOU DOWNLOAD THE PATCH INSTALL, the second link on this page, and NOT the full version:
http://www.pokertracker3.com/products/PTH/download.php
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: What needs to be fixed here?

Postby jeppish » Thu Apr 17, 2008 10:13 am

Seems to work..thanks alot for giving fast answers as always. well appreciated!
jeppish
 
Posts: 2
Joined: Thu Apr 17, 2008 6:48 am

Re: What needs to be fixed here?

Postby vitutus » Thu Sep 18, 2008 6:46 pm

Hi,

I got the same error while playing at IPoker and it wont go away. So what should I do to get it fixed? im using k-patch. Should I install that b-patch like u told to that other guy? I am using pt2 and not pt3 yet.

Thanks in advance pat
vitutus
 
Posts: 11
Joined: Tue Jul 08, 2008 6:18 am

Re: What needs to be fixed here?

Postby ptrack pat » Thu Sep 18, 2008 7:42 pm

You should get the latest PATCH, version 2.17.03b from this link (MAKE SURE YOU DOWNLOAD THE PATCH INSTALL, the second link on this page, and NOT the full version:
http://www.pokertracker.com/products/PTH/download.php
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 0 guests