Scores not working

@ba1udze

Resolved. The user in question had 191 points because he had already received points for future matches (for example, Brazil vs. Mexico).

At some point you have tried to resolve the error score running some SQL command to assign the points correctly? That’s the only explanation for why this has occurred, perhaps with some missing in the WHERE condition of this command given.

@biancoweb

Let me know if you upgraded to version 1.9.1 and now everything is working properly.

Hi there, I updated plugin and did as you instructed and now all points went to 0,
https://deporteaenpractica.com.ar/ranking/

And no info is showing on the Predictions by match and by user pages,
https://deporteaenpractica.com.ar/predicciones-por-partido/
https://deporteaenpractica.com.ar/predicciones-por-usuario/

@biancoweb

After updating the plugin, you accessed Admin >> World Cup >> Predictions >> Score Matches and asked to recalculate the points? If you have not, I suggest you do so now.

Yes, that’s exactly what I did and it went to 0 points for all users.

Probably the upgrade did not work for you then. You have access to the database? For the best alternative is to solve this by running two simple SQL commands that solve the problem:

ALTER TABLE wp_wcup_prediction CHANGE wwhen wwhen TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

And:

UPDATE wp_wcup_prediction p INNER JOIN wp_wcup_match m ON m.match_id = p.match_id SET p.wwhen = DATE_SUB(m.kickoff, INTERVAL 1 HOUR)

This task was that the upgrade should have done.

Yes! It worked! Thank you!
Now, these other pages are still not working, should I just forget about this? Or is there a shortcode I can use?
https://deporteaenpractica.com.ar/predicciones-por-partido/
https://deporteaenpractica.com.ar/predicciones-por-usuario/

After creating these pages you must access Admin >> World Cup >> Overview and select them in “Page by Match Predictions” and “Page Predictions of User”. After doing so, when the user is viewing your page ranking for example, a magnifying glass will be displayed and clicking on it you will see the score obtained in the matches.

@landoweb, I have upgraded to 1.9.1 and some player points have gone to zero for some matches. The same issue as above but I really don’t understand your fix – I don’t know how to run an SQL command…?? Any help?

@euan01

Do you execute de command below?

ALTER TABLE wp_wcup_prediction CHANGE wwhen wwhen TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

Visit your admin panel and check what time the prediction of one of the users in the match Colombia – Greece and what time of match in the table match.

I don’t know how to execute that command. I have almost zero knowledge of SQL.

Colombia – Greece has scores correctly. the only scores that have not worked are Chile – Australia and Spain – Netherlands (all players got zero points for those two games). all other games have scored correctly.

Chile – Australia predication made at 2014-06-14 13:19:43
Chile – Australia time of match 2014-06-13 22:00:00