19 Posts
kitamot
7 years ago
Topic

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!

Get a VIP membership
4229 Posts
Kadministrator
7 years ago
1
Level 1

Seems you have set space as default value (there is space between quotes in "AND t3.country = ' '")

19 Posts
kitamot
7 years ago
0
Level 2

Hello Kas,

Thanks very much, it was the space between quotes ...

Get a VIP membership