By aeolus.cleanslate on

I'm developing a site for a community that scheduled lots of events. I've installed and am using

Core 6.17
CCK 6.x-2.7
Calendar 6.x-2.2
Views 6.x-2.11

I've created a Content Type called Event, for which I've created a field called "Start Date" (known in the DB as field_startdate) of Type "Date". I've successfully created content for the event, and it seems to be working fine at the node level.

So now I want a View that displays upcoming events, and in that view I want to display the start date and time. The view seems to work great, until I try to add field_startdate. When I do that I get an error in the Fields section that reads:
Broken/missing handler: node_data_field_startdate > field_startdate_value
I've never seen this error before, and I can't find more than a reference or two in Drupal.org or Google searches. I imagine that what I'm trying to do is not particularly uncommon, and I can't imagine why following this straightforward path leads to such a weird error.

I'd be happy to recreate the missing handler, but am not certain at all how to do so, nor what I'd be creating if I tried. But it seems silly to dig that deep for something so normal. There must be something simple I'm doing/ not doing that will fix the problem. Any ideas?

⋅ Categories: Drupal 6.x

Comments

aeolus.cleanslate’s picture

aeolus.cleanslate commented

Digging further, it appears that when I try to export the view, it has a portion in it that seems to reference a table: 

 'field_startdate_value' => array(
    'id' => 'field_startdate_value',
    'table' => 'node_data_field_startdate',
    'field' => 'field_startdate_value',
  ),
  'field_startdate_value2' => array(
    'id' => 'field_startdate_value2',
    'table' => 'node_data_field_startdate',
    'field' => 'field_startdate_value2',
  ),

... only the node_data_field_startdate table doesn't seem to exist. Shouldn't it have been created when I created the content type? Should I create the table by hand?

There is a table called content_field_startdate, which contains the start/end times of my events perfectly well. Why, when I add Content: Start Date (field_startdate) - From date in the view, doesn't the view handler reference that table?

lsiden’s picture

lsiden commented

I'm running into exactly the same problem after upgrading from D5 to D6. Looks like some tables that needed to get created when converting from D5 to D6 didn't get created. How did you resolve it? Is there a script that you needed to run?

Heidi Fiscus’s picture

Heidi Fiscus commented

Any word on this. Happening for me now...

Subscribing

mannos’s picture

mannos commented

I'm having the same issue... or at least the same symptoms. I just found it; no telling how long it's been there.
Core 6.19
CCK 6.x-2.9
Views6.x-2.12