since a few days, pokertracker didn't work. I importet the hands vom pokerstars automatic und the Tournament History manully as always. Pokertracker start as always, but show no information. I always get an DB-Error, as you can see in log file.
How can i fix this problem?
- Code: Select all
2012/01/15 12:59:09.083: [- Main -][System] PokerTracker v3.11.8 beta
2012/01/15 12:59:09.086: [- Main -][SystemInfo] OS: Windows NT 6.1 (build 7601, Service Pack 1)
2012/01/15 12:59:09.086: [- Main -][SystemInfo] Windows Version: 6.1 build 7601 (platform 2) Service Pack 1
2012/01/15 12:59:09.086: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0407
2012/01/15 12:59:09.087: [- Main -][SystemInfo] Total Logical Processing Units: 4
2012/01/15 12:59:09.087: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 2 PUs: 4 (L1: 2, L2: 2, L3: 1)
2012/01/15 12:59:09.088: [- Main -][SystemInfo] Processor 1: Speed: 2.39 GHz Name: Intel(R) Core(TM) i5 CPU M 520 @ 2.40GHz
2012/01/15 12:59:09.088: [- Main -][SystemInfo] Processor 2: Speed: 2.39 GHz Name: Intel(R) Core(TM) i5 CPU M 520 @ 2.40GHz
2012/01/15 12:59:09.088: [- Main -][SystemInfo] Processor 3: Speed: 2.39 GHz Name: Intel(R) Core(TM) i5 CPU M 520 @ 2.40GHz
2012/01/15 12:59:09.089: [- Main -][SystemInfo] Processor 4: Speed: 2.39 GHz Name: Intel(R) Core(TM) i5 CPU M 520 @ 2.40GHz
2012/01/15 12:59:09.089: [- Main -][SystemInfo] C:\ Disk Space: 228,834 mb total; 118,926 mb used; 109,908 mb free
2012/01/15 12:59:09.115: [- Main -][SystemInfo] Physical Memory: 4,096 mb (4,096 mb available) Virtual Memory: 2,048 mb (1,932 mb available) Page File: 4,096 mb (4,096 mb available)
2012/01/15 12:59:09.115: [- Main -][System Info] Video[0]: ATI Mobility Radeon HD 4670 (\\.\DISPLAY1)
2012/01/15 12:59:09.116: [- Main -][System Info] Video[1]: ATI Mobility Radeon HD 4670 (\\.\DISPLAY2)
2012/01/15 12:59:09.122: [- Main -][SystemInfo] Adobe Flash: 11.1.102.55 Plugin: 11.1.102.55 AIR: Error: Adobe AIR not installed
2012/01/15 12:59:09.139: [- Main -][SystemInfo] Configuration: [WindowInfo]\nMainMaximized=Y\nMainPos=1931,42\nMainSize=1015,740\n\n\n[General]\nLogging=Y\nBuildDate=2012/01/11\nRegistrationCode=*** REG CODE REMOVED ***\nBestHudPerformance=Y\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\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=N\nAutoStart.2100=N\nAutoStart.1100=N\nAutoStart.600=N\nAutoStart.900=N\nAutoStart.200=N\nAutoStart.100=Y\nAutoStart.2200=N\nAutoStart.1800=N\nAutoStart.2400=N\nForceSetupWizard=N\nIncludeSubDirectories=Y\nCloseOnCompletion=N\nStartHud=Y\nDetectOnCompletion=Y\nOverwriteTournamentSummary=N\nPriority=2\n\n\n\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=dbpass\nDB1.Name=PT3\nDB1.Default=Y\nDB1.Type=postgres\nDB1.Postgres.Database=PT3_2011_09_22_105008\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\n\n\n[ReportInfo]\n\n\n[HandReplayer]\nShowHeroCards=Y\nShowKnownCards=Y\nShowHud=Y\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.Everest]\nHandHistoryDirectories=-\n[Site.Everleaf]\nHandHistoryDirectories=-\n[Site.iPoker]\nHandHistoryDirectories=-\n[Site.Merge]\nHandHistoryDirectories=-\n[Site.MicroGaming]\nHandHistoryDatabases=-\n[Site.OnGame]\nHandHistoryDirectories=-;\n[Site.Pacific]\nHandHistoryDirectories=-\n[Site.Party]\nHandHistoryDirectories=-\n[Site.YatahayNetwork]\nHandHistoryDirectory=-\n[Tabs]\nLast:WindowMain=1\nLast:WindowImport=0\nLast:WindowStats:Holdem=1\nLast:WindowStatsTab:holdem-cash=8\nLast:WindowStatsTab:holdem-tourney=8\nLast:WindowStats:Omaha=1\nLast:WindowStatsTab:omaha-cash=8\nLast:WindowStatsTab:omaha-tourney=8\nShow:Main:TableTracker=N\n[TableTracker]\nGameIndex=0\nHideTablesNoStats=N\n[Directories]\nManualImportFile=C:\Users\user\Desktop\*\nManualImportDirectory=C:\Users\user\Desktop\ps\nPostgresBin=\Program Files (x86)\PostgreSQL\8.3\bin\nBackupDirectory=C:\n[Messages]\nOptOut:1b9775a152c0353de5fd74d94ea1f85c=Y\nOptOut:218b96d1c4038f78923963117951eceb=Y\nOptOut:1ab4c8e72d3d58a327deeadb1bbc88a9=Y\nOptOut:99f7ba05d2216ef45d6109c13c89b4f4=Y\n[Hud]\nNotesSize=450,152\nMuckedCards.Display=Y\nMuckedCards.Length=5\nMuckedCards.Translucency=64\nNotes.Translucency=90\nMinHands=50\nCurrentLimit=Y\nCurrentBlind=N\nSessionStats=Y\nLastXHands=0\nRefreshRates=0,25,1|25,100,5|100,200,10|200,100000,20|\n[Site.Winamax]\nPreferred=3\nHeroName=tangle76\n
2012/01/15 12:59:27.276: [- Main -][System] Getting String: 1058-24FB-6D3D-BEA6-CEAF-3918-F810-3CC7
2012/01/15 12:59:27.292: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/regcheck.php
2012/01/15 12:59:27.293: [- Main -][wxThreadedRead] Starting read thread ...
2012/01/15 12:59:27.293: [00001870][ConnectorReadThread] Thread [0x00001870]: Begin
2012/01/15 12:59:27.293: [00001870][ConnectorReadThread::Entry] Beginning thread.
2012/01/15 12:59:27.295: [00001870][ConnectorReadThread] Creating socket...
2012/01/15 12:59:27.296: [00001870][ConnectorReadThread] DNS lookup...
2012/01/15 12:59:27.312: [00001870][ConnectorReadThread] Socket connect...
2012/01/15 12:59:28.113: [00001870][ConnectorReadThread] Sending request...
2012/01/15 12:59:28.445: [00001870][ConnectorReadThread] Reading response...
2012/01/15 12:59:28.448: [00001870][ConnectorReadThread] Read complete.
2012/01/15 12:59:28.449: [00001870][ConnectorReadThread] Returning.
2012/01/15 12:59:28.545: [- Main -][wxThreadedRead] Getting data ...
2012/01/15 12:59:28.567: [- Main -][Registration] License written to C:\Program Files (x86)\PokerTracker 3/Data/Config/PokerTracker.lic
2012/01/15 12:59:28.574: [- Main -][System] Registered: true
2012/01/15 12:59:28.576: [- Main -][System] HelpMessages v1.01 is up to date.
2012/01/15 12:59:28.577: [- Main -][System] FullTilt v1.15 is up to date.
2012/01/15 12:59:28.579: [- Main -][System] 888 v1.1 is up to date.
2012/01/15 12:59:28.580: [- Main -][System] Currencies v1.00 is up to date.
2012/01/15 12:59:28.596: [- Main -][System] TournamentDetect v1.72 is up to date.
2012/01/15 12:59:28.609: [- Main -][System] TRP Status: TH: false; TO: false; RH: true; RO: true; PH: true; PO: true;
2012/01/15 12:59:28.624: [- Main -][WindowSplash] Beginning load process
2012/01/15 12:59:28.628: [00000590][WindowSplash::Worker::Entry] Beginning thread.
2012/01/15 12:59:28.629: [00000590][WindowSplash::Worker] Thread [0x00000590]: Begin
2012/01/15 12:59:28.634: [00000590][CurrencyManager] Rates are 0 days old
2012/01/15 12:59:28.634: [00000590][QueryManager] Loading queries
2012/01/15 12:59:28.636: [00000590][StatManager] CacheRebuildPercent: 90.0%
2012/01/15 12:59:28.637: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Aliases.xml.pte
2012/01/15 12:59:28.643: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Hand-Detail.xml.pte
2012/01/15 12:59:28.675: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Hand-Summary.xml.pte
2012/01/15 12:59:28.689: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Notes.xml.pte
2012/01/15 12:59:28.693: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Hand-Detail.xml.pte
2012/01/15 12:59:28.725: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Hand-Summary.xml.pte
2012/01/15 12:59:28.739: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Players.xml.pte
2012/01/15 12:59:28.746: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-BBWon.xml.pte
2012/01/15 12:59:28.760: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-EV-AllinPerformance.xml.pte
2012/01/15 12:59:28.766: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-MoneyWon.xml.pte
2012/01/15 12:59:28.779: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Graphs-ShowdownNoShowdown.xml.pte
2012/01/15 12:59:28.793: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Player-Details.xml.pte
2012/01/15 12:59:28.795: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Players.xml.pte
2012/01/15 12:59:28.805: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-Hands-Graph.xml.pte
2012/01/15 12:59:28.816: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Sessions-More-Details.xml.pte
2012/01/15 12:59:28.817: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Summary-Site.xml.pte
2012/01/15 12:59:28.825: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer-Detail.xml.pte
2012/01/15 12:59:28.869: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\vsPlayer.xml.pte
2012/01/15 12:59:28.893: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph-Month.xml.pte
2012/01/15 12:59:28.896: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Cash\Winnings-Graph.xml.pte
2012/01/15 12:59:28.899: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Graphs-MoneyWon.xml.pte
2012/01/15 12:59:28.912: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Player-Details.xml.pte
2012/01/15 12:59:28.915: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Players.xml.pte
2012/01/15 12:59:28.923: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Summary-Site.xml.pte
2012/01/15 12:59:28.931: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\Tournaments-Hands-Graph.xml.pte
2012/01/15 12:59:28.941: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer-Detail.xml.pte
2012/01/15 12:59:28.995: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Holdem-Tourney\vsPlayer.xml.pte
2012/01/15 12:59:29.026: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-BBWon.xml.pte
2012/01/15 12:59:29.041: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-EV-AllinPerformance.xml.pte
2012/01/15 12:59:29.048: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-MoneyWon.xml.pte
2012/01/15 12:59:29.062: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Graphs-ShowdownNoShowdown.xml.pte
2012/01/15 12:59:29.077: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Player-Details.xml.pte
2012/01/15 12:59:29.078: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Players.xml.pte
2012/01/15 12:59:29.086: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-Hands-Graph.xml.pte
2012/01/15 12:59:29.098: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Sessions-More-Details.xml.pte
2012/01/15 12:59:29.100: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Summary-Site.xml.pte
2012/01/15 12:59:29.108: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer-Detail.xml.pte
2012/01/15 12:59:29.156: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\vsPlayer.xml.pte
2012/01/15 12:59:29.180: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph-Month.xml.pte
2012/01/15 12:59:29.184: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Cash\Winnings-Graph.xml.pte
2012/01/15 12:59:29.188: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Graphs-MoneyWon.xml.pte
2012/01/15 12:59:29.200: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Player-Details.xml.pte
2012/01/15 12:59:29.201: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Players.xml.pte
2012/01/15 12:59:29.208: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Summary-Site.xml.pte
2012/01/15 12:59:29.216: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\Tournaments-Hands-Graph.xml.pte
2012/01/15 12:59:29.227: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer-Detail.xml.pte
2012/01/15 12:59:29.283: [00000590][Query] Loading query file: C:\Program Files (x86)\PokerTracker 3/Data/Queries\Omaha-Tourney\vsPlayer.xml.pte
2012/01/15 12:59:29.315: [00000590][QueryManager] Queries loaded.
2012/01/15 12:59:29.315: [00000590][StatManager] Loading stats and reports...
2012/01/15 12:59:30.514: [00000590][StatManager] Stats and reports loaded. Load: 1.20s, Custom: 0.8875ms, Dupe: 0.0205ms
2012/01/15 12:59:30.515: [00000590][FilterManager] Loading filters...
2012/01/15 12:59:32.854: [00000590][FilterManager] Filters loaded.
2012/01/15 12:59:32.855: [00000590][LayoutManager] Loading layouts...
2012/01/15 12:59:32.970: [00000590][StatManager] Loading stats and reports...
2012/01/15 12:59:34.171: [00000590][StatManager] Stats and reports loaded. Load: 1.20s, Custom: 1ms, Dupe: 0.0205ms
2012/01/15 12:59:34.171: [00000590][LayoutManager] Layouts loaded.
2012/01/15 12:59:34.175: [00000590][PostgresConnection] Connecting to database: PT3_2011_09_22_105008
2012/01/15 12:59:34.238: [00000590][PostgresConnection] [0652E030] Successfully connected to: PT3_2011_09_22_105008 [0x0652fc50] (ver = 80309, autotune = N)
2012/01/15 12:59:34.252: [00000590][ConnectionManager] Database Version: 300049
2012/01/15 12:59:34.264: [00000590][PostgresConnection] Connecting to database: PT3_2011_09_22_105008
2012/01/15 12:59:34.321: [00000590][PostgresConnection] [085FCAC0] Successfully connected to: PT3_2011_09_22_105008 [0x085fc4f0] (ver = 80309, autotune = N)
2012/01/15 12:59:34.327: [00000590][PostgresConnection] Connecting to database: PT3_2011_09_22_105008
2012/01/15 12:59:34.381: [00000590][PostgresConnection] [085FCA40] Successfully connected to: PT3_2011_09_22_105008 [0x085fddd0] (ver = 80309, autotune = N)
2012/01/15 12:59:34.388: [00000590][PostgresConnection] Connecting to database: PT3_2011_09_22_105008
2012/01/15 12:59:34.443: [00000590][PostgresConnection] [085FC2E0] Successfully connected to: PT3_2011_09_22_105008 [0x085fd530] (ver = 80309, autotune = N)
2012/01/15 12:59:34.449: [00000590][WindowSplash::Worker::Entry] Ending thread.
2012/01/15 12:59:34.449: [- Main -][WindowSplash::winNotify] Notified of worker completion.
2012/01/15 12:59:34.449: [- Main -][WindowSplash::checkProgress] Worker complete.
2012/01/15 12:59:34.832: [- Main -][EverleafOptions] Found INI File:
2012/01/15 12:59:35.281: [- Main -][PokerStarsOptions] Found INI File: C:\Users\user\AppData\Local\PokerStars\user.ini
2012/01/15 12:59:35.309: [- Main -][PokerStars] Install Path: C:\Program Files (x86)\PokerStars
2012/01/15 12:59:35.353: [- Main -][WPEXOptions] Unable to access registry key
2012/01/15 12:59:35.353: [- Main -][WPEXOptions] Found INI File:
2012/01/15 12:59:35.433: [- Main -][Players] Buddies:
2012/01/15 12:59:35.434: [- Main -][Players] 0 buddies found
2012/01/15 12:59:39.001: [- Main -][WindowStatsTab] Refreshing active player: false
2012/01/15 12:59:39.089: [- Main -][WindowStatsTab] Refreshing active player: false
2012/01/15 12:59:39.166: [- Main -][WindowStatsTab] Refreshing active player: false
2012/01/15 12:59:39.230: [- Main -][WindowStatsTab] Refreshing active player: false
2012/01/15 12:59:39.713: [- Main -][WindowMain] Database: PT3 Size: 1179 MB
2012/01/15 12:59:39.733: [- Main -][WindowMain] Database: PT3 Cache Status: Holdem: 100% Holdem Tourney: 100% Omaha: 100%
2012/01/15 12:59:39.766: [00001548][ThreadPool] Thread [09284CE0]: Created
2012/01/15 12:59:39.766: [00001548][Query::QueryThread] Thread [0x00001548]: Begin
2012/01/15 12:59:39.766: [00001548][Query] Connecting to database: PT3
2012/01/15 12:59:39.768: [00001548][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 (((date_trunc('day', (tourney_holdem_hand_player_statistics.date_played + INTERVAL '1 HOURS')) = date_trunc('day', (now() + INTERVAL '0 HOURS'))))AND ((tourney_holdem_hand_player_statistics.date_played >= '2012/01/11 23:00:00'))) ) ORDER BY player.player_name_search asc
2012/01/15 12:59:39.774: [00001548][Query] Query execution time: 5.50190148 ms
2012/01/15 12:59:39.967: [00001548][QueryReportCtrl::Populate] Thread [0x00001548]: Begin
2012/01/15 12:59:39.970: [00001548][QueryReportCtrl] Query 1: Populate: 2.8282 ms, 0 rows, 6 cols, 0.0000 ms/col (time log: Query 1: t0: 2.6793 ms, t1: 0.0103 ms, t2: 0.0086 ms, t3: 0.0004 ms, t4: 0.0932 ms, t5: 0.0056 ms, t6: 0.0009 ms)
2012/01/15 12:59:46.291: [00001548][Query::QueryThread] Thread [0x00001548]: Begin
2012/01/15 12:59:46.291: [00001548][Query] Connecting to database: PT3
2012/01/15 12:59:46.292: [000006EC][ThreadPool] Thread [09293060]: Created
2012/01/15 12:59:46.293: [000006EC][Query::QueryThread] Thread [0x000006EC]: Begin
2012/01/15 12:59:46.293: [00001548][Query] Executing SQL (Thread): SELECT (sum(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_statistics.id_tourney) as "__gph__id_tourney", (tourney_holdem_summary.date_start) as "__gph__tourney_date" FROM tourney_holdem_hand_player_statistics , tourney_holdem_summary, tourney_holdem_blinds WHERE (tourney_holdem_hand_player_statistics.id_tourney = tourney_holdem_summary.id_tourney) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = {1}) GROUP BY (tourney_holdem_hand_player_statistics.id_tourney), (tourney_holdem_summary.date_start) ORDER BY (tourney_holdem_summary.date_start) asc, (tourney_holdem_hand_player_statistics.id_tourney) asc
2012/01/15 12:59:46.293: [000006EC][Query] Connecting to database: PT3
2012/01/15 12:59:46.295: [00001548][PostgresConnection (Error)] Unable to execute query: SELECT (sum(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_statistics.id_tourney) as "__gph__id_tourney", (tourney_holdem_summary.date_start) as "__gph__tourney_date" FROM tourney_holdem_hand_player_statistics , tourney_holdem_summary, tourney_holdem_blinds WHERE (tourney_holdem_hand_player_statistics.id_tourney = tourney_holdem_summary.id_tourney) AND (tourney_holdem_blinds.id_blinds = tourney_holdem_hand_player_statistics.id_blinds) AND (tourney_holdem_hand_player_statistics.id_player = {1}) GROUP BY (tourney_holdem_hand_player_statistics.id_tourney), (tourney_holdem_summary.date_start) ORDER BY (tourney_holdem_summary.date_start) asc, (tourney_holdem_hand_player_statistics.id_tourney) asc; Reason: Fatal Error (ERROR: syntax error at or near "{" LINE 1: ...tourney_holdem_hand_player_statistics.id_player = {1}) GROU... ^ )
2012/01/15 12:59:46.295: [00001548][Query] Query execution time: 1.55779563 ms
2012/01/15 12:59:46.296: [000006EC][Query] Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.player_name) as "str_player_name", (count(tourney_holdem_summary.id_tourney)) as "cnt_tourneys", (CASE WHEN ((count(tourney_holdem_summary.id_tourney)) ) <> 0 THEN (( ((sum(tourney_holdem_results.amt_won))-(sum(tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon)))* 1.0 )/((count(tourney_holdem_summary.id_tourney)) )) ELSE 0 END) as "amt_won_per", (sum(tourney_holdem_results.amt_won)) as "amt_won", (sum(tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon)) as "amt_buyin_ttl", (count( distinct date_trunc('day', (tourney_holdem_results.date_start + INTERVAL '1 HOURS')) )) as "cnt_days_played", (CASE WHEN ( (count( distinct date_trunc('day', (tourney_holdem_results.date_start + INTERVAL '1 HOURS')) )) ) <> 0 THEN (( (sum(tourney_holdem_results.amt_won))-(sum(tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon)) * 1.0 )/( (count( distinct date_trunc('day', (tourney_holdem_results.date_start + INTERVAL '1 HOURS')) )) )) ELSE 0 END) as "net_per_day" FROM tourney_holdem_summary, tourney_holdem_results, player WHERE (tourney_holdem_results.id_tourney = tourney_holdem_summary.id_tourney) AND (player.id_player = tourney_holdem_results.id_player) AND (tourney_holdem_results.id_player = {1}) GROUP BY (player.player_name_search), (player.player_name)
2012/01/15 12:59:46.297: [000006EC][PostgresConnection (Error)] Unable to execute query: SELECT (player.player_name_search) as "str_player_name_search", (player.player_name) as "str_player_name", (count(tourney_holdem_summary.id_tourney)) as "cnt_tourneys", (CASE WHEN ((count(tourney_holdem_summary.id_tourney)) ) <> 0 THEN (( ((sum(tourney_holdem_results.amt_won))-(sum(tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon)))* 1.0 )/((count(tourney_holdem_summary.id_tourney)) )) ELSE 0 END) as "amt_won_per", (sum(tourney_holdem_results.amt_won)) as "amt_won", (sum(tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon)) as "amt_buyin_ttl", (count( distinct date_trunc('day', (tourney_holdem_results.date_start + INTERVAL '1 HOURS')) )) as "cnt_days_played", (CASE WHEN ( (count( distinct date_trunc('day', (tourney_holdem_results.date_start + INTERVAL '1 HOURS')) )) ) <> 0 THEN (( (sum(tourney_holdem_results.amt_won))-(sum(tourney_holdem_summary.amt_buyin + tourney_holdem_summary.amt_rake + tourney_holdem_results.amt_rebuy + tourney_holdem_results.amt_addon)) * 1.0 )/( (count( distinct date_trunc('day', (tourney_holdem_results.date_start + INTERVAL '1 HOURS')) )) )) ELSE 0 END) as "net_per_day" FROM tourney_holdem_summary, tourney_holdem_results, player WHERE (tourney_holdem_results.id_tourney = tourney_holdem_summary.id_tourney) AND (player.id_player = tourney_holdem_results.id_player) AND (tourney_holdem_results.id_player = {1}) GROUP BY (player.player_name_search), (player.player_name) ; Reason: Fatal Error (ERROR: syntax error at or near "{" LINE 1: ...player) AND (tourney_holdem_results.id_player = {1}) GROU... ^ )
2012/01/15 12:59:46.297: [000006EC][Query] Query execution time: 1.08985812 ms
