+ Post New Thread
Results 1 to 15 of 15
Web Development Thread, MRBS Random DB issue in Coding and Web Development; I have decided to put the MRBS system that we currently use on our intranet online to the world. However ...
  1. #1
    mossj's Avatar
    Join Date
    Dec 2008
    Location
    Leicester
    Posts
    1,466
    Thank Post
    157
    Thanked 189 Times in 174 Posts
    Rep Power
    52

    MRBS Random DB issue

    I have decided to put the MRBS system that we currently use on our intranet online to the world.

    However when I tried to do this it misses random bookings out, nothing has changed from the original install (apart from the DB section of the config file ^_^).

    The bookings it misses are constant and don't go in/out of existance nor do they disappear. I have checked the databases against each other and they both show the same amount of records (it's large @ 16,000 records in one & 1,500 records in the other) so i don't think its that....

    Was wondering what you guys think it is? could it be host related? or a change of mysql version?

    p.s I used navicat lite to do the mysql dump/import

  2. #2

    Join Date
    Dec 2005
    Posts
    535
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    The only time I have seen mrbs forget bookings it when there has been a change in time on the server.

    It happened to me when I switched from BST to GMT. So is there are difference between times in the hosts?

    Which exact bookings are missing?

    I solved mine by changing my server to UTC time (I think that's what its called) so it doesnt now switch between GMT and BST.

  3. Thanks to siuko from:

    mossj (21st April 2009)

  4. #3
    mossj's Avatar
    Join Date
    Dec 2008
    Location
    Leicester
    Posts
    1,466
    Thank Post
    157
    Thanked 189 Times in 174 Posts
    Rep Power
    52
    The servers could i suppose (its on a shared host) be on different times, does that cause it to lose random bookings, and not the whole lot?

    Anyone know what TZ csnewmedia's servers are on?
    Last edited by mossj; 21st April 2009 at 06:29 PM.

  5. #4

    Join Date
    Dec 2005
    Posts
    535
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    Sadly it would normally be the whole lot.

    But its the only time I've seen it lose bookings.

    Sorry if its not any help.

  6. #5


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,690
    Thank Post
    352
    Thanked 796 Times in 715 Posts
    Rep Power
    347
    Check for yourself? - Add a new booking and see what time it comes back with.

    They are UK based (traceroute) so it's plausible the change is causing an upset but seems unlikely to have only affected certain bookings unless they were scheduled to start/end at 00:00hrs which might cause it to scream and die.

  7. Thanks to kmount from:

    mossj (21st April 2009)

  8. #6
    mossj's Avatar
    Join Date
    Dec 2008
    Location
    Leicester
    Posts
    1,466
    Thank Post
    157
    Thanked 189 Times in 174 Posts
    Rep Power
    52
    I can place bookings in the same place as the missing ones, so I don't think its a TZ issue... also (for anyone elses info) there on gmt

    Does anyone know a way to find out something unique about the entry (IE convert the start time into the series of numbers stored in the DB), so i can check if it exists...
    Last edited by mossj; 21st April 2009 at 07:27 PM.

  9. #7


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,690
    Thank Post
    352
    Thanked 796 Times in 715 Posts
    Rep Power
    347
    I know you said the db's were the exact same size, can you locate said booking ANYWHERE in the db? Seems very odd indeed.

  10. Thanks to kmount from:

    mossj (21st April 2009)

  11. #8
    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 kmount View Post
    I know you said the db's were the exact same size, can you locate said booking ANYWHERE in the db? Seems very odd indeed.
    This is what im looking into now, but I need something unique to look for (name or user isn't enough), 16000 records ^_^

    start time + user would be but start time is stored as some *seemingly* random numbers...

  12. #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
    hmm according to the hosts technical support the servers are on GMT (i was wrong..) , whilst the old server was on BST.

    Do you think this could be the issue? any way to check/solve?
    Last edited by mossj; 21st April 2009 at 07:31 PM.

  13. #10


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,690
    Thank Post
    352
    Thanked 796 Times in 715 Posts
    Rep Power
    347
    I wouldn't have thought so mate; best thing I can suggest is crack on and see if any new appointments made on the new server disappear.

  14. Thanks to kmount from:

    mossj (21st April 2009)

  15. #11
    mossj's Avatar
    Join Date
    Dec 2008
    Location
    Leicester
    Posts
    1,466
    Thank Post
    157
    Thanked 189 Times in 174 Posts
    Rep Power
    52
    Sorted it ^_^ I won't bother telling you what it was but if you have more than two brain cells it shouldn't matter....

  16. #12


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,690
    Thank Post
    352
    Thanked 796 Times in 715 Posts
    Rep Power
    347
    Happens to the best of us, glad it's resolved though

  17. Thanks to kmount from:

    mossj (21st April 2009)

  18. #13

    Join Date
    Dec 2005
    Posts
    535
    Thank Post
    34
    Thanked 89 Times in 79 Posts
    Rep Power
    39
    Go on mossj tell us what it was please

    It always helps to know fixes for things even if they are obvious.

  19. #14

    Join Date
    Jan 2008
    Posts
    99
    Thank Post
    6
    Thanked 18 Times in 14 Posts
    Rep Power
    17
    Just in case it's useful to anyone, times in MRBS are stored as [ame="http://en.wikipedia.org/wiki/Unix_time"]UNIX/POSIX[/ame] (seconds since the "epoch" in January 1970!).

  20. #15
    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 siuko View Post
    Go on mossj tell us what it was please

    It always helps to know fixes for things even if they are obvious.
    I backed up the database a week earlier and that was the database I was uploading/checking

SHARE:
+ Post New Thread

Similar Threads

  1. MRBS Help
    By Scotmk in forum Wireless Networks
    Replies: 5
    Last Post: 27th March 2008, 08:34 AM
  2. Random GPO issue
    By edie209 in forum Windows
    Replies: 8
    Last Post: 14th September 2007, 12:18 PM
  3. MRBS Help!
    By adamf in forum Network and Classroom Management
    Replies: 1
    Last Post: 22nd April 2007, 09:48 PM
  4. MRBS
    By j17sparky in forum Web Development
    Replies: 6
    Last Post: 17th November 2006, 03:11 PM
  5. Software Installation Policies - random issue
    By CM786 in forum Wireless Networks
    Replies: 4
    Last Post: 2nd October 2006, 02:12 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
  •