Problem Importing Tournament Summaries

Any support related posts should go here.

Problem Importing Tournament Summaries

Postby RaineTech » Sat Apr 12, 2008 7:16 pm

This is the first time i've ever had this problem, as it has worked before with no problems. When I try to import, I get the following error message:


*********************************
PT Version: 2.17.00i
Error Date: 04/12/2008 17:58
Database Error: -1812
Error Text: SQLSTATE = S1001
[Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk.

No changes made to database.

INSERT INTO tourney_summary ( tourney_id, place_of_finish, player_id, amt_won, real_player_id, sat_seat_won, actual_buy_in, actual_fee, total_rebuys, rebuy_amt, total_addons, addon_amt ) VALUES ( 1612, 5492, 236698, 0.0000, 236698, 0, 10.0000, 1.0000, 0, 0.0000, 0, 0.0000 )
DataObject: d_tourney_summary
Syntax In Error: INSERT INTO tourney_summary ( tourney_id, place_of_finish, player_id, amt_won, real_player_id, sat_seat_won, actual_buy_in, actual_fee, total_rebuys, rebuy_amt, total_addons, addon_amt ) VALUES ( 1612, 5492, 236698, 0.0000, 236698, 0, 10.0000, 1.0000, 0, 0.0000, 0, 0.0000 )
*********************************
RaineTech
 
Posts: 4
Joined: Sat Apr 12, 2008 7:11 pm

Re: Problem Importing Tournament Summaries

Postby ptrack pat » Sat Apr 12, 2008 8:55 pm

Is this from a huge Stars tournament? I suggest using the Customize Summary Info. To Import button on the File > Tournament Results - Manual Entry > PokerStars window to limit the # of players that get imported by choosing the "only in the money" or "in the money/played with" option. This will keep the database error from happening and keep your player database from getting huge with names you will probably never see again.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Problem Importing Tournament Summaries

Postby RaineTech » Sat Apr 12, 2008 9:30 pm

ptrack pat wrote:Is this from a huge Stars tournament? I suggest using the Customize Summary Info. To Import button on the File > Tournament Results - Manual Entry > PokerStars window to limit the # of players that get imported by choosing the "only in the money" or "in the money/played with" option. This will keep the database error from happening and keep your player database from getting huge with names you will probably never see again.


It's from when I go to import tournament summaries do the import from a file. I usually have stars send HH of like 50 tournaments at once. I have done this before even with the sunday hundred grand it is only now giving me this error. I have tried what you just said and re-running the import so we'll see what happens. Thanks.
RaineTech
 
Posts: 4
Joined: Sat Apr 12, 2008 7:11 pm

Re: Problem Importing Tournament Summaries

Postby ptrack pat » Sat Apr 12, 2008 10:28 pm

How do you get them to send this many summaries at once? Do you request it from their lobby window menu? Or does support email you a file? Because if you request it from the lobby window menu, they are only going to send the full summaries from the last handful of tournaments and the other summaries aren't going to contain the data PT needs.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PTH Support

Who is online

Users browsing this forum: No registered users and 1 guest