Cant see all custom fields in the Search in custom fields box

[SteffenRasileParticipant]

I cannot see all the custom fields available in the Search in custom fields box while I am setting up my search.

Can you tell me how to make this happen?

[Ernest MarcinkoKeymaster]

Hi!

It’s limited to 300 in the current version (it’s because this one time I’ve seen a site with 102 thousand custom fields and the search options didn’t show up at all…)

You can easily break this limit, by opening up the wp-content/plugins/ajax-search-pro/backend/settings/class/customfields.class.php file and go to line 17, where you should see this:

$this->types = $wpdb->get_results("SELECT * FROM " . $wpdb->postmeta . " GROUP BY meta_key LIMIT 300", ARRAY_A);

change that line to:

$this->types = $wpdb->get_results("SELECT * FROM " . $wpdb->postmeta . " GROUP BY meta_key LIMIT 30000", ARRAY_A);

Now the limit is increased to 30 thousand, so it will most likely show anything. (except if you have more than 30k custom fields)

Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[Author]

Posts