Scores are not updated

When you downgraded did all your data remain (players predictions etc)?

If so, how about trying downgrading to version 1.7

I am using version 1.7 and the scoring is now working fine.

data remain, problems too. ??

at least you haven’t lost the data when you downgraded, that would be a disaster. maybe try downgrading further to 1.7?

So does downgrading to 1.7 work (predictions not lost and scores updated)? If so would someone be able to share how to do this?
Thank you
Damian

@damian65,

Please indicate to what time zone you are.

Until version 1.7 of the plugin, there was a problem with the constraint update the score only if the predictions had been made ??prior to scheduled departure.

This has been fixed in version 1.8, but if you are reporting this problem, you may need to perform a new fix.

The most important is that the forecasts have been successfully saved. For once this correction is made??, you can update the ranking by Admin >> World Cup >> Predictions.

@chmelka

Please enter your timezone too, as well as their first installation was version 1.9, or if you installed a previous version and did the upgrade.

@tarmost

With respect to change the game automatically change the time of the forecast, this has been fixed in version 1.8 as follows:

In table prediction had the condition:

'wwhen' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

It was modified to:

'wwhen' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

And in the same admin.class wcp-file condition was included:

// Remove auto update from prediction table.
			if (!empty($installed_ver) && $installed_ver == "1.5") {
				$sql = "ALTER TABLE  <code>{$wpdb->prefix}{$this->prefix}prediction</code> CHANGE  <code>wwhen</code>  <code>wwhen</code> TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP";
				$wpdb->query($sql);
				update_option($this->prefix.'db_version', '1.8');
			}

I believe this ALTER TABLE failed. I’ll try to release a fix today, but if you want to get ahead, just do it directly in the database.

I have set wordpress UTC +2 and wordcup v1.9 UTC+3 v
And users doesnt have points.

@pokerbanter

Earlier you told to Euan the solution worked and then mentioned that you may need to manually make adjustments.

Please inquire if everything is working correctly for you or not.

My problem persists. Bonus scores didnt apply. I dont want to manually input bonus points for every prediction as its not practical.

Thank you for the reply.
I am not sure about the time zone – I have just deselected the time zone box in the settings mode but that had not helped. Sorry I am not really sure of this next step.

I was in Hong Kong when I set up the plug in.

@chmelka

Probably you should be passing the problem that had until version 1.7 of the plugin. You have access to your database? If so, I suggest you do the following:

First, run the command:

ALTER TABLE '{$wpdb->prefix}{$this->prefix}prediction' CHANGE 'wwhen' 'wwhen' TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

Replacing wpdb->prefix and this->prefix defined by prefixes on your site. In my case:

ALTER TABLE 'cup_wcup_prediction' CHANGE 'wwhen' 'wwhen' TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

Then run the command:

UPDATE 'cup_wcup_prediction' SET wwhen = '2014-05-13 11:20:19' WHERE match_id = 1

Then go to Admin >> World Cup >> Predictions >> Matches Score, select the match Brazil vs. Croatia and click the Score Selected button.

Note: the backticks in the names of tables and columns have been replaced by single quotes here because the formatting of the forum.

@damian65

If you were in Hong Kong, it is possible that your problem is the same as @chmelka. In fact, the most important is not your location itself, but to the server where the website is installed.

If you have access to the database, I suggest running the suggested command above to remove the option to auto update the prediction table.

@pokerbanter

In your case, only the bonus scores are not being applied?

I’ll check what may have occurred.