+ Post New Thread
Results 1 to 15 of 15
Educational Software Thread, MRBS 1.4 and BST in Technical; We've been using MRBS at my school for several years with no real major issues. Got in this morning, however, ...
  1. #1

    Join Date
    Jul 2007
    Posts
    64
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    15

    MRBS 1.4 and BST

    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.

  2. #2

    rush_tech's Avatar
    Join Date
    Jul 2006
    Location
    Nottingham
    Posts
    1,408
    Thank Post
    111
    Thanked 265 Times in 201 Posts
    Rep Power
    194
    Thats funny exactly the same has happening here Slightly confused why this has happened

  3. #3

    Join Date
    Jul 2007
    Posts
    64
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    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?

  4. #4

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,401
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319
    Have you checked the time/date on the server?

  5. #5
    amvc's Avatar
    Join Date
    Oct 2007
    Posts
    136
    Thank Post
    39
    Thanked 14 Times in 12 Posts
    Rep Power
    18
    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

  6. #6


    Join Date
    Oct 2006
    Posts
    3,411
    Thank Post
    184
    Thanked 356 Times in 285 Posts
    Rep Power
    148
    Quote Originally Posted by amvc View Post
    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

  7. #7
    amvc's Avatar
    Join Date
    Oct 2007
    Posts
    136
    Thank Post
    39
    Thanked 14 Times in 12 Posts
    Rep Power
    18

  8. 2 Thanks to amvc:

    bonjour (30th March 2009), rush_tech (30th March 2009)

  9. #8

    Join Date
    Jul 2007
    Posts
    64
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    I did get it sorted in the end, but thanks for everyone's input. Much appreciated.

  10. #9
    mossj's Avatar
    Join Date
    Dec 2008
    Location
    Leicester
    Posts
    1,466
    Thank Post
    157
    Thanked 189 Times in 174 Posts
    Rep Power
    52
    Quote Originally Posted by bonjour View Post
    I did get it sorted in the end, but thanks for everyone's input. Much appreciated.
    How? it might be use for future refrence...

  11. #10
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,998
    Thank Post
    120
    Thanked 280 Times in 258 Posts
    Rep Power
    106
    Quote Originally Posted by mossj View Post
    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.

  12. #11

    rush_tech's Avatar
    Join Date
    Jul 2006
    Location
    Nottingham
    Posts
    1,408
    Thank Post
    111
    Thanked 265 Times in 201 Posts
    Rep Power
    194
    Go on be a devil tell us what you did!

  13. #12


    Join Date
    Oct 2006
    Posts
    3,411
    Thank Post
    184
    Thanked 356 Times in 285 Posts
    Rep Power
    148
    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";

  14. Thanks to j17sparky from:

    rush_tech (31st March 2009)

  15. #13

    rush_tech's Avatar
    Join Date
    Jul 2006
    Location
    Nottingham
    Posts
    1,408
    Thank Post
    111
    Thanked 265 Times in 201 Posts
    Rep Power
    194
    that did the trick cheers

  16. #14

    Join Date
    Mar 2009
    Location
    Essex/London
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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.

  17. #15

    Join Date
    May 2008
    Location
    Irlanda del Norte
    Posts
    36
    Thank Post
    10
    Thanked 1 Time in 1 Post
    Rep Power
    13
    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 <mail@ca...> - 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 <mail@ca...> - 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

SHARE:
+ Post New Thread

Similar Threads

  1. change GMT to BST on gentoo
    By RabbieBurns in forum *nix
    Replies: 3
    Last Post: 17th June 2008, 04:13 PM
  2. MRBS Help
    By Scotmk in forum Wireless Networks
    Replies: 5
    Last Post: 27th March 2008, 08:34 AM
  3. MRBS help
    By niknik in forum Web Development
    Replies: 0
    Last Post: 29th August 2007, 03:00 PM
  4. MRBS Help!
    By adamf in forum Network and Classroom Management
    Replies: 1
    Last Post: 22nd April 2007, 09:48 PM
  5. MRBS
    By j17sparky in forum Web Development
    Replies: 6
    Last Post: 17th November 2006, 03:11 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •