MRBS 1.4 and BST

[bonjour]

We've been using MRBS at my school for several years with no real major issues.

 

Got in this morning, however, to find that no bookings were displaying from today onwards (i.e. post clocks moving forward).

 

All bookings from before the weekend are OK, and if I go into a recurring booking and save it then it will appear right the way through to the end of the recurrance once more. I've now done this for all of our recurring bookings, but this doesn't help for the many single bookings that have been made, which are no doubt still in the database but not being displayed.

 

I'm just wondering if anyone else has experienced any problems with the latest MRBS 1.4 following the move into British standard time, using periodical bookings rather than time.

 

Cheers.

[rush_tech]

Thats funny exactly the same has happening here:confused: Slightly confused why this has happened:confused:

[bonjour]

I've looked into it a bit further, and the bookings appear OK if (through SQL) I alter the start time entry back by an hour (so to start at 11.00 rather than 12.00 GMT for e.g).

 

There's no way I'm doing that for every booking, so I'll see if I can work out some SQL to do it for me.

 

Serves me right for jumping to 1.4 without it being thoroughly tested.

 

Anyone else had this happen?

[webman]

Have you checked the time/date on the server?

[amvc]

Are you signed up to the MRBS-General mailing list? There are others that are having the same problems today. I can post the address if you are not.

 

Jon

[Guest Guest]

Are you signed up to the MRBS-General mailing list? There are others that are having the same problems today. I can post the address if you are not.

 

Jon

 

Yes please, ive got the same problem

[amvc]

https://lists.sourceforge.net/lists/listinfo/mrbs-general

 

jon

[bonjour]

I did get it sorted in the end, but thanks for everyone's input. Much appreciated.

[mossj]

I did get it sorted in the end, but thanks for everyone's input. Much appreciated.

 

How? it might be use for future refrence...

[ChrisH]

How? it might be use for future refrence...

 

Yes please give an answer this will rank highly on a google search and will end up a dead end.

[rush_tech]

Go on be a devil tell us what you did!

[Guest Guest]

You have to change all the timestamps. Use the following code in phpmyadmin on the SQL tab of the appropriate database

 

UPDATE mrbs_entry SET start_time = start_time - 3600, end_time = end_time - 3600 WHERE timestamp < '2009-03-30 09:00:00' AND start_time < "1256428800" AND start_time > "1238288400";

[rush_tech]

that did the trick cheers

[cjackson]

Just noticed this problem myself, instead of changing the results in mysql, I tried this at the top of the config file: putenv ("TZ=GMT"); which forces the timezone back.

[diagram]

I'm not a spokesperson for the MRBS developers, but the following is off their mailing list:

 

SourceForge.net: Meeting Room Booking System: mrbs-general

 

[MRBS-general] DST problems

From: Campbell Morrison - 2009-04-08 14:08

 

Attachments: Message as HTML

So far I'm not aware of anyone running MRBS 1.4.1 that has had problems with bookings following the DST change. If you have had problems and are running 1.4.1 (and were running it before the DST change) then please shout, because at the moment I believe that all DST problems are fixed in 1.4.1 ....

 

Campbell

 

The fix they give is related to an earlier version. From an earlier thread:

 

Re: [MRBS-general] FW: MRBS showing wrong time after clocks wentforward

From: Campbell Morrison - 2009-04-08 14:02

OK - that makes sense. There were some problems in 1.2.3 to do with DST.

If you've just got a small number of bookings you could edit them manually.

Otherwise the only way to rectify the problem is by running an SQL query to

correct them.

 

First of all make a back up of your database!

 

Then run the following two queries:

 

UPDATE mrbs_entry SET start_time = start_time - 3600, end_time = end_time -

3600 where WHERE timestamp < '2009-03-29 03:00:00' AND start_time >

1238292000

UPDATE mrbs_repeat SET start_time = start_time - 3600, end_time = end_time -

3600 where WHERE timestamp < '2009-03-29 03:00:00' AND start_time >

1238292000

 

This will look for all bookings made before the summertime change for times

after the change and move them back an hour. Note that it assumes that

you haven't got any bookings after summer time ends in October. If you

have, you'll need a slightly different query.

 

In the longer term I'd recommend upgrading to MRBS 1.4.1 where to the best

of my knowledge the DST problems are fixed.

 

Campbell

 

If your problem relates to the most recent version, maybe you ought to contact them. I don't run any version of MRBS myself at the moment