Unable to execute query

[Tunatic]

Hello. I am a new PokerTracker 3 user and this is the first error I encountered in the trial since I started using it. Hopefully I can get some help on here.

Anyhow, PokerTracker has been running perfect lately, except for one single MTT yesterday. When I finished the tournament, I went to check the hands under the tournaments tab. The tournament list was fine, but below where the hands are supposed to be displayed, this is all I got:

Unable to execute query: SELECT (tourney_holdem_hand_summary.id_hand) as "id_hand" ...

... and a load of other crap, several lines of such stuff.

I've already searched the forum regarding this issue, but none of the resolutions helped me. Things I tried so far to fix it:

restarting the PC

restarting PokerTracker

re-indexing PostgreSQL

using the command in PostgreSQL configuration file to ignore errors

exporting and importing the tournament

Nothing helped, so I'd appreciate any help from you.

Below is the .log file with logging enabled:

Spoiler: show

2011/08/11 05:57:54.437: [- Main -][System] PokerTracker v3.10
2011/08/11 05:57:54.468: [- Main -][SystemInfo] OS: Windows XP (build 2600, Service Pack 3)
2011/08/11 05:57:54.484: [- Main -][SystemInfo] Windows Version: 5.1 build 2600 (platform 2) Service Pack 3
2011/08/11 05:57:54.484: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0424
2011/08/11 05:57:54.500: [- Main -][SystemInfo] Total Logical Processing Units: 1
2011/08/11 05:57:54.515: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 1 PUs: 1 (L1: 1, L2: 1, L3: 0)
2011/08/11 05:57:54.515: [- Main -][SystemInfo] Processor 1: Speed: 2.21 GHz Name: AMD Athlon(tm) 64 Processor 3500+
2011/08/11 05:57:54.531: [- Main -][SystemInfo] C:\ Disk Space: 152,617 mb total; 75,950 mb used; 76,667 mb free
2011/08/11 05:57:54.546: [- Main -][SystemInfo] E:\ Disk Space: 980 mb total; 980 mb used; 0 mb free
2011/08/11 05:57:54.562: [- Main -][SystemInfo] Physical Memory: 2,048 mb (2,048 mb available) Virtual Memory: 2,048 mb (1,974 mb available) Page File: 4,096 mb (4,096 mb available)
2011/08/11 05:57:54.578: [- Main -][System Info] Video[0]: Radeon X1650 Series (\\.\DISPLAY1)
2011/08/11 05:57:54.625: [- Main -][SystemInfo] Configuration: [WindowInfo]\nMainPos=91,115\nMainSize=1015,733\nMainMaximized=N\n\n\n[General]\nLogging=Y\nBuildDate=2011/03/16\nBestHudPerformance=N\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\nForceSetupWizard=N\nAutoStart.1400=N\nAutoStart.1300=N\nAutoStart.700=N\nAutoStart.1200=N\nAutoStart.800=N\nAutoStart.1000=N\nAutoStart.500=N\nAutoStart.2300=N\nAutoStart.300=N\nAutoStart.400=Y\nAutoStart.2100=N\nAutoStart.1100=N\nAutoStart.600=N\nAutoStart.900=N\nAutoStart.200=Y\nAutoStart.100=N\nAutoStart.2200=N\nAutoStart.1800=N\nAutoStart.2400=N\nIncludeSubDirectories=Y\nCloseOnCompletion=N\nStartHud=Y\nDetectOnCompletion=Y\nOverwriteTournamentSummary=N\nPriority=2\nAutoTourneyDetect=Y\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]\n\n[Site.FullTilt]\nRushHud=Y\n[Site.Betfair]\nHandHistoryDirectories=-\n[Site.Boss]\nHandHistoryDirectories=-;\n[Site.Cake]\nHandHistoryDirectories=-\n[Site.Cereus]\nHandHistoryDirectories=-\n[Site.Entraction]\nHandHistoryDirectories=-\n[Site.Everleaf]\nHandHistoryDirectories=-\n[Site.iPoker]\nHandHistoryDirectories=C:\Poker\William Hill Poker\History;\n[Site.Merge]\nHandHistoryDirectories=-\n[Site.MicroGaming]\nHandHistoryDatabases=-\n[Site.OnGame]\nHandHistoryDirectories=-\n[Site.YatahayNetwork]\nHandHistoryDirectory=-\n[Tabs]\nLast:WindowMain=1\nLast:WindowImport=0\nLast:WindowStats:Holdem=1\nLast:WindowStatsTab:holdem-cash=6\nLast:WindowStatsTab:holdem-tourney=3\nLast:WindowStats:Omaha=0\nLast:WindowStatsTab:omaha-cash=0\nLast:WindowStatsTab:omaha-tourney=0\nShow:Main:Omaha=Y\n[TableTracker]\nGameIndex=0\nHideTablesNoStats=N\nSites=PartyGaming;\nLimits=$0.10 NL;\n[Messages]\nOptOut:1ab4c8e72d3d58a327deeadb1bbc88a9=Y\nOptOut:99f7ba05d2216ef45d6109c13c89b4f4=Y\nOptOut:ca181ba850dd86852eda807cab29b1d4=Y\nOptOut:5c3975c93b81eb60943870d3fc8646b8=Y\n[Hud]\nNotesSize=449,150\nMuckedCards.Display=Y\nMuckedCards.Length=5\nMuckedCards.Translucency=20\nNotes.Translucency=20\nMinHands=1\nCurrentLimit=N\nCurrentBlind=N\nSessionStats=Y\nLastXHands=0\nRefreshRates=0,1000,1|\n[TournamentDetect]\nCheckBoxProtectType=Y\nCheckBoxSavePosPrize=Y\nCheckBoxSaveType=Y\nDefaultTables=0\nDefaultMinsPerRound=10\n[Directories]\nDatabaseExportDirectory=C:\Documents and Settings\Tunatic\Desktop\n
2011/08/11 05:57:54.703: [- Main -][System] Getting String: 4CD7-F257-9696-1845-B240-443C-5157-0FD7
2011/08/11 05:57:54.750: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/regcheck.php
2011/08/11 05:57:54.750: [- Main -][wxThreadedRead] Starting read thread ...
2011/08/11 05:57:54.765: [00000900][ConnectorReadThread] Thread [0x00000900]: Begin
2011/08/11 05:57:54.781: [00000900][ConnectorReadThread::Entry] Beginning thread.
2011/08/11 05:57:54.781: [00000900][ConnectorReadThread] Creating socket...
2011/08/11 05:57:54.796: [00000900][ConnectorReadThread] DNS lookup...
2011/08/11 05:57:54.828: [00000900][ConnectorReadThread] Socket connect...
2011/08/11 05:57:55.437: [00000900][ConnectorReadThread] Sending request...
2011/08/11 05:57:55.781: [00000900][ConnectorReadThread] Reading response...
2011/08/11 05:57:55.796: [00000900][ConnectorReadThread] Read complete.
2011/08/11 05:57:55.812: [00000900][ConnectorReadThread] Returning.
2011/08/11 05:57:55.812: [- Main -][wxThreadedRead] Getting data ...
2011/08/11 05:57:55.828: [- Main -][Registration] License written to C:\Program Files\PokerTracker 3/Data/Config/PokerTracker.lic
2011/08/11 05:57:55.859: [- Main -][System] Registered: false
2011/08/11 05:57:55.890: [- Main -][System] Registration Status Invalid
2011/08/11 05:57:55.906: [- Main -][System] TRP Status: TH: true; TO: false; RH: false; RO: false; PH: true; PO: false;
2011/08/11 05:59:44.531: [- Main -][WindowSplash] Beginning load process
2011/08/11 05:59:44.562: [00000F74][WindowSplash::Worker::Entry] Beginning thread.
2011/08/11 05:59:44.562: [00000F74][WindowSplash::Worker] Thread [0x00000F74]: Begin
2011/08/11 05:59:44.593: [00000F74][CurrencyManager] Rates are 0 days old
2011/08/11 05:59:44.609: [00000F74][QueryManager] Loading queries
2011/08/11 05:59:44.625: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Aliases.xml.pte
2011/08/11 05:59:44.640: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2011/08/11 05:59:44.703: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2011/08/11 05:59:44.750: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Notes.xml.pte
2011/08/11 05:59:44.765: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Hand-Detail.xml.pte
2011/08/11 05:59:44.843: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Hand-Summary.xml.pte
2011/08/11 05:59:44.875: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Players.xml.pte
2011/08/11 05:59:44.890: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2011/08/11 05:59:44.937: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-EV-AllinPerformance.xml.pte
2011/08/11 05:59:44.953: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2011/08/11 05:59:44.984: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2011/08/11 05:59:45.031: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Player-Details.xml.pte
2011/08/11 05:59:45.046: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2011/08/11 05:59:45.078: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2011/08/11 05:59:45.093: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-More-Details.xml.pte
2011/08/11 05:59:45.125: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Summary-Site.xml.pte
2011/08/11 05:59:45.140: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2011/08/11 05:59:45.250: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2011/08/11 05:59:45.296: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2011/08/11 05:59:45.328: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2011/08/11 05:59:45.343: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2011/08/11 05:59:45.390: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Player-Details.xml.pte
2011/08/11 05:59:45.406: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2011/08/11 05:59:45.437: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Summary-Site.xml.pte
2011/08/11 05:59:45.468: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2011/08/11 05:59:45.500: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2011/08/11 05:59:45.593: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2011/08/11 05:59:45.671: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-BBWon.xml.pte
2011/08/11 05:59:45.703: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-EV-AllinPerformance.xml.pte
2011/08/11 05:59:45.734: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-MoneyWon.xml.pte
2011/08/11 05:59:45.781: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-ShowdownNoShowdown.xml.pte
2011/08/11 05:59:45.812: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Player-Details.xml.pte
2011/08/11 05:59:45.828: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Players.xml.pte
2011/08/11 05:59:45.859: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-Hands-Graph.xml.pte
2011/08/11 05:59:45.890: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-More-Details.xml.pte
2011/08/11 05:59:45.906: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Summary-Site.xml.pte
2011/08/11 05:59:45.937: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer-Detail.xml.pte
2011/08/11 05:59:46.031: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer.xml.pte
2011/08/11 05:59:46.125: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph-Month.xml.pte
2011/08/11 05:59:46.156: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph.xml.pte
2011/08/11 05:59:46.156: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\Graphs-MoneyWon.xml.pte
2011/08/11 05:59:46.203: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\Player-Details.xml.pte
2011/08/11 05:59:46.218: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\Players.xml.pte
2011/08/11 05:59:46.234: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\Summary-Site.xml.pte
2011/08/11 05:59:46.265: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\Tournaments-Hands-Graph.xml.pte
2011/08/11 05:59:46.296: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer-Detail.xml.pte
2011/08/11 05:59:46.421: [00000F74][Query] Loading query file: C:\Program Files\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer.xml.pte
2011/08/11 05:59:46.484: [00000F74][QueryManager] Queries loaded.
2011/08/11 05:59:46.500: [00000F74][StatManager] Loading stats and reports...
2011/08/11 05:59:47.500: [00000F74][StatManager] Stats and reports loaded. Load: 980ms, Custom: 0.0673ms, Dupe: -0.0000ms
2011/08/11 05:59:47.515: [00000F74][FilterManager] Loading filters...
2011/08/11 05:59:49.609: [00000F74][FilterManager] Filters loaded.
2011/08/11 05:59:49.625: [00000F74][LayoutManager] Loading layouts...
2011/08/11 05:59:49.734: [00000F74][StatManager] Loading stats and reports...
2011/08/11 05:59:51.015: [00000F74][StatManager] Stats and reports loaded. Load: 1.26s, Custom: 0.0774ms, Dupe: 0.0000ms
2011/08/11 05:59:51.031: [00000F74][LayoutManager] Layouts loaded.
2011/08/11 05:59:51.046: [00000F74][PostgresConnection] Connecting to database: PT3 DB
2011/08/11 05:59:51.109: [00000F74][PostgresConnection] [041D5D30] Successfully connected to: PT3 DB [0x041d59d0] (ver = 80309, autotune = N)
2011/08/11 05:59:51.156: [00000F74][ConnectionManager] Database Version: 300049
2011/08/11 05:59:51.187: [00000F74][PostgresConnection] Connecting to database: PT3 DB
2011/08/11 05:59:51.234: [00000F74][PostgresConnection] [041E0900] Successfully connected to: PT3 DB [0x041e01a0] (ver = 80309, autotune = N)
2011/08/11 05:59:51.265: [00000F74][PostgresConnection] Connecting to database: PT3 DB
2011/08/11 05:59:51.343: [00000F74][PostgresConnection] [041E0860] Successfully connected to: PT3 DB [0x041e19e0] (ver = 80309, autotune = N)
2011/08/11 05:59:51.375: [00000F74][PostgresConnection] Connecting to database: PT3 DB
2011/08/11 05:59:51.437: [00000F74][PostgresConnection] [041E1C60] Successfully connected to: PT3 DB [0x041e10e0] (ver = 80309, autotune = N)
2011/08/11 05:59:51.468: [- Main -][WindowSplash::winNotify] Notified of worker completion.
2011/08/11 05:59:51.484: [00000F74][WindowSplash::Worker::Entry] Ending thread.
2011/08/11 05:59:51.500: [- Main -][WindowSplash::checkProgress] Worker complete.
2011/08/11 05:59:51.656: [- Main -][EverleafOptions] Found INI File:
2011/08/11 05:59:51.703: [- Main -][FullTiltOptions] Using FullTiltPoker: C:\Documents and Settings\Tunatic\Local Settings\Application Data\FullTiltPoker
2011/08/11 05:59:51.781: [- Main -][PokerStars] Install Path: C:\Program Files\PokerStars
2011/08/11 05:59:51.796: [- Main -][PokerStarsOptions] Found INI File: C:\Program Files\PokerStars\user.ini
2011/08/11 05:59:51.843: [- Main -][WPEXOptions] Unable to access registry key
2011/08/11 05:59:51.859: [- Main -][WPEXOptions] Found INI File:
2011/08/11 05:59:51.906: [- Main -][Players] Buddies:
2011/08/11 05:59:51.921: [- Main -][Players] 0 buddies found
2011/08/11 05:59:54.984: [- Main -][System] Getting String:
2011/08/11 05:59:55.140: [- Main -][WindowStatsTab] Refreshing active player: false
2011/08/11 05:59:55.187: [- Main -][WindowStatsTab] Refreshing active player: false
2011/08/11 05:59:55.718: [- Main -][WindowMain] Database: PokerTracker 3 Database Size: 28 MB
2011/08/11 05:59:55.734: [- Main -][WindowMain] Database: PokerTracker 3 Database Cache Status: Holdem: 100% Holdem Tourney: 0%
2011/08/11 05:59:55.796: [00000200][ThreadPool] Thread [050E9D10]: Created
2011/08/11 05:59:55.812: [00000200][Query::QueryThread] Thread [0x00000200]: Begin
2011/08/11 05:59:55.828: [00000200][Query] Connecting to database: PokerTracker 3 Database
2011/08/11 05:59:55.843: [00000200][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_summary, tourney_holdem_hand_player_statistics WHERE 1=1 AND tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand AND (((tourney_holdem_hand_summary.id_site in (400) ))) ) ORDER BY player.player_name_search asc
2011/08/11 05:59:55.921: [00000200][Query] Query execution time: 46.51652654 ms
2011/08/11 05:59:55.984: [00000200][QueryReportCtrl::Populate] Thread [0x00000200]: Begin
2011/08/11 05:59:56.140: [00000200][QueryReportCtrl] Query 1: Populate: 129.2790 ms, 479 rows, 6 cols, 0.0450 ms/col (time log: Query 1: t0: 1.7983 ms, t1: 1.3407 ms, t2: 126.0459 ms, t3: 0.0017 ms, t4: 0.0534 ms, t5: 0.0056 ms, t6: 0.0020 ms)
2011/08/11 06:00:16.203: [00000200][Query::QueryThread] Thread [0x00000200]: Begin
2011/08/11 06:00:16.218: [00000200][Query] Connecting to database: PokerTracker 3 Database
2011/08/11 06:00:16.250: [00000200][Query] Executing SQL (Thread): SELECT (tourney_holdem_summary.id_tourney) as "id_tourney", (tourney_holdem_summary.flg_note) as "flg_note", (tourney_holdem_summary.tourney_no) as "tourney_no", (tourney_holdem_results.date_start) as "date_start_player", (tourney_holdem_results.date_end) as "date_end_player", (tourney_holdem_summary.id_site) as "id_site", (tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon) as "amt_buyin_ttl", (tourney_holdem_results.val_finish) as "val_finish", (tourney_holdem_results.amt_won) as "amt_won" FROM tourney_holdem_results, tourney_holdem_summary WHERE (tourney_holdem_results.id_tourney = tourney_holdem_summary.id_tourney) AND (tourney_holdem_results.id_player = 759) AND ((( tourney_holdem_summary.id_site in (400) )))
2011/08/11 06:00:16.265: [00000200][Query] Query execution time: 2.97300355 ms
2011/08/11 06:00:16.406: [00000200][QueryReportCtrl::Populate] Thread [0x00000200]: Begin
2011/08/11 06:00:16.515: [00000200][QueryReportCtrl] Query 2: Populate: 97.5487 ms, 78 rows, 14 cols, 0.0893 ms/col (time log: Query 2: t0: 2.0933 ms, t1: 0.2310 ms, t2: 94.9313 ms, t3: 0.0014 ms, t4: 0.2534 ms, t5: 0.0059 ms, t6: 0.0025 ms)
2011/08/11 06:00:16.656: [00000200][Query::QueryThread] Thread [0x00000200]: Begin
2011/08/11 06:00:16.671: [00000200][Query] Connecting to database: PokerTracker 3 Database
2011/08/11 06:00:16.687: [00000200][Query] Executing SQL (Thread): SELECT (tourney_holdem_hand_summary.id_hand) as "id_hand", (tourney_holdem_hand_summary.id_site) as "id_site", (tourney_holdem_hand_summary.hand_no) as "hand_no", (tourney_holdem_hand_summary.flg_note) as "flg_note", (tourney_holdem_hand_player_statistics.id_holecard) as "id_holecard", (tourney_holdem_hand_summary.date_played) as "date_played", (tourney_holdem_hand_player_statistics.flg_blind_s) as "flg_blind_s", (tourney_holdem_hand_player_statistics.flg_blind_b) as "flg_blind_b", (tourney_holdem_hand_player_statistics.flg_p_ccall) as "flg_p_ccall", (tourney_holdem_hand_player_statistics.amt_won) as "amt_won", (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)) as "amt_bb_won", (tourney_holdem_hand_player_detail.holecard_1) as "id_holecard1", (tourney_holdem_hand_player_detail.holecard_2) as "id_holecard2", (tourney_holdem_hand_player_statistics.flg_f_saw) as "flg_f_saw", (tourney_holdem_hand_summary.card_1) as "id_flop1", (tourney_holdem_hand_summary.card_2) as "id_flop2", (tourney_holdem_hand_summary.card_3) as "id_flop3", (tourney_holdem_hand_summary.card_4) as "id_turn", (tourney_holdem_hand_summary.card_5) as "id_river", (tourney_holdem_hand_player_statistics.id_final_hand) as "id_final_hand", (tourney_holdem_hand_player_statistics.flg_showed) as "flg_showed", (tourney_holdem_hand_player_statistics.enum_folded) as "enum_folded", (player_winner.player_name) as "str_winner", (tourney_holdem_hand_summary.id_win_hand) as "id_win_hand", (tourney_holdem_hand_summary.id_tourney) as "id_tourney" FROM tourney_holdem_hand_player_statistics , tourney_holdem_hand_player_detail, tourney_holdem_hand_summary, player player_winner, tourney_holdem_blinds WHERE (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = 759) AND ((tourney_holdem_hand_summary.id_tourney) in (1)) AND (((tourney_holdem_hand_summary.id_site in (400) )))
2011/08/11 06:00:16.718: [00000200][Query] Query execution time: 7.97447720 ms
2011/08/11 06:00:16.859: [00000200][QueryReportCtrl::Populate] Thread [0x00000200]: Begin
2011/08/11 06:00:16.906: [00000200][QueryReportCtrl] Query 3: Populate: 37.2740 ms, 28 rows, 22 cols, 0.0605 ms/col (time log: Query 3: t0: 2.2268 ms, t1: 0.0983 ms, t2: 31.5437 ms, t3: 0.0014 ms, t4: 0.0017 ms, t5: 3.3465 ms, t6: 0.0036 ms)
2011/08/11 06:00:18.125: [00000200][Query::QueryThread] Thread [0x00000200]: Begin
2011/08/11 06:00:18.140: [00000200][Query] Connecting to database: PokerTracker 3 Database
2011/08/11 06:00:18.156: [00000200][Query] Executing SQL (Thread): SELECT (tourney_holdem_hand_summary.id_hand) as "id_hand", (tourney_holdem_hand_summary.id_site) as "id_site", (tourney_holdem_hand_summary.hand_no) as "hand_no", (tourney_holdem_hand_summary.flg_note) as "flg_note", (tourney_holdem_hand_player_statistics.id_holecard) as "id_holecard", (tourney_holdem_hand_summary.date_played) as "date_played", (tourney_holdem_hand_player_statistics.flg_blind_s) as "flg_blind_s", (tourney_holdem_hand_player_statistics.flg_blind_b) as "flg_blind_b", (tourney_holdem_hand_player_statistics.flg_p_ccall) as "flg_p_ccall", (tourney_holdem_hand_player_statistics.amt_won) as "amt_won", (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)) as "amt_bb_won", (tourney_holdem_hand_player_detail.holecard_1) as "id_holecard1", (tourney_holdem_hand_player_detail.holecard_2) as "id_holecard2", (tourney_holdem_hand_player_statistics.flg_f_saw) as "flg_f_saw", (tourney_holdem_hand_summary.card_1) as "id_flop1", (tourney_holdem_hand_summary.card_2) as "id_flop2", (tourney_holdem_hand_summary.card_3) as "id_flop3", (tourney_holdem_hand_summary.card_4) as "id_turn", (tourney_holdem_hand_summary.card_5) as "id_river", (tourney_holdem_hand_player_statistics.id_final_hand) as "id_final_hand", (tourney_holdem_hand_player_statistics.flg_showed) as "flg_showed", (tourney_holdem_hand_player_statistics.enum_folded) as "enum_folded", (player_winner.player_name) as "str_winner", (tourney_holdem_hand_summary.id_win_hand) as "id_win_hand", (tourney_holdem_hand_summary.id_tourney) as "id_tourney" FROM tourney_holdem_hand_player_statistics , tourney_holdem_hand_player_detail, tourney_holdem_hand_summary, player player_winner, tourney_holdem_blinds WHERE (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = 759) AND ((tourney_holdem_hand_summary.id_tourney) in (1)) AND (((tourney_holdem_hand_summary.id_site in (400) )))
2011/08/11 06:00:18.187: [00000200][Query] Query execution time: 6.42372145 ms
2011/08/11 06:00:18.328: [00000200][QueryReportCtrl::Populate] Thread [0x00000200]: Begin
2011/08/11 06:00:18.375: [00000200][QueryReportCtrl] Query 4: Populate: 32.0429 ms, 28 rows, 22 cols, 0.0520 ms/col (time log: Query 4: t0: 2.4721 ms, t1: 0.0997 ms, t2: 27.2887 ms, t3: 0.0017 ms, t4: 0.0017 ms, t5: 2.1215 ms, t6: 0.0036 ms)
2011/08/11 06:00:19.109: [00000200][Query::QueryThread] Thread [0x00000200]: Begin
2011/08/11 06:00:19.109: [00000200][Query] Connecting to database: PokerTracker 3 Database
2011/08/11 06:00:19.140: [00000200][Query] Executing SQL (Thread): SELECT (tourney_holdem_hand_summary.id_hand) as "id_hand", (tourney_holdem_hand_summary.id_site) as "id_site", (tourney_holdem_hand_summary.hand_no) as "hand_no", (tourney_holdem_hand_summary.flg_note) as "flg_note", (tourney_holdem_hand_player_statistics.id_holecard) as "id_holecard", (tourney_holdem_hand_summary.date_played) as "date_played", (tourney_holdem_hand_player_statistics.flg_blind_s) as "flg_blind_s", (tourney_holdem_hand_player_statistics.flg_blind_b) as "flg_blind_b", (tourney_holdem_hand_player_statistics.flg_p_ccall) as "flg_p_ccall", (tourney_holdem_hand_player_statistics.amt_won) as "amt_won", (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)) as "amt_bb_won", (tourney_holdem_hand_player_detail.holecard_1) as "id_holecard1", (tourney_holdem_hand_player_detail.holecard_2) as "id_holecard2", (tourney_holdem_hand_player_statistics.flg_f_saw) as "flg_f_saw", (tourney_holdem_hand_summary.card_1) as "id_flop1", (tourney_holdem_hand_summary.card_2) as "id_flop2", (tourney_holdem_hand_summary.card_3) as "id_flop3", (tourney_holdem_hand_summary.card_4) as "id_turn", (tourney_holdem_hand_summary.card_5) as "id_river", (tourney_holdem_hand_player_statistics.id_final_hand) as "id_final_hand", (tourney_holdem_hand_player_statistics.flg_showed) as "flg_showed", (tourney_holdem_hand_player_statistics.enum_folded) as "enum_folded", (player_winner.player_name) as "str_winner", (tourney_holdem_hand_summary.id_win_hand) as "id_win_hand", (tourney_holdem_hand_summary.id_tourney) as "id_tourney" FROM tourney_holdem_hand_player_statistics , tourney_holdem_hand_player_detail, tourney_holdem_hand_summary, player player_winner, tourney_holdem_blinds WHERE (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = 759) AND ((tourney_holdem_hand_summary.id_tourney) in (82)) AND (((tourney_holdem_hand_summary.id_site in (400) )))
2011/08/11 06:00:19.156: [00000200][PostgresConnection (Error)] Unable to execute query: SELECT (tourney_holdem_hand_summary.id_hand) as "id_hand", (tourney_holdem_hand_summary.id_site) as "id_site", (tourney_holdem_hand_summary.hand_no) as "hand_no", (tourney_holdem_hand_summary.flg_note) as "flg_note", (tourney_holdem_hand_player_statistics.id_holecard) as "id_holecard", (tourney_holdem_hand_summary.date_played) as "date_played", (tourney_holdem_hand_player_statistics.flg_blind_s) as "flg_blind_s", (tourney_holdem_hand_player_statistics.flg_blind_b) as "flg_blind_b", (tourney_holdem_hand_player_statistics.flg_p_ccall) as "flg_p_ccall", (tourney_holdem_hand_player_statistics.amt_won) as "amt_won", (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)) as "amt_bb_won", (tourney_holdem_hand_player_detail.holecard_1) as "id_holecard1", (tourney_holdem_hand_player_detail.holecard_2) as "id_holecard2", (tourney_holdem_hand_player_statistics.flg_f_saw) as "flg_f_saw", (tourney_holdem_hand_summary.card_1) as "id_flop1", (tourney_holdem_hand_summary.card_2) as "id_flop2", (tourney_holdem_hand_summary.card_3) as "id_flop3", (tourney_holdem_hand_summary.card_4) as "id_turn", (tourney_holdem_hand_summary.card_5) as "id_river", (tourney_holdem_hand_player_statistics.id_final_hand) as "id_final_hand", (tourney_holdem_hand_player_statistics.flg_showed) as "flg_showed", (tourney_holdem_hand_player_statistics.enum_folded) as "enum_folded", (player_winner.player_name) as "str_winner", (tourney_holdem_hand_summary.id_win_hand) as "id_win_hand", (tourney_holdem_hand_summary.id_tourney) as "id_tourney" FROM tourney_holdem_hand_player_statistics , tourney_holdem_hand_player_detail, tourney_holdem_hand_summary, player player_winner, tourney_holdem_blinds WHERE (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = 759) AND ((tourney_holdem_hand_summary.id_tourney) in (82)) AND (((tourney_holdem_hand_summary.id_site in (400) ))) ; Reason: Fatal Error (ERROR: division by zero )
2011/08/11 06:00:19.171: [00000200][Query] Query execution time: 24.99172381 ms
2011/08/11 06:00:21.656: [- Main -][WindowStatsTab] Manually refreshing data...
2011/08/11 06:00:21.750: [- Main -][WindowStatsTab] Refreshing active player: true
2011/08/11 06:00:21.859: [00000200][Query::QueryThread] Thread [0x00000200]: Begin
2011/08/11 06:00:21.875: [00000200][Query] Connecting to database: PokerTracker 3 Database
2011/08/11 06:00:21.890: [00000C90][ThreadPool] Thread [05407020]: Created
2011/08/11 06:00:21.906: [00000200][Query] Executing SQL (Thread): SELECT (tourney_holdem_summary.id_tourney) as "id_tourney", (tourney_holdem_summary.flg_note) as "flg_note", (tourney_holdem_summary.tourney_no) as "tourney_no", (tourney_holdem_results.date_start) as "date_start_player", (tourney_holdem_results.date_end) as "date_end_player", (tourney_holdem_summary.id_site) as "id_site", (tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon) as "amt_buyin_ttl", (tourney_holdem_results.val_finish) as "val_finish", (tourney_holdem_results.amt_won) as "amt_won" FROM tourney_holdem_results, tourney_holdem_summary WHERE (tourney_holdem_results.id_tourney = tourney_holdem_summary.id_tourney) AND (tourney_holdem_results.id_player = 759) AND ((( tourney_holdem_summary.id_site in (400) )))
2011/08/11 06:00:21.937: [00000C90][Query::QueryThread] Thread [0x00000C90]: Begin
2011/08/11 06:00:21.953: [00000200][Query] Query execution time: 2.49500984 ms
2011/08/11 06:00:21.968: [00000C90][Query] Connecting to database: PokerTracker 3 Database
2011/08/11 06:00:21.984: [00000C90][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_summary, tourney_holdem_hand_player_statistics WHERE 1=1 AND tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand AND (((tourney_holdem_hand_summary.id_site in (400) ))) ) ORDER BY player.player_name_search asc
2011/08/11 06:00:22.062: [00000C90][Query] Query execution time: 49.97813968 ms
2011/08/11 06:00:22.078: [00000200][QueryReportCtrl::Populate] Thread [0x00000200]: Begin
2011/08/11 06:00:22.218: [00000200][QueryReportCtrl] Query 5: Populate: 123.5509 ms, 78 rows, 14 cols, 0.1131 ms/col (time log: Query 5: t0: 3.3543 ms, t1: 0.2294 ms, t2: 116.3634 ms, t3: 0.0017 ms, t4: 0.2671 ms, t5: 3.2778 ms, t6: 0.0039 ms)
2011/08/11 06:00:22.281: [00000200][QueryReportCtrl::Populate] Thread [0x00000200]: Begin
2011/08/11 06:00:22.406: [00000200][QueryReportCtrl] Query 6: Populate: 109.3703 ms, 479 rows, 6 cols, 0.0381 ms/col (time log: Query 6: t0: 3.0308 ms, t1: 1.3368 ms, t2: 104.3898 ms, t3: 0.0017 ms, t4: 0.0494 ms, t5: 0.0059 ms, t6: 0.5246 ms)
2011/08/11 06:00:22.718: [00000200][Query::QueryThread] Thread [0x00000200]: Begin
2011/08/11 06:00:22.750: [00000200][Query] Connecting to database: PokerTracker 3 Database
2011/08/11 06:00:22.765: [00000200][Query] Executing SQL (Thread): SELECT (tourney_holdem_hand_summary.id_hand) as "id_hand", (tourney_holdem_hand_summary.id_site) as "id_site", (tourney_holdem_hand_summary.hand_no) as "hand_no", (tourney_holdem_hand_summary.flg_note) as "flg_note", (tourney_holdem_hand_player_statistics.id_holecard) as "id_holecard", (tourney_holdem_hand_summary.date_played) as "date_played", (tourney_holdem_hand_player_statistics.flg_blind_s) as "flg_blind_s", (tourney_holdem_hand_player_statistics.flg_blind_b) as "flg_blind_b", (tourney_holdem_hand_player_statistics.flg_p_ccall) as "flg_p_ccall", (tourney_holdem_hand_player_statistics.amt_won) as "amt_won", (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)) as "amt_bb_won", (tourney_holdem_hand_player_detail.holecard_1) as "id_holecard1", (tourney_holdem_hand_player_detail.holecard_2) as "id_holecard2", (tourney_holdem_hand_player_statistics.flg_f_saw) as "flg_f_saw", (tourney_holdem_hand_summary.card_1) as "id_flop1", (tourney_holdem_hand_summary.card_2) as "id_flop2", (tourney_holdem_hand_summary.card_3) as "id_flop3", (tourney_holdem_hand_summary.card_4) as "id_turn", (tourney_holdem_hand_summary.card_5) as "id_river", (tourney_holdem_hand_player_statistics.id_final_hand) as "id_final_hand", (tourney_holdem_hand_player_statistics.flg_showed) as "flg_showed", (tourney_holdem_hand_player_statistics.enum_folded) as "enum_folded", (player_winner.player_name) as "str_winner", (tourney_holdem_hand_summary.id_win_hand) as "id_win_hand", (tourney_holdem_hand_summary.id_tourney) as "id_tourney" FROM tourney_holdem_hand_player_statistics , tourney_holdem_hand_player_detail, tourney_holdem_hand_summary, player player_winner, tourney_holdem_blinds WHERE (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = 759) AND ((tourney_holdem_hand_summary.id_tourney) in (82)) AND (((tourney_holdem_hand_summary.id_site in (400) )))
2011/08/11 06:00:22.781: [00000200][PostgresConnection (Error)] Unable to execute query: SELECT (tourney_holdem_hand_summary.id_hand) as "id_hand", (tourney_holdem_hand_summary.id_site) as "id_site", (tourney_holdem_hand_summary.hand_no) as "hand_no", (tourney_holdem_hand_summary.flg_note) as "flg_note", (tourney_holdem_hand_player_statistics.id_holecard) as "id_holecard", (tourney_holdem_hand_summary.date_played) as "date_played", (tourney_holdem_hand_player_statistics.flg_blind_s) as "flg_blind_s", (tourney_holdem_hand_player_statistics.flg_blind_b) as "flg_blind_b", (tourney_holdem_hand_player_statistics.flg_p_ccall) as "flg_p_ccall", (tourney_holdem_hand_player_statistics.amt_won) as "amt_won", (tourney_holdem_hand_player_statistics.amt_won * 1.0 / (tourney_holdem_blinds.amt_bb * tourney_holdem_blinds.val_nlpl_mult)) as "amt_bb_won", (tourney_holdem_hand_player_detail.holecard_1) as "id_holecard1", (tourney_holdem_hand_player_detail.holecard_2) as "id_holecard2", (tourney_holdem_hand_player_statistics.flg_f_saw) as "flg_f_saw", (tourney_holdem_hand_summary.card_1) as "id_flop1", (tourney_holdem_hand_summary.card_2) as "id_flop2", (tourney_holdem_hand_summary.card_3) as "id_flop3", (tourney_holdem_hand_summary.card_4) as "id_turn", (tourney_holdem_hand_summary.card_5) as "id_river", (tourney_holdem_hand_player_statistics.id_final_hand) as "id_final_hand", (tourney_holdem_hand_player_statistics.flg_showed) as "flg_showed", (tourney_holdem_hand_player_statistics.enum_folded) as "enum_folded", (player_winner.player_name) as "str_winner", (tourney_holdem_hand_summary.id_win_hand) as "id_win_hand", (tourney_holdem_hand_summary.id_tourney) as "id_tourney" FROM tourney_holdem_hand_player_statistics , tourney_holdem_hand_player_detail, tourney_holdem_hand_summary, player player_winner, tourney_holdem_blinds WHERE (tourney_holdem_hand_player_statistics.id_hand = tourney_holdem_hand_player_detail.id_hand AND tourney_holdem_hand_player_statistics.id_player = tourney_holdem_hand_player_detail.id_player) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_statistics.id_hand) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_summary.id_hand = tourney_holdem_hand_player_detail.id_hand) AND (player_winner.id_player = tourney_holdem_hand_summary.id_winner) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_summary.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = 759) AND ((tourney_holdem_hand_summary.id_tourney) in (82)) AND (((tourney_holdem_hand_summary.id_site in (400) ))) ; Reason: Fatal Error (ERROR: division by zero )
2011/08/11 06:00:22.796: [00000200][Query] Query execution time: 24.37237135 ms
2011/08/11 06:00:30.359: [- Main -][App] Shutting down subsystems...
2011/08/11 06:00:30.390: [- Main -][HudIpcInterface] Closing connection...
2011/08/11 06:00:30.406: [00000CAC][TableManager] Thread [0x00000CAC]: Begin
2011/08/11 06:00:30.437: [00000CAC][TableManager::Entry] Beginning thread.
2011/08/11 06:00:30.453: [00000CAC][HudIpcInterface] Stopping. 1 executed
2011/08/11 06:00:30.468: [00000CAC][TableManager] Thread exiting.
2011/08/11 06:00:30.515: [- Main -][PostgresConnection] [041D5D30] Disconnecting from database: PT3 DB
2011/08/11 06:00:30.546: [- Main -][PostgresConnection] [041E0900] Disconnecting from database: PT3 DB
2011/08/11 06:00:30.562: [- Main -][PostgresConnection] [041E0860] Disconnecting from database: PT3 DB
2011/08/11 06:00:30.578: [- Main -][PostgresConnection] [041E1C60] Disconnecting from database: PT3 DB
2011/08/11 06:00:30.593: [- Main -][ThreadPool] Stopping all threads.
2011/08/11 06:00:30.609: [- Main -][ThreadPool] Stopping Thread [050E9D10]
2011/08/11 06:00:30.625: [- Main -][ThreadPool] Stopping Thread [05407020]
2011/08/11 06:00:30.640: [- Main -][System] Application exiting

Thanks!

[Tunatic]

Oh, by the way, the hands are displayed totally normal, without errors, in the "Enter Hold'em Results" section. There, I can see the hands played in the tournament. I can also see the hands of other players in the tournament. The problem only arises when selecting myself in the player list in the tournament section, and selecting this particular tourney. Here is a screenshot:
http://www.shrani.si/f/1H/uG/4WUXCd9n/pokertracker.png

[Tunatic]

Sorry for spamming in here, but there is another thing I'm interested about. If I buy the PokerTracker 3 Micro Stakes version today, will I still have free access (without paying) to PokerTracker 4, when it gets released?

[WhiteRider]

I'm not sure why, but something has been imported as zero when it shouldn't be.
Try purging that tournament and see if the error goes away. Tutorial: Purging Sessions
Assuming it does, update to v3.11.3 Beta (there have been a few fixes for iPoker since v3.10) and re-import the tournament.
If you get the same error again please compress and attach the original hand history file(s) for the tournament to a Support ticket so that we can investigate.

[WhiteRider]

Sorry for spamming in here, but there is another thing I'm interested about. If I buy the PokerTracker 3 Micro Stakes version today, will I still have free access (without paying) to PokerTracker 4, when it gets released?

Yes - you will have access to the microstakes version of PT4 for free if you buy the microstakes version of PT3 now.

[KingKongMarek]

hi i still use pt3

when i started pt3 today the player statistics wasn´t there. everything in the window is red an it starts with : unable to execute query: and so on...what do i have to do?

[kraada]

Please restart PT3 with the Logging Enabled link on your Start menu, reproduce and report this problem and we'll investigate what the right next step is for you.

[KingKongMarek]

i restarted pt3 the prob was still there,,,than i restarted it with log. enabled and it was gone...funny...thx

[kraada]

If it happens again, please do send us the log.

[gavind]

This has been working good for me so far. I guess there was an fix made on an update then? [ img ]