SUPPORT TICKET [HOB-93241]

5.7.5 Error: Search Filter = Faceted

Error if category is selected that has a business in that category

HY000 SQLSTATE[HY000]: General error: 3685 Illegal argument to a regular expression.

How to reproduce

I can now confirm that this error is the result of 5.7.5 and the specific setting of J-BusinessDirectory > General Settings > Business Listings > Search > Search Filter = Faceted

Select categories = Select all categories available

The setting does work correctly in version 5.7.4

I think what you describe, or maybe something similar,  has been around for a while, see here:

   - Example #1:  J-BusinessDirectory - Table headers disappear (cmsjunkie.com)

   - Example #2: J-BusinessDirectory - 5.7.5 Error: Search Filter = faceted (cmsjunkie.com)

   - Example #3: J-BusinessDirectory - Internal Menu Not Working (cmsjunkie.com)

JBD's July 04, 2022 Changelog also indicates recent improvements to the "faceted" Search Filters:

   "Improvements

      Improve the faceted category display

      Changed faceted condition to AND"

- See Here: J-BusinessDirectory v5.7.5 stable released (cmsjunkie.com)

I think what most administrators do is just NOT use the "Faceted" General Setting.

Instead, try using the "Regular" setting NOT "Facted" as it obviously does not work?

- Image URL: https://imgur.com/a/yR6KuZq

I appreciate your information here. Faceted is a necessary feature so users can select multiple categories, resulting in a more refined search.

And you are correct, I just checked and the bug is indeed not working on older versions as well. When I was rolling back it was changing my setting that's why I thought it was working on older versions.

Hopefully, they can fix this as it is a significantly important search feature.

Are you testing in PHP8 or PHP7?

On my ticket, they said they are making a patch sometime next week.

I am using PHP7 currently but that reminds me to update. I'll do that and check back in if there is any difference.

I'm now running 

no difference on the setting, same error