Boris Hoekmeijer in reply to:
Date filter always produces zero results

#247699

Hi Ross,

I thought I had set the min-max field exactly as you suggested. I probably have things mixed up with the live website. I set it to overlap on the staging site, now it does work as intended, the date also.

But the live website still doesn’t. I don’t see any difference in the settings.

Add New Note to this Reply

Boris Hoekmeijer in reply to:
Date filter always produces zero results

#247683

Hi Ross,
what do you mean? For the date selector, I’m using Date not Number.

Add New Note to this Reply

Boris Hoekmeijer in reply to:
Date filter always produces zero results

#247649

Hi Ross,

you’re absolutely right, I just couldn’t reproduce the issue on staging. But now I have:

I overlooked the difference in ID’s you noticed. I changed the ID to show the 10652 results on the page. Now the problem is the same as the live website.

If I select june 15 and june 21 for instance as first and last days, I get a blank page for results. Do you see it too?

Add New Note to this Reply

Boris Hoekmeijer in reply to:
Date filter always produces zero results

#247640

Yes: https://ispacetest.nl/alle-accommodaties/?_sfm_unavailable-date=15062020+15062020&_sfm_accom_min_occupancy=1+13

But you need to select the dates (june 15 to june 22) yourself. Then you will see that at first it still shows all of the accommodations, and only after a refresh does it show the results as they should.

However, for now I think it’s better to focus on the live website, where we do not get any results at all no matter what dates you enter. If we fix that, we can always see if the other problem exists on the live website as well.

Add New Note to this Reply

Boris Hoekmeijer in reply to:
Date filter always produces zero results

#247581

Hi Ross,

I’ve tried to recreate the issue on the staging site, but I can’t. I’ve equalized everything I could find:
– same themes/KWO-villa/search-filter/results.php file
– removed the customized search-filter-pro/public/includes/class-search-filter-cache.php file
– replicated all the settings in the live filter to the villafilter-nl-test on the staging site.

Do you see any other difference?

What I can see, is that on the staging site it also doesn’t work as it should: all the “Wald” accommodations are actually blocked from booking from june until september 30. But if I select any date range, they all still show up. Until I refresh the page with F5.

Add New Note to this Reply

Boris Hoekmeijer in reply to:
Post Meta range slider not working as expected – take 2

#247558

Hi Ross,
I’ve done the following:
– set up the beta plugin (without modifications),
– set the post meta slider fields correctly for all languages,
– rebuilt the S&F cache
– updated all plugins
– removed all caching stuff from htaccess

I tested with all languages on Chrome with caching disabled and enabled. It all works!

Add New Note to this Reply

Boris Hoekmeijer in reply to:
Date filter always produces zero results

#247527

Hello Trevor,
sorry for not getting back sooner, was occuppied with the other suport ticket Ross is working on.

I checked your suggestion, but it is actually already set up like you suggested.

My developer managed to solve the problem by manually changing the class-search-filter-cache.php file from line 1292 (else if compare_mode overlap onward to this:

       else if($filter['compare_mode']=="overlap")
        {
            $field_terms_results = $wpdb->get_results( $wpdb->prepare(
                "
				SELECT post_id, post_parent_id, field_value_min, field_value_max FROM
					(SELECT min_table.post_id as post_id, min_table.post_parent_id as post_parent_id, min_table.field_value as field_value_min, max_table.field_value as field_value_max 
					FROM (SELECT post_id, post_parent_id, field_value FROM $this->table_name WHERE field_name = '%s') AS min_table
					LEFT JOIN (SELECT post_id, field_value FROM $this->table_name WHERE field_name = '%s') AS max_table 
					ON min_table.post_id = max_table.post_id) as range_table
				WHERE 
				(
					cast(field_value_min AS $cast_type) > cast(%s as $cast_type) AND
					cast(field_value_min AS $cast_type) < cast(%s as $cast_type)
				)
				OR
				(
				    cast(field_value_max AS $cast_type) > cast(%s as $cast_type) AND
					cast(field_value_max AS $cast_type) < cast(%s as $cast_type)
				)
				OR
				(
				    cast(field_value_min AS $cast_type) < cast(%s as $cast_type) AND
					cast(field_value_max AS $cast_type) > cast(%s as $cast_type)
				)
				OR
				(
				    cast(field_value_min AS $cast_type) >= cast(%s as $cast_type) AND
					cast(field_value_max AS $cast_type) <= cast(%s as $cast_type)
				)
				",
                $start_field_name, $end_field_name, $min_value, $max_value, $min_value, $max_value, $min_value, $max_value, $min_value, $max_value
            ) );
        }

I really do not want to revert to manual customization of plugin files, because that will cause me headaches with any future plugin update. Is there a way to make this change without altering the plugin files itself?

Add New Note to this Reply

Boris Hoekmeijer in reply to:
Post Meta range slider not working as expected – take 2

#247525

Hi Ross,

what you are saying makes sense. The option of not setting the filter and then not getting results is not an option.

So back to the original setting. Most likely, visitors will not change the maximum number, but they will change the minimum number. If that is set to 6, all accommodations housing 1-6 people should also be in the results.

So if I set it up like that (min-max, any overlap, 1-13 guests) on the test system, it works. But on the live website, it doesn’t. What do I need to change to make that work?

Regards,
Boris

Add New Note to this Reply

Boris Hoekmeijer in reply to:
Post Meta range slider not working as expected – take 2

#247469

Hi Ross,
actually, I started out that way (both set to max), but that also gave unexpected results, which is why I changed it to min-max, hoping that would work.

What I want is that the accommodation is displayed when the slider is between 1 (that’s very accommodation) and the maximum number of allowed guests. Including the maximum number.

Can you tell me how to set it up so that it will work that way? The settings for start and end key as well as compare mode are not 100% clear to me, and I could not find any documentation on it.

Kind regards,
Boris

Add New Note to this Reply

Boris Hoekmeijer in reply to:
Post Meta range slider not working as expected – take 2

#247387

Hi Ross,

I see Chalet Underhill (9), Ferienahsu Glück Auf 1 & 2 (12) and Villa Alpenrose (12)

Regards,
Boris

Add New Note to this Reply

[Author]

Posts