[Plugin: All-in-One Event Calendar] Change from summer time to winter time in Europe (Berlin)

Monday morning after the clocks have changed from summer time and all of my event times have changed back by 1 hour.

I have had to correct with:

UPDATE wp_ai1ec_event_instances
SET
start = DATE_ADD(start,INTERVAL 1 HOUR),
end = DATE_ADD(end,INTERVAL 1 HOUR)

UPDATE wp_ai1ec_events
SET
start = DATE_ADD(start,INTERVAL 1 HOUR),
end = DATE_ADD(end,INTERVAL 1 HOUR)

I’m new to WordPress.. Where does one add the above code to fix this problem with the clock after the end of British Summer Time? Thanks

Hi pandalu,

The above is a correction SQL query that needs to be run once in database administration (eg. phpmyadmin)

Had the same problem. Will it be corrected wirh tehe next update? This would be better, then I will work around in the database myself…

9:00am is 9:00am, Summer-time or Winter-time!

There should never be cause to change event times, past or future, when the clocks are changed. The fix therefore, will be to not change times so it is likely that the above queries will need to be run to correct data which, by the time the fix is implemented, most people will have already changed.

I don’t know why – but the events times went back an hour on the calendar when the clocks went back. I have manually returned them to what I originally inputted but I don’t understand why they were re-set if WP timezone is set to London (appears to take account of end of BST automatically)

I have no experience of editing PHP and only recently started to use WP with plug-ins, have not yet looked as the database end of things!

Just been caught out by the same issue. Fortunately it’s a new site so only a couple of entries in the diary.
But, would like to see the developers fix this too.

I can confirm that this is fixed in our trunk. We will have the new version released soon.

That works! Thx