Only the keyword search shows [#633514]

I've installed faceted search according to the instructions in the readme. The user has permissions to Lock Tables and Create Temp Tables, and everything generally seems to have gone smoothly. However, the only thing that shows up on our pages is the keyword search form (which does appear to work) - no guided search, no current search, no sort options, etc.

Couple things:

1) We're getting errors in watchdog:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY n.nid ASC ORDER BY score DESC' at line 1 query: CREATE TEMPORARY TABLE temp_faceted_search_results_1 (nid int unsigned NOT NULL, PRIMARY KEY (nid)) Engine=HEAP SELECT DISTINCT(n.nid) AS nid, 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) - 1257329885) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 0.0769230769231)) AS score FROM node AS n LEFT JOIN node_comment_statistics AS c ON n.nid = c.nid WHERE ((n.status = 1) AND (n.type IN ('gear_page'))) AND n.nid IN () GROUP BY n.nid ASC ORDER BY score DESC in /Library/WebServer/cd/sites/all/modules/faceted_search/faceted_search.inc on line 1174.

Followed by:

Table 'cd.temp_faceted_search_results_1' doesn't exist query: SELECT COUNT(*) FROM temp_faceted_search_results_1 in /Library/WebServer/cd/sites/all/modules/faceted_search/faceted_search.inc on line 1175.

This happens on every page load for pages we have faceted search blocks set up for.

the permissions in MySQL for this user are as follows:

mysql> SHOW GRANTS FOR CURRENT_USER;
+--------------------------------------------------------------------------------------------------------------------+
| Grants for nofrills_13@localhost                                                                                   |
+--------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON `cd`.* TO 'nofrills_13'@'localhost'                                              |
+--------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

2) We are calling the blocks from a Panels based layout (Panels 6.x-3.1) if this makes any difference. The pages on which we have the blocks installed are taxonomy term override pages in Panels, not node view pages.

3) Versions of stuff:
Drupal 6.13
Mysql 5.1.40
PHP 5.2.8
Faceted Search 6.x-1.0-Beta2
-Faceted Search
-Faceted Search UI
-Content Type Facet
-Faceted Search Views
-Taxonomy Facets

Any ideas?

Comments

Comment #1

vijoy CreditAttribution: vijoy commented 18 November 2009 at 06:56

I'm having the same issue though no errors are being thrown-- only the Keyword Search text box is displaying, nothing else. The funny thing is that I have an older D6.4 install with Faceted Search 6.x-1.0-beta1 working just fine with a different but similar set of data. Currently running on D6.14 with all other aspects of my environment being the same as the older, working instance.

I'm wondering if it's a better idea to roll back to the beta1 version or try the dev version.

Comment #2

friolator CreditAttribution: friolator commented 18 November 2009 at 17:46

we went down to beta 1, and it works. So this seems to be an issue specific to beta 2.

How stable is the dev version right now? can anyone confirm if this is fixed there?

Comment #3

friolator CreditAttribution: friolator commented 18 November 2009 at 17:46

Category:

support

» bug

changing to a bug report

Comment #4

vijoy CreditAttribution: vijoy commented 24 November 2009 at 23:22

I just downgraded to beta 1 myself and unfortunately the same behavior exists- only the Keyword search block shows up. Since my site is live, running the dev version is not attractive to me.

UPDATE: just tried the current dev version and same issue, only Keyword search block is showing. (24-Nov-09)

Comment #5

adrinux CreditAttribution: adrinux commented 26 November 2009 at 20:44

@vijoy are you using a taxonomy facet and is it hierarchical (child terms of parents)? One of my facets stopped appearing when I added a child term to a vocabulary, maybe your problem is similar?

Comment #6

vijoy CreditAttribution: vijoy commented 1 December 2009 at 00:33

@adrinux, thanks for the tip.

I just went through all taxonomies associated with the faceted search to ensure there were no hierarchical elements (we didn't design any from the outset, but maybe there was data entry error). We have 4 flat (non-hierarchical) taxonomies associated with a single content type.

In the FS environment we have all four taxonomy facets enabled along with the single content type to which they are associated. Sadly, with all the blocks configured appropriately, only Keyword Search displays. Current Search *will* display once a term is entered into the Keyword Search textbox, however Guided Search steadfastly refuses to join the party-- and it's the one we want the most.

Are there any known module incompatibilities associated with current versions of FS? On my D6.14 install, the only modules that are slightly out of date (as of 2009-Nov-30) is CCK (still on 6.x-2.5) and FCKeditor (6.x-2.0-rc2).

I do have Content Taxonomy installed (6.x-1.0-rc2) in case that might offer some added info.

And I'm using Faceted Search 6.x-1.x-dev (2009-Oct-13) in case there were some improvements over the beta versions. (still no luck.)

Comment #7

VasyOK CreditAttribution: VasyOK commented 2 January 2010 at 11:57

Version:

6.x-1.0-beta2

» 6.x-1.0-beta1

Hello people! I have this problem too.

Can anyone upload on this site module Faceted Search version beta1 ?

Comment #8

Coxus CreditAttribution: Coxus commented 16 February 2010 at 07:22

I have this problem too.
I see this error if select on "Display style" field other except Extras and Teasers.
This error not visible with Extras and Teasers field are selected

Comment #9

tobedeleted CreditAttribution: tobedeleted commented 5 March 2010 at 16:50

Version:	6.x-1.0-beta1	» 6.x-1.0-beta2
Priority:	Normal	» Critical

I'm seeing the exact same errors being generated when trying to access pages where the guided search block should be shown. I'm using the beta 2 version of Faceted Search on a D6.13 install. It has been working without fault for some months, and I've just noticed that is not working now. In the last few days i have installed the Flag module along with Views Carousel, and set up some new views on the site, but I don't think I've done anything else that might have triggered this error.

The guided search is an important element in this live site so this is a very real and present problem for me. Consequently very keen to get it resolved.

Update: I've just disabled the Flag module (version 6.x-1.2). Hey presto: my Guided Search block reappears. I'll check the Flag issue queue and if needed post an issue there also.

Comment #10

blawrenc3 CreditAttribution: blawrenc3 commented 6 April 2010 at 04:34

I do not have the flag module installed yet am also having this issue too.

I think it may be an issue with drupal core cause I have the most recent version of it and even when I disable everything it is not working.

upperholme could you please let us know what ur setup is cause it would help me out alot cause I need to have this working real soon.

Comment #11

jamesfk CreditAttribution: jamesfk commented 8 April 2010 at 15:50

Guys,

If you are using content taxonomy, are you making sure that the per field settings are set to store the taxonomy relationships in the core tables? If you don't do this Faceted Search can't see the relationships and won't show the guided search block.

This was my problem experiencing the same issues above anyway. Setting content taxonomy to store the terms in the core tables, and re saving all nodes sorted this for me - good luck!

@m4atif - the setting is under the field settings for the content taxonomy field, just tick the option - make sure you're using the latest release....