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

seabird
Topic Author
Offline
Elite Member

6 years 5 months ago - 6 years 5 months ago #70578 by seabird

Frontend Filter for date Field causes SQL error with in single value mode (dropdown select OR date picker) was created 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: 6 years 5 months ago by ggppdk.

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

ggppdk
Offline
Administrator

6 years 5 months ago - 6 years 5 months ago #70593 by ggppdk

Replied by ggppdk on topic Frontend Filter for date Field causes SQL error with in single value mode (dropdown select OR date picker)

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: 6 years 5 months ago by ggppdk.

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