Jump to:
| Project: | Date |
| Version: | 6.x-2.0 |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
Drupal 6.10
Calendar 6.x-2.0
CCK 6.x-2.1
Date 6.x-2.0
Views 6.x-2.3
PHP 5.2.6
I have created a calendar view for "activities" that I defined by adding a CCK date field to the typical content type. I use granularity month and the timezone Europe/Paris (site).
I understand that entering an "Activity" with "start date" = "end date" and time = 00:00 describes a whole day event. This works for almost any date.
However if the date is the first of a month during the summer time period the activity is not appearing in the view.
Looking at the case of 1st May, I see that the date stored in the database is: 2009-04-30T22:00:00. This looks like the correct UTC time.
I also see that the where clause in the select statement is:
WHERE
((node.status <> 0) AND (node.type in ('activity')))
AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'),
SEC_TO_TIME(3600)), '%Y-%m') <= '2009-05'
AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'),
SEC_TO_TIME(3600)), '%Y-%m') >= '2009-05'))adding only one hour to the date stored in the database (i.e. the time difference for the winter time). And, of course, the 1st of any month during summer time is not selected.
Is it realy a bug or have I done something wrong?
I attach the view and the content type exports.
| Attachment | Size | Status | Test result | Operations |
|---|---|---|---|---|
| view.txt | 11.08 KB | Ignored: Check issue status. | None | None |
| activity.txt | 3.57 KB | Ignored: Check issue status. | None | None |
Comments
#1
Not sure if anyone has looked into this, but I'm experiencing the same problem described by rkessi. All-day events don't show up on the monthly calendar if they fall on the first day of the month.
For the moment, I'm just working around it by assigning a specific time rather than creating an all day event.
My setup:
Drupal 6.15
Calendar 6.x-2.2
CCK 6.x-2.x-dev
Date 6.x-2.4
Views 6.x-2.8
PHP 5.2.8
#2
#3
Has anyone been able to resolve this problem? I'm having exactly the same issue. I'm working around it by using the same method as khenney, but I'd be happier if I could fix the problem. Thanks.