Database Error need help please.

Any support related posts should go here.

Database Error need help please.

Postby Patizzie » Wed Apr 15, 2009 3:15 am

PTO Version: 1.13.03b
Error Date: 04/15/2009 03:10
Database Error: -1206
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt.

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, 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 ) VALUES ( 14116, 3, 881478, 4, 48.0000, 0.0000, 0.0000, 0.0000, 48.0000, 0.0000, 'Y', 'a pair of nines', 2, 1, 0, 0, 94808, 1, 4, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, 1, 1, 0, 2, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0.0000, 14116, 0, 0, 0, 2516.9000, 'Ad', 'Ks', '9d', '4d', 'xyxx', 'AK94', 14, 13, 9, 4, 0, 0, 0, 0, 0 )
DataObject: d_game_players
Syntax In Error: INSERT INTO game_players ( player_id, seat_number, game_id, button, pre_flop_bet, flop_bet, turn_bet, river_bet, total_bet, total_won, 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 ) VALUES ( 14116, 3, 881478, 4, 48.0000, 0.0000, 0.0000, 0.0000, 48.0000, 0.0000, 'Y', 'a pair of nines', 2, 1, 0, 0, 94808, 1, 4, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, 1, 0, 0, 1, 1, 0, 2, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0.0000, 14116, 0, 0, 0, 2516.9000, 'Ad', 'Ks', '9d', '4d', 'xyxx', 'AK94', 14, 13, 9, 4, 0, 0, 0, 0, 0 )



I got this before but after running repair it stopped now when I run repair it does not fix this. Whenever I get a new HH from cereus I get this error.
Patizzie
 
Posts: 2
Joined: Tue Dec 30, 2008 1:20 pm

Re: Database Error need help please.

Postby ptrack mike » Wed Apr 15, 2009 5:52 am

Please see #2 of this FAQ. DO NOT do #1:
viewtopic.php?f=41&t=3454
ptrack mike
 
Posts: 1731
Joined: Thu Feb 21, 2008 5:48 pm

Re: Database Error need help please.

Postby Patizzie » Wed Apr 15, 2009 1:54 pm

When I click the link on the bottom of option to to convert my database to PostgreSQL nothing is there.
Patizzie
 
Posts: 2
Joined: Tue Dec 30, 2008 1:20 pm

Re: Database Error need help please.

Postby ptrack mike » Wed Apr 15, 2009 4:15 pm

Try the link again now.
ptrack mike
 
Posts: 1731
Joined: Thu Feb 21, 2008 5:48 pm


Return to PTO Support

Who is online

Users browsing this forum: No registered users and 0 guests