Re-indexing loses data of custom fields in the FacetWP index
Support › MB FacetWP Integration › Re-indexing loses data of custom fields in the FacetWP indexResolved
- This topic has 6 replies, 4 voices, and was last updated 2 years, 5 months ago by
Anh Tran.
-
AuthorPosts
-
May 22, 2021 at 5:17 AM #28368
AMX
ParticipantHi,
I am new to Meta Box and FacetWP, coming from Toolset.
I'm building my first project with the Meta Box / FacetWP combination (the latest versions) and have an issue with filtering by custom fields.
With custom Taxonomies everything works flawlessly as expected.
But when a facet contains a Meta Box custom field and I press "Re-index" in FacetWP, the data from all custom fields is lost in the FacetWP index, so all field filters on the front end are empty, as if the posts didn't have custom field values. Taxonomy filters stay intact.
The values of custom fields remain in the post itself, but they are gone completely from the FacetWP index table in the database after triggering re-indexation.
When I open one post and simply re-save it, the values of all fields from the particular post "magically" re-appear in the FacetWP index. So, after each re-indexing I would need to open every single post and re-save it, but that is not doable, of course.
I tested it with several field types: checkboxes, text and numbers. The behavior was always the same.
The options "Searchable", "Sortable" and "Filterable" are checked for the fields. Deactivating practically all other plugins didn't help.
It's probably something simple, but after reading the documentation I cannot figure out why re-indexing always loses the data of custom fields.
I will appreciate your help.
Greetings,
Tom
May 23, 2021 at 4:04 PM #28381Long Nguyen
ModeratorHi,
Thank you for reaching out.
I'm using FacetWP v3.8.0.1 but do not see any issue after clicking "Re-index", all field values show on the filter as well. Please use the field ID under section Custom Fields instead of section Meta Box in the Data Source input. Screenshot https://share.getcloudapp.com/ApuzKvwY
May 25, 2021 at 1:31 AM #28398AMX
ParticipantThank you for your answer.
Indeed, when I scroll down to the Custom Fields section and use that, the data stays after re-indexing.However, if I use a Custom Table, the custom fields are not visible in that section, so I cannot select them. I can then only see them in Data Source -> Meta Box -> [CPT Name] Custom Field Label.
According to this thread:
https://support.metabox.io/topic/facetwp-custom-table/the Integrator supports Custom Tables, so I am a little confused. Of course, I would prefer to use custom tables, when possible. Is it (still) possible to have custom tables with FacetWP?
What is the function of the Meta Box section in Data Source? When would I use that?
Filtering kind of works, but only until I click "re-index"...Greetings,
TomMay 25, 2021 at 5:16 PM #28411Long Nguyen
ModeratorHi Tom,
Thank you for your feedback.
I also experience that issue with the field value saved in the custom table. It is possible that something goes wrong in the new version of both plugins. I will inform the development team to check this issue and get back to you later.
May 26, 2021 at 3:36 AM #28424AMX
ParticipantThank you, Long.
May 27, 2021 at 2:37 AM #28447[email protected]
ParticipantHi, wait a solution for that! thanks
October 22, 2022 at 10:44 AM #38782Anh Tran
KeymasterHey guys,
We've just tested the plugins with the latest version and the index works well for us. Here are some screenshots:
Custom field settings with custom table: https://monosnap.com/direct/u8XtJOvmYvV6BSj3M20Y6g3BCY2szK
FacetWP settings: https://monosnap.com/direct/qU8rsZkBqHrQRgt3HBu2UXFmmCAiYP
After press Re-index, the data in the database is correct: https://monosnap.com/direct/qr6Zjt3p8dsCDrwb9rrs8xvB2Iz5zy
-
AuthorPosts
- You must be logged in to reply to this topic.