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

More
7 years 1 week ago - 7 years 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:
Code:
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: 7 years 1 week ago by ggppdk.

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

More
7 years 1 week ago - 7 years 1 week ago #70593 by ggppdk
Hello

Fixed it
Please test this (use install via URL)
github.com/FLEXIcontent/flexicontent-cck...e/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...
Last edit: 7 years 1 week ago by ggppdk.

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

More
7 years 1 week ago #70605 by seabird

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.614 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline