Hi @basboerman,
Thank you for contact. I will try to help you. I need some information from you:
1. Screenshot of edit page of post you want to find.
2. Screenshot of edit Field Groups for your post.
3. Screenshot of settings page of plugin.
4. Screenshot of plugins list in your WordPress.
5. Information about your version of WP and PHP.
6. Make this change in plugin code, then try to search for post and copy query that will be displayed: https://gbiorczyk.pl/img/8jYkbzF.png
7. Make query in database (set your prefix and enter ID of post you want to find) and send me resultat: SELECT * FROM wp_postmeta WHERE post_id = 100
Thank you in advance!
Maybe it’s easier if i give you a db dumb? Running PHP 7.2 en WP 4.9.8
For reasons of forum rules, you can’t do this.
SELECT DISTINCT SQL_CALC_FOUND_ROWS bas_posts.* FROM bas_posts LEFT JOIN bas_postmeta AS a ON (a.post_id = bas_posts.ID) LEFT JOIN bas_postmeta AS b ON (b.post_id = bas_posts.ID) LEFT JOIN bas_posts AS c ON ((c.post_type = ‘acf-field’) AND ((c.post_content LIKE ‘%:”text”%’) OR (c.post_content LIKE ‘%:”textarea”%’) OR (c.post_content LIKE ‘%:”number”%’) OR (c.post_content LIKE ‘%:”email”%’) OR (c.post_content LIKE ‘%:”url”%’) OR (c.post_content LIKE ‘%:”wysiwyg”%’) OR (c.post_content LIKE ‘%:”select”%’) OR (c.post_content LIKE ‘%:”checkbox”%’) OR (c.post_content LIKE ‘%:”radio”%’))) WHERE 1=1 AND bas_posts.ID NOT IN (2)AND (((a.meta_value LIKE ‘%WOTS%’) AND (b.meta_id = a.meta_id + 1) AND (c.post_name = b.meta_value)) OR ((bas_posts.post_title LIKE ‘%WOTS%’) OR (bas_posts.post_content LIKE ‘%WOTS%’) OR (bas_posts.post_excerpt LIKE ‘%WOTS%’))) AND bas_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘project’) AND (bas_posts.post_status = ‘publish’ OR bas_posts.post_status = ‘acf-disabled’ OR bas_posts.post_author = 2 AND bas_posts.post_status = ‘private’) ORDER BY bas_posts.post_title LIKE ‘{0acf8a6a51a02204c8d8e665b78a8c205f5100212f087e295e4b7f640adb29ca}WOTS{0acf8a6a51a02204c8d8e665b78a8c205f5100212f087e295e4b7f640adb29ca}’ DESC, bas_posts.post_date DESC LIMIT 0, 100
query: https://we.tl/t-HGCVeSa3r7
hope you have enough information now!
Screenshot from point 2 is missing
Hi @basboerman,
The problem probably concerns AUTO_INCREMENT field, which in your database is more than 1. Please download the latest update and let us know if this solved the problem.
Thta’s it, problem solved. many thanks for the great support!