27 Posts
Yusuf
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

Get a VIP membership
8 years ago
1
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

27 Posts
Yusuf
8 years ago
0
Level 2

Hi Lionel,

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

Thanks for you time.

8 years ago
2
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

27 Posts
Yusuf
8 years ago
1
Level 2

Hi Lionel,

I think that was my mistake. However, I now get this error (image below) whenever a search is done? Where to fix that?

 

Thanks

27 Posts
Yusuf
8 years ago
0
Level 3

Hi,

I solved this by hidden the debug message.

Thanks

Get a Book for SEBLOD