Sorting custom fields in wordpress doesn't work when two many records

Question

I'm making a website to sell properties. I use wordpress with wp-property plugging. My db contains around 2000 properties. On my macbook (localhost), everything is working fine. But online, I have the following problem : when there are a large amount of properties matching the search criteria (i.e. more than 500), I can only sort the found properties according to the post title. If I try to sort them according to any of the custom fields I created (price, area,zip code...), I get the message "no properties found" and all properties which were shown disappear. If the amount of property is low, it works... I guess that this problem could come from some parameter... Any idea ? Thanks.

Answer 1

the thing that is limiting your results is php/apache max_input_vars setting on your hosting provider .. you can try to contact them and ask if they can increase that limit for you (the default limit is 1000) or you could try to create php.ini in your web root and enter higher limit number like:

max_input_vars = 2000

or you can create .htaccess with this content:

php_value max_input_vars 2000