tourney summaries messed up

[neill0021]

hmm help?

[neill0021]

also doesn't show hero's stats in cash games

[WhiteRider]

Does removing the "Today" filter help?
If not, try rebuilding your cache via Database > Database Management.

[neill0021]

Still doesn't work. Its the same screen for cash games and HUD popup isn't working properly for other players.

[kraada]

Please restart PT4 using the logging enabled link on your Start Menu, reproduce this problem and then report it via our support system with the log file - that will help us figure out what is going on here and get it fixed for you. You can find that file by clicking File --> Show User Data Folder in the main PT4 window - the file we need is the text file called PokerTracker4 that is in that folder. That will contain the full text of the error message so that we can investigate exactly what is causing it.

[neill0021]

I created a support ticket yesterday and uploaded the pic and the support file today.

2013/05/24 12:26:48.888 [00000]: [- Main -][System] PokerTracker v4.08.1
2013/05/24 12:26:48.888 [00000]: [- Main -][SystemInfo] OS: Windows 7 (build 7601, Service Pack 1), 64-bit edition
2013/05/24 12:26:48.888 [00000]: [- Main -][SystemInfo] Windows Version: 6.1 build 7601 (platform 2) Service Pack 1
2013/05/24 12:26:48.888 [00000]: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0409
2013/05/24 12:26:48.888 [00000]: [- Main -][SystemInfo] Total Logical Processing Units: 4
2013/05/24 12:26:48.888 [00001]: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 2 PUs: 4 (L1: 2, L2: 2, L3: 1)
2013/05/24 12:26:48.888 [00000]: [- Main -][SystemInfo] Processor 1: Speed: 1.60 GHz Name: Intel(R) Core(TM) i5-2467M CPU @ 1.60GHz
2013/05/24 12:26:48.888 [00000]: [- Main -][SystemInfo] Processor 2: Speed: 1.60 GHz Name: Intel(R) Core(TM) i5-2467M CPU @ 1.60GHz
2013/05/24 12:26:48.888 [00000]: [- Main -][SystemInfo] Processor 3: Speed: 1.60 GHz Name: Intel(R) Core(TM) i5-2467M CPU @ 1.60GHz
2013/05/24 12:26:48.888 [00001]: [- Main -][SystemInfo] Processor 4: Speed: 1.60 GHz Name: Intel(R) Core(TM) i5-2467M CPU @ 1.60GHz
2013/05/24 12:26:48.888 [00000]: [- Main -][SystemInfo] C:\ Disk Space: 99,262 mb total; 79,114 mb used; 20,148 mb free
2013/05/24 12:26:48.888 [00000]: [- Main -][SystemInfo] D:\ Disk Space: 18,444 mb total; 16,430 mb used; 2,014 mb free
2013/05/24 12:26:48.888 [00001]: [- Main -][SystemInfo] Physical Memory: 4,041 mb (1,569 mb available) Virtual Memory: 2,047 mb (2,047 mb available) Page File: 8,081 mb (5,320 mb available)
2013/05/24 12:26:48.888 [00000]: [- Main -][System Info] Video[0]: Intel(R) HD Graphics Family (\\.\DISPLAY1)
2013/05/24 12:26:48.908 [00017]: [- Main -][SystemInfo] Adobe Flash: 11.5.502.146 Plugin: 11.7.700.202 AIR: Error: Adobe AIR not installed
2013/05/24 12:26:48.918 [00005]: [- Main -][SystemInfo] Configuration: [General]\nRunCount=575\nBuildDate=2013/05/17\nFirstRun=N\nLogging=Y\nRegistrationCode=*** REG CODE REMOVED ***\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=dbpass\nDB1.Name=PokerTracker 4 DB\nDB1.Default=Y\nDB1.Type=postgres\nDB1.Postgres.Database=PT4_2013_01_28_121545\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\n[Site.Merge]\nHandHistoryDirectories=C:\Program Files (x86)\BlackChipPoker\history;C:\Program Files (x86)\CarbonPoker\history;\nPreferred.9=3\nPreferred.6=4\n[Site.CakeNetwork]\nPreferred.9=5\nPreferred.6=3\nHandHistoryDirectories=C:\Users\Neill\AppData\Local\CPN\Cake\Hand History;C:\Users\Neill\AppData\Local\CPN\INTERTOPS\Hand History;C:\Users\Neill\AppData\Local\CPN\Juicy\Hand History;C:\Users\Neill\AppData\Local\CPN\LOCKPOKER\Hand History;\n[Players]\nActiveName=CoconutBrah\nActiveSiteID=100\nPrevious.1.SiteID=100\nPrevious.1.Name=Danglez123\nPrevious.2.SiteID=200\nPrevious.2.Name=FatWheels\nPrevious.3.SiteID=300\nPrevious.3.Name=CoconutBrah\nPrevious.4.SiteID=100\nPrevious.4.Name=mishun\nPrevious.5.SiteID=200\nPrevious.5.Name=buzan4664\nPrevious.6.SiteID=100\nPrevious.6.Name=Krocodil1986\nPrevious.7.SiteID=100\nPrevious.7.Name=GENOK777\nPrevious.8.SiteID=100\nPrevious.8.Name=elymint\nPrevious.9.SiteID=1200\nPrevious.9.Name=FatWheels\nPrevious.10.SiteID=100\nPrevious.10.Name=smallon2012\nPrevious.11.SiteID=100\nPrevious.11.Name=manut0r\nPrevious.12.SiteID=100\nPrevious.12.Name=nanbuxian\nPrevious.13.SiteID=100\nPrevious.13.Name=FiltrMan\nPrevious.14.SiteID=100\nPrevious.14.Name=Nick2thekey\nPrevious.15.SiteID=100\nPrevious.15.Name=truckie paul\nPrevious.16.SiteID=100\nPrevious.16.Name=HULKMULK\nPrevious.17.SiteID=100\nPrevious.17.Name=snowking_85\nPrevious.18.SiteID=100\nPrevious.18.Name=Rich Peng\nPrevious.19.SiteID=100\nPrevious.19.Name=*krasav4ik*\nPrevious.20.SiteID=100\nPrevious.20.Name=ChumintheH2O\nPrevious.21.SiteID=100\nPrevious.21.Name=A.Tricarico\nPrevious.22.SiteID=100\nPrevious.22.Name=ursus123\nPrevious.23.SiteID=100\nPrevious.23.Name=Sublime8700\nPrevious.24.SiteID=100\nPrevious.24.Name=TheRYC\nPrevious.25.SiteID=100\nPrevious.25.Name=boerni21\nPrevious.26.SiteID=200\nPrevious.26.Name=pittlhammer\nPrevious.27.SiteID=100\nPrevious.27.Name=LiftGrind\nPrevious.28.SiteID=1200\nPrevious.28.Name=mongiiiiii\nPrevious.29.SiteID=1200\nPrevious.29.Name=123_barrel\n[HudMenu]\nLocked=N\n[Hud]\nMuckedCards.Display=Y\nMuckedCards.Length=5\nMuckedCards.Translucency=20\nLowOpacityTranslucency=90\nUseNoteColorOutline=Y\nUseTranslucency=Y\nVectorScaling=Y\nMinHands=1\nCurrentLimit=N\nCurrentBetType=Y\nSessionStats=Y\nShowEquityPercentages=Y\nLastXHands=0\nPlayerRanges=2,2|3,6|7,10|\nTourneyStackFilter.0=-1\nTourneyStackFilter.1=-1\nTourneyStackFilter.2=-1\nTourneyStackFilter.3=-1\nTourneyStackFilter.4=-1\nTourneyStackFilter.5=-1\nNotesMaxLines=10\n[Import]\nMoveProcessedFiles=Y\nMoveProcessedFilesDirectory=C:\Users\Neill\AppData\Local\PokerTracker 4\Processed\nMoveProcessedFilesBySite=Y\nMoveProcessedFilesByDate=Y\nImportObservedHands=Y\nAutoTreatAs=Y\nOverwriteTournamentSummary=N\nEquity:HeroDeadCards=Y\nEquity:PreflopEnumeration=Hero\nAutoStart.900=N\nHidden.900=N\nAutoStart.2600=N\nHidden.2600=N\nAutoStart.1400=N\nHidden.1400=N\nAutoStart.1300=N\nHidden.1300=N\nAutoStart.800=N\nHidden.800=N\nAutoStart.2500=N\nHidden.2500=N\nAutoStart.500=N\nHidden.500=N\nAutoStart.2300=N\nHidden.2300=N\nAutoStart.300=Y\nHidden.300=N\nAutoStart.1000=N\nHidden.1000=N\nAutoStart.700=N\nHidden.700=N\nAutoStart.400=N\nHidden.400=N\nAutoStart.2100=Y\nHidden.2100=N\nAutoStart.1100=N\nHidden.1100=N\nAutoStart.600=N\nHidden.600=N\nAutoStart.200=Y\nHidden.200=N\nAutoStart.100=Y\nHidden.100=N\nAutoStart.1200=Y\nHidden.1200=N\nAutoStart.2200=N\nHidden.2200=N\nAutoStart.2400=N\nHidden.2400=N\nEmail:Pop:Port=110\nEmail:Pop:Password=^E:\nEmail:Pop:UseSSL=N\nTournamentDetectPostSummary=N\nPromptOnCloseDuringAutoImport=N\n[Site.Pacific]\nPreferred.9=3\n[Replayer]\nSpeed=7\nShowHeroLifetimeStats=Y\n[Site.PokerStars]\nZoomHud=Y\n[Directories]\nPostgresBin=C:/Program Files (x86)/PostgreSQL/8.3/bin/\n[HandFormatting]\nDisplayChipsInBB=N\nDisplayMaskPlayerNames=N\nHideResults=N\n[Site.EnetNetwork]\nHandHistoryDirectory=-\n[Site.OnGame]\nHandHistoryDirectories=-\n[Site.MicroGaming]\nHandHistoryDatabases=-\n[TournamentDetect]\nCheckBoxProtectType=N\nCheckBoxSavePosPrize=Y\nCheckBoxSaveType=Y\nDefaultTables=0\nDefaultMinsPerRound=10\nUnknownFinishRefundBuyin=N\nUnknownFinishICMAward=N\nNetAdjAllPlayers=Y\nNetAdjActivePlayerDecisions=N\n[Site.FullTilt]\nHandHistoryDirectory=C:\Users\Neill\Documents\HandHistory\n[Video]\nshowChipsInBB=N\nshowHeroHoleCards=Y\nshowKnownHands=N\nmaskHero=Y\nmaskVillain=Y\nspeed=15\n[Site.Party]\nPreferred.6=4\nHandHistoryDirectories=C:\Programs\PartyGaming\PartyPoker\HandHistory;\nPreferred.9=5\nPreferred.10=6\n[HudGui]\nNotesWindowX=446\nNotesWindowY=722\n[CrashReporter]\nEmail=neillclark0021@gmail.com\n
2013/05/24 12:26:48.918 [00001]: [- Main -][PostgresService] Install: postgresql-x64-9.0 (64bit)
2013/05/24 12:26:48.918 [00005]: [- Main -][System] diffInDaysNow = 1604
2013/05/24 12:26:48.988 [00065]: [- Main -][Registration] counter1 = 0xba52d644
2013/05/24 12:26:48.988 [00000]: [- Main -][Registration] counter2 = 0x00000000
2013/05/24 12:26:49.018 [00033]: [- Main -][Registration] counter1 = 0xba52d644
2013/05/24 12:26:49.018 [00000]: [- Main -][Registration] counter2 = 0x00000000
2013/05/24 12:26:49.028 [00008]: [- Main -][System] Getting String: 1058-D312-7BD9-BDBA-B2B9-9CFF-7808-2375
2013/05/24 12:26:49.078 [00051]: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/regcheck.php
2013/05/24 12:26:52.388 [03312]: [- Main -][Registration] License written to C:\Users\Neill\AppData\Local\PokerTracker 4\Config/PokerTracker.lic
2013/05/24 12:26:52.398 [00010]: [- Main -][System] Registered: true
2013/05/24 12:26:52.398 [00001]: [- Main -][System] Currencies v1.04 is up to date.
2013/05/24 12:26:52.448 [00049]: [- Main -][System] TournamentDetect v2.86 is up to date.
2013/05/24 12:26:52.448 [00000]: [- Main -][System] FullTilt v1.23 is up to date.
2013/05/24 12:26:52.448 [00000]: [- Main -][System] Party v1.02 is up to date.
2013/05/24 12:26:52.448 [00001]: [- Main -][System] iPoker v1.02 is up to date.
2013/05/24 12:26:52.458 [00002]: [- Main -][System] Files up to date
2013/05/24 12:26:52.458 [00004]: [- Main -][System] TRP Status: TH: false; TO: false; RH: true; RO: false; PH: true; PO: false;
2013/05/24 12:26:52.458 [00001]: [00002764][ThreadPool] Thread [07546A08]: Created
2013/05/24 12:26:52.458 [00000]: [000027C0][ThreadPool] Thread [07546C18]: Created
2013/05/24 12:26:52.458 [00000]: [000026E8][ThreadPool] Thread [07586CA8]: Created
2013/05/24 12:26:52.458 [00000]: [000025C8][ThreadPool] Thread [07546AB8]: Created
2013/05/24 12:26:52.478 [00023]: [- Main -][WindowSplash] Checking installation
2013/05/24 12:26:52.488 [00001]: [- Main -][PostgresService] Failed to start service
2013/05/24 12:26:52.488 [00004]: [- Main -][PostgresConnection] Connecting to database: postgres
2013/05/24 12:26:52.688 [00200]: [- Main -][PostgresConnection] [0x0018f77c] Successfully connected to: postgres [075856e8] (PostgreSQL version 90011)
2013/05/24 12:26:52.688 [00001]: [- Main -][PostgresConnection] [0x0018f77c] Disconnecting from database: postgres
2013/05/24 12:26:52.688 [00002]: [- Main -][PostgresConnection] Connecting to database: postgres
2013/05/24 12:26:52.878 [00184]: [- Main -][PostgresConnection] [0x0018f2b4] Successfully connected to: postgres [075853f8] (PostgreSQL version 90011)
2013/05/24 12:26:52.878 [00000]: [- Main -][PostgresConnection] [0x0018f2b4] Disconnecting from database: postgres
2013/05/24 12:26:52.878 [00005]: [000026C8][WindowSplash::Worker::Entry] Beginning thread.
2013/05/24 12:26:52.878 [00000]: [000026C8][WindowSplash::Worker] Thread [0x000026C8]: Begin
2013/05/24 12:26:52.958 [00078]: [000026C8][StatManager] Loading stats and reports...
2013/05/24 12:26:53.098 [00142]: [000026C8][StatManager] Stats and reports loaded. Load: 141ms, Custom: 1ms, Dupe: 0.0180ms
2013/05/24 12:26:53.098 [00000]: [000026C8][FilterManager] Loading filters...
2013/05/24 12:26:53.368 [00271]: [000026C8][FilterManager] Filters loaded.
2013/05/24 12:26:53.368 [00000]: [000026C8][LayoutManager] Loading layouts...
2013/05/24 12:26:53.548 [00174]: [000026C8][StatManager] Loading stats and reports...
2013/05/24 12:26:53.668 [00125]: [000026C8][StatManager] Stats and reports loaded. Load: 125ms, Custom: 0.5760ms, Dupe: 0.0180ms
2013/05/24 12:26:53.668 [00000]: [000026C8][LayoutManager] Layouts loaded.
2013/05/24 12:26:53.718 [00046]: [000026C8][TagManager] Loaded 23 tag icons in 45ms
2013/05/24 12:26:53.718 [00000]: [000026C8][StatManager] Loading stats and reports...
2013/05/24 12:26:53.838 [00120]: [000026C8][StatManager] Stats and reports loaded. Load: 120ms, Custom: 0.3400ms, Dupe: 0.0135ms
2013/05/24 12:26:54.378 [00543]: [000026C8][NotesManager] AutoNotes loaded.
2013/05/24 12:26:54.438 [00054]: [000026C8][NotesManager] Initialized: 717ms
2013/05/24 12:26:54.448 [00009]: [000026C8][Player] 1 buddies found
2013/05/24 12:26:54.448 [00000]: [000026C8][WindowSplash::Worker::Entry] Ending thread.
2013/05/24 12:26:54.448 [00000]: [- Main -][WindowSplash] Initializing Main Window
2013/05/24 12:26:54.448 [00002]: [- Main -][PostgresConnection] Connecting to database: PT4_2013_01_28_121545
2013/05/24 12:26:54.598 [00149]: [- Main -][PostgresConnection] [0x0ab7ad08] Successfully connected to: PT4_2013_01_28_121545 [0a73c9e0] (PostgreSQL version 90011)
2013/05/24 12:26:54.648 [00055]: [- Main -][ConnectionManager] Database Version: 400015
2013/05/24 12:26:54.668 [00015]: [- Main -][PostgresConnection] Connecting to database: PT4_2013_01_28_121545
2013/05/24 12:26:54.818 [00150]: [- Main -][PostgresConnection] [0x0ab79ac0] Successfully connected to: PT4_2013_01_28_121545 [0a0b7d80] (PostgreSQL version 90011)
2013/05/24 12:26:54.818 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2013_01_28_121545
2013/05/24 12:26:54.968 [00147]: [- Main -][PostgresConnection] [0x0ab7ae40] Successfully connected to: PT4_2013_01_28_121545 [0a6d2d78] (PostgreSQL version 90011)
2013/05/24 12:26:54.968 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2013_01_28_121545
2013/05/24 12:26:55.108 [00144]: [- Main -][PostgresConnection] [0x0ab7af78] Successfully connected to: PT4_2013_01_28_121545 [0a025070] (PostgreSQL version 90011)
2013/05/24 12:26:55.118 [00004]: [- Main -][CurrencyManager] Database Global Currency: USD
2013/05/24 12:26:55.118 [00000]: [- Main -][LayoutManager] Caching profile data.
2013/05/24 12:26:57.078 [01960]: [- Main -][LayoutManager] Caching profile data complete: 1.96s
2013/05/24 12:26:57.518 [00445]: [- Main -][WindowMain] Database: PokerTracker 4 DB Size: 3221 MB
2013/05/24 12:27:00.038 [02518]: [- Main -][ptButtonBar] Selected: View Stats
2013/05/24 12:27:00.078 [00038]: [- Main -][cbiReportOptions] Loading report options...
2013/05/24 12:27:00.158 [00081]: [- Main -][cbiReportOptions] Loaded.
2013/05/24 12:27:00.168 [00007]: [- Main -][cbiReportFilters] Loading report filters...
2013/05/24 12:27:00.218 [00056]: [- Main -][cbiReportFilters] Loaded.
2013/05/24 12:27:00.268 [00046]: [- Main -][wpReportPage] Creating report on demand: Overview
2013/05/24 12:27:00.268 [00000]: [- Main -][wpTourneyResults] Creating overview...
2013/05/24 12:27:00.288 [00024]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2013/05/24 12:27:00.308 [00014]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2013/05/24 12:27:00.308 [00000]: [00002764][Query::QueryThread] Thread [0x00002764]: Begin
2013/05/24 12:27:00.308 [00002]: [00002764][Query] Executing SQL (Thread): SELECT (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv", (sum( (case when(tourney_results.amt_won > 0) then 1 else 0 end) )) as "cnt_itm", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (timezone('UTC', tourney_summary.date_start + INTERVAL '0 HOURS')) as "tourney_date_start", (tourney_summary.id_tourney) as "id_tourney_summary", (tourney_results.id_tourney) as "__gph__id_tourney", (tourney_results.date_start) as "__gph__tourney_date", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv" FROM tourney_results, tourney_summary WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='coconutbrah' AND id_site='100')) AND ((tourney_results.id_gametype = 1)) GROUP BY (timezone('UTC', tourney_summary.date_start + INTERVAL '0 HOURS')), (tourney_summary.id_tourney), (tourney_results.id_tourney), (tourney_results.date_start) ORDER BY __gph__tourney_date asc, __gph__id_tourney asc
2013/05/24 12:27:00.328 [00014]: [00002764][PostgresConnection (Error)] Unable to execute query: SELECT (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv", (sum( (case when(tourney_results.amt_won > 0) then 1 else 0 end) )) as "cnt_itm", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (timezone('UTC', tourney_summary.date_start + INTERVAL '0 HOURS')) as "tourney_date_start", (tourney_summary.id_tourney) as "id_tourney_summary", (tourney_results.id_tourney) as "__gph__id_tourney", (tourney_results.date_start) as "__gph__tourney_date", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv" FROM tourney_results, tourney_summary WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='coconutbrah' AND id_site='100')) AND ((tourney_results.id_gametype = 1)) GROUP BY (timezone('UTC', tourney_summary.date_start + INTERVAL '0 HOURS')), (tourney_summary.id_tourney), (tourney_results.id_tourney), (tourney_results.date_start) ORDER BY __gph__tourney_date asc, __gph__id_tourney asc; Reason: Fatal Error (ERROR: more than one row returned by a subquery used as an expression )
2013/05/24 12:27:00.328 [00000]: [00002764][Query] Query execution time: 15.20128440 ms
2013/05/24 12:27:00.468 [00146]: [- Main -][wpTourneyResults] Overview created.
2013/05/24 12:27:00.468 [00000]: [- Main -][wpReportPage] Report successfully created.
2013/05/24 12:27:00.588 [00122]: [- Main -][cbiReportFilters] Populating report filters...
2013/05/24 12:27:01.758 [01164]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2013/05/24 12:27:01.778 [00024]: [- Main -][StatManager] Unable to use cache due to column: amt_buyin_curr_conv (amt_buyin_curr_conv)
2013/05/24 12:27:01.878 [00096]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2013/05/24 12:27:01.878 [00003]: [00002764][Query::QueryThread] Thread [0x00002764]: Begin
2013/05/24 12:27:01.888 [00002]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2013/05/24 12:27:01.888 [00004]: [00002764][Query] Executing SQL (Thread): SELECT id_player, id_site, str_player_name, sum(amt_buyin_curr_conv), sum(amt_fee_curr_conv), sum(amt_bounty_per_curr_conv), count(distinct cnt_tourneys), sum(cnt_itm), sum(amt_buyin_ttl_curr_conv), avg(avg_finish), sum(cnt_finish_1), sum(cnt_finish_2), sum(cnt_finish_3), sum(amt_won_curr_conv) FROM ( SELECT (tourney_hand_player_statistics.id_player) as "id_player", (player_real.id_site) as "id_site", (player.player_name) as "str_player_name", (((case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_buyin else 0.0 end))) as "amt_buyin_curr_conv", (( (case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_fee else 0.0 end) )) as "amt_fee_curr_conv", (((case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_bounty else 0.0 end))) as "amt_bounty_per_curr_conv", ((tourney_summary.id_tourney)) as "cnt_tourneys", (( (case when(tourney_results.amt_won > 0) then 1 else 0 end) )) as "cnt_itm", (((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv", ((tourney_results.val_finish)) as "avg_finish", (((case when(tourney_results.val_finish=1) then 1 else 0 end))) as "cnt_finish_1", (((case when(tourney_results.val_finish=2) then 1 else 0 end))) as "cnt_finish_2", (((case when(tourney_results.val_finish=3) then 1 else 0 end))) as "cnt_finish_3", (((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv" FROM tourney_hand_player_statistics , player, tourney_summary, tourney_results, player player_real WHERE (player.id_player = tourney_hand_player_statistics.id_player) AND (tourney_summary.id_tourney = tourney_hand_player_statistics.id_tourney) AND (tourney_results.id_tourney = tourney_hand_player_statistics.id_tourney AND tourney_results.id_player = tourney_hand_player_statistics.id_player) AND (player_real.id_player = tourney_hand_player_statistics.id_player_real) AND (player.id_player = tourney_results.id_player) AND (tourney_results.id_tourney = tourney_summary.id_tourney) AND (player_real.id_player = tourney_results.id_player_real) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='coconutbrah' AND id_site='100')) AND ((tourney_results.id_gametype = 1)) GROUP BY tourney_results.cnt_bounty, tourney_results.val_finish, tourney_results.cnt_addon, tourney_results.cnt_rebuy, tourney_results.amt_won, tourney_summary.amt_addon, tourney_summary.amt_rebuy, tourney_summary.id_tourney, tourney_summary.amt_bounty, tourney_summary.amt_fee, tourney_summary.currency, tourney_summary.amt_buyin, tourney_summary.val_curr_conv, (tourney_hand_player_statistics.id_player), (player_real.id_site), (player.player_name) ) AS tnySumGroup GROUP BY id_player, id_site, str_player_name
2013/05/24 12:27:01.898 [00008]: [- Main -][StatManager] Unable to use cache due to column: id_table_type (id_table_type)
2013/05/24 12:27:01.908 [00010]: [00002764][PostgresConnection (Error)] Unable to execute query: SELECT id_player, id_site, str_player_name, sum(amt_buyin_curr_conv), sum(amt_fee_curr_conv), sum(amt_bounty_per_curr_conv), count(distinct cnt_tourneys), sum(cnt_itm), sum(amt_buyin_ttl_curr_conv), avg(avg_finish), sum(cnt_finish_1), sum(cnt_finish_2), sum(cnt_finish_3), sum(amt_won_curr_conv) FROM ( SELECT (tourney_hand_player_statistics.id_player) as "id_player", (player_real.id_site) as "id_site", (player.player_name) as "str_player_name", (((case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_buyin else 0.0 end))) as "amt_buyin_curr_conv", (( (case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_fee else 0.0 end) )) as "amt_fee_curr_conv", (((case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_bounty else 0.0 end))) as "amt_bounty_per_curr_conv", ((tourney_summary.id_tourney)) as "cnt_tourneys", (( (case when(tourney_results.amt_won > 0) then 1 else 0 end) )) as "cnt_itm", (((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv", ((tourney_results.val_finish)) as "avg_finish", (((case when(tourney_results.val_finish=1) then 1 else 0 end))) as "cnt_finish_1", (((case when(tourney_results.val_finish=2) then 1 else 0 end))) as "cnt_finish_2", (((case when(tourney_results.val_finish=3) then 1 else 0 end))) as "cnt_finish_3", (((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv" FROM tourney_hand_player_statistics , player, tourney_summary, tourney_results, player player_real WHERE (player.id_player = tourney_hand_player_statistics.id_player) AND (tourney_summary.id_tourney = tourney_hand_player_statistics.id_tourney) AND (tourney_results.id_tourney = tourney_hand_player_statistics.id_tourney AND tourney_results.id_player = tourney_hand_player_statistics.id_player) AND (player_real.id_player = tourney_hand_player_statistics.id_player_real) AND (player.id_player = tourney_results.id_player) AND (tourney_results.id_tourney = tourney_summary.id_tourney) AND (player_real.id_player = tourney_results.id_player_real) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='coconutbrah' AND id_site='100')) AND ((tourney_results.id_gametype = 1)) GROUP BY tourney_results.cnt_bounty, tourney_results.val_finish, tourney_results.cnt_addon, tourney_results.cnt_rebuy, tourney_results.amt_won, tourney_summary.amt_addon, tourney_summary.amt_rebuy, tourney_summary.id_tourney, tourney_summary.amt_bounty, tourney_summary.amt_fee, tourney_summary.currency, tourney_summary.amt_buyin, tourney_summary.val_curr_conv, (tourney_hand_player_statistics.id_player), (player_real.id_site), (player.player_name) ) AS tnySumGroup GROUP BY id_player, id_site, str_player_name; Reason: Fatal Error (ERROR: more than one row returned by a subquery used as an expression )
2013/05/24 12:27:01.908 [00000]: [00002764][Query] Query execution time: 18.54506665 ms
2013/05/24 12:27:01.918 [00009]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2013/05/24 12:27:01.918 [00004]: [00002764][Query::QueryThread] Thread [0x00002764]: Begin
2013/05/24 12:27:01.928 [00004]: [00002764][Query] Executing SQL (Thread): SELECT (tourney_summary.id_table_type) as "id_table_type", (sum((case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_buyin else 0.0 end))) as "amt_buyin_curr_conv", (sum( (case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_fee else 0.0 end) )) as "amt_fee_curr_conv", (sum((case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_bounty else 0.0 end))) as "amt_bounty_per_curr_conv", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (sum( (case when(tourney_results.amt_won > 0) then 1 else 0 end) )) as "cnt_itm", (avg(tourney_results.val_finish)) as "avg_finish", (sum((case when(tourney_results.val_finish=1) then 1 else 0 end))) as "cnt_finish_1", (sum((case when(tourney_results.val_finish=2) then 1 else 0 end))) as "cnt_finish_2", (sum((case when(tourney_results.val_finish=3) then 1 else 0 end))) as "cnt_finish_3", (sum(tourney_summary.cnt_players)) as "cnt_tourney_players", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv" FROM tourney_results, tourney_summary WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='coconutbrah' AND id_site='100')) AND ((tourney_results.id_gametype = 1)) GROUP BY (tourney_summary.id_table_type)
2013/05/24 12:27:01.928 [00004]: [00002764][PostgresConnection (Error)] Unable to execute query: SELECT (tourney_summary.id_table_type) as "id_table_type", (sum((case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_buyin else 0.0 end))) as "amt_buyin_curr_conv", (sum( (case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_fee else 0.0 end) )) as "amt_fee_curr_conv", (sum((case when(tourney_summary.val_curr_conv!=0) then tourney_summary.val_curr_conv * tourney_summary.amt_bounty else 0.0 end))) as "amt_bounty_per_curr_conv", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (sum( (case when(tourney_results.amt_won > 0) then 1 else 0 end) )) as "cnt_itm", (avg(tourney_results.val_finish)) as "avg_finish", (sum((case when(tourney_results.val_finish=1) then 1 else 0 end))) as "cnt_finish_1", (sum((case when(tourney_results.val_finish=2) then 1 else 0 end))) as "cnt_finish_2", (sum((case when(tourney_results.val_finish=3) then 1 else 0 end))) as "cnt_finish_3", (sum(tourney_summary.cnt_players)) as "cnt_tourney_players", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.cnt_bounty * tourney_summary.amt_bounty) else 0.0 end))) as "amt_won_curr_conv", (sum((case when(tourney_summary.val_curr_conv != 0) then tourney_summary.val_curr_conv * (tourney_summary.amt_buyin + tourney_summary.amt_fee + tourney_summary.amt_rebuy * tourney_results.cnt_rebuy + tourney_summary.amt_addon * tourney_results.cnt_addon + tourney_summary.amt_bounty) else 0.0 end))) as "amt_buyin_ttl_curr_conv" FROM tourney_results, tourney_summary WHERE (tourney_results.id_tourney = tourney_summary.id_tourney) AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search='coconutbrah' AND id_site='100')) AND ((tourney_results.id_gametype = 1)) GROUP BY (tourney_summary.id_table_type) ; Reason: Fatal Error (ERROR: more than one row returned by a subquery used as an expression )
2013/05/24 12:27:01.928 [00000]: [00002764][Query] Query execution time: 3.98200656 ms
2013/05/24 12:28:34.804 [92873]: [- Main -][WindowMain] Executing: Explorer /e,/root,"C:\Users\Neill\AppData\Local\PokerTracker 4"

[kraada]

Thanks, we will get back to you via your ticket.

[neill0021]

I know you guys are working hard but I use this software nearly every day to play and right now my HUD is unusable. When can I expect a response? From an internet search it seems that if you use the same name on stars/FTP then this error happens. I tried to purge all hands for FTP and I was using the software for months before this happened. This is a very important time for me to be playing with SCOOP and I can't use the software properly.

[BillGatesIII]

Do you know how to run a query in pgAdmin? If yes, what's the result of this one?

Code: Select all

select *
from player
where player_name_search = 'coconutbrah'

[neill0021]

I think this is right.