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

More
8 months 1 week ago - 8 months 1 week 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
Last edit: 8 months 1 week ago by ggppdk.

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

More
8 months 1 week ago - 8 months 1 week ago #70593 by ggppdk
Hello

Fixed it
Please test this (use install via URL)
https://github.com/FLEXIcontent/flexicontent-cck/archive/3.2.1.x-stable.zip


-- 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!
Last edit: 8 months 1 week ago by ggppdk.

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

More
8 months 1 week ago #70605 by seabird

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

Moderators: vistamediajoomlacornerggppdk
© 2018 Flexicontent. All Rights Reserved.