problem with pokertracker

[unpredictab]

Hello,

I have some problem with pokertracker.
When i start PT, he run, but dont load the database. In the left column (when usually appears player list) appears this message: "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 tourney_holde_hand_player"
Then I did the Housekeeping and got this error message:
In this morning, while i was doing a sessione, PT crushed. I stopped PT by task manager and i restarted my notebook.

When i start PT, he run, but dont load the database. In the left column (when usually appears player list) appears this message: "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"

I hope you can help me.
Regards
Sebastian

[kraada]

Please restart PT3 with the Logging Enabled link and reproduce and report this problem so that we can investigate further for you - what you pasted here was only a portion of the full error message and we'll need the full message in order to more accurately determine what is going wrong here for you and what needs to be done to get things working again properly.

[unpredictab]

Ok, I use the logging enabled link.
This is my pokertrackerlogfile.
Or didnt you mean this?

2011/02/18 18:24:27.828: [- Main -][System] PokerTracker v3.09.3 beta
2011/02/18 18:24:27.906: [- Main -][SystemInfo] OS: Windows XP (build 2600, Service Pack 3)
2011/02/18 18:24:27.937: [- Main -][SystemInfo] Windows Version: 5.1 build 2600 (platform 2) Service Pack 3
2011/02/18 18:24:27.968: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0407
2011/02/18 18:24:27.984: [- Main -][SystemInfo] Total Logical Processing Units: 2
2011/02/18 18:24:28.015: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 2 PUs: 2 (L1: 2, L2: 1, L3: 0)
2011/02/18 18:24:28.046: [- Main -][SystemInfo] Processor 1: Speed: 1.66 GHz Name: Genuine Intel(R) CPU T2300 @ 1.66GHz
2011/02/18 18:24:28.078: [- Main -][SystemInfo] Processor 2: Speed: 1.66 GHz Name: Genuine Intel(R) CPU T2300 @ 1.66GHz
2011/02/18 18:24:28.109: [- Main -][SystemInfo] C:\ Disk Space: 305,235 mb total; 300,245 mb used; 4,990 mb free
2011/02/18 18:24:28.171: [- Main -][SystemInfo] Physical Memory: 2,046 mb (928 mb available) Virtual Memory: 2,048 mb (1,971 mb available) Page File: 3,939 mb (2,722 mb available)
2011/02/18 18:24:28.203: [- Main -][System Info] Video[0]: ATI Mobility Radeon X1400 (\\.\DISPLAY1)
2011/02/18 18:24:28.328: [- Main -][SystemInfo] Configuration: [WindowInfo]\nMainPos=427,1\nMainSize=1138,1166\nMainMaximized=Y\n\n\n[General]\nLogging=N\nBestHudPerformance=N\nRegistrationCode=*** REG CODE REMOVED ***\nBuildDate=2011/02/04\nInvalidText=#C0C0C0:NA\nUseCardImages=Y\nColorPositiveText=009900\nColorPositiveRow=EBFFEB\nColorNegativeText=AA0000\nColorNegativeRow=FFEBEB\n\n\n[Import]\nBeepOnCompletion=Y\nClusterOnCompletion=Y\nVacuumOnCompletion=Y\nAnalyzeOnCompletion=Y\nUpCacheOnCompletion=Y\nMoveProcessedFilesDirectory=C:\Programme\PokerTracker 3\Processed\nIncludeSubDirectories=Y\nCloseOnCompletion=N\nStartHud=Y\nPriority=2\nHidden.700=Y\nForceSetupWizard=N\nDetectOnCompletion=Y\nOverwriteTournamentSummary=Y\nAutoStart.100=N\nAutoStart.200=Y\nImportObservedHands=Y\nImportObservedHandsText=N\nAutoTreatAs=N\n\n\n\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=dbpass\nDB1.Name=PokerTracker 3 Database\nDB1.Type=postgres\nDB1.Postgres.Database=PT3 DB\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\nDB1.Default=Y\n\n\n[ReportInfo]\n\n\n[HandReplayer]\nShowKnownCards=Y\nShowHeroCards=Y\nShowHud=N\n\n[Tabs]\nLast:WindowMain=1\nLast:WindowImport=0\nLast:WindowStats:Holdem=1\nLast:WindowStatsTab:holdem-cash=0\nLast:WindowStatsTab:holdem-tourney=9\nLast:WindowStats:Omaha=0\nLast:WindowStatsTab:omaha-cash=0\nLast:WindowStatsTab:omaha-tourney=0\n[TableTracker]\nHideTablesNoStats=N\nGameIndex=0\n[Site.OnGame]\nHandHistoryDirectories=C:\Dokumente und Einstellungen\Basti\Lokale Einstellungen\Anwendungsdaten\P5\bwin\handhistory;C:\Dokumente und Einstellungen\Basti\Lokale Einstellungen\Anwendungsdaten\P5\HeyPoker\handhistory;C:\Dokumente und Einstellungen\Basti\Lokale Einstellungen\Anwendungsdaten\P5\RedKings\handhistory;C:\Dokumente und Einstellungen\Basti\Lokale Einstellungen\Anwendungsdaten\P5\Towergaming;\n[Messages]\nOptOut:99f7ba05d2216ef45d6109c13c89b4f4=Y\nOptOut:1ab4c8e72d3d58a327deeadb1bbc88a9=Y\nOptOut:218b96d1c4038f78923963117951eceb=Y\nOptOut:cbabd16e2b3e061d85fb6eb40d17f728=Y\nOptOut:ca181ba850dd86852eda807cab29b1d4=Y\nOptOut:68f87987379afe0141c2bc0e83ea383b=Y\nOptOut:eb33978b2449a0ed0a1039c410ea9d17=Y\n[Hud]\nPerformanceOption=0\nMuckedCards.Display=Y\nMuckedCards.Length=5\nMuckedCards.Translucency=20\nNotes.Translucency=20\nMinHands=1\nCurrentLimit=N\nCurrentBlind=Y\nSessionStats=Y\nLastXHands=0\nRefreshRates=0,100,1|101,500,5|501,2000,10|2001,100000,20|\nPlayerRanges=2,2|3,6|7,10|\nNotesSize=450,150\n[Directories]\nManualImportDirectory=C:\Programme\OnGame Hand Grabber\Hand History\nPostgresBin=\Programme\PostgreSQL\8.3\bin\nBackupDirectory=C:\Dokumente und Einstellungen\Basti\Desktop\nManualImportFile=C:\Dokumente und Einstellungen\Basti\Desktop\AN9aAoOD20101029111609\*\n[Site.PokerStars]\nHandHistoryDirectory=C:\Programme\PokerStars\HandHistory\n[Site.FullTilt]\nRushHud=Y\n[TournamentDetect]\nCheckBoxProtectType=Y\nCheckBoxSavePosPrize=Y\nCheckBoxSaveType=Y\nDefaultTables=0\nDefaultMinsPerRound=5\n[Site.Party]\n
2011/02/18 18:24:28.640: [- Main -][System] Getting String: 1058-2529-F65D-77AB-E5A0-5C06-9259-3BFC
2011/02/18 18:24:28.718: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/regcheck.php
2011/02/18 18:24:28.734: [- Main -][wxThreadedRead] Starting read thread ...
2011/02/18 18:24:28.765: [000013AC][ConnectorReadThread] Thread [0x000013AC]: Begin
2011/02/18 18:24:28.812: [000013AC][ConnectorReadThread::Entry] Beginning thread.
2011/02/18 18:24:28.843: [000013AC][ConnectorReadThread] Creating socket...
2011/02/18 18:24:28.859: [000013AC][ConnectorReadThread] DNS lookup...
2011/02/18 18:24:29.078: [000013AC][ConnectorReadThread] Socket connect...
2011/02/18 18:24:30.515: [000013AC][ConnectorReadThread] Sending request...
2011/02/18 18:24:30.937: [000013AC][ConnectorReadThread] Reading response...
2011/02/18 18:24:30.968: [000013AC][ConnectorReadThread] Read complete.
2011/02/18 18:24:31.000: [000013AC][ConnectorReadThread] Returning.
2011/02/18 18:24:31.046: [- Main -][wxThreadedRead] Getting data ...
2011/02/18 18:24:31.093: [- Main -][Registration] License written to C:\Programme\PokerTracker 3/Data/Config/PokerTracker.lic
2011/02/18 18:24:31.140: [- Main -][System] Registered: true
2011/02/18 18:24:31.187: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/content/up ... mentDetect
2011/02/18 18:24:31.203: [- Main -][wxThreadedRead] Starting read thread ...
2011/02/18 18:24:31.234: [00001444][ConnectorReadThread] Thread [0x00001444]: Begin
2011/02/18 18:24:31.265: [00001444][ConnectorReadThread::Entry] Beginning thread.
2011/02/18 18:24:31.312: [00001444][ConnectorReadThread] Creating socket...
2011/02/18 18:24:31.375: [00001444][ConnectorReadThread] DNS lookup...
2011/02/18 18:24:31.453: [00001444][ConnectorReadThread] Socket connect...
2011/02/18 18:24:32.359: [00001444][ConnectorReadThread] Sending request...
2011/02/18 18:24:32.984: [00001444][ConnectorReadThread] Reading response...
2011/02/18 18:24:33.015: [00001444][ConnectorReadThread] Read complete.
2011/02/18 18:24:33.046: [00001444][ConnectorReadThread] Returning.
2011/02/18 18:24:33.234: [- Main -][wxThreadedRead] Getting data ...
2011/02/18 18:24:33.296: [- Main -][System] TRP Status: TH: false; TO: false; RH: true; RO: false; PH: true; PO: false;
2011/02/18 18:24:33.359: [- Main -][WindowSplash] Beginning load process
2011/02/18 18:24:33.390: [00001378][WindowSplash::Worker::Entry] Beginning thread.
2011/02/18 18:24:33.406: [00001378][WindowSplash::Worker] Thread [0x00001378]: Begin
2011/02/18 18:24:33.453: [00001378][CurrencyManager] Rates are 0 days old
2011/02/18 18:24:33.484: [00001378][QueryManager] Loading queries
2011/02/18 18:24:33.515: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Aliases.xml.pte
2011/02/18 18:24:33.562: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2011/02/18 18:24:33.750: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2011/02/18 18:24:33.875: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Notes.xml.pte
2011/02/18 18:24:33.953: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Hand-Detail.xml.pte
2011/02/18 18:24:34.156: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Hand-Summary.xml.pte
2011/02/18 18:24:34.296: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Players.xml.pte
2011/02/18 18:24:34.406: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2011/02/18 18:24:34.531: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-EV-AllinPerformance.xml.pte
2011/02/18 18:24:34.609: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2011/02/18 18:24:34.750: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2011/02/18 18:24:34.875: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\Player-Details.xml.pte
2011/02/18 18:24:34.968: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2011/02/18 18:24:35.078: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2011/02/18 18:24:35.234: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-More-Details.xml.pte
2011/02/18 18:24:35.281: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\Summary-Site.xml.pte
2011/02/18 18:24:35.406: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2011/02/18 18:24:35.718: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2011/02/18 18:24:35.906: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2011/02/18 18:24:35.937: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2011/02/18 18:24:35.984: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2011/02/18 18:24:36.078: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Tourney\Player-Details.xml.pte
2011/02/18 18:24:36.109: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2011/02/18 18:24:36.171: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Tourney\Summary-Site.xml.pte
2011/02/18 18:24:36.250: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2011/02/18 18:24:36.328: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2011/02/18 18:24:36.640: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2011/02/18 18:24:36.828: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-BBWon.xml.pte
2011/02/18 18:24:36.921: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-EV-AllinPerformance.xml.pte
2011/02/18 18:24:36.984: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-MoneyWon.xml.pte
2011/02/18 18:24:37.078: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-ShowdownNoShowdown.xml.pte
2011/02/18 18:24:37.171: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\Player-Details.xml.pte
2011/02/18 18:24:37.203: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\Players.xml.pte
2011/02/18 18:24:37.281: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-Hands-Graph.xml.pte
2011/02/18 18:24:37.359: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-More-Details.xml.pte
2011/02/18 18:24:37.500: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\Summary-Site.xml.pte
2011/02/18 18:24:37.578: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer-Detail.xml.pte
2011/02/18 18:24:37.875: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer.xml.pte
2011/02/18 18:24:38.031: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph-Month.xml.pte
2011/02/18 18:24:38.062: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph.xml.pte
2011/02/18 18:24:38.109: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Tourney\Graphs-MoneyWon.xml.pte
2011/02/18 18:24:38.187: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Tourney\Player-Details.xml.pte
2011/02/18 18:24:38.234: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Tourney\Players.xml.pte
2011/02/18 18:24:38.296: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Tourney\Summary-Site.xml.pte
2011/02/18 18:24:38.359: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Tourney\Tournaments-Hands-Graph.xml.pte
2011/02/18 18:24:38.453: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer-Detail.xml.pte
2011/02/18 18:24:38.796: [00001378][Query] Loading query file: C:\Programme\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer.xml.pte
2011/02/18 18:24:38.984: [00001378][QueryManager] Queries loaded.
2011/02/18 18:24:39.015: [00001378][StatManager] Loading stats and reports...
2011/02/18 18:24:43.312: [00001378][StatManager] Stats and reports loaded. Load: 4.26s, Custom: 0.6378ms, Dupe: 0.0858ms
2011/02/18 18:24:43.375: [00001378][FilterManager] Loading filters...
2011/02/18 18:24:51.671: [00001378][FilterManager] Filters loaded.
2011/02/18 18:24:51.750: [00001378][LayoutManager] Loading layouts...
2011/02/18 18:24:52.203: [00001378][StatManager] Loading stats and reports...
2011/02/18 18:24:56.390: [00001378][StatManager] Stats and reports loaded. Load: 4.16s, Custom: 0.6540ms, Dupe: 0.0824ms
2011/02/18 18:24:56.546: [00001378][LayoutManager] Layouts loaded.
2011/02/18 18:24:56.593: [00001378][PostgresConnection] Connecting to database: PT3 DB
2011/02/18 18:24:56.703: [00001378][PostgresConnection] [0447E9A0] Successfully connected to: PT3 DB [0x0447e640] (ver = 80304, autotune = N)
2011/02/18 18:24:56.796: [00001378][ConnectionManager] Database Version: 300049
2011/02/18 18:24:56.859: [00001378][PostgresConnection] Connecting to database: PT3 DB
2011/02/18 18:24:56.968: [00001378][PostgresConnection] [0448BFC0] Successfully connected to: PT3 DB [0x0448bc30] (ver = 80304, autotune = N)
2011/02/18 18:24:57.031: [00001378][PostgresConnection] Connecting to database: PT3 DB
2011/02/18 18:24:57.125: [00001378][PostgresConnection] [0448BEB0] Successfully connected to: PT3 DB [0x0448b3c0] (ver = 80304, autotune = N)
2011/02/18 18:24:57.187: [00001378][PostgresConnection] Connecting to database: PT3 DB
2011/02/18 18:24:57.296: [00001378][PostgresConnection] [0448B6A0] Successfully connected to: PT3 DB [0x0448cb50] (ver = 80304, autotune = N)
2011/02/18 18:24:57.625: [00001378][WindowSplash::Worker::Entry] Ending thread.
2011/02/18 18:24:57.656: [- Main -][WindowSplash::winNotify] Notified of worker completion.
2011/02/18 18:24:57.687: [- Main -][WindowSplash::checkProgress] Worker complete.
2011/02/18 18:24:58.078: [- Main -][WPEXOptions] Unable to access registry key
2011/02/18 18:24:58.125: [- Main -][WPEXOptions] Found INI File:
2011/02/18 18:24:58.921: [- Main -][EverleafOptions] Found INI File:
2011/02/18 18:25:00.015: [- Main -][PokerStars] Install Path: C:\Programme\PokerStars
2011/02/18 18:25:00.031: [- Main -][PokerStarsOptions] Found INI File: C:\Programme\PokerStars\user.ini
2011/02/18 18:25:00.687: [- Main -][Players] Buddies:
2011/02/18 18:25:00.718: [- Main -][Players] 0 buddies found
2011/02/18 18:25:14.250: [- Main -][System] Getting String: PSMG=2009/10/27 22:38
2011/02/18 18:25:14.921: [- Main -][WindowStatsTab] Refreshing active player: false
2011/02/18 18:25:15.171: [- Main -][WindowStatsTab] Refreshing active player: false
2011/02/18 18:25:15.953: [- Main -][WindowMain] Database: PokerTracker 3 Database Size: 2641 MB
2011/02/18 18:25:16.046: [- Main -][WindowMain] Database: PokerTracker 3 Database Cache Status: Holdem: 100% Holdem Tourney: 100%
2011/02/18 18:25:16.250: [0000012C][ThreadPool] Thread [05408D50]: Created
2011/02/18 18:25:16.296: [0000012C][Query::QueryThread] Thread [0x0000012C]: Begin
2011/02/18 18:25:16.359: [0000012C][Query] Connecting to database: PokerTracker 3 Database
2011/02/18 18:25:16.421: [0000012C][Query] Executing SQL (Thread): 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 tourney_holdem_hand_player_statistics.id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 AND (((tourney_holdem_hand_player_statistics.date_played >= '2010/10/31 23:00:00'))) ) ORDER BY player.player_name_search asc
2011/02/18 18:25:22.281: [0000012C][PostgresConnection (Error)] 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 tourney_holdem_hand_player_statistics.id_player FROM tourney_holdem_hand_player_statistics WHERE 1=1 AND (((tourney_holdem_hand_player_statistics.date_played >= '2010/10/31 23:00:00'))) ) ORDER BY player.player_name_search asc ; Reason: Fatal Error (ERROR: could not read block 735 of relation 1663/16403/76982: Invalid argument )
2011/02/18 18:25:22.578: [0000012C][Query] Query execution time: 6100.43175878 ms

[WhiteRider]

For future reference please attach your log files to a Support ticket rather than pasting the contents as things can get cut off.

Here it looks as if you have a file error in your database.
Try a Reindex in Database > Housekeeping.
If ReIndex in housekeeping doesn't help, you can try setting PostgreSQL to ignore these errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text “zero_damaged_pages = on” on a new line and then save and close the file. Click Start --> Programs --> PostgreSQL --> Reload Configuration and PostgreSQL will ignore the damaged data.

[unpredictab]

Thanks for the answer.
Housekeeping didnt work.
I put the text "zero_damaged_pages = on" on a new line, saved and closed it and reload it but when I start Pokertracker I have the same problem.
Can I do something else?


I dont understand it, I didnt nothing today just playing poker but now there are no players to see at the tournament tab. When I click the cash game tab I see all the players there.

[WhiteRider]

There could be an error with one of the files which makes up your database - try running "chkdsk" to see if you have any disk errors?

[unpredictab]

I run chkdsk and now it works.
Ty for your help.

[WhiteRider]

Great - thanks for the update.