Hello
I use the seblod generic search. I want search the word „demo“, but I get no results.
The field art_fulltext is set in the generic serach field.
debug infos
SELECT t0.id AS pid,t0.pk AS
pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS
author,t0.author_session AS author_session,t0.cck AS cck,t0.storage_location AS
loc,tt.id AS type_id,tt.alias AS type_alias
FROM `#__cck_core` AS t0
LEFT JOIN `#__content` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t1.state = 1
AND t1.access IN (1,1,5)
AND ( t1.publish_up = '0000-00-00 00:00:00' OR
t1.publish_up <= '2019-03-13 18:18' )
AND ( t1.publish_down = '0000-00-00 00:00:00' OR
t1.publish_down >= '2019-03-13 18:18' )
AND t0.cck = 'content'
AND (((t1.introtext REGEXP
"(::fulltext::).*Demo.*(::/fulltext::)")))
ORDER BY t1.title ASC
LIMIT 25
What make I wrong?
If I use a like instead the REGXP I get a result in phpmyadmin.
It seems that you searched for Demo. - note the ending point. Regex is correct here as Seblod is using introtext field to store intro and full text, this is one of remains of the past. I suggest that you replace fultext field with a new wyswyg field with standard storage (where each field is stored in separate database column), than you won't experience this problems.
Thank you for your answer.
After I have replaced the storage, it works.