Ultimate Bet Import Error: No dealer line found for game # 1

[bball44]

Well, thank you for all your attempts to find a fix. You've been remarkably responsive.

I'd just like to confirm that it's not a problem with my PT2 and that getting PT3 won't help. Aslo that the fact that my db now has about 250k hands isn't the problem.

Lastly, is there a way to avoid the actual db error that seems to be occuring when some insert query is being run? The report of the error appears in a new db window and essentially renders my PT useless when it pops up.

Thanks again for all your help.

[ptrack pat]

What is the db error you are getting? All you have mentioned so far is formatting errors with some hands. A database error is something entirely different. What is the exact db error you are getting?

[bball44]

I mentioned the DB error but didn't emphasis it or give any detail - sorry, I figured the error was simply some sort update query not working becuase of the structure of the hand history file. Here is the error from the pterrorlog file (I should have included this from the start).

PT Version: 2.17.03k
Error Date: 06/17/2009 23:01
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.

No changes made to database.

INSERT INTO session ( session_id, player_id, session_start, session_end, table_name, seat_number, game_level_id, amount_won, total_hands, site_id, vol_saw_flop, pre_flop_raise, att_steal, chance_to_steal, won_hand, went_to_sd, won_at_sd, real_player_id ) VALUES ( 104328, 18605, {ts '2009-06-17 22:59:10'}, {ts '2009-06-17 23:00:12'}, 'Mobil (speed)', 1, 1, 0, 3, 11, 0, 0, 0, 0, 0, 0, 0, 18605 )
DataObject: d_sessions
Syntax In Error: INSERT INTO session ( session_id, player_id, session_start, session_end, table_name, seat_number, game_level_id, amount_won, total_hands, site_id, vol_saw_flop, pre_flop_raise, att_steal, chance_to_steal, won_hand, went_to_sd, won_at_sd, real_player_id ) VALUES ( 104328, 18605, {ts '2009-06-17 22:59:10'}, {ts '2009-06-17 23:00:12'}, 'Mobil (speed)', 1, 1, 0, 3, 11, 0, 0, 0, 0, 0, 0, 0, 18605 )
*********************************

[ptrack pat]

That error means the database is getting full. See this FAQ, ISSUE #2
viewtopic.php?f=30&t=1377
If it keeps coming back after the repair, you'll have to start a new db or convert to PostgreSQL.

[bball44]

I've repaired the db several times and the errors return so I have downloaded and installed postgresql. What do I put in the field ODBC entry to use under the postgresql settings window? I use the default for the user name and the password I created when installing postgreSql, but the dropdown for odbc entry to use is blank. Thank you.

[ptrack pat]

Did you install PostgreSQL 8.3? If so, see here...
archives/PT2/viewtopic.php?t=24880

[bball44]

I did install 8.3 (couldn't find an available version of 8.2.6 to download as the page no longer existed for any of the mirror sites I tried). Was able to convert the db following your instructions. Was able to import files again. I still have some errors for UB, but other sites import fine, and only small % of UB hands are a problem and the DB errors no longer occur so it's perfectly workbale for me (must be an occasional issue with the format from UB of individual hand histories as you said).

Thank you again for all your help. It seems to be fine now.