more than one row returned by a subquery used as an expressi

[jacques]

hi there, it have been a long time :)
I am not sure but i guess there's a pb with my DB...
when i try to go to view Stats, an error message occurs : "more than one row returned by a subquery used as an expression" any id to repair my db (vacuum analysis and etc done...
hope it can be resolved...
(EDIT) support is contacted) :/
here is what log said :

Code: Select all

2014/12/02 01:56:00.607 [00001]: [0000158C][Query::QueryThread] Thread [0x0000158C]: Begin
2014/12/02 01:56:00.608 [00001]: [0000158C][Query] Executing SQL (Thread): SELECT (tourney_summary.id_tourney) as "id_tourney_summary", (player_real.id_site) as "id_site", (tourney_summary.tourney_no) as "tourney_no", (tourney_summary.amt_buyin) as "amt_buyin", (tourney_summary.amt_bounty) as "amt_bounty_per", (tourney_summary.currency) as "tourney_currency", (tourney_summary.amt_fee) as "amt_fee", ((tourney_summary.amt_buyin) + (tourney_summary.amt_fee)) as "amt_buyin_fee", (timezone('UTC',  tourney_summary.date_start  + INTERVAL '0 HOURS')) as "tourney_date_start", (timezone('UTC',  tourney_summary.date_end  + INTERVAL '0 HOURS')) as "tourney_date_end", (tourney_summary.id_table_type) as "id_table_type", (tourney_summary.id_tourney_type) as "id_tourney_type", (tourney_summary.id_gametype) as "id_gametype_summary", (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               player player_real, tourney_results, tourney_summary WHERE  (player_real.id_player = tourney_results.id_player_real)  AND (tourney_results.id_tourney = tourney_summary.id_tourney)   AND (tourney_results.id_player = (SELECT id_player FROM player WHERE player_name_search=E'_enorme_'  AND id_site='2200'))        AND ((((tourney_summary.date_end >= '2014/12/01 03:00:00' and tourney_summary.date_end <= '2014/12/02 02:59:59'))))  GROUP BY (tourney_summary.id_tourney), (player_real.id_site), (tourney_summary.tourney_no), (tourney_summary.amt_buyin), (tourney_summary.amt_bounty), (tourney_summary.currency), (tourney_summary.amt_fee), ((tourney_summary.amt_buyin) + (tourney_summary.amt_fee)), (timezone('UTC',  tourney_summary.date_start  + INTERVAL '0 HOURS')), (timezone('UTC',  tourney_summary.date_end  + INTERVAL '0 HOURS')), (tourney_summary.id_table_type), (tourney_summary.id_tourney_type), (tourney_summary.id_gametype)
2014/12/02 01:56:00.610 [00001]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): Begin
2014/12/02 01:56:00.610 [00000]: [- Main -][ptQueryCtrlBase] ptQueryCtrlBase::doLoad(): End
2014/12/02 01:56:00.611 [00002]: [000011D8][Query::QueryThread] Thread [0x000011D8]: Begin
2014/12/02 01:56:00.612 [00001]: [000011D8][Query] Executing SQL (Thread): SELECT (date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-4 HOURS'))) as "__cal__date_played_grp", (count(distinct tourney_summary.id_tourney)) as "cnt_tourneys", (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=E'_enorme_'  AND id_site='2200'))         AND ((tourney_summary.date_start >= '2014/07/01 02:00:00'  AND tourney_summary.date_start <= '2014/08/01 01:59:59')) GROUP BY (date_trunc('day', timezone('UTC', tourney_summary.date_start + INTERVAL '-4 HOURS')))
2014/12/02 01:56:00.688 [00075]: [0000158C][PostgresConnection (Error)] Error: Unable to execute query: Fatal Error; Reason: Error:  (ERROR:  more than one row returned by a subquery used as an expression )
2014/12/02 01:56:00.688 [00000]: [0000158C][Query] Query execution time: 79.39971245 ms
2014/12/02 01:56:00.693 [00004]: [000011D8][PostgresConnection (Error)] Error: Unable to execute query: Fatal Error; Reason: Error:  (ERROR:  more than one row returned by a subquery used as an expression )
2014/12/02 01:56:00.693 [00000]: [000011D8][Query] Query execution time: 80.30590854 ms

[WhiteRider]

I believe that this issue is fixed for the next version, and we'll get back to you via your ticket when the fix is released.

[daddymou]

Hello there!

I just have the same problem with the same error message since a few days now......
"more than one row returned by a subquery useR"

Best,

daddymou

[kraada]

Are you using 4.12.1? If not please upgrade. If so, 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.

[daddymou]

Dear Kraada,

I'm now using the latest version of PT4. I'm not sure I've found the correct file but have a look at this:

[General]
RegistrationCode=[code removed]
FirstRun=N
RunCount=22
BuildDate=2014/11/25
[Database]
Default.Postgres.Server=localhost
Default.Postgres.Port=5432
Default.Postgres.User=postgres
Default.Postgres.Password=dbpass
DB1.Name=PokerTracker 4 Database
DB1.Type=postgres
DB1.Postgres.Database=PT4 DB
DB1.Postgres.Server=localhost
DB1.Postgres.Port=5432
DB1.Postgres.User=postgres
DB1.Postgres.Password=dbpass
DB1.Default=Y
[Import]
AutoStart.900=N
AutoStart.300=N
AutoStart.700=N
AutoStart.2100=N
AutoStart.600=N
AutoStart.200=N
AutoStart.100=N
AutoStart.2200=Y
[Players]
ActiveSiteID=2200
ActiveName=daddymou
[TableTracker]
GameIndex=0
HideTablesNoStats=N

Thank you and happy new year!

daddymou

[Flag_Hippo]

Please check your PM's.

- Rob

[zqMsxL]

Hello there,

I have the same problem since a bit of time but can't fix it :/
Could someone help me please?

Thanks in advance

[Flag_Hippo]

Can you please enable logging, reproduce this issue and send your log file to us in a Support Ticket:

Guide: How to Create & Submit a PokerTracker4.log File

You can access the 'Logs' folder with the log file by clicking 'File --> Open User Data Folder' in the main PokerTracker 4 window and the file we need is the text file called 'PokerTracker4' or 'PokerTracker4.log' that is in that folder.

[zqMsxL]

Thank you, just openned a ticket.

Thank you!