error after entering match scores

  • Hi Antoine

    I receive the following error after I updated match scores on the very first match. I had to place the site in maintenance mode… so… some timely assistance is greatly appreciated. (still running 2.10.3… didn’t want upgrade during the season). Thanks. D

    <div id="error"><p class="wpdberror"><strong>WordPress database error:</strong> [Subquery returns more than 1 row]<br><code>SELECT 
						user_id
						, SUM( full ) AS breakdown_full
						, SUM( toto ) AS breakdown_toto
						, SUM( goal_bonus ) AS breakdown_goalbonus
						, SUM( goal_diff_bonus ) AS breakdown_goaldiff
                        , SUM( IF( joker_used &gt; 0, full, 0 ) ) AS joker_full
                        , SUM( IF( joker_used &gt; 0, toto, 0 ) ) AS joker_toto
                        , SUM( IF( joker_used &gt; 0, goal_bonus, 0 ) ) AS joker_goalbonus
                        , SUM( IF( joker_used &gt; 0, goal_diff_bonus, 0 ) ) AS joker_goaldiff
						, SUM( joker_used ) AS jokers_used
						, (select um.meta_value from wp_5abc03afac_usermeta um where um.meta_key='store_location'  and um.user_id = user_id) as store
					FROM pool_wp_5abc03afac_scorehistory_s1_t1 
					WHERE ranking_id = 1 AND type = 0
					GROUP BY user_id 
					ORDER BY user_id ASC</code></p></div>
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author AntoineH

    (@antoineh)

    hi,

    This is caused by a customization in the query. Not something that I created.

    This is the culprit:

    (select um.meta_value from wp_5abc03afac_usermeta um where um.meta_key='store_location'  and um.user_id = user_id) as store

    Apparently, you have users that are linked to multiple stores. This is something you’ll need to fix (or the dev that did this customization).

    Thread Starter dtayl20

    (@dtayl20)

    Antoine

    Deactivating Football Pool Ranking Score Breakdown fixed the issue… but its removed a custom column that was necessary for my users? Any idea how I might add in a custom column in the rankings table??

    Thread Starter dtayl20

    (@dtayl20)

    Hi Antoine

    Thanks for the speedy reply. OK. I’ll search the the DB and find the duplicate. It was probably me during testing.

    Thread Starter dtayl20

    (@dtayl20)

    Hi Antoine

    I have another issue. I use the pickem style.

    The game tonight was a draw. I added in match results. All users should get one point. But after calculation ALL are still zero.

    Any ideas?

    Plugin Author AntoineH

    (@antoineh)

    I don’t think pickem style supports draws. There is only 1-0 or 0-1 in the predictions database and therefore a draw will always result in zero points. Unless you’ve also changed the pickem script of course.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘error after entering match scores’ is closed to new replies.