error after entering match scores

(@dtayl20)

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)

3 years, 2 months ago
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)

3 years, 2 months ago

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)

3 years, 2 months ago

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)

3 years, 2 months ago

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)

3 years, 2 months ago

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.