Stats importing doesnt work

General discussion of PokerTracker 3.

Moderator: Moderators

Stats importing doesnt work

Postby Tomann21 » Sun Jul 24, 2011 5:16 pm

Hi, I have a problem with importing my statistics. If I open my PT in a list - TEXAS HOLDEM - CASH-GAMES, there should be a list of players (on the right side of the window) - these are all players I have ever met by the tables. But the names are missing - there are written some errors instead:

Unable to execute query:
SELECT player.id_player,
player.id_site,
player.player_name,
player.val_icon FROM player
WHERE player.id_player > 0
AND player.id_player_alias = 0
AND player.id_player in (
SELECT DISTINCT
holdem_table_session_summary.id

The spaces in the column´s name: "Player" is empty (there should be written my nick "Tomann21") and it is impossible to write it in it standardly, and the column next to it called "Site" is also empty.

This all caused that I also cannot see any winnigs, graphs, results of sessions, starting hands etc. and if I click on "Begin Auto Import", no stats are imported.

I also tried MANUAL IMPORT FROM DIRECTORY but it doesn´t work as well - error message:
"There were errors during the housekeeping process:
Unable to execute query: VACUUM
holdem_table_session_summary;; Reason: Fatal Error
(ERROR: relation "holdem_table_session_summary" does not exist)"

I would be grateful for some advices.
Tomann21
 
Posts: 10
Joined: Sun Jul 17, 2011 2:24 pm

Re: Stats importing doesnt work

Postby WhiteRider » Mon Jul 25, 2011 5:36 am

When you did the manual import were any hands imported?
It doesn't sound like there is any information in the database but if you report your problem your log files will contain the full errors and allow one of our support technicians to work with you to get things sorted out.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Stats importing doesnt work

Postby Tomann21 » Mon Jul 25, 2011 6:13 am

No, the manual import wasnt sucessfull as well:

I also tried MANUAL IMPORT FROM DIRECTORY but it doesn´t work as well - error message:
"There were errors during the housekeeping process:
Unable to execute query: VACUUM
holdem_table_session_summary;; Reason: Fatal Error
(ERROR: relation "holdem_table_session_summary" does not exist)"

How can I find, if there is any informations in the database?
Tomann21
 
Posts: 10
Joined: Sun Jul 17, 2011 2:24 pm

Re: Stats importing doesnt work

Postby kraada » Mon Jul 25, 2011 9:36 am

That error message is implying that one of our necessary database tables does not exist; you will almost certainly need to create a new database in order to get around this issue.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stats importing doesnt work

Postby Tomann21 » Mon Jul 25, 2011 10:20 am

But HOW can I create a new database, from which directory? I clicked on the top icon "Database" and then "Database management", then "Edit" on the bottom left pannel but I dont know which directory to choose - WHERE is the database saved in my PC.
Tomann21
 
Posts: 10
Joined: Sun Jul 17, 2011 2:24 pm

Re: Stats importing doesnt work

Postby WhiteRider » Tue Jul 26, 2011 3:44 am

You will need to create a new database by clicking "New" - see this post for more information.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests