Hi @rachbeginner,
Thank you for reporting. I will try to help you.
First of all, execute the following command in the database, e.g. w phpMyAdmin (enter the correct database prefix, post_id and in meta_key enter the ACF field’s slug instead of “field_name”):
SELECT * FROM wp_postmeta WHERE post_id = "0" AND meta_key LIKE "%field_name%" ORDER BY meta_id ASC
As a result, you should receive 2 records – one of them (has meta_key with prefix “_”) should have meta_id bigger by 1 than the other. If this is not the case then you have an incorrect database structure – delete this field and add it again.
If this does not help, I will need more information from you:
1. A screenshot of a command to perform the database and results (entire window).
2. SQL query displayed after change in plugin code (https://gbiorczyk.pl/img/8jYkbzF.png) when you try to search for something.
3. Database dump (only table wp_posts and wp_postmeta tables). Please delete private data from it, if any.
4. ID of post you want to find.
5. A screenshot of used plugins list.
6. Version of ACF plugin and version of ACF: Better Search.
7. Screenshot of your search results (entire browser window).
If I helped you, let me know. I am grateful for all the information.
