so ive recently played a few hands, but still not sure how to attach the log file. hope you can do the same with the log file paste.
i can only fit 60000 words so have the full log file in the following 2 pastes. thanks
2015/06/27 16:19:14.939 [00001]: [- Main -][System] PokerTracker v4.13.4
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] OS: Windows 7 (build 7601, Service Pack 1), 64-bit edition
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] Windows Version: 6.1 build 7601 (platform 2) Service Pack 1
2015/06/27 16:19:14.940 [00000]: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0409
2015/06/27 16:19:14.941 [00000]: [- Main -][SystemInfo] Total Logical Processing Units: 2
2015/06/27 16:19:14.941 [00000]: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 2 PUs: 2 (L1: 2, L2: 1, L3: 0)
2015/06/27 16:19:14.942 [00000]: [- Main -][SystemInfo] Processor 1: Speed: 2.79 GHz Name: Intel(R) Core(TM)2 Duo CPU P9700 @ 2.80GHz
2015/06/27 16:19:14.942 [00000]: [- Main -][SystemInfo] Processor 2: Speed: 2.79 GHz Name: Intel(R) Core(TM)2 Duo CPU P9700 @ 2.80GHz
2015/06/27 16:19:14.943 [00000]: [- Main -][SystemInfo] C:\ Disk Space: 305,143 mb total; 64,628 mb used; 240,515 mb free
2015/06/27 16:19:15.095 [00151]: [- Main -][SystemInfo] Physical Memory: 4,083 mb (2,319 mb available) Virtual Memory: 2,047 mb (2,047 mb available) Page File: 8,165 mb (4,542 mb available)
2015/06/27 16:19:15.104 [00008]: [- Main -][System Info] Video[0]: NVIDIA Quadro NVS 160M (\\.\DISPLAY1)
2015/06/27 16:19:15.106 [00001]: [- Main -][SystemInfo] Display[0]: Position: 0x0, Size: 1280x760
2015/06/27 16:19:15.181 [00074]: [- Main -][SystemInfo] Anti Virus: [Not Installed]
2015/06/27 16:19:20.226 [05044]: [- Main -][SystemInfo] Adobe Flash: 17.0.0.190 Plugin: 17.0.0.190 AIR: Error: Adobe AIR not installed
2015/06/27 16:19:20.228 [00002]: [- Main -][SystemInfo] Configuration: [General]\nRunCount=107\nBuildDate=2015/06/15\nRegistrationCode=*** REG CODE REMOVED ***\nFirstRun=N\nLogging=Y\n[Database]\nDefault.Postgres.Server=localhost\nDefault.Postgres.Port=5432\nDefault.Postgres.User=postgres\nDefault.Postgres.Password=hammies08\nDB1.Name=PokerTracker 4 Database\nDB1.Type=postgres\nDB1.Postgres.Database=PT4 DB\nDB1.Postgres.Server=localhost\nDB1.Postgres.Port=5432\nDB1.Postgres.User=postgres\nDB1.Postgres.Password=dbpass\nDB2.Name=PT4_2014_10_06_195153\nDB2.Type=postgres\nDB2.Postgres.Database=PT4_2014_10_06_195153\nDB2.Postgres.Server=localhost\nDB2.Postgres.Port=5432\nDB2.Postgres.User=postgres\nDB2.Postgres.Password=hammies08\nDB2.Default=Y\nDB3.Name=PT4_2015_06_23_155954\nDB3.Type=postgres\nDB3.Postgres.Database=PT4_2015_06_23_155954\nDB3.Postgres.Server=localhost\nDB3.Postgres.Port=5432\nDB3.Postgres.User=postgres\nDB3.Postgres.Password=hammies08\n[Import]\nAutoStart.900=N\nAutoStart.2300=N\nAutoStart.300=Y\nAutoStart.700=N\nAutoStart.400=Y\nAutoStart.2100=N\nAutoStart.1100=N\nAutoStart.600=Y\nAutoStart.200=N\nAutoStart.100=Y\nAutoStart.1200=N\nAutoStart.2200=N\nAutoStart.2400=N\nMoveProcessedFiles=Y\nMoveProcessedFilesDirectory=C:\Users\user\AppData\Local\PokerTracker 4\Processed\iPoker\2015\06-19\iPoker\2015\06-19\nMoveProcessedFilesBySite=Y\nMoveProcessedFilesByDate=Y\nImportObservedHands=Y\nAutoTreatAs=Y\nPromptOnCloseDuringAutoImport=N\nOverwriteTournamentSummary=N\nTournamentDetectPostSummary=N\nAutoTourneyDetect=Y\nEquity:HeroDeadCards=Y\nEquity:PreflopEnumeration=Hero\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\nHidden.2300=N\nHidden.300=N\nAutoStart.1000=N\nHidden.1000=N\nHidden.700=N\nHidden.400=N\nHidden.2100=N\nHidden.1100=N\nHidden.600=N\nHidden.200=N\nHidden.100=N\nHidden.1200=N\nHidden.2200=N\nHidden.2400=N\nEmail:Pop:Port=110\nEmail:Pop:Password=^E:\nEmail:Pop:UseSSL=N\n[Site.iPoker]\nFastHud=Y\nHandHistoryDirectories=C:\Poker\Betfair.com Poker\History;C:\Users\user\Documents\HandHistory\No-rebuy-4-u\No-rebuy-4-u;\nSkinName=Default\nSkinTimeZone=GMT\nAutoCenter=Y\n[Site.OnGame]\nPreferred.10=7\nAlwaysOnTop=Y\nHandHistoryDirectories=C:\Users\user\P5JavaClientSettings\handhistory;\n[TournamentDetect]\nCheckBoxProtectType=N\nCheckBoxSavePosPrize=Y\nCheckBoxSaveType=Y\nUnknownFinishRefundBuyin=N\nUnknownFinishICMAward=N\nNetAdjAllPlayers=Y\nNetAdjActivePlayerDecisions=N\nDefaultTables=0\nDefaultMinsPerRound=10\nDefaultRebuyMinutes=60\nNetAdjMTT=N\n[Players]\nActiveSiteID=300\nActiveName=No-rebuy-4-u\nPrevious.1.SiteID=100\nPrevious.1.Name=SoMany1Times\nPrevious.2.SiteID=300\nPrevious.2.Name=No-rebuy-4-u\nPrevious.3.SiteID=600\nPrevious.3.Name=SoMany1Times\n[Site.PokerStars]\nZoomHud=Y\nAutoCenter=Y\nPreferred.6=3\nPreferred.9=5\n[Site.FullTilt]\nHandHistoryDirectory=C:\Users\user\Documents\HandHistory\No-rebuy-4-u\No-rebuy-4-u\nRushHud=Y\nAutoCenter=Y\nPreferred.6=3\nPreferred.2=2\n[HudGui]\nNotesWindowX=450\nNotesWindowY=325\n[Hud]\nMuckedCards.Display=Y\nMuckedCards.Length=5\nMuckedCards.Translucency=20\nLowOpacityTranslucency=90\nNotesMaxLines=10\nUseNoteColorOutline=Y\nUseTranslucency=Y\nVectorScaling=Y\nTableSelect=Y\nMinHands=1\nCurrentLimit=N\nCurrentBetType=Y\nSessionStats=Y\nShowEquityPercentages=Y\nLastXHands=0\nLastXWeeks=0\nPlayerRanges=-\nTourneyStackFilter.0=-1\nTourneyStackFilter.1=-1\nTourneyStackFilter.2=-1\nTourneyStackFilter.3=-1\nTourneyStackFilter.4=-1\nTourneyStackFilter.5=-1\nDatabases=PokerTracker 4 Database\nPT4_2014_10_06_195153\n
2015/06/27 16:19:20.445 [00217]: [- Main -][Community] Sub Process: C:\Program Files (x86)\PokerTracker 4\PokerTrackerWeb4.exe
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Cache Dir: C:\Users\user\AppData\Local\PokerTracker 4\Community\Cache
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Log File: C:\Users\user\AppData\Local\PokerTracker 4\PokerTrackerWeb4.log
2015/06/27 16:19:20.445 [00000]: [- Main -][Community] Resources Dir: C:\Program Files (x86)\PokerTracker 4\Data\Bin\chromium
2015/06/27 16:19:20.446 [00000]: [- Main -][Community] Locales Dir: C:\Program Files (x86)\PokerTracker 4\Data\Bin\chromium\locales
2015/06/27 16:19:44.178 [23733]: [- Main -][PostgresService] Install: postgresql-9.3 (32bit)
2015/06/27 16:19:44.353 [00175]: [- Main -][System] diffInDaysNow = 2368
2015/06/27 16:19:44.354 [00001]: [- Main -][Registration] counter1 = 0xba70d93c
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter2 = 0x00000000
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter1 = 0xba70d940
2015/06/27 16:19:44.355 [00000]: [- Main -][Registration] counter2 = 0x00000000
2015/06/27 16:19:44.355 [00001]: [- Main -][System] Getting String: 1059-4E4B-5E3C-9DA2-46FF-C5F1-7700-24F8
2015/06/27 16:19:44.650 [00294]: [- Main -][System] Attempting to connect to:
https://ptlicense.com/regcheck.php2015/06/27 16:19:48.617 [03968]: [- Main -][Registration] License written to C:\Users\user\AppData\Local\PokerTracker 4\Config/PokerTracker.lic
2015/06/27 16:19:51.016 [02397]: [- Main -][WindowDialog] Opening Dialog: New Version Available (0018F130)
2015/06/27 16:19:55.856 [04840]: [- Main -][WindowDialog] Closing Dialog: New Version Available (0018F130)
2015/06/27 16:19:55.862 [00006]: [- Main -][System] Currencies v1.04 is up to date.
2015/06/27 16:19:55.948 [00086]: [- Main -][System] TournamentDetect v3.92 is up to date.
2015/06/27 16:19:55.949 [00001]: [- Main -][System] FullTilt v1.34 is up to date.
2015/06/27 16:19:55.950 [00000]: [- Main -][System] Party v1.18 is up to date.
2015/06/27 16:19:55.950 [00000]: [- Main -][System] iPoker v2.12 is up to date.
2015/06/27 16:19:55.951 [00001]: [- Main -][System] Pacific v1.11 is up to date.
2015/06/27 16:19:56.087 [00136]: [- Main -][System] Attempting to connect to:
https://www.ptrackupdate.com/autoUpdate ... leList.ini2015/06/27 16:19:58.915 [02828]: [- Main -][System] Checking MD5 checksums...
2015/06/27 16:19:58.915 [00000]: [- Main -][System] MD5 checksum complete
2015/06/27 16:19:58.924 [00009]: [- Main -][System] Holdem: Small Omaha: NO
2015/06/27 16:19:58.925 [00001]: [- Main -][System] TRP Status: TH: false; TO: false; RH: true; RO: false; PH: true; PO: false;
2015/06/27 16:19:58.936 [00011]: [0000129C][ThreadPool(Idle)] Thread [0x0000129C]: Begin
2015/06/27 16:19:58.936 [00000]: [0000129C][ThreadPool] Thread [02F192E0]: Created
2015/06/27 16:19:58.937 [00000]: [00002434][ThreadPool(Idle)] Thread [0x00002434]: Begin
2015/06/27 16:19:58.937 [00000]: [00002434][ThreadPool] Thread [02F18838]: Created
2015/06/27 16:19:58.962 [00025]: [00001484][ThreadPool(Idle)] Thread [0x00001484]: Begin
2015/06/27 16:19:58.962 [00000]: [00001484][ThreadPool] Thread [02F18940]: Created
2015/06/27 16:19:58.963 [00001]: [00002044][ThreadPool(Idle)] Thread [0x00002044]: Begin
2015/06/27 16:19:58.963 [00000]: [00002044][ThreadPool] Thread [02F18890]: Created
2015/06/27 16:19:59.211 [00248]: [- Main -][WindowSplash] Checking installation
2015/06/27 16:19:59.212 [00001]: [- Main -][PostgresService] Attempting to start service...
2015/06/27 16:19:59.221 [00009]: [- Main -][PostgresService (ERROR)] Failed to start service
2015/06/27 16:19:59.227 [00006]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:00.620 [01392]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:00.621 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:00.774 [00153]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:01.785 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:01.889 [00104]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:01.890 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:02.018 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:03.027 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:03.101 [00074]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:03.102 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:03.163 [00061]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:04.169 [01006]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:04.201 [00032]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:04.201 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:04.244 [00043]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:05.254 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:05.502 [00249]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:05.503 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:05.581 [00078]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:06.591 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:06.894 [00302]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:06.895 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:07.023 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:08.034 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:08.299 [00265]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:08.300 [00001]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:08.476 [00176]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:09.487 [01010]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:09.599 [00111]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:09.600 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:09.719 [00118]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:10.729 [01009]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:10.850 [00121]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:10.851 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:10.928 [00077]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:11.950 [01022]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:12.056 [00105]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:12.057 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:12.293 [00235]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.327 [01034]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:13.566 [00238]: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.566 [00000]: [- Main -][PostgresConnection] Connecting to database: template1
2015/06/27 16:20:13.695 [00128]: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:20:13.697 [00001]: [- Main -][PostgresConnection] Connecting to database: postgres
2015/06/27 16:20:15.160 [01463]: [- Main -][PostgresConnection] [0x0018f328] Successfully connected to: postgres [02f4bb28] (PostgreSQL version 90305)
2015/06/27 16:20:15.160 [00000]: [- Main -][PostgresConnection] [0x0018f328] Disconnecting from database: postgres
2015/06/27 16:20:15.162 [00002]: [00002124][WindowSplash::Worker::Entry] Beginning thread.
2015/06/27 16:20:15.163 [00000]: [00002124][WindowSplash::Worker] Thread [0x00002124]: Begin
2015/06/27 16:20:15.280 [00116]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:15.958 [00677]: [00002124][StatManager] Stats and reports loaded. Load: 678ms, Custom: 101ms, Dupe: -
2015/06/27 16:20:15.958 [00000]: [00002124][FilterManager] Loading filters...
2015/06/27 16:20:17.197 [01239]: [00002124][FilterManager] Filters loaded.
2015/06/27 16:20:17.198 [00000]: [00002124][LayoutManager] Loading layouts...
2015/06/27 16:20:20.839 [03642]: [00002124][LayoutManager] Adding Table Select Layout
2015/06/27 16:20:20.841 [00002]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:21.120 [00278]: [00002124][StatManager] Stats and reports loaded. Load: 278ms, Custom: 0.1404ms, Dupe: -
2015/06/27 16:20:21.120 [00000]: [00002124][LayoutManager] Layouts loaded.
2015/06/27 16:20:22.211 [01092]: [00002124][TagManager] Loaded 23 tag icons in 1.09s
2015/06/27 16:20:22.212 [00000]: [00002124][StatManager] Loading stats and reports...
2015/06/27 16:20:22.384 [00172]: [00002124][StatManager] Stats and reports loaded. Load: 172ms, Custom: 0.1104ms, Dupe: -
2015/06/27 16:20:23.394 [01010]: [00002124][NotesManager] AutoNotes loaded.
2015/06/27 16:20:23.791 [00397]: [00002124][StatManager] Unable to use cache due to column: __can__id_player (__can__id_player)
2015/06/27 16:20:23.806 [00014]: [00002124][StatManager] Unable to use cache due to column: __can__id_player (__can__id_player)
2015/06/27 16:20:23.873 [00066]: [00002124][StatManager] Unable to use cache due to column: __can__player (__can__player)
2015/06/27 16:20:23.902 [00029]: [00002124][StatManager] Unable to use cache due to column: __can__player (__can__player)
2015/06/27 16:20:23.925 [00022]: [00002124][NotesManager] Initialized: 1.71s
2015/06/27 16:20:23.930 [00005]: [00002124][Player] 0 buddies found
2015/06/27 16:20:23.931 [00000]: [00002124][WindowSplash::Worker::Entry] Ending thread.
2015/06/27 16:20:23.931 [00000]: [- Main -][WindowSplash] Initializing Main Window
2015/06/27 16:20:23.936 [00004]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:24.393 [00456]: [- Main -][PostgresConnection] [0x0c1281e0] Successfully connected to: PT4_2014_10_06_195153 [0c011f80] (PostgreSQL version 90305)
2015/06/27 16:20:29.688 [05295]: [- Main -][ConnectionManager] Database Version: 400019
2015/06/27 16:20:32.181 [02492]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.411 [00229]: [- Main -][PostgresConnection] [0x0c127f90] Successfully connected to: PT4_2014_10_06_195153 [0b666330] (PostgreSQL version 90305)
2015/06/27 16:20:32.412 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.457 [00044]: [- Main -][PostgresConnection] [0x0c1280b8] Successfully connected to: PT4_2014_10_06_195153 [0afde9c8] (PostgreSQL version 90305)
2015/06/27 16:20:32.458 [00001]: [- Main -][PostgresConnection] Connecting to database: PT4_2014_10_06_195153
2015/06/27 16:20:32.665 [00207]: [- Main -][PostgresConnection] [0x0c128308] Successfully connected to: PT4_2014_10_06_195153 [0aeaa280] (PostgreSQL version 90305)
2015/06/27 16:20:34.538 [01873]: [- Main -][System] Attempting to connect to:
https://www.ptrackupdate.com/currencyRates.php2015/06/27 16:20:36.280 [01742]: [- Main -][CurrencyManager] Added 10 new rates
2015/06/27 16:20:37.002 [00722]: [- Main -][CurrencyManager] Database Global Currency: USD
2015/06/27 16:20:37.058 [00056]: [- Main -][LayoutManager] Caching profile data.
2015/06/27 16:20:39.906 [02848]: [- Main -][LayoutManager] Caching profile data complete: 2.85s
2015/06/27 16:20:44.285 [04378]: [- Main -][StatManager] cacheVerifyIndexes: Cache indexes up to date.
2015/06/27 16:20:46.511 [02226]: [- Main -][WindowMain] Database: PT4_2014_10_06_195153 Size: 1635 MB
2015/06/27 16:22:29.241 [99999]: [- Main -][WindowMain] Executing: Explorer /e,/root,"C:\Users\user\AppData\Local\PokerTracker 4"
2015/06/27 16:24:46.599 [99999]: [- Main -][wpImport] Click: Get Hands While Playing
2015/06/27 16:24:46.603 [00003]: [- Main -][ImportAuto] startImporting()::begin
2015/06/27 16:24:46.603 [00000]: [- Main -][ImportAuto] Starting ImportAuto Worker Thread
2015/06/27 16:24:46.603 [00000]: [- Main -][ImportAuto] startThread()::begin
2015/06/27 16:24:46.604 [00000]: [- Main -][ImportAuto] startThread()::begin
2015/06/27 16:24:46.604 [00001]: [- Main -][TableManager] Starting Up...
2015/06/27 16:24:46.623 [00019]: [00001228][TableManager] Thread [0x00001228]: Begin
2015/06/27 16:24:46.624 [00000]: [00001228][TableManager::Entry] Beginning thread.
2015/06/27 16:24:46.639 [00015]: [00001CE8][ImportAutoWorker] Thread [0x00001CE8]: Begin
2015/06/27 16:24:46.641 [00001]: [00001CE8][ImportAuto::ImportAutoWorker::Entry] Beginning thread.
2015/06/27 16:24:48.521 [01878]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_rotate AS UPDATE live_cash_table SET cnt_hands=cnt_hands+1, amt_pot_9=amt_pot_8, amt_pot_8=amt_pot_7, amt_pot_7=amt_pot_6, amt_pot_6=amt_pot_5, amt_pot_5=amt_pot_4, amt_pot_4=amt_pot_3, amt_pot_3=amt_pot_2, amt_pot_2=amt_pot_1, amt_pot_1=amt_pot, amt_rake_9=amt_rake_8, amt_rake_8=amt_rake_7, amt_rake_7=amt_rake_6, amt_rake_6=amt_rake_5, amt_rake_5=amt_rake_4, amt_rake_4=amt_rake_3, amt_rake_3=amt_rake_2, amt_rake_2=amt_rake_1, amt_rake_1=amt_rake, cnt_players_9=cnt_players_8, cnt_players_8=cnt_players_7, cnt_players_7=cnt_players_6, cnt_players_6=cnt_players_5, cnt_players_5=cnt_players_4, cnt_players_4=cnt_players_3, cnt_players_3=cnt_players_2, cnt_players_2=cnt_players_1, cnt_players_1=cnt_players, cnt_saw_flop_9=cnt_saw_flop_8, cnt_saw_flop_8=cnt_saw_flop_7, cnt_saw_flop_7=cnt_saw_flop_6, cnt_saw_flop_6=cnt_saw_flop_5, cnt_saw_flop_5=cnt_saw_flop_4, cnt_saw_flop_4=cnt_saw_flop_3, cnt_saw_flop_3=cnt_saw_flop_2, cnt_saw_flop_2=cnt_saw_flop_1, cnt_saw_flop_1=cnt_saw_flop, winner_9=winner_8, winner_8=winner_7, winner_7=winner_6, winner_6=winner_5, winner_5=winner_4, winner_4=winner_3, winner_3=winner_2, winner_2=winner_1, winner_1=winner WHERE id_live_table=$1;
2015/06/27 16:24:48.567 [00046]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_rotate AS UPDATE live_tourney_table SET cnt_hands=cnt_hands+1, amt_pot_9=amt_pot_8, amt_pot_8=amt_pot_7, amt_pot_7=amt_pot_6, amt_pot_6=amt_pot_5, amt_pot_5=amt_pot_4, amt_pot_4=amt_pot_3, amt_pot_3=amt_pot_2, amt_pot_2=amt_pot_1, amt_pot_1=amt_pot, amt_rake_9=amt_rake_8, amt_rake_8=amt_rake_7, amt_rake_7=amt_rake_6, amt_rake_6=amt_rake_5, amt_rake_5=amt_rake_4, amt_rake_4=amt_rake_3, amt_rake_3=amt_rake_2, amt_rake_2=amt_rake_1, amt_rake_1=amt_rake, cnt_players_9=cnt_players_8, cnt_players_8=cnt_players_7, cnt_players_7=cnt_players_6, cnt_players_6=cnt_players_5, cnt_players_5=cnt_players_4, cnt_players_4=cnt_players_3, cnt_players_3=cnt_players_2, cnt_players_2=cnt_players_1, cnt_players_1=cnt_players, cnt_saw_flop_9=cnt_saw_flop_8, cnt_saw_flop_8=cnt_saw_flop_7, cnt_saw_flop_7=cnt_saw_flop_6, cnt_saw_flop_6=cnt_saw_flop_5, cnt_saw_flop_5=cnt_saw_flop_4, cnt_saw_flop_4=cnt_saw_flop_3, cnt_saw_flop_3=cnt_saw_flop_2, cnt_saw_flop_2=cnt_saw_flop_1, cnt_saw_flop_1=cnt_saw_flop, winner_9=winner_8, winner_8=winner_7, winner_7=winner_6, winner_6=winner_5, winner_5=winner_4, winner_4=winner_3, winner_3=winner_2, winner_2=winner_1, winner_1=winner WHERE id_live_table=$1;
2015/06/27 16:24:48.568 [00002]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_rotate AS UPDATE live_cash_player SET amt_won_9=amt_won_8, amt_won_8=amt_won_7, amt_won_7=amt_won_6, amt_won_6=amt_won_5, amt_won_5=amt_won_4, amt_won_4=amt_won_3, amt_won_3=amt_won_2, amt_won_2=amt_won_1, amt_won_1=amt_won WHERE id_live_table=$2 AND id_player=$1;
2015/06/27 16:24:48.570 [00002]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_rotate AS UPDATE live_tourney_player SET amt_won_9=amt_won_8, amt_won_8=amt_won_7, amt_won_7=amt_won_6, amt_won_6=amt_won_5, amt_won_5=amt_won_4, amt_won_4=amt_won_3, amt_won_3=amt_won_2, amt_won_2=amt_won_1, amt_won_1=amt_won WHERE id_live_table=$2 AND id_player=$1;
2015/06/27 16:24:48.571 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_update AS UPDATE live_cash_table SET amt_ante=$2, amt_sb=$3, amt_bb=$4, amt_avg_stack=$5, amt_min_stack=$6, amt_pot=$7, amt_rake=$8, cnt_players=$9, cnt_saw_flop=$10, winner=$11 WHERE id_live_table=$1;
2015/06/27 16:24:48.572 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_update AS UPDATE live_tourney_table SET amt_ante=$2, amt_sb=$3, amt_bb=$4, amt_avg_stack=$5, amt_min_stack=$6, amt_pot=$7, amt_rake=$8, cnt_players=$9, cnt_saw_flop=$10, winner=$11 WHERE id_live_table=$1;
2015/06/27 16:24:48.572 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_update AS UPDATE live_cash_player SET amt_ante=$4, amt_before=$5, amt_stack=$6, amt_won=$7 WHERE id_player=$1 AND id_player_real=$2 AND id_live_table=$3;
2015/06/27 16:24:48.573 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_update AS UPDATE live_tourney_player SET amt_ante=$4, amt_before=$5, amt_stack=$6, amt_won=$7 WHERE id_player=$1 AND id_player_real=$2 AND id_live_table=$3;
2015/06/27 16:24:48.574 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_table_insert AS INSERT INTO live_cash_table VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11);
2015/06/27 16:24:48.644 [00071]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_table_insert AS INSERT INTO live_tourney_table VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11);
2015/06/27 16:24:48.645 [00001]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_cash_player_insert AS INSERT INTO live_cash_player VALUES ($1,$2,$3,$4,$5,$6,$7);
2015/06/27 16:24:48.646 [00000]: [- Main -][PostgresConnection] Prepared Statment: PREPARE live_tourney_player_insert AS INSERT INTO live_tourney_player VALUES ($1,$2,$3,$4,$5,$6,$7);
2015/06/27 16:24:48.647 [00001]: [00001B20][HudManager] Thread [0x00001B20]: Begin
2015/06/27 16:24:48.676 [00029]: [- Main -][TableManager] Started
2015/06/27 16:24:48.676 [00000]: [- Main -][TableManager] Startup: ref_count: 1
2015/06/27 16:24:48.728 [00052]: [00001228][TableManager] Hud reading from database: PokerTracker 4 Database
2015/06/27 16:24:48.729 [00000]: [00001228][TableManager] Hud reading from database: PT4_2014_10_06_195153
2015/06/27 16:24:48.729 [00001]: [00001228][TableManager] Connecting to database: PokerTracker 4 Database PT4_2014_10_06_195153
2015/06/27 16:24:48.765 [00035]: [000023A0][AutoNoteThread] Thread [0x000023A0]: Begin
2015/06/27 16:24:48.765 [00000]: [000023A0][AutoNoteThread] Beginning thread.
2015/06/27 16:24:48.766 [00000]: [00001228][PostgresConnection] Connecting to database: PT4 DB
2015/06/27 16:24:49.387 [00622]: [00001228][PostgresConnection (Error)] Unable to login to database (PT4 DB). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:24:49.387 [00000]: [00001228][Connection] Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:24:49.388 [00001]: [00001228][TableManager (Error)] The Hud cannot use the cache due to one or more databases containing an invalid cache.
2015/06/27 16:24:49.388 [00000]: [00001228][TableManager] Connecting to database: PokerTracker 4 Database PT4_2014_10_06_195153
2015/06/27 16:24:49.390 [00001]: [00001228][PostgresConnection] Connecting to database: PT4 DB
2015/06/27 16:24:49.961 [00572]: [- Main -][TourneyDetect] System Language: en_US
2015/06/27 16:24:49.962 [00000]: [- Main -][ImportAuto] startImporting()::end
2015/06/27 16:24:49.963 [00002]: [- Main -][wpImport] AutoImport: Start Importing: Full Tilt
2015/06/27 16:24:49.963 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:49.979 [00015]: [00000F50][TourneyDetectThread] Thread [0x00000F50]: Begin
2015/06/27 16:24:49.979 [00000]: [00000F50][TourneyDetectThread] Beginning thread.
2015/06/27 16:24:49.984 [00005]: [00001228][PostgresConnection (Error)] Unable to login to database (PT4 DB). Reason: FATAL: password authentication failed for user "postgres"
2015/06/27 16:24:49.984 [00000]: [00001228][Connection] Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:24:49.985 [00000]: [- Main -][ImportAuto] Starting AutoImporter: Full Tilt
2015/06/27 16:24:49.985 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:49.985 [00000]: [00001228][TableManager (Error)] The Hud cannot use the cache due to one or more databases containing an invalid cache.
2015/06/27 16:24:50.019 [00034]: [- Main -][ImportStatus] Full Tilt: Starting auto-import.
2015/06/27 16:24:50.073 [00054]: [- Main -][ImportStatus] Full Tilt: Monitoring tables for Rush Poker.
2015/06/27 16:24:50.074 [00001]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.075 [00000]: [- Main -][wpImport] AutoImport: Start Importing: iPoker
2015/06/27 16:24:50.075 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.075 [00001]: [- Main -][ImportAuto] Starting AutoImporter: iPoker
2015/06/27 16:24:50.075 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.076 [00000]: [- Main -][ImportStatus] iPoker: Starting auto-import.
2015/06/27 16:24:50.087 [00011]: [0000061C][FullTiltHandGrabber] Thread [0x0000061C]: Begin
2015/06/27 16:24:50.088 [00000]: [0000061C][FullTiltHandGrabber] Thread Start
2015/06/27 16:24:50.110 [00022]: [- Main -][DirectoryMonitor] Unable to monitor directory: C:\Poker\Betfair.com Poker\History
2015/06/27 16:24:50.112 [00002]: [- Main -][ImportStatus] iPoker: Monitoring tables for Speed Poker.
2015/06/27 16:24:50.112 [00001]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.113 [00000]: [- Main -][wpImport] AutoImport: Start Importing: OnGame
2015/06/27 16:24:50.113 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.114 [00000]: [- Main -][ImportAuto] Starting AutoImporter: OnGame
2015/06/27 16:24:50.114 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.114 [00001]: [- Main -][ImportStatus] OnGame: Starting auto-import.
2015/06/27 16:24:50.115 [00001]: [0000061C][FullTiltOptions] Using FullTiltPoker: C:\Users\user\AppData\Local\FullTiltPoker.eu
2015/06/27 16:24:50.132 [00017]: [- Main -][ImportStatus] OnGame: Monitoring tables for Strobe Poker.
2015/06/27 16:24:50.133 [00000]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.133 [00001]: [- Main -][wpImport] AutoImport: Start Importing: PokerStars
2015/06/27 16:24:50.133 [00000]: [- Main -][ImportAuto] startImporting(site)::begin
2015/06/27 16:24:50.134 [00001]: [- Main -][ImportAuto] Starting AutoImporter: PokerStars
2015/06/27 16:24:50.134 [00000]: [- Main -][AutoImporter] Starting auto-import. Ply: PT4_2014_10_06_195153, Obs: PT4_2014_10_06_195153
2015/06/27 16:24:50.135 [00000]: [- Main -][ImportStatus] PokerStars: Starting auto-import.
2015/06/27 16:24:50.136 [00001]: [- Main -][PokerStarsOptions] Found INI File: C:\Users\user\AppData\Local\PokerStars\user.ini
2015/06/27 16:24:50.139 [00002]: [00001768][OnGameHandGrabber] Thread [0x00001768]: Begin
2015/06/27 16:24:50.139 [00000]: [00001768][OnGameHandGrabber] Thread Start
2015/06/27 16:24:50.146 [00008]: [0000061C][FullTiltHandGrabber] Table Style: Classic, Avatars: ON
2015/06/27 16:24:50.148 [00002]: [000024FC][iPokerHandGrabber] Thread [0x000024FC]: Begin
2015/06/27 16:24:50.148 [00000]: [000024FC][iPokerHandGrabber] Thread Start
2015/06/27 16:24:50.149 [00001]: [00001768][OnGameHandGrabber] Monitoring C:\Users\user\P5JavaClientSettings\handhistory\strobe-hand-starts.dat
2015/06/27 16:24:50.193 [00044]: [- Main -][ImportStatus] PokerStars: Monitoring tables for Zoom Poker.
2015/06/27 16:24:50.194 [00000]: [- Main -][ImportAuto] startImporting(site)::end
2015/06/27 16:24:50.210 [00016]: [- Main -][wpImport] Done: Get Hands While Playing
2015/06/27 16:24:50.214 [00005]: [- Main -][HudLauncher] Launching: C:\Program Files (x86)\PokerTracker 4\PokerTrackerHud4.exe
2015/06/27 16:24:50.231 [00017]: [00001110][PokerStarsMemoryGrabber] Thread [0x00001110]: Begin
2015/06/27 16:24:50.231 [00000]: [00001110][PokerStarsMemoryGrabber] Starting memory hand grabber thread
2015/06/27 16:24:50.232 [00000]: [00001110][System] Getting String:
2015/06/27 16:24:50.243 [00011]: [00000440][PokerStarsHandGrabber] Thread [0x00000440]: Begin
2015/06/27 16:24:50.243 [00000]: [00000440][PokerStarsHandGrabber] Thread Start
2015/06/27 16:24:50.568 [00324]: [- Main -][ImportStatus] Full Tilt: Found 0 files to monitor.
2015/06/27 16:24:50.594 [00026]: [- Main -][ImportStatus] iPoker: Found 0 files to monitor.
2015/06/27 16:24:50.627 [00032]: [- Main -][ImportStatus] OnGame: Found 0 files to monitor.
2015/06/27 16:24:50.627 [00001]: [- Main -][ImportStatus] PokerStars: Found 0 files to monitor.
2015/06/27 16:24:51.197 [00569]: [000024FC][iPokerHandGrabber] Launching iPoker Communicator
2015/06/27 16:24:52.258 [01061]: [000024FC][iPokerHandGrabber] Opening the Comm Pipe
2015/06/27 16:24:52.258 [00000]: [000024FC][iPokerHandGrabber] Waiting for messages...
2015/06/27 16:24:53.837 [01579]: [00001B20][HudIpcClient] PONG: Launch: 5.19s
2015/06/27 16:24:56.883 [03046]: [000024FC][GrabberPipe] High mark is: 32
2015/06/27 16:24:56.884 [00001]: [000024FC][iPokerHandGrabber] Session: 6457192740, HWND: 00010BFE
2015/06/27 16:24:57.450 [00566]: [000024FC][GrabberPipe] High mark is: 136
2015/06/27 16:24:57.450 [00000]: [000024FC][iPokerHandGrabber] Session: 6457192740, HWND: 00010BFE
2015/06/27 16:24:57.450 [00000]: [000024FC][iPokerHandGrabber] New Table: Speed Hold'em 3 [LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20] (€0.20 NL FAST (6 max))
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 1: Akingge
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 3: hovlaaaa
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 5: hevos5mih
2015/06/27 16:24:57.451 [00000]: [000024FC][iPokerHandGrabber] Seat 6: PISTONS55
2015/06/27 16:24:57.452 [00000]: [000024FC][iPokerHandGrabber] Seat 8: LastClock
2015/06/27 16:24:57.468 [00016]: [00001228][TableManager] Table found: 'Speed Hold'em 3' ([PTIODEVICE] LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20)
2015/06/27 16:24:57.469 [00001]: [00001228][TableManager] Hero for table 'Speed Hold'em 3' is 'LastClock'
2015/06/27 16:24:57.469 [00000]: [00001228][TableManager] Initial table refresh: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:57.469 [00000]: [00001228][TableManager] Refreshing table: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:57.566 [00097]: [00001228][ProfileManager] Hud Profiles loaded.
2015/06/27 16:24:57.566 [00000]: [00001228][ProfileManager] Profile: Cash - Default Priority: 0
2015/06/27 16:24:57.567 [00000]: [00001228][ProfileManager] Selected Profile: Cash - Default
2015/06/27 16:24:57.567 [00000]: [00001228][TableManager] Auto selected Profile: Cash - Default
2015/06/27 16:24:57.567 [00000]: [00001228][LayoutManager] Loading profile: iPoker - 6 max - Speed Cash | Cash - Default
2015/06/27 16:24:58.522 [00955]: [00001228][StatManager] Unable to use cache due to column: live_amt_stack (live_amt_stack)
2015/06/27 16:24:58.864 [00343]: [00001228][LayoutManager] Load Success: Cash - Default
2015/06/27 16:24:58.865 [00000]: [00001228][HudManager] Profile: Commands: 11284, Bytes: 766106
2015/06/27 16:24:58.865 [00000]: [00001228][LayoutManager] st: 3401 t: 1.30s p1: 929ms p3: 0.2119ms s: 406ms sc: 7ms st: 361ms sp: 3ms q: 366ms
2015/06/27 16:24:58.865 [00000]: [00001228][WindowUpdater] Setting profile: Cash - Default
2015/06/27 16:24:58.866 [00001]: [00001228][TableManager] Table refreshed.
2015/06/27 16:24:58.866 [00000]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 8
2015/06/27 16:24:58.866 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 5 (8), Preferred Seat: 3, Total Seats: 6, Offset: 4
2015/06/27 16:24:58.867 [00001]: [00001228][TableManager] Query [0]: SLOW, [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:58.867 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20' 1 queries)
2015/06/27 16:24:58.895 [00028]: [00001228][TableManager] Query Begin [0]: Channel: SLOW Priority: 33140, [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20
2015/06/27 16:24:58.895 [00000]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:24:58.895 [00000]: [00001484][Query] [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE (lookup_actions_p.id_action=cash_hand_player_statistics.id_action_p) AND (cash_limit.id_limit = cash_hand_player_statistics.id_limit) AND (player.id_player = cash_hand_player_statistics.id_player) AND (((cash_limit.flg_nl=true) AND (cash_limit.flg_lo=false))AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=1.01) or (hlrl.flg_nlpl=true and blind_to_usd[hlrl.limit_currency,hlrl.amt_bb]<=0.51)))))AND (((cash_hand_player_statistics.id_gametype=1))AND (cash_hand_player_statistics.id_player in (SELECT if[p.id_player_alias <> 0, p.id_player_alias, p.id_player] FROM player p WHERE ((p.id_site=400 AND p.player_name_search=E'akingge') OR (p.id_site=400 AND p.player_name_search=E'hovlaaaa') OR (p.id_site=400 AND p.player_name_search=E'hevos5mih') OR (p.id_site=400 AND p.player_name_search=E'pistons55')))))) GROUP BY (player.player_name_search), (player.id_site)
2015/06/27 16:24:58.895 [00000]: [00001484][Query] [EVY:LIFE:I$:33140]: LastClock: Speed Hold'em 3 - Texas Hold'em, No limit - €0.10/€0.20: Query execution time: 0.00623253 ms
2015/06/27 16:24:58.920 [00025]: [00001228][TableManager] Query Failure [0]: Unable to connect to database: PokerTracker 4 Database
2015/06/27 16:25:16.332 [17412]: [000024FC][iPokerHandGrabber] Speed Update Table: Speed Hold'em 3 Limit: €0.20 NL FAST (6 max)
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 1: harrycys
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 3: VKARTMANN10
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 5: RD709324
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 6: LastClock
2015/06/27 16:25:16.332 [00000]: [000024FC][iPokerHandGrabber] Seat 8: hevos5mih
2015/06/27 16:25:16.333 [00000]: [000024FC][iPokerHandGrabber] Seat 10: ReeblStribe
2015/06/27 16:25:16.526 [00193]: [00001228][TableManager] Table: Speed Hold'em 3, Hero: LastClock, Seat: 6
2015/06/27 16:25:16.526 [00000]: [00001228][TableManager] Table Rotation: Hero Seat: 4 (6), Preferred Seat: 3, Total Seats: 6, Offset: 5
2015/06/27 16:25:16.536 [00010]: [00001228][TableManager] Query [1]: SLOW, [EVY:LIFE:I$:33040]: Speed Hold'em 3
2015/06/27 16:25:16.536 [00000]: [00001228][TableManager] Retrieve: There are 1 queries pending (querying 'Speed Hold'em 3' 1 queries)
2015/06/27 16:25:16.610 [00074]: [00001484][Query::QueryThread] Thread [0x00001484]: Begin
2015/06/27 16:25:16.610 [00000]: [00001484][Query] [EVY:LIFE:I$:33040]: Speed Hold'em 3: Executing SQL (Thread): SELECT (player.player_name_search) as "str_player_name_search", (player.id_site) as "id_site_player", (sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])) as "cnt_hands", (sum(if[cash_hand_player_statistics.flg_vpip, 1, 0])) as "cnt_vpip", (sum(if[lookup_actions_p.action = '', 1, 0])) as "cnt_walks", (sum(if[cash_hand_player_statistics.cnt_p_raise > 0, 1, 0])) as "cnt_pfr", (sum(if[ lookup_actions_p.action LIKE '__%' OR (lookup_actions_p.action LIKE '_' AND (cash_hand_player_statistics.amt_before > (cash_limit.amt_bb + cash_hand_player_statistics.amt_ante)) AND (cash_hand_player_statistics.amt_p_raise_facing < (cash_hand_player_statistics.amt_before - (cash_hand_player_statistics.amt_blind + cash_hand_player_statistics.amt_ante))) AND (cash_hand_player_statistics.flg_p_open_opp OR cash_hand_player_statistics.cnt_p_face_limpers > 0 OR cash_hand_player_statistics.flg_p_3bet_opp OR cash_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])) as "cnt_pfr_opp", (sum(if[cash_hand_player_statistics.flg_f_bet, 1, 0])) as "cnt_f_bet", (sum(cash_hand_player_statistics.cnt_f_raise)) as "cnt_f_raise", (sum(if[cash_hand_player_statistics.flg_t_bet, 1, 0])) as "cnt_t_bet", (sum(cash_hand_player_statistics.cnt_t_raise)) as "cnt_t_raise", (sum(if[cash_hand_player_statistics.flg_r_bet, 1, 0])) as "cnt_r_bet", (sum(cash_hand_player_statistics.cnt_r_raise)) as "cnt_r_raise", (sum(cash_hand_player_statistics.cnt_f_call )) as "cnt_f_call", (sum(if[cash_hand_player_statistics.flg_f_fold, 1, 0])) as "cnt_f_fold", (sum(cash_hand_player_statistics.cnt_t_call )) as "cnt_t_call", (sum(if[cash_hand_player_statistics.flg_t_fold, 1, 0])) as "cnt_t_fold", (sum(cash_hand_player_statistics.cnt_r_call )) as "cnt_r_call", (sum(if[cash_hand_player_statistics.flg_r_fold, 1, 0])) as "cnt_r_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet, 1, 0])) as "cnt_f_cbet", (sum(if[cash_hand_player_statistics.flg_f_cbet_opp, 1, 0])) as "cnt_f_cbet_opp", (sum(if[cash_hand_player_statistics.flg_t_cbet, 1, 0])) as "cnt_t_cbet", (sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])) as "cnt_t_cbet_opp", (sum(if[cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])) as "cnt_f_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])) as "cnt_f_cbet_def_opp", (sum(if[cash_hand_player_statistics.enum_t_cbet_action='F', 1, 0])) as "cnt_t_cbet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])) as "cnt_t_cbet_def_opp", (sum(if[cash_hand_player_statistics.flg_p_3bet, 1, 0])) as "cnt_p_3bet", (sum(if[cash_hand_player_statistics.flg_p_3bet_opp, 1, 0])) as "cnt_p_3bet_opp", (sum(if[cash_hand_player_statistics.enum_p_3bet_action='F', 1, 0])) as "cnt_p_3bet_def_action_fold", (sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])) as "cnt_p_3bet_def_opp", (sum(if[cash_hand_player_statistics.flg_steal_att, 1, 0])) as "cnt_steal_att", (sum(if[cash_hand_player_statistics.flg_steal_opp, 1, 0])) as "cnt_steal_opp", (sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F', 1, 0])) as "cnt_steal_def_action_fold", (sum(if[cash_hand_player_statistics.flg_blind_def_opp, 1, 0])) as "cnt_steal_def_opp" FROM cash_hand_player_statistics , lookup_actions lookup_actions_p, cash_limit, player WHERE