Search all + element filter -> getData:Got error 'empty (sub)expression'

Status
Not open for further replies.

Raindog

New Member
Hello!

Here link for clean Joomla site: http://www.gorod-dudinka.ru/fabrik/index.php/contactus
Fabrik with last update from GitHub.
Example on Fabrik sample data. All settings by default, except:

1. List -> Contact Us Data -> Filters -> Search all -> Yes
2. Elements -> first_name -> List view settings -> Filters ->Filter type -> Dropdown

Now, when we fill one or both filters for the first time, it's all right.
But if we change any data in filters without pressing "Clear filters" button, we get error like this:

getData:Got error 'empty (sub)expression' from regexp SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `fb3_fb_contact_sample`.`id` AS `fb3_fb_contact_sample___id`, `fb3_fb_contact_sample`.`id` AS `fb3_fb_contact_sample___id_raw`, `fb3_fb_contact_sample`.`first_name` AS `fb3_fb_contact_sample___first_name`, `fb3_fb_contact_sample`.`first_name` AS `fb3_fb_contact_sample___first_name_raw`, `fb3_fb_contact_sample`.`last_name` AS `fb3_fb_contact_sample___last_name`, `fb3_fb_contact_sample`.`last_name` AS `fb3_fb_contact_sample___last_name_raw`, `fb3_fb_contact_sample`.`email` AS `fb3_fb_contact_sample___email`, `fb3_fb_contact_sample`.`email` AS `fb3_fb_contact_sample___email_raw`, `fb3_fb_contact_sample`.`message` AS `fb3_fb_contact_sample___message`, `fb3_fb_contact_sample`.`message` AS `fb3_fb_contact_sample___message_raw`, `fb3_fb_contact_sample`.`id` AS slug , `fb3_fb_contact_sample`.`id` AS `__pk_val` FROM `fb3_fb_contact_sample` WHERE ( ( `fb3_fb_contact_sample`.`id` REGEXP '' OR `fb3_fb_contact_sample`.`last_name` REGEXP 'fname1' OR `fb3_fb_contact_sample`.`email` REGEXP 'fname1' OR `fb3_fb_contact_sample`.`message` REGEXP 'fname1' ) AND `fb3_fb_contact_sample`.`first_name` = 'fname1' ) LIMIT 0, 10

New link with debug on: http://www.gorod-dudinka.ru/fabrik/...k&view=list&listid=1&Itemid=486&fabrikdebug=1
 
hi
could you update from github please. I think I have fixed this issue.

Cheers
Rob
 
Status
Not open for further replies.
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top