Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author Mateusz Gbiorczyk

    (@mateuszgbiorczyk)

    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!

    Thread Starter basboerman

    (@basboerman)

    Maybe it’s easier if i give you a db dumb? Running PHP 7.2 en WP 4.9.8

    Plugin Author Mateusz Gbiorczyk

    (@mateuszgbiorczyk)

    For reasons of forum rules, you can’t do this.

    Thread Starter basboerman

    (@basboerman)

    Thread Starter basboerman

    (@basboerman)

    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

    Thread Starter basboerman

    (@basboerman)

    query: https://we.tl/t-HGCVeSa3r7

    hope you have enough information now!

    Plugin Author Mateusz Gbiorczyk

    (@mateuszgbiorczyk)

    Screenshot from point 2 is missing

    Thread Starter basboerman

    (@basboerman)

    Screenshot for point 2: https://we.tl/t-nft2yEJNIv

    Plugin Author Mateusz Gbiorczyk

    (@mateuszgbiorczyk)

    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.

    Thread Starter basboerman

    (@basboerman)

    Thta’s it, problem solved. many thanks for the great support!

    Thread Starter basboerman

    (@basboerman)

    job done!

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Plugin doesn’t seem to search in all fields’ is closed to new replies.