phpScheduleIt 1.2.12 trouble moving to new server : empty booking calendar

[Diatheke]

I'm trying to move phpScheduleIt from an older Debian server to an Ubuntu 10.04 LTS. Seems straight forward to me at first. Get all the underlying requirements in place (e.g. PEAR) and well as same time zone etc. Tar up the original directory and untar it on the new server. Mysql dump your original db and restore it on the new target server. Create db accounts with identical privs and permissions on both servers.

After doing all that it looks OK at first. Though there is something I just can't figure out. The booking calendar displays completely empty on the new server. Yet if I look on the schedule calendar or view system stats (admin function) everything appears to be in place on the new server.  On the new system with the empty booking calendar I go ahead and create a new reservation and it shows up on the booking calendar just fine then.

So my question is can anyone think of a reason why the booking calendar would be showing empty but the schedule calendar has all the reservations?

Thanks

[Diatheke]

I thought I'd mention briefly that this issue was also reported here:

http://php.brickhost.com/forums/index.php?topic=2845.msg5799#msg5799

I'm quite confident that both my source and destination system have the same time zone.

[Nick]

My initial thought is also that the time or timezones may be different.  If you still have access to the old server, try running the following script in both:

<?php
echo date('Y-m-d H:i:s e');
?>

If they're different by more than an hour we'll need to adjust the reservation times.

[Diatheke]

I looked at MySQL select now() output and unix date output from both servers and it was the same.

I found one minor difference on the systems and it appears to have fixed it for me.

On one system the php.ini file had the timezone value set (correct timezone) and the other system the timezone value was empty.

I made the timezone in the php.ini file empty and that resolved the issue for me.