There's been some fairly large updates to views in the latest alpha release (also a security release).

Unfortunately, this breaks my views based faceted search. I've tried everything superficial...

rebuild fs index
clear cache
clear views cache
run cron

Next level was to create a simple new view and test that.

No joy.

This issue solved getting views to show up in the results drop down...

http://drupal.org/node/792752

Beyond that I'm stumped.

Is anyone else having problems with 6.x-3.0-alpha3? Or no problems with 6.x-3.0-alpha3?

Thanks,
mike

Comments

mpaler’s picture

mpaler CreditAttribution: mpaler commented
Title: Support for 6.x-3.0-alpha3? » Support for Views 6.x-3.0-alpha3?

change title

mpaler’s picture

mpaler CreditAttribution: mpaler commented
Title: 6.x-3.0-alpha3 breaks faceted search views » Support for Views 6.x-3.0-alpha3?
mpaler’s picture

mpaler CreditAttribution: mpaler commented
Title: Support for Views 6.x-3.0-alpha3? » 6.x-3.0-alpha3 breaks faceted search views

making the title slightly more urgent to attract attention.

Doing some debugging, I've been able to uncover one difference in the faceted search query object b/w 6.x-3.0-alpha1 (which works with FS as expected) vs alpha3.

Doing a print_r on $query towards the bottom of execute() in faceted_search.inc just after module_invoke_all (line 1170'ish)

for alpha1 (works) the subquery looks like this:

$query->subqueries[default][0]['n.nid IN (SELECT DISTINCT node.nid AS nid FROM {node} node WHERE node.type in ('%s', '%s', '%s') )'];

whereas alpha3 the subquery looks like this

$query->subqueries[default][0]['n.nid IN (SELECT DISTINCT node.title AS node_title FROM {node} node WHERE node.type in ('%s', '%s', '%s') )'];

I believe the problem is in function query_alter in faceted_search_views.module but I'm not enough of a views expert to solve.

(note:this is based on a simple test view that selects just node title).

--

A little more info from execute()

$this->_results_count = db_result(db_query('SELECT COUNT(*) FROM '. $this->_results_table));

Is returning FALSE

mpaler’s picture

mpaler CreditAttribution: mpaler commented

Is anyone else having this problem?

mpaler’s picture

mpaler CreditAttribution: mpaler commented
Title: Support for Views 6.x-3.0-alpha3? » 6.x-3.0-alpha3 breaks faceted search views

It appears the real problem is in function query_alter in faceted_search_views.module

$views_query = db_rewrite_sql($view->build_info['count_query'], $view->base_table, $view->base_field, array('view' => &$view));

The query returned from views 2 vs 3 is vastly different.

salientknight’s picture

salientknight CreditAttribution: salientknight commented

I see the last post in this thread was from June 2010. Has this problem been addressed yet? I've having a number of bugs related to Views 3 with faceted search and cannot find any solutions :)

mpaler’s picture

mpaler CreditAttribution: mpaler commented

I gave up as it requited way too much noodling with Faceted Search module. Planning on migrating to ApacheSolr & ApacheSolr Views.

sstose’s picture

sstose CreditAttribution: sstose commented

I'm having the same problem, as I need it to expose sorting (only in Views 3). But in that case, neither does it seem to (?) allow for exposed filters in Views 2, after all I've tried.

This module is great! I reverted back to it in D6 after futzing around with D7 and VPS Solr/Lucene options, including out-of-box Search Lucene API module (which doesn't allow me to use Views...). The best part about it is it allows faceted *browsing* in Views, not just faceted search results.

If PHP were up to scratch (it isn't), I'd love to contribute. Just a shout out to thank you for module, good work, and I hope to see more updates!