Re: UK BST DST Issue
2011-04-01 10:17:05 GMT
Thanks for your helpful reply Campbell. Can I just clarify that this will deal OK with series (repeat) bookings that span beyond BST into GMT? That's the purpose of the second part right?
revmarkp
Yes – you should set $timezone to “Europe/London”. It won’t solve the problem of your existing entries, but will ensure that future bookings don’t suffer the same problem. To correct the existing bookings, *backup your database first* and then run a script such as:
UPDATE mrbs_entry SET start_time = start_time - 3600, end_time = end_time - 3600 where WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP('2011-03-27 02:00:00') AND start_time < UNIX_TIMESTAMP('2011-10-30 02:00:00');
UPDATE mrbs_repeat SET start_time = start_time - 3600, end_time = end_time -3600 where WHERE timestamp < '2011-03-27 02:00:00' AND start_time > UNIX_TIMESTAMP('2011-03-27 02:00:00') AND start_time < UNIX_TIMESTAMP('2011-10-30 02:00:00');
Tailor the script to meet your requirements. This one will correct all bookings made before the change that were made for this summer. Obviously if you’ve got bookings for next summer or beyond you’ll need to run another script.
There are known issues with 1.2.1 and DST changes – not sure why you’ve only just come across them. 1.4.6 should be free of DST issues (apart from one minor problem to do with making bookings for the day of DST changes, which has been fixed in the trunk and the fix will appear in 1.4.7).
Campbell
From: Mark Pengelly [mailto:markshop <at> pengelly.info]
Sent: 31 March 2011 09:22
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] UK BST DST Issue
I am UK based. We make a DST change from GMT to BST (British Summer Time, spring and autumn...)
After change to BST last saturday night (26-03-11) bookings within the BST period *showed* as one hour later (ie a 9.00am start time showed as 10.00am).
I upgraded MRBS upgraded as a result (v 1.2.1 is from 2003, I am a longtime happy user!).
1.4.6 has a php variable for getting Daylight Saving Time correct. $timezone = "Europe/London"; didn't appear to work; it results in the BST entries still being an hour out. (GMT, winter ones unnafected).
However $timezone = "GMT"; *appears* to solve the issue.
Sent this Q to my webhost: Is there anything I should know about the way time is configured on your servers that would confirm that this is an appropriate solution?
Obviously I am concerned about things running smoothly with future DST time changes...
Is it possible that our BST times are not really set right? If so we should consider using the correct timezone and running a script to correct the BST entries perhaps? Not sure why this would have been highlighted now though, it certainly hasn't been an issue each DST change??
Thanks for any insights, revmarkp
thecrossing.co.uk/bookings
------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
--
Mark Pengelly
Worksop
Notts.
------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________ mrbs-general mailing list mrbs-general <at> lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mrbs-general Want to unsubscribe: mailto:mrbs-general-request <at> lists.sourceforge.net?subject=unsubscribe
RSS Feed