Time Slot Calendar does not work

You changed the argument to reflect your Date CCK; did you also change the field?

You should not have to add the field to the view, so that is a bug. The different behavior between rc6 and 2.0 is that rc6 added a field in the background, but that creates problems when you try to combine multiple values so that had to be changed.

This is a good report that provides a lot of info that will help me debug this, but I also need to know more info about the date field you created -- what is the granularity and what timezone settings are you using?

My View with upcomming dates is not working anymore.

Settings see Attach1

Output of the query

SELECT node.nid AS nid,
   node_data_field_date.field_date_value AS node_data_field_date_field_date_value,
   node_data_field_date.nid AS node_data_field_date_nid,
   node.type AS node_type,
   node.title AS node_title
 FROM node node 
 LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid
 WHERE (node.type in ('calendar', 'calendar_internal'))
    AND (DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m-%d') > '2009-01-01')
   ORDER BY node_data_field_date_field_date_value ASC

Note that the now-1day gets '2009-01-01'

Changing the settings to a fixed date: Attach2

Now the query look like:

SELECT node.nid AS nid,
   node_data_field_date.field_date_value AS node_data_field_date_field_date_value,
   node_data_field_date.nid AS node_data_field_date_nid,
   node.type AS node_type,
   node.title AS node_title
 FROM node node 
 LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid
 WHERE (node.type in ('calendar', 'calendar_internal'))
    AND (DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m-%d') > '2009-03-03')
   ORDER BY node_data_field_date_field_date_value ASC

The date is now correct.
It looks like some problem with the Relative value is not used.

Hope this helps

BTW: I'm on PHP 5.2.8

/B

@arlinsandbulte: Sorry if I made a mix-up. I posted here because http://drupal.org/node/386296 (calendar events disappear after upgrade) #30 by KarenS referrer to this node. Thank you for the link!

/B

I also have this problem with very similar settings.

Also, I have two different date fields, but there is no way for me to differentiate them in Views - they both appear as Content: -value, so I don't know which one I choose.

Confirming the bug and the fix and that the issue's title as of March 11 "The argument date field must also be added to View Fields or Calendar does not work" was easy for me to find and enabled me to work around the bug.

Thanks, this worked for us!

No offense intended or implied, KarenS, but should this really be flagged a ".0" release? I'm getting lots of emails from clients of mine who are breaking sites because Drupal recommends an upgrade to this release, and their websites are getting killed because of it.

Is it possible to roll back a release and have Drupal not suggest an upgrade? It seems like that might be prudent.

Doesn't look fixed yet, so changed back to active.

I ran into this trouble just now during an upgrade. I am using the current versions of CCK and Views, and dev versions of Date and Calendar as of today, and I am still required to both change the date argument to key from the CCK date value AND add the same CCk date field to the view itself (and of course tell the view to omit this from the display).

It's not a lot of trouble to apply this workaround, but it would be unfair to call it fixed. This is where the update module is actually hurting Date module users as Ed Ropple pointed out.

When this actually gets resolved, I'll update my screencast to reflect any changes.

I was going nuts until I found this post. The documentation should definitely be updated to reflect this until it gets resolved... thanks, all.

That fixes the calendar/date problems I had before. I still have "Content: Error: missing title" in my views tho :(

The fact you have to add the date as a field at all is frankly unbelievable. Not trying to point fingers at all; if it's necessary, that's fine - but the logic behind it totally escapes me as a user. I would never in a million years thought to do that, and I wasted a lot of hours trying to fix it yesterday.

On the positive side, I can now go and close another issue that I opened yesterday which definitely relates directly to this problem. IMO though, this should be flagged up BIG TIME in a readme or on the calendar project page until it's fixed.

Thanks.

I could not reproduce the problem in this issue but I can't tell if anyone reporting this had the problem in -dev or just in 2.0. I did run into an error if the field was missing and committed a fix for that and with that change I see no problems in the latest -dev code.

As to the questions about rolling back releases, that would re-introduce other bugs that the release fixed, that makes no sense. I had a lot of people pressuring me to get a release out to fix their problems in the previous code, but every release potentially opens up new, different problems. So now you guys want me to get a new release out to fix *your* problem, which will possibly introduce other new issues, and I will get a new slew of complaints about releasing it.

Never the less I am planning a new release after I make some passes through the latest issues because there are a couple significant bug fixes that need to get into an official release.

I am still having this problem - however the work around still "works" - reluctantly change the setting to "Active".

I'm not sure if the issue was set to "fixed" because there's a good work around, anyway, I just wanted to report that the issue is still occurring.

In my setup, Calendar events spanning multiple days will only appear on the start date unless I add a date field to the view. When I add a date field the event will appear on the calendar as expected (except now I've got the extra text of the date from/to information showing).

I have been through all the troubleshooting steps and have read the full thread.

Fresh installs of:

Using:
cck 6.x-3.1-rc1
calendar 6.x-2.x-dev
date 6.x-2.x-dev
and
Views 6.x-2.5

Cache's emptied

In my calendar view the settings are:
Argument: date: granularity of Month, date field: start date From date, method "or"
Export of view attached.

Thank you!

Alright, here is what is going on and why. When you create a calendar view without a date field, the date value is not added to the query. The only values that are available to the calendar are the fields you add, like the node title. The calendar picks up the list of nodes that matched the query and has to figure out which 'date' cell to put them in. At that point it has to know the event date to do its calculations. Without that information it has no way to know where the node belongs.

The reason this is a change from the earlier version is that in the earlier version the calendar automatically added the date field to the view. That was removed because it wasn't needed in every view (list views didn't need that info, for instance) and having the field there all the time could create unwanted duplicate values. I didn't notice that when I fixed that problem I introduced the possibility of having a calendar item that was missing any date value.

But it is now obvious that the calendar style will have to either require or supply the date field. I think it is better for you to add the date field so that you can see it and decide if you want to display it or not, instead of the old method of silently adding a field you didn't put there.

This is only needed in the calendar styles because the calendar style has to sub-allocate the values by date.

So I need to add some documentation and a validation test to be sure it's there.

Actually, this is a Calendar issue anyway.

I tried two different paths, going back to silently adding the field and adding a validation error and explanation if it was missing, and the second option is much cleaner and more bug-free. So that is committed.

Thanks KarenS - the explanation (in an error message) to add the date field to the field list helped me fix my view - good solution :)

when i copy booking_timeslots/theme/ to my theme directory then calender month view is not shown and week view contain "book now option" for only 4 days. day view option is working properly. i am trying it from last 3 days please anybody help me.
i have attached screenshot with my issue.

Please don't re-open old closed issues with new problems, especially when you already posted another issue about the same thing.