Frontend Filter for date Field causes SQL error with in single value mode (dropdown select OR date picker)

1 year 1 month ago - 1 year 1 month ago #70578 by seabird
Hello,

I am testing the date field and filtering in frontend.
Filtering is ok with date picker (range). But there is a problem with simple filter date picker.
When I select a filter date, I have this error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%('2017%-11%-10%', "%Y%-%m%-%d%") ) AND i.id IN (SELECT id FROM fc_filter_iids_' at line 1

Eric

Please Log in or Create an account to join the conversation.

1 year 1 month ago - 1 year 1 month ago #70593 by ggppdk


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

1 year 1 month ago #70605 by seabird

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
© 2018 Flexicontent. All Rights Reserved.