Hello everybody,
After updating seblod to 3.11.2, a problem occur in a search list with dynamic select field (list of countries). No results appear... If I choose one country (like France / FR ) the results are displayed... The debugger shows :
SELECT COUNT(t0.id)
FROM `#__cck_core` AS t0
LEFT JOIN `#__cck_store_XXXXXXXX` AS t3 ON t3.id = t0.pk
LEFT JOIN `#__content` AS t4 ON t4.id = t0.pk
LEFT JOIN `#__contentitem_tag_map` AS t1 ON t1.content_item_id = t4.id
LEFT JOIN `#__tags` AS t2 ON t2.id = t1.tag_id
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE ( t4.publish_up = '0000-00-00 00:00:00' OR t4.publish_up <= '2017-06-05 10:02' )
AND ( t4.publish_down = '0000-00-00 00:00:00' OR t4.publish_down >= '2017-06-05 10:02' )
AND t3.country = ' '
AND t0.cck = 'XXXXXXX'
AND t4.state = '1'
AND t4.access = '1'
AND t3.spect_grp_genre = 'Danse / Théâtre'
0.019 seconds (0.019); 18.82 MB (18.815) - afterSearch [Cache=OFF] = 0 result.
I think the problem is in the county field....
Anyone have the same problem?
Thanks in advance!