By karl sf on

Drupal 5.1
Modules: CCK, Views, Calendar Views, Date.

I created a CCK content type Events, with custom 'date' field. I got the error below on the calendar pages.

QUESTION: Is it necessary to "add" a new view based on calendar to create a block with a calendar interface? It seems so to me. The calendar does not seem to do anything with only the default view (?).

Then I created a new view from calendar with the date field for a block in the right column. The calendar showed but clicking showed the error below above the calendar. NO events created were visible in the calendar.

I got a little lost in the new Calendar view settings, so I decided to start over. So I deleted the CCK Event type, deleted the Date field. I am still seeign the error below, but now on EVERY page. bummer. Help.

Again. Right now I have no Event CCK content type, no date field. I want to fix this error before trying again. Or do I need to recreate the field to start again?

Any ideas? Thanks much.
Has anyone got Calendar and Date working? I am not clear on how to use the Views with Calendar exactly. Does a view ('Add' from Views module) need to be created for each type of calendar page (list, event detail, month, day and so on)?

⋅ Categories: Drupal 5.x

Comments

karl sf’s picture

karl sf commented

user warning: Unknown table 'node_data_field_start_date' in field list query: SELECT node.nid, node.changed AS node_changed_changed, node.title AS node_title, node.changed AS node_changed, node_data_field_start_date.field_start_date_value AS node_data_field_start_date_field_start_date_value, node.type FROM nexusnode node WHERE (node.status = '1') ORDER BY node_changed_changed ASC LIMIT 0, 4 in /home/karl/public_html/home/d5/includes/database.mysql.inc on line 172.

coolin’s picture

coolin commented

Hi,
I have the same problem when using the module calendar ...
no solutions came since your post?

joachim’s picture

joachim commented

Same sort of problem here.
Subscribing :)

When I add my custom CCK date field as a field to the View, I don't see the same Handler options as for 'Node: Updated Time'. Instead of date-type options for the handler, I see 'Group multiple values'.
Looks like Calendar isn't recognizing CCK dates as dates.

joachim’s picture

joachim commented

Here's something weird.

I tried this on my local installation of Drupal, which was fairly fresh, I got it to work.
Here's what I did:

create custom content type
add date field (works with a dropdown select type, not sure any other)
clone the standard calendar (click 'add'
add a filter to get only custom content type
remove the field and the sort doodad, replacing with the date field.

I just went through the same steps on my site's Drupal (same version, same modules, everything), and got the error above.

The only difference was that I had defined several Date fields on my site, for use in other content types (eg I had a 'Job advert' with a listing start and job start, and I'd made two fields.

I've just delede the Job advert content type, leaving the 'Event' content type I just made as a test.
And now it works.

So it looks like the problem comes from having more than one date field.

joachim’s picture

joachim commented

Scratch that.
I re-created my Job Advert content type, which needs several date elemeents, and accidentally created a new date field instead of reusing the existing one.
It still works.

The only other thing I can think of that was different before was that I'd created one of date fields as a range.