Download & Extend
Views Fast Search » Issues

Getting malformed queries when using CCK fields for search input

Posted by randomswathe on June 12, 2008 at 7:47pm
Project:Views Fast Search
Version:5.x-2.0
Component:Code
Category:support request
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

Great module...I'm having a few problems which may not be bugs, but I can't seem to solve them. I am using fastsearch in conjunction with views_filterblock. I've created a input block at http://ibe.scribeproduction.com. There are a few instances when I get malformed queries when I search on certain words, characters, etc. For instance, when I search on 'baron' in the author field I get an error. Here is the query:

SELECT count(node.nid) FROM node node LEFT JOIN content_type_bep_title node_data_field_bep_author ON node.vid = node_data_field_bep_author.vid WHERE (node.status = '1') AND (node.type IN ('bep_title')) AND (UPPER(node_data_field_bep_author.field_bep_author_value) LIKE UPPER(''node'aron%'))

However, when I search on 'Baron' (capitalized) the query is formed properly. Also an issue with 'business' and 'Business' in the title field. Ideas?

Login or register to post comments

Comments

#1

Posted by slowlemur on August 26, 2008 at 12:16am

I'm seeing the same thing. It seems to be caused by that 'node' being inserted in the last UPPER(''node'aron%')). It looks like the lowercase 'b' is being replaced by 'node'. Oddly enough, I have the same EXACT problem, lowercase b being replaced...

#2

Posted by slowlemur on August 26, 2008 at 3:25am

After some more searching...I found this:

http://drupal.org/node/165611

It is not a problem with the views fast search, but with the views module. There is a patch that fixes the problem.

#3

Posted by randomswathe on September 3, 2008 at 4:25pm
Status:active» closed (fixed)

Thanks for passing this along, I never came across the patch when researching this issue. Applied the patch and all is well. Sorry for assuming this was a views_fastsearch issue!