96 Posts
Hableur
3 years ago
10
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 VIP membership
3 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

3 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

42 Posts
SemaphoreOxalis
2 months 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 ?

14 days 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.

42 Posts
SemaphoreOxalis
14 days 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)

20 Posts
StanislavR
7 days 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


42 Posts
SemaphoreOxalis
6 days ago
0
Level 3

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

14 days 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.

42 Posts
SemaphoreOxalis
14 days 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.

8 days 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.

Get a VIP membership