bonus points not updated

@mcbot, @addics, @chmelka

I suggest you upgrade to version 1.9.1 and then ask you to give feedback to let me know if the issue is resolved.

@jue_mue

Select one of your users to check what time the forecast for Brazil vs. Croatia. Then check what time the match Brazil vs. Croatia into your admin panel and tell me please.

@landoweb

User 1, prediction time (wwhen) : 2014-06-14 07:18:26 (the time a run the re-calculation)

Kick-off time Brazil – Croatia e.g. : 2014-06-12 20:00:00

@landoweb

Match Brazil – Croatia from the Admin panel showing the time last modified:

2014-06-13 11:04:49

@jue_mue

Strange. If the time the prediction is being recalculated, is a sign that the upgrade did not work for you. You did upgrade through the update page in WordPress?

Well in that case you need to run the two SQL commands that I mentioned earlier.

@landoweb

No, I run the upgrade by just replacing the files and re-run the score calculation as recommended by you

@landoweb

Syntax error

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”wp_wcup_prediction’ CHANGE ‘wwhen’ ‘wwhen’ TIMESTAMP NOT NULL DEFAULT CURRENT_T’ at line 1

@landoweb

MySQL version: 5.1.63-0+squeeze1 – (Debian)

@landoweb

Sorry, did not replace the quotes…

Will come back to you soon

@landoweb

Ok, it’s fine now. I run the SQL commands and re-calculated the scores… it worked.

Thanks a lot for your help. Time to donate ??

@landoweb

I entered the last results and recalculated scores – all userpoints are back to zero. Same Problem like before the update to 1.9.1.

I don′t now how o run SQL commands… ??

@tiiruff

Go to phpMyAdmin and run the commands in the SQL window. Don’t forget to remove the quotes!

I figuerd out how to run SQL commands but i got the same error as @jue_mue!

WTF is a backtick? Never heard before ??
How to make one??? ??

Just remove them by using the delete button and run the command again. It’s nothing special

should i remove the single quotes????