sql error when using Search for 'Any words' or 'Exact Phrase'

[cheesegrits]

It's a little harder than I'd hoped, but I should have a solution today.

-- hugh

 

[cheesegrits]

OK, hopefully this commit will fix it for you:

https://github.com/Fabrik/fabrik/commit/37df31e014e3c105d2b7bdf614cf5016e6eb6d9a

As mentioned before, you will probably have to create a fulltext index on any fields in other tables in the searchall. Let me know if you need help doing that.

-- hugh

 

[Borox]

Thanks Hugh, I test this fix and I'll let you know the result.

 

[Borox]

Hi Hugh,
I've done a complete Github update
I had a fulltext index on #__users.name , #__users.username and #__users.email

I works great for a ALL WORD search! Thanks
For ANY WORD and EXACT SEARCH I still have a 500 error but as I know now where the problemcomes from, I excluded the list using #__users from 'Joomla search' and no more error and the search works great! thanks Hugh, you're the king of Fabrik!

 

[cheesegrits]

Hmmm, not sure why it wouldn't work for those other modes, as I thought they just changed the term modifiers on the search value, didn't change the query at all.

How do I change that mode? I'm just using the search box, top right of your home page on my local copy of the site.

-- hugh

 

[Borox]

Hi, oh oh, just saw something wrong with the display of the lists ( look at the field 'Action'):


If I replace the file list.php by the previous version:

I've done a complete Github update yesterday, I don't think I messed up ( but it's always a possibility