Update1: The booked time is displayed correctly, but the begin and end times are still 2 hours off. I checked the mysql database, but the times in the database are correct. I think the problem is that in J1.5 with Seminar the times in the database were stored as CET and now in J2.5 with Matukio the times are stored as UTC. Since J2.5 now thinks that the stored time is UTC (while it in fact is CET), it automatically ads 2 hours, thus creating the 2 hour time offset.
Update2: Since times are now stored in UTC instead off CET all times in the mysql database for Matukio need to be updated when you imperted data from Seminar. To do so, execute this sql statement (in phpMyAdmin) (
replace vlgf5 with your own prefix):
UPDATE vlgf5_matukio SET begin = DATE_SUB(begin, INTERVAL 2 HOUR);
UPDATE vlgf5_matukio SET end = DATE_SUB(end, INTERVAL 2 HOUR);
UPDATE vlgf5_matukio SET booked = DATE_SUB(booked, INTERVAL 2 HOUR);
You can test the code by executing this statement to see if it does what you want before you make any changes.
Also, always backup you database before executing mysql statements!
SELECT begin, DATE_SUB(begin, INTERVAL 2 HOUR) FROM vlgf5_matukio;
