Scores are not updated

Thanks again. I am not really sure how to do that and do not have access at the moment to my database.

@grell

You can tell me what time it is said that the predictions were written by users and what time of departure. Both information can be found at Admin >> World Cup >> Predictions and Admin >> World Cup >> Teams and Matches.

I am in uk & so is server. I didd see that game times are 1 hour earlier than should be for me. Predictions also close 1 hour before kickoff time

Yes only bonus points failed to apply

@damian65

Tonight I release an update that will perform this task without having to access the database. Then I suggest you just let the participants that the correct score will be calculated in the next 24 hours.

Moreover, competition usually inform you organize it in Regulation. That scores are calculated within 24 hours. This prevents any kind of complaint when some unexpected problem occurs.

I Run first command and here is mysql error:
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ”{$wpdb->prefix}{$this->prefix}prediction’ CHANGE ‘wwhen’ ‘wwhen’ TIMESTAMP NOT ‘ at line 1
??

@pokerbanter

The matches starting an hour earlier was something that only happened in version 1.5. This was fixed in later versions.

In other words, I believe that your version is outdated.

I’ll try to release a fix tonight. I suggest you ask your patience and inform users that the correct score will be calculated in the next 24 hours.

@chmelka

Like I said, replace {$wpdb->prefix} and {$this->prefix} by prefixes that you are using in your database. This is defined in the file wp-config and world-cup-predictor.php file.

Just watch the tables of your database and see how they are called.

I dont know how replace. ??
Will be update what fix the problem?

I am definitely running version 1.9

@landoweb

The times are:

Admin >> World Cup >> Predictions = 2010-01-01 12:00:00

Admin >> World Cup >> Teams and Matches>>Matches = Last modified 2014-06-13 04:28:28

Thank you for all your help!

I suggest everyone who had problems with time they perform the upgrade to version 1.9.1.

@landoweb
Thank you

@grell

Please give a return stating if it worked, ok?

@landoweb

Today entered the first game’s (Brazil v Croatia) points for each user manually. When I put the second game’s score in it seemed to be working. That seems to tell me that there was a problem wit the first game only.

I will wait to enter the next game’s results (Greece/Columbia, England/Italy etc.). If it works I will not update. I will update of there is a problem again.

OK?

By the way, thanks again, and language caster.com will be giving a donation for your fantastic work!

Well, if you prefer, you can make the change directly in the database, it is a simple SQL command:

ALTER TABLE wp_wcup_prediction CHANGE wwhen wwhen TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

It serves only to remove the auto update of the prediction table, which prevents the allocation of bonus points depending on your time zone.