Good Morning,
I'm stuck here and wanted to ask if anyone here has an idea how I could solve the problem.
Basics:
PHP 5.6.36
MySQLi 5.5.59
J! 3.8.6
Seblod 3.15.0
I have created a page with different groups of people, which are listed differently. Since I wanted to have all but one in a DB, I did it through Groups, which are now addressed differently. Everything works fine. Now I wanted to do a search, but no matter how I want to do it, I always get: "Message: there is no result"
So first the template changed, joomla cache deactivated and reactivated, menu newly created, seblod search modules and services de- and reactivated, the whole list & search newly created. Now I have tentatively chosen Article as a format in the menu and lo and behold, I also have the same problem here.
The debug report for finding how it should be like is:
SELECT t0.id AS pid, t0.pk AS pk, t0.pkb AS pkb, t0.parent_id AS parent, t0.author_id AS author, t1. *, T2. *, 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 `#__ cck_store_form_stammdaten` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__ content` AS t2 ON t2.id = t0.pk
LEFT JOIN `#__ cck_core_types` AS tt ON tt.name = t0.cck
WHERE t2.state = 1
AND t2.access IN (1,1,2,3,6,7,8,9,10)
AND (t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2018-08-01 03:43')
AND (t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down> = '2018-08-01 03:43')
AND t0.cck = 'master data'
AND t1.surname_sd LIKE '% Kohn%'
ORDER BY t2.title ASC
SELECT COUNT (t0.id)
FROM `#__ cck_core` AS t0
LEFT JOIN `#__ cck_store_form_stammdaten` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__ content` AS t2 ON t2.id = t0.pk
LEFT JOIN `#__ cck_core_types` AS tt ON tt.name = t0.cck
WHERE t2.state = 1
AND t2.access IN (1,1,2,3,6,7,8,9,10)
AND (t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2018-08-01 03:43')
AND (t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down> = '2018-08-01 03:43')
AND t0.cck = 'master data'
AND t1.surname_sd LIKE '% Kohn%'
0.016 seconds (0.016); 21.69 MB (21,687) - afterSearch [Cache = ON] = 0 result.
0.016 seconds (0.000); 21.69 MB (0.003) - afterRender
The debug report for the Articel search:
SELECT t0.id AS pid, t0.pk AS pk, t0.pkb AS pkb, t0.parent_id AS parent, t0.author_id AS author, 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,2,3,6,7,8,9,10)
AND (t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2018-08-01 04:30')
AND (t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down> = '2018-08-01 04:30')
AND t0.cck = 'article'
AND t1.title LIKE '% Allina%'
ORDER BY t1.title ASC
LIMIT 25
0.027 seconds (0.027); 21.71 MB (21.709) - afterSearch [Cache = OFF] = 0 result.
0.027 seconds (0.000); 21.71 MB (0.003) - afterRender
The search words are naturally present in both databases.
Does any of you have any suggestions for me?
LG C