Re: [MRBS-general] Summer Time

[Alexander J. S. [axs] <ax...@ab...>]

Hi Campbell,

Thank you for the speedy reply, I had to do this last year and have misplaced the SQL used.

The version of MRBS is 1.2.5

I ran grep timezone * inside my mrbs directory and the only reference to timezone was in Changelog.


I will play with your SQL statement which kindly supplied by running a few select statements to make sure I am updating the correct entries.

This is a great tool used by us for room and equipment booking.

Regards,

Sandy Spence
Department of Computer Science
Aberystwyth University
Penglais Campus
Llandinam Building
Aberystwyth
Ceredigion
SY23 3DB
Tel:  01970-622433
Fax: 01970-628536


From: Campbell Morrison [mailto:ma...@ca...]
Sent: 31 March 2010 16:33
To: 'General purpose list (support/developers/users)'
Subject: Re: [MRBS-general] Summer Time

There have been a few posts on the list about this in the last couple of days.   I'm copying one in below.

As a matter of interest, (a) which version of MRBS are you running?  and (b) what is $timezone set to, or is it commented out?

Campbell

-----

Ah - apologies, that's because this is a copy and paste from last  year and the first condition should refer to 2010.   So it should be


UPDATE mrbs_entry SET start_time = start_time - 3600, end_time = end_time - 3600 WHERE timestamp < '2010-03-28 02:00:00' AND start_time > UNIX_TIMESTAMP('2010-03-28 02:00:00') AND start_time < UNIX_TIMESTAMP('2010-10-31 02:00:00')



UPDATE mrbs_repeat SET start_time = start_time - 3600, end_time = end_time -3600 WHERE timestamp < '2010-03-28 02:00:00' AND start_time > UNIX_TIMESTAMP('2010-03-28 02:00:00') AND start_time < UNIX_TIMESTAMP('2010-10-31 02:00:00')

Except that you'll first have to reverse the 2 entries which were changed last time (these were booked before 29 March 2009) otherwise they'll now be an hour the other way!

In fact it's a little trickier than this, because I suspect that the problem only applies to bookings made in wintertime for summertime.    So if you have bookings made in summer 2009 they may well be OK.   You're probably going to have to do a bit of manual checking, or else add in a few more conditions to the SQL to get the timestamp interval correct.



From: Alexander James Spence [axs] [mailto:ax...@ab...]
Sent: 31 March 2010 16:11
To: mrb...@li...
Subject: [MRBS-general] Summer Time

Hi All,

I have been caught out again by the British Summer Time clock, now all my bookings have been moved on one hour since the change.  Last year someone kindly supplied an sql statement to fix the entries in the data base that had been made before the clocks moved on one hour, could that kind person resend the statement?

Thanks in advance,

Sandy Spence
Department of Computer Science
Aberystwyth University
Penglais Campus
Llandinam Building
Aberystwyth
Ceredigion
SY23 3DB
Tel:  01970-622433
Fax: 01970-628536