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

Home Forums Product Support Forums Ajax Search Pro for WordPress Support Cant see all custom fields in the Search in custom fields box

This topic contains 1 reply, has 2 voices, and was last updated by Ernest Marcinko Ernest Marcinko 7 years, 3 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #4276
    SteffenRasile
    SteffenRasile
    Participant

    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?

    #4285
    Ernest Marcinko
    Ernest Marcinko
    Keymaster

    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 :)


Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.