Re: odd issues moving mrbs from 1 server to another
Borrow, Anthony S.J. <ABorrow <at> JESUITCP.ORG>
2006-08-04 01:01:43 GMT
I assure you there is at least one person out here and interested in what is happening with MRBS as I am using it
at our high school. Thanks for your work. Some of the mysql 5 issues I have seen have been related to strict
tables being enforced.
Peace - Anthony
-----Original Message-----
From: mrbs-general-bounces <at> lists.sourceforge.net on behalf of Matthew Fazakerley
Sent: Thu 8/3/2006 7:29 PM
To: General purpose list (support/developers/users)
Subject: Re: [MRBS-general] odd issues moving mrbs from 1 server to another
Hi all,
Not that there's anyone out there, but I found a solution.
Installed MySQL 4.0.20 instead of MySQL 5.
Repeat bookings work.
That's weird.
Matthew Fazakerley
IT Systems Support
Annesley College
CRICOS Provider No: 00357D
89 Greenhill Road, Wayville SA 5034
e: fazakerleym <at> annesley.sa.edu.au
w: www.annesley.sa.edu.au
p: 8422 2224
f: 8422 2237
Annesley College is a Uniting Church day and boarding school for girls.
________________________________
From: mrbs-general-bounces <at> lists.sourceforge.net
[mailto:mrbs-general-bounces <at> lists.sourceforge.net] On Behalf Of Matthew
Fazakerley
Sent: Tuesday, 1 August 2006 10:34 AM
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] odd issues moving mrbs from 1 server to another
Importance: High
Hi,
I'm migrating an mrbs install and data from a decommissioned server to a
new one, and am having some frustrating trouble!!!## <at> $ <at> !
The original install is on a Windows 2000 box,
Meeting Room Booking System <http://mrbs.sourceforge.net> - MRBS
1.1-pre1
Database: MySQL 4.0.16-nt
System: Windows NT OLDSERVER 5.0 build 2195
PHP: 4.3.4
I new installed on a Windows 2003 box
Meeting Room Booking System <http://mrbs.sourceforge.net> - MRBS
1.1-pre1
Database: MySQL 5.0.21-community-nt
System: Windows NT ZEUS 5.2 build 3790
PHP: 5.1.4
The issue is that when running on the new server, all existing bookings
from the old install are 10 hours out - ie a booking from 8.30 Friday 14
July morning to starting 22.30 Thursday 13 July night. This is
consistent with all bookings, however, those that were repeat bookings
have just disappeared.
I am using the same MRBS version on the new server currently, just to
make sure that data is working - which it's not!!! I tried the same
version of MySQL (see below)
When I export and import the mrbs mySQL database from 4.0.16-nt to
whatever version - when I install the 4.0.16 onto windows 2003 the
version changes to - 4.0.16-max-debug. whatever the case I get the same
issue I do with MySQL 5...
OK -
Installed PHP 4.3.4 instead of 5 - and all works fine - time and
existing repeat bookings reappeared. Looks like an incompatibility with
PHP 5....
Until... - can add new bookings, but repeat bookings do not work - no
entry is added. Using the n-weekly method, this does the first in the
series, and then nothing!
Any advice is greatly appreciated!
Matthew
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general