Events from specific two-week span not displaying

[ianc]

PHP version: 5.1.6
Database server and version: MySQL 5.0.27
Web server and version: Apache/2.2.2 (Fedora)
Browser vendor and version: All
phpScheduleit: 1.0.1 & 1.2.5

Description of bug:

Events with start dates from 3/12/2007 through 4/1/2007 are not displaying in the schedule view.  However, they do display in the MyCalendar view.  I've downloaded the records and compared those that do display with those that do not and cannot find any consistent differences that might point to why events with start dates from that time period do not display.  I've also examined the php files .  Events prior to 3/12/2007 and those after 4/1/2007 are visible.  

I looked at create dates and user ids to see if there were any commonalities among the non-displaying events and did not find any.  If I open and  save each non-displaying event, the event will then display correctly within the schedule view.

Thanks for your help.

[mspijker]

phpScheduleIt version:     1.2.5
Database backend:    mysql
Database name:    phpscheduleit
PHP version:    5.0.4
Server OS:    Apache/2.0.54 (Linux/SUSE)
Browser: all

I have a similar problem. I can't see the user names and description in the bookings calender with a schedule that has a timespan of 2 hours or more. The bookings are only indicated by the light blue color. The blackout descriptions are also shortened to 15 characters with the last 3 "..." If I change the timespan to 1 hour, everything works fine.
At mouseover, the username and description are always displayed properly in the bookings calender regardless of the time span. In the schedule calender things are also displayed correctly regardless of the time span.

I changed the possible time spans to: {30, 15, 60, 120, 180, 240, 300} in templates/admin.template.php

Menno

[Nick]

1) Was the time or timezone of the server changed?

2) This is a bug with how the hover text is displayed.  I'm hoping to have it fixed in the next release.

[ianc]

The server time setting may have changed to reflect daylight savings.

[Nick]

I haven't heard of daylight savings affecting this before, but I suppose it is possible.  Just to clarify, if you create a new reservation between those dates, it is not showing on the schedule?

[ianc]

If I create the event it shows.  Plus, if I modify the event via the reservation page, it will revert to displaying.  However, if I simply update the modified date via a sql query from the db backend, the records remain hidden.  Also, when I review the page source, the events are not there.  This only occurs in the schedule view and does not impact the calendar view.

[kathyb]

We love this program...but when I updated my server for the daylight savings time change the reservations that were displaying on the my bookings page disappeared but were still in the database and displaying on the calendars - the only way I could have them display again in the my booking section was to modify each reservation (6000+) in the manage reservation section. AND my bookings section would allow a new reservation to be added even though an old one was still active in other parts of the program - if anyone has a quicker solution than modifying the reservations one by one, please share.

[Nick]

There is a script in testing now for fixing both the DST and other time issues.  If anyone has control over their database and can easily make a backup to test the script on, I'd be happy to send it to you.  Please contact me directly for this.

[tsewen]

I tested the patch, and the patch seems to be working fine.  However, there is a side effect that anyone who uses it should know: Because overlapping reservations could actually be made in the three-week time span from 3/12 to 4/1, after the fix, some events are displayed incorrectly in the Bookings UI, but once you click on the event, you get the correct times.  Thanks for the quick patch!

[camilosl]

I am having the same problem. Some reservations are not being displayed in the bookings UI (schedule.php) , but they are in the database and I can see them in the schedule calendar UI (rescalendar.php). Please let me know how can I get this patch. Thanks a lot.

Camilo S

[Nick]

Please contact me directly for the patch, at this point.  I will be making it publicly available very soon.