When to many post meta in options, form clears all fields selected

Anonymous

#25231

Hi,
I have a site with 20000 products (books) and i create a search form for searching some fields in post meta. The only way to search for example author is to auto find all records (options in your plugin) and select them all in order to be searchable through the form, but when i update the search form it losses all post meta search options i have configured (let’s say i configured 6 post meta fields and it looses all except the first one). I figured that it happens when you select more than a number (don’t know the exact number but if i choose 100 it works, on 2000 it is not).
For me it would be easier if i didn’t have to select searchable options and just search everything in the specified field by default, because new books are added every day and that means i will have to update searchable options when ever i add them.
Thank you in advance.

Ross Moderator

#25637

Hi there

I’m afraid you can’t add that many options to the form – this is due to PHP/Server limits in most cases – the settings you could try to change on your server are outlined here:

https://support.searchandfilter.com/forums/topic/post-meta-issue/#post-24854

Can I ask, how are you displaying the field? Are you giving your users’ thousands of options to choose from, or are you using a combobox?

Thanks

Anonymous

#25660

Hi,
I already read that post and tried playing with php load limits to no avail, even with extreme values. I do not thing that the problem is php limits. I use multi select with combobox, but i have a lot of post meta fields like author, year_published, translator, pages, condition etc.
I believe that something hangs on the code when there are to many options to save in db and the form is not completely saved, that is why it keeps only the first post meta field and losses everything else (of course that is my feeling and you know what your code does better than me).
As i mentioned in my previous post, it would be easier if i didn’t have to select the searchable options, because new books are added every day and i will have to add searchable options every time in order to include new authors for example in my search.
I will try 2.01 today and let you know if there is any difference.
Than you.

Ross Moderator

#26034

THanks, I will be adding meta syncing to 2.1 hopefully so this should alleviate the problem.

A user has also discovered the issue to this error which I will refer to you:

https://support.searchandfilter.com/forums/topic/sf-form-not-saving-added-options/#post-25801

The variable that needs changing on the server is max_input_vars

Thanks

[Author]

Posts