Database error

[SimonH]

Been using PTH for a few years now with no problems until recently.

When auto importing hands from stars and full tilt I have occasionaly recieved a database error warning box.

The following text is copied from the error log file.

PT Version: 2.16.03d
Error Date: 04/05/2008 16:29
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 tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, flop_1, flop_2, flop_3, turn, river, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 10548, 653606, 653606, {ts '2008-04-05 10:46:18'}, 1, 'N/A', 0, '3h', '9d', '8s', '7d', '9c', 60.0000, 140090, {ts '2008-05-04 16:29:34'}, 'Table 1', 'two pairs, nines and eights', 140090, 2, 9, 0, '5917107843' )
DataObject: d_game_tourney
Syntax In Error: INSERT INTO tourney_game ( tourney_id, game_id, game_number, date_played, blind_structure_id, game_level, pp_game_number, flop_1, flop_2, flop_3, turn, river, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up, ub_game_number ) VALUES ( 10548, 653606, 653606, {ts '2008-04-05 10:46:18'}, 1, 'N/A', 0, '3h', '9d', '8s', '7d', '9c', 60.0000, 140090, {ts '2008-05-04 16:29:34'}, 'Table 1', 'two pairs, nines and eights', 140090, 2, 9, 0, '5917107843' )
*********************************

Any help would be appreciated.

[ptrack mike]

Try using the Utilities > Repair A Poker Database option to fix the file.

If it works for a while after the repair and then comes back then this error means you have hit the maximum allowable file size for an Access database file (imposed by Microsoft, not PT) so you need to start a new database using the File/Maintain Database Names window and then start importing hands into that. If you are importing hands from tables you are just watching, then make sure to change the configuration to point to this new database as well so it doesn't try to add them to this full database.

Another option is to convert the database to the PostgreSQL database format that does not have the file size restriction. See this post for more details.

http://www.pokertracker3.com/products/P ... InstallSQL