I have a website on which I created a database existing of CCK nodes.
I also created a views-finder to search through these nodes.
I've added a multi-value checkbox element to it to list all the options for the field 'themas'.
When I set the finder field for this element to 'Content: Thema's (field_themas)' it works, but because the database has grown rather large it takes a long time to build the finder form. And there are several similar fields i need to add like this, and then opening the finder form causes a time-out on the webserver.
So i tried setting the finder field to 'Content: Thema's (field_themas) - allowed values' instead, thinking it wouldn't need to go over each node to build the list of options for this field, and use the list of allowed values that I defined in the cck-options for this field. But then I get the following table not found error:
user warning: Unknown column 'finder_table_2.field_themas_value_many_to_one' in 'field list' query: SELECT COUNT(*) FROM (SELECT DISTINCT node.title AS node_title, node.nid AS nid, node_data_field_regio.field_regio_value AS node_data_field_regio_field_regio_value, node.type AS node_type, node.vid AS node_vid, node_data_field_regio.field_stad_value AS node_data_field_regio_field_stad_value, node_data_field_regio.field_minleeftijd_value AS node_data_field_regio_field_minleeftijd_value, node_data_field_regio.field_maxleeftijd_value AS node_data_field_regio_field_maxleeftijd_value, finder_table_2.field_themas_value_many_to_one AS finder_field_1 FROM node node LEFT JOIN content_type_verwijsgids_instantie node_data_field_regio ON node.vid = node_data_field_regio.vid LEFT JOIN content_field_themas finder_table_2 ON node.vid = finder_table_2.vid WHERE (node.type in ('verwijsgids_instantie')) AND (finder_table_2.field_themas_value_many_to_one IS NOT NULL) ) count_alias in C:\xampp\htdocs\pvoc\sites\all\modules\views\plugins\views_plugin_pager.inc on line 141.
user warning: Unknown column 'finder_table_2.field_themas_value_many_to_one' in 'field list' query: SELECT DISTINCT node.title AS node_title, node.nid AS nid, node_data_field_regio.field_regio_value AS node_data_field_regio_field_regio_value, node.type AS node_type, node.vid AS node_vid, node_data_field_regio.field_stad_value AS node_data_field_regio_field_stad_value, node_data_field_regio.field_minleeftijd_value AS node_data_field_regio_field_minleeftijd_value, node_data_field_regio.field_maxleeftijd_value AS node_data_field_regio_field_maxleeftijd_value, finder_table_2.field_themas_value_many_to_one AS finder_field_1 FROM node node LEFT JOIN content_type_verwijsgids_instantie node_data_field_regio ON node.vid = node_data_field_regio.vid LEFT JOIN content_field_themas finder_table_2 ON node.vid = finder_table_2.vid WHERE (node.type in ('verwijsgids_instantie')) AND (finder_table_2.field_themas_value_many_to_one IS NOT NULL) LIMIT 0, 10 in C:\xampp\htdocs\pvoc\sites\all\modules\views\plugins\views_plugin_query_default.inc on line 1150.
There is no table "finder_table_2" in the database.
export of my finder: http://pastebin.com/5Chk2RxN
Any help on this issue is appreciated
Comments
Comment #1
savedario commentedHi there,
I am not sure about your error but, since I had to deal with multi-choice cck fields before, I think Finder does not (did not yet) deal with those.
I had to hack into the code and put one "ugly" patch to make it work.
Did you try to simplify your view/query to check that multi-choice are supported ?
TBC
Dario
Comment #2
danielb commentedNo more D6