Date renders other search filters ineffective

Permalink Browser Info Environment
As soon as I add the date select filter all of the other filters stop working except the date filter. If I remove the date filter the others start working.

Type: Discussion
Status: In Progress
View Replies:
kimstone replied on at Permalink Reply
You can test it here:
http://westernpainsociety.org/events/community-events/...

Eugene and Portland are cities you can enter, and Lecture & Family are categories.
kimstone replied on at Permalink Reply
And here is a demo with the date deactivated...so other filters work.

http://westernpainsociety.org/events/community-events/1105-2/...
SkyBlueSofa replied on at Permalink Reply
SkyBlueSofa
Can you turn on the debugging on the 'view' tab for both? It will then output the generated sql. Usually, we can figure out what the issue is quickly from there.
kimstone replied on at Permalink Reply
Ok...I just setup the debugging on both the search and the page lists on both pages.

Thank you so much!
SkyBlueSofa replied on at Permalink Reply
SkyBlueSofa
If you run the date page athttp://westernpainsociety.org/events/community-events/... and then fill out the date field, you'll notice something like this about half way down:
ak_date_start LIKE '%2016-12-01%'

which means it is looking for pages with a 'start date' of 'December 1, 2016'.

If you fill out the date field with 1/3/2017, it will return one event.

Is there an option such as 'is after search value'? I believe this is what you will need.
kimstone replied on at Permalink Reply
Ok, I set the date to 'is after' and its still working as it was. Though the formatting of the date in the debugging info is different.

It hasn't fixed the issue of the other search fields not working though.

If its of any importantce, I've changed my custom page list date formatting to
<?php $date = $c->getAttribute('date_start'); echo date('F j, Y', strtotime($date)); ?>
kimstone replied on at Permalink Reply
So, I'm wondering if you are clear on the issue I'm having.

The date search works, but to the detriment of all the other search fields...as you can see on this page:
http://westernpainsociety.org/events/community-events/...

On this page, the other search fields work when I remove the date search:
http://westernpainsociety.org/events/community-events/1105-2/...

I'm hoping that all the fields can work congruently.

Thanks, again.
SkyBlueSofa replied on at Permalink Reply
SkyBlueSofa
Here's the page I'm reviewing (with it's search):http://westernpainsociety.org/events/community-events/?query=&s...

You'll notice on the left side the date is
ak_date_start LIKE '%2016-12-23%'
and on the right, it is
((CONVERT(ak_date_start, DECIMAL)>'2016-12-23') OR (ak_date_start>'2016-12-23'))


You'll need to update the block on the left to match the settings for the block on the right, using the 'is after' functionality.
kimstone replied on at Permalink Reply
Ok, they're the same now, and now the date query doesn't work at all, while the other fields do.

Would it help if I pm'd you with login access to C5?
kimstone replied on at Permalink Reply
It seems the only way I can get the filters to work congruently is to set the date to 'matches current entry' (in fact, that's the only way the date works).

Go ahead and do a date search for 2/2/17 for an initial query. Then select 'family' under categories for a second query. You will see it narrow the results.

Unfortunately it won't work if you don't select a date.

Forgive me for being so high maintenance.
kimstone replied on at Permalink Reply
So, I changed my tactic and came up with a better solution. I created select questions for the day, month, and year which accommodate the filtering I'm looking for.

I appreciate your efforts immensely though, and think its easily one of the best add ons in the market place.

Happy Holidays and 2017!!

Thank again,

Kim

concrete5 Environment Information

# concrete5 Version
5.6.3.1

# concrete5 Packages
Cache Free Content (1.1.0.5.6.3.1), eCommerce (2.8.16), Fix Required Labels (0.0.2), Forgot Password (1.0), Form Tableless Layout (1.2.1), Front End Attribute Editor (1.1), Lerteco Membership (2.2.2.1), Lerteco User Importer (2.1.1), Login (1.1.1), Login Redirect (1.3), Magic Data (2.9.8), Magic Data Symbols1 (2.7.2), Magic Data Templates1 (2.1), Mega Menu (1.5.27), Page List+ (6.0.0), Page Redirect (1.4), Page Selector Attribute (1.1), Paypal Website Payment Pro Gateway (2.0), Popup Login (1.0.5), Popup Pro (1.6.8), Pro Forms (7.6.2), Register User Pro (1.3.16), Registrant Group (1.1), Sortable Fancybox Gallery (1.17), Uhuru Theme (1.1), Ukao Menu (1.5.2), Whale Nivo Image Slider (1.0.4), Where Is My Block? (1.1).

# concrete5 Overrides
blocks/jb_megamenu, blocks/content, blocks/jb_register, blocks/autonav, blocks/login, blocks/page_list_plus, blocks/date_archive, blocks/product, blocks/jb_popup, elements/profile, elements/reload_on_attribute_change.php, elements/cart_item_list.php, elements/checkout, languages/es_ES, languages/zh_CN, languages/es_PE, languages/ru_RU, languages/tr_TR, languages/nb_NO, languages/ro_RO, languages/sk_SK, languages/zh_TW, languages/vi_VN, languages/fi_FI, languages/de_DE, languages/he_IL, languages/nl_NL, languages/ar, languages/it_IT, languages/sv_SE, languages/es_AR, languages/pt_PT, languages/cs_CZ, languages/ja_JP, languages/es_MX, languages/fa_IR, languages/sl_SI, languages/el_GR, languages/fr_FR, languages/da_DK, mail/receipt.php, models/attribute, single_pages/page_forbidden.php, single_pages/password_request.php, single_pages/profile, single_pages/conference_registration_lcms.php, single_pages/conference_registration.php, single_pages/register.php, single_pages/login.php, single_pages/loginOrig.php, single_pages/join.php, single_pages/page_not_found.php, single_pages/checkout, themes/uhuru

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off

# Server Software
Apache/2.4.23

# Server API
cgi-fcgi

# PHP Version
5.4.45

# PHP Extensions
apc, bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imagick, imap, ionCube Loader, json, libxml, mbstring, mcrypt, mysql, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, SimpleXML, soap, sockets, SPL, sqlite3, standard, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, Zend Guard Loader, zip, zlib.

# PHP Settings
max_execution_time - 120
apc.max_file_size - 1M
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 64M
post_max_size - 48M
sql.safe_mode - Off
upload_max_filesize - 32M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 10000000
pcre.recursion_limit - 10000000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:50.0) Gecko/20100101 Firefox/50.0

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.