156 Posts
Hableur
7 years ago
12
Topic

Hello,

Joomla 3.8.1 Seblod 3.14.1

I made a Search Generic Field with two fields to search in : art_title and art_introtext. But when searching, the search is done in title but not in introtec=xt (only results with the searched word in title, not in introtext).

I tried many manipulations, but without success.

Have some body an idea ?

Thanks a lot.

Get a Book for SEBLOD
7 years ago
2
Level 1

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

7 years ago
1
Level 2

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

59 Posts
SemaphoreOxalis
3 years ago
0
Level 3

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 ?

3 years ago
3
Level 1

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.

59 Posts
SemaphoreOxalis
3 years ago
0
Level 2

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)

47 Posts
StanislavR
3 years ago
1
Level 2

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


59 Posts
SemaphoreOxalis
3 years ago
0
Level 3

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

3 years ago
1
Level 1

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.

59 Posts
SemaphoreOxalis
3 years ago
0
Level 2

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.

3 years ago
0
Level 1

Hi

SemaphoreOxalis,  

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

Regards.

3 years ago
0
Level 1

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

3 years ago
0
Level 1

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

Get a VIP membership