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.
21st April 2009, 07:18 PM #1
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
21st April 2009, 07:23 PM #2
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.
21st April 2009, 07:27 PM #3
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 07:29 PM.
21st April 2009, 07:28 PM #4
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.
21st April 2009, 07:32 PM #5
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.
21st April 2009, 07:43 PM #6
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 08:27 PM.
21st April 2009, 08:05 PM #7
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.
21st April 2009, 08:13 PM #8
This is what im looking into now, but I need something unique to look for (name or user isn't enough), 16000 records ^_^
Originally Posted by kmount
start time + user would be but start time is stored as some *seemingly* random numbers...
21st April 2009, 08:28 PM #9
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 08:31 PM.
21st April 2009, 08:44 PM #10
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.
21st April 2009, 08:59 PM #11
Sorted it ^_^ I won't bother telling you what it was but if you have more than two brain cells it shouldn't matter....
21st April 2009, 09:01 PM #12
Happens to the best of us, glad it's resolved though
22nd April 2009, 09:46 AM #13
Go on mossj tell us what it was please
It always helps to know fixes for things even if they are obvious.
22nd April 2009, 08:16 PM #14
- Rep Power
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!).
22nd April 2009, 08:24 PM #15
I backed up the database a week earlier and that was the database I was uploading/checking
Originally Posted by siuko
By Scotmk in forum Wireless Networks
Last Post: 27th March 2008, 09:34 AM
By edie209 in forum Windows
Last Post: 14th September 2007, 01:18 PM
By adamf in forum Network and Classroom Management
Last Post: 22nd April 2007, 10:48 PM
By j17sparky in forum Web Development
Last Post: 17th November 2006, 04:11 PM
By CM786 in forum Wireless Networks
Last Post: 2nd October 2006, 03:12 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)