Moving phpScheduleIt to new server

[desertbabe]

Hello - I am very new to mySQL - my office needed a resource calendar and I found that phpScheduleIt met our needs.
I put the trial run on a free webhost server and have recently moved it to a paid webhost server.  Herein lies the problem.  I can install the software part of the program and the new version looks identical to the old one.

I have re-created the database using setup.sql, as instructed, in a new install and then exported (from the old database) the data and imported (into the new database).  BUT all the days are off by -1!  Can't find the bug.  All the reservation dates, users, resources etc carried over, but when looking at the bookings on MyCalendar or ScheduleCalendar they are all off by -1 day (Sunday is displayed on Saturday, but with Saturdays date) but on MyReservations they are shown correctly.

I spent 3 hours today with siteground.com working on this - they couldn't find it.  I uninstalled the whole lot, cleared my cache and rebooted and then started all over again - same problem.  Days are off by -1.

I am really frustrated.  I want to move the database off the free server (for support and security reasons) but can't go live until this problem is sorted out.

NOTE1:  I did a new software install phpScheduleIt 1.2.10, copied the files that we had modified so the software is customized the same - worked fine, no problems.  I used setup.sql to create the new database tables (created 15 tables) and then tried to register a new user - 'jos_user table not found' - no go.

NOTE2: the free server is phpMyAdmin 3.1.1 and mySQL 5.0.51a and the new server is phpMyAdmin 2.11.6 and mySQL 4.1.22 - don't know if this is the problem ??

I am sure this is basic but not being a programmer I can't see what I have missed.

Does anyone have any ideas?  Cheers, Ellie

[desertbabe]

OK - panic over (almost) it was a simple fix after all - I changed the TimeZone in config.php and it moved everything to where it should be (however, in Asia/Riyadh we don't have DST so I'll have to manually change it to +3 from +4 when the clocks change???)

MyCalendar and ScheduleCalendar works fine - but roscalendar.php is blank   I can't find how to fix this now.  It's not really a big deal since it's read-only and the users have to log in to place a reservation, but it's a nice feature to have.

I found this:

<?php
date_default_timezone_set('Asia/Riyadh');

$script_tz = date_default_timezone_get();

if (strcmp($script_tz, ini_get('date.timezone'))){
    echo 'Script timezone differs from ini-set timezone.';
} else {
    echo 'Script timezone and ini-set timezone match.';
}
?>

and think it might help, but can't find my php.ini and if I did, I am not sure where to put the script.  Any ideas?  I am a secretary, who noodles around, not a programmer :-)

Cheers, Ellie

[Nick]

Unfortunately, if the server is hosted somewhere that observes DST, you will need to change your timezone when DST starts/ends.

This will be fixed in phpScheduleIt version 2.0, though.

For your script, you can just throw it into any file with .php as the extension and within a web-accessible directory on your server.

You can also view the settings of your php.ini file by creating the following script:

Code:

<?php
phpinfo();
?>