Hi

I'm facing the same issue.

If you enable the debug mode for the list you will see seblod is performing the query (granted you entered 'token' ) :

t1.title LIKE '%token%' OR t1.introtext REGEXP "(::introtext::).*token.*(::/introtext::)"

in PHPmyadmin if you try the SQL query

SELECT * FROM `xxxx_content` WHERE introtext REGEXP "(::introtext::).*token.*(::/introtext::)"

you will be surprised it returns LESS results than

SELECT * FROM `xxxx_content` WHERE introtext LIKE "%token%"

Shouldn't be .... but this is what's happening ....

Cyril

Digging further I discovered that if you manually remove some CR characters in the introtext in PHPmyadmin the REGEXP query finds more results!

I'm not a REGEXP expert but it seems that performing a REGEXP "(::introtext::).*token.*(::/introtext::)" is not the right thing to do

Cyril

Same issue here 3 years later ! The REGEX don't return the article if the searched value is a second paragraph for example.

Any idea on how to solve that ?

Hi SemaphoreOxalis,

You said: The REGEX don't return the article if the searched value is a second paragraph for example.

So I presume that you are speaking about the Fulltext Field.

If you are using fields Introtext and Fulltext which come with SEBLOD and don't change anything about their storage, you must have that :

So simply add the 2 fields name in your Search Generic field, and that's all:

On this fild put the Match (3): Any Words

You will normally have that request:    

Now if you speak about other fields, feel free to share their storage.

Regards.

Hi lionel,

We already have bith intro and fulltext in the generic search. When we slightly modify the Regxp function (can't remember the exact modification we made) inside plugins/cck_storage/custom/custom.php we get the resultats we are looking for (so it's not a fields or not field question)

All settings are exactly the same

But the query returns 0 results, if MySQL is 5.5.5-10.3.22-MariaDB

And OK (72 items), if MySQL is 5.6.44-86.0

Very iInteresting but in our case we use MariaDB instead of Mysql...

Ok SemaphoreOxalis,   

So not sure to understand what you need here....

Perhaps 3 years ago the functionnality was buggy, but currently if you are using a clean installation of SEBLOD, the search on Custom stotage is ok.    

Regards.

Our seblod version is 3.17.4 (I d'ont see anything about generic search in changelog since this version).

You said : your issue probably come from you have not add fulltext inb your generic search. 

I answer by : we already had fulltext and intro text and if we change the regxp in the core file (it's not good I know but our client was quite upset about the search not working) we have better result.

Hi

SemaphoreOxalis,  

I would advice you to update SEBLOD on a development environnement and try again without hacking any files.    

Regards.

Hi

very weird that 3 years after the same issue remains because the query contains :

(t1.introtext REGEXP "(::introtext::).*mystring.*(::/introtext::)")) 

But the introtext does NOT start with (::introtext::) but with ::cck::xxxx::/cck::
::introtext::

and the introtext doe not ends with (::/introtext::) so it can't match

whichever matching criteria you use the regexp can't find any word in the introtext 

... unless there is some settings I forgot :(

Saba, can you give us your thought here ?

Thanks

Cyril

Actually the problem had been found almost 4 years ago on https://github.com/Octopoos/SEBLOD/issues/473