Search generic Plugin not working

8 years ago

Topic

Hi,

I recently purchased Search Generic plugin to enable search across multiple fields on my form.

However, after adding the Search Generic search bar and setting things accordingly, it didn’t work as expected. It redirect to "500 Internal server error" url on the server (...index.php?cck=individual_form&searchgeneral=test&boxchecked=0&search=searchng&task=search).

May be am missing something? Any help will be appreciated.

Below is a snap shot of what i have done for buttons 1, 2, and 3.

Thanks

Button [1] - Label+Validation

Button [2] - Life+Life value

Button [3] - Match+Stage

756 Posts

Octopoos - Lioneladministrator

8 years ago

Level 1

Hi Yusuf,

can you show us the configuration of the Search Generic field? (on which fields you are searching)

Is the "search type" is configured to perform a search on different content types?

Regards.

Lionel

Yusuf

8 years ago

Level 2

Hi Lionel,

Here is the configuration of the Search Generic field ==>

Thanks for you time.

756 Posts

Octopoos - Lioneladministrator

8 years ago

Level 1

Hi Yusuf,

it's an SQL error that you have.

AND (
    t1.title LIKE '%plop%' 
    OR t1.introtext REGEXP "(::ng_amount::).*plop.*(::/ng_amount::)" 
    OR 
    OR t1.introtext REGEXP "(::ng_date_collected::).*plop.*(::/ng_date_collected::)" 
    OR t1.introtext REGEXP "(::ng_date_of_payment::).*plop.*(::/ng_date_of_payment::)" 
    OR t1.introtext REGEXP "(::ng_purchase_reason::).*plop.*(::/ng_purchase_reason::)" 
    OR t1.introtext REGEXP "(::ng_seller_name::).*plop.*(::/ng_seller_name::)"
    ) 
<br>

It seem that you are searching in the field "ng_buttons_indcomp" which don't have any stockage.

Have a look on this side.

Regards.

Lionel