23 Posts
cassirer
6 years ago
3
Topic

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

Get a VIP membership
4229 Posts
Kadministrator
6 years ago
2
Level 1

I don't know if you noticed, but there is an empty space in '% Kohn%' and  '% Allina%'  

23 Posts
cassirer
6 years ago
1
Level 2

Dear Klas, thx a lot for your reply. No I haven´t seen the empty  space and I don´t know where it´s from. Now I´ve updated J! and Seblod, the empty space disappeared, but the search-function still doesn't work.

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 `#__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-07 03:14' )
AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2018-08-07 03:14' )
AND t0.cck = 'stammdaten'
AND t1.nachname_sd LIKE '%Allina%'
ORDER BY t2.title ASC
LIMIT 25

0.012 seconds (0.012); 22.10 MB (22.105) - afterSearch [Cache=OFF] = 0 result.
0.012 seconds (0.000); 22.11 MB (0.003) - afterRender

Any Ideas?

Best, c

4229 Posts
Kadministrator
6 years ago
0
Level 3

As you can see from the query, there are no results, you need to check why, it can be anything from publish dates to access that is not matching - try running the query without where parts to see if you get any results.

Get a VIP membership