Absolute/UB - no dealer and no big blind errors....

[ptrack pat]

Anyone with these Absolute/UB errors should get the 2.17.03K patch here...
http://s217900936.onlinehome.us/patch21703k.exe

[superglue]

this was an error that popped up prior to installing the patch then I tried to import it again and this is the error received, I still receive, Error finding the big blind for game#, No dealer line found for game # 1378369345, Error finding any player collecting money from the pot for game #1611800203., No dealer line found for tournament game # 1602930044
*********************************
PT Version: 2.17.03d
Error Date: 03/17/2009 10:01
Database Error: -1907
Error Text: SQLSTATE = 42000
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be added; no insert permission on 'hand_histories'.

No changes made to database.

INSERT INTO hand_histories ( game_number, site_id, hand_history, import_date ) VALUES ( 1534831498, 5, 'STAGE #1534831498 TOURNEY ID 4184662 HOLDEM MULTI NORMAL TOURNAMENT NO LIMIT $100 - 2009-03-17 09:59:56 (ET)
Table: 358 (Real Money) Seat #6 is the dealer
Seat 1 - SHORTSTUFF137 ($8440 in chips)
Seat 2 - SUTAN ($755 in chips)
Seat 3 - MOFOE1 ($16775 in chips)
Seat 4 - DARYLEJOHN ($10025 in chips)
Seat 5 - ACEHOLE13 ($3110 in chips)
Seat 6 - CHOOCH54 ($3775 in chips)
Seat 7 - SOOPERGLUE ($4525 in chips)
Seat 8 - PLUGNICKEL ($4485 in chips)
Seat 9 - WASABIQUEEN ($1285 in chips)
SOOPERGLUE - Posts small blind $50
PLUGNICKEL - Posts big blind $100
*** POCKET CARDS ***
Dealt to SOOPERGLUE [Kc 10h]
WASABIQUEEN - Folds
SHORTSTUFF137 - Folds
SUTAN - Folds
MOFOE1 - Folds
DARYLEJOHN - Calls $100
ACEHOLE13 - Folds
CHOOCH54 - Folds
SOOPERGLUE - Calls $50
PLUGNICKEL - Checks
*** FLOP *** [8h As 8c]
SOOPERGLUE - Checks
PLUGNICKEL - Checks
DARYLEJOHN - Checks
*** TURN *** [8h As 8c] [10s]
SOOPERGLUE - Bets $100
PLUGNICKEL - Raises $200 to $200
DARYLEJOHN - Folds
SOOPERGLUE - Calls $100
*** RIVER *** [8h As 8c 10s] [4h]
SOOPERGLUE - Checks
PLUGNICKEL - Bets $700
SOOPERGLUE - Folds
PLUGNICKEL - returned ($700) : not called
*** SHOW DOWN ***
PLUGNICKEL - Does not show
PLUGNICKEL Collects $700 from main pot
*** SUMMARY ***
Total Pot($700)
Board [8h As 8c 10s 4h]
Seat 1: SHORTSTUFF137 Folded on the POCKET CARDS
Seat 2: SUTAN Folded on the POCKET CARDS
Seat 3: MOFOE1 Folded on the POCKET CARDS
Seat 4: DARYLEJOHN Folded on the TURN
Seat 5: ACEHOLE13 Folded on the POCKET CARDS
Seat 6: CHOOCH54 (dealer) Folded on the POCKET CARDS
Seat 7: SOOPERGLUE (small blind) Folded on the RIVER
Seat 8: PLUGNICKEL (big blind) collected Total ($700) HI:($700) [Does not show]
Seat 9: WASABIQUEEN Folded on the POCKET CARDS



', {ts '2009-03-17 10:01:25'} )
DataObject: d_gr_load_hh
Syntax In Error: INSERT INTO hand_histories ( game_number, site_id, hand_history, import_date ) VALUES ( 1534831498, 5, 'STAGE #1534831498 TOURNEY ID 4184662 HOLDEM MULTI NORMAL TOURNAMENT NO LIMIT $100 - 2009-03-17 09:59:56 (ET)
Table: 358 (Real Money) Seat #6 is the dealer
Seat 1 - SHORTSTUFF137 ($8440 in chips)
Seat 2 - SUTAN ($755 in chips)
Seat 3 - MOFOE1 ($16775 in chips)
Seat 4 - DARYLEJOHN ($10025 in chips)
Seat 5 - ACEHOLE13 ($3110 in chips)
Seat 6 - CHOOCH54 ($3775 in chips)
Seat 7 - SOOPERGLUE ($4525 in chips)
Seat 8 - PLUGNICKEL ($4485 in chips)
Seat 9 - WASABIQUEEN ($1285 in chips)
SOOPERGLUE - Posts small blind $50
PLUGNICKEL - Posts big blind $100
*** POCKET CARDS ***
Dealt to SOOPERGLUE [Kc 10h]
WASABIQUEEN - Folds
SHORTSTUFF137 - Folds
SUTAN - Folds
MOFOE1 - Folds
DARYLEJOHN - Calls $100
ACEHOLE13 - Folds
CHOOCH54 - Folds
SOOPERGLUE - Calls $50
PLUGNICKEL - Checks
*** FLOP *** [8h As 8c]
SOOPERGLUE - Checks
PLUGNICKEL - Checks
DARYLEJOHN - Checks
*** TURN *** [8h As 8c] [10s]
SOOPERGLUE - Bets $100
PLUGNICKEL - Raises $200 to $200
DARYLEJOHN - Folds
SOOPERGLUE - Calls $100
*** RIVER *** [8h As 8c 10s] [4h]
SOOPERGLUE - Checks
PLUGNICKEL - Bets $700
SOOPERGLUE - Folds
PLUGNICKEL - returned ($700) : not called
*** SHOW DOWN ***
PLUGNICKEL - Does not show
PLUGNICKEL Collects $700 from main pot
*** SUMMARY ***
Total Pot($700)
Board [8h As 8c 10s 4h]
Seat 1: SHORTSTUFF137 Folded on the POCKET CARDS
Seat 2: SUTAN Folded on the POCKET CARDS
Seat 3: MOFOE1 Folded on the POCKET CARDS
Seat 4: DARYLEJOHN Folded on the TURN
Seat 5: ACEHOLE13 Folded on the POCKET CARDS
Seat 6: CHOOCH54 (dealer) Folded on the POCKET CARDS
Seat 7: SOOPERGLUE (small blind) Folded on the RIVER
Seat 8: PLUGNICKEL (big blind) collected Total ($700) HI:($700) [Does not show]
Seat 9: WASABIQUEEN Folded on the POCKET CARDS



', {ts '2009-03-17 10:01:25'} )
*********************************

*********************************
PT Version: 2.17.03k
Error Date: 04/27/2009 11:06
Database Error: -3702
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Field 'tourney_game.table_name' cannot be a zero-length string.

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, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up ) VALUES ( 241, 17882, 1619864323, {ts '2009-04-27 10:39:04'}, 5, 'N/A', 0, '5s', 'Qc', '4h', 180.0000, 8487, {ts '2009-04-27 11:06:44'}, '', '(did not show hand)', 8487, 3, 7, 0 )
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, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up ) VALUES ( 241, 17882, 1619864323, {ts '2009-04-27 10:39:04'}, 5, 'N/A', 0, '5s', 'Qc', '4h', 180.0000, 8487, {ts '2009-04-27 11:06:44'}, '', '(did not show hand)', 8487, 3, 7, 0 )
*********************************

*********************************
PT Version: 2.17.03k
Error Date: 04/27/2009 11:19
Database Error: -3702
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Field 'tourney_game.table_name' cannot be a zero-length string.

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, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up ) VALUES ( 242, 17952, 1619864323, {ts '2009-04-27 10:39:04'}, 5, 'N/A', 0, '5s', 'Qc', '4h', 180.0000, 8532, {ts '2009-04-27 11:19:09'}, '', '(did not show hand)', 8532, 3, 7, 0 )
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, pot, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, heads_up ) VALUES ( 242, 17952, 1619864323, {ts '2009-04-27 10:39:04'}, 5, 'N/A', 0, '5s', 'Qc', '4h', 180.0000, 8532, {ts '2009-04-27 11:19:09'}, '', '(did not show hand)', 8532, 3, 7, 0 )
*********************************

[ptrack pat]

PT Version: 2.17.03k
Error Date: 04/27/2009 11:19
Database Error: -3702
Error Text: SQLSTATE = S1000
[Microsoft][ODBC Microsoft Access Driver] Field 'tourney_game.table_name' cannot be a zero-length string.

this is a database error, not one of the errors that were fixed in this patch. Open the File > Import Hand Histories/Tournament Summaries window, click the Select Files To Import button. Navigate to the folder where your hand history files are being saved and select one to import. Does it give this same error? If not, keep selecting files until you find the one that does. When you find it, open that file and copy/paste a couple hand histories from it here so I can see what it looks like.

[superglue]

Its all good now. I purged the errors, they remain there until purged correct, meaning that if I dont purge them then next time any error comes up it still shows old ones? and then would that have an effect on the [Microsoft][ODBC Microsoft Access Driver] Field 'tourney_game.table_name' cannot be a zero-length string. error? Because I dont receive it anymore when the hands are imported.

[ptrack pat]

Database errors do not display on the error log/maintenance window, you got that error from the pterrorlog.txt file correct?

[superglue]

correct, it had popped up in a separate window almost immediately after forcing an import.
It had said to copy the pterrorlog.txt which is the file pasted in the post. I was just commenting on the other errors that I posted because I hadnt purged them in awhile.

and another issue I recently started playing at FT do free rolls import? I have the auto import set, it reads the file but doesn't import any hands

[ptrack pat]

and another issue I recently started playing at FT do free rolls import? I have the auto import set, it reads the file but doesn't import any hands

I think so but I don't remember. Post a hand history from one of these.

[superglue]

I just realized its omaha, nevermind...I never play it so it didnt click,

thanks for all the help

[ptrack pat]

That's from an Omaha tournament so it's not going to import into PT2. Do you have any Hold'em hands?

[superglue]

That's from an Omaha tournament so it's not going to import into PT2. Do you have any Hold'em hands?

its been a long day...Im sure itll import, I havent played Holdem yet