Excellent module!!

When I upgraded to version 5.x-0.10 today, I wanted to try out the Views integration. I ran update, created my view, selected the Display Style in faceted's admin area, ran a search and got:

user warning: Table 'ourdatabase.tcf_temp_faceted_search_results' doesn't exist query: SELECT count(node.nid) FROM tcf_node node INNER JOIN tcf_temp_faceted_search_results temp_faceted_search_results ON node.nid = temp_faceted_search_results.nid in /ourpath/www/includes/database.mysql.inc on line 172.
user warning: Table ourdatabase.tcf_temp_faceted_search_results' doesn't exist query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed FROM tcf_node node INNER JOIN tcf_temp_faceted_search_results temp_faceted_search_results ON node.nid = temp_faceted_search_results.nid LIMIT 0, 10 in /ourpath/www/includes/database.mysql.inc on line 172.

Thanks for any clues, would love to use the views integration feature.

Comments

mygumbo’s picture

mygumbo commented

Shouldn't there be a faceted_search_views.install file? If so, there's not one in the distribution I just downloaded.

david lesieur’s picture

david lesieur commented

Umm, I think the table prefix might be the issue. Normally, temporary tables are not prefixed, but it looks like a query is prefixing it with tcf_. This will have to be looked into...

david lesieur’s picture

david lesieur commented
Version: 5.x-0.10 » 6.x-1.x-dev

The problem lies in how Views handles JOINed tables. It does not distinguish temporary tables (which should not be prefixed) from persistent tables. I have posted a patch against Views.

david lesieur’s picture

david lesieur commented
Status: Active » Closed (duplicate)

See the workaround: http://drupal.org/node/227634#comment-864171.