Title: Plugin not working Last modified: November 7, 2018 --- # Plugin not working * Resolved [Ciro Urdaneta](https://wordpress.org/support/users/curdaneta/) * (@curdaneta) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/) * Hello * The plugin is not working for me. At this time the site is in local development. I tried using the search widget and also a CPT Search Widget. * This are the strings [http://localhost/wordpress/?s=](http://localhost/wordpress/?s=) RING&post_type=parts [http://localhost/wordpress/?s=RING](http://localhost/wordpress/?s=RING) * These are the active plugins – ACF: Better Search – Advanced Custom Fields PRO– Classic Editor – Custom Post Type UI – Custom Post Type Widgets – Disable Comments– Divi Booster – Divi Breadcrumbs Module – DP Portfolio Posts Pro – Redirection– Remove Projects in Divi – Widget Options – WP-PageNavi * Screenshots here [https://www.dropbox.com/s/g7a88xyvzhdk774/acf-search.jpg?dl=0](https://www.dropbox.com/s/g7a88xyvzhdk774/acf-search.jpg?dl=0) [https://www.dropbox.com/s/crjjrvxy9kl6fz3/aircraft-field_group.jpg?dl=0](https://www.dropbox.com/s/crjjrvxy9kl6fz3/aircraft-field_group.jpg?dl=0) [https://www.dropbox.com/s/eryk7zhekd9roph/parts-field_group.jpg?dl=0](https://www.dropbox.com/s/eryk7zhekd9roph/parts-field_group.jpg?dl=0) [https://www.dropbox.com/s/dorm196c93jlnue/aircraft-edit.jpg?dl=0](https://www.dropbox.com/s/dorm196c93jlnue/aircraft-edit.jpg?dl=0) [https://www.dropbox.com/s/j9ftl44b99ylpa3/parts-edit.jpg?dl=0](https://www.dropbox.com/s/j9ftl44b99ylpa3/parts-edit.jpg?dl=0) * Thanks Ciro Viewing 15 replies - 1 through 15 (of 24 total) 1 [2](https://wordpress.org/support/topic/plugin-not-working-690/page/2/?output_format=md) [→](https://wordpress.org/support/topic/plugin-not-working-690/page/2/?output_format=md) * Plugin Author [Mateusz Gbiorczyk](https://wordpress.org/support/users/mateuszgbiorczyk/) * (@mateuszgbiorczyk) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10859561) * @@tedmanders, can you check if version 3.0.1 was working correctly for you?, can you check if version 3.0.1 was working correctly for you? * Thread Starter [Ciro Urdaneta](https://wordpress.org/support/users/curdaneta/) * (@curdaneta) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10859568) * Sure, let me download it and I’ll post ASAP Thanks * Thread Starter [Ciro Urdaneta](https://wordpress.org/support/users/curdaneta/) * (@curdaneta) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10859602) * No, it doesn’t work. Takes a long to perform the query (in localhost) and returns a 500 error * Plugin Author [Mateusz Gbiorczyk](https://wordpress.org/support/users/mateuszgbiorczyk/) * (@mateuszgbiorczyk) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10859722) * Hi [@curdaneta](https://wordpress.org/support/users/curdaneta/), * Please make update to latest version (3.1.2) and change one line in **/functions/ search.php** file: * > [View post on imgur.com](https://imgur.com/xEbAE91) * Did it help? - This reply was modified 7 years, 7 months ago by [Mateusz Gbiorczyk](https://wordpress.org/support/users/mateuszgbiorczyk/). * Plugin Author [Mateusz Gbiorczyk](https://wordpress.org/support/users/mateuszgbiorczyk/) * (@mateuszgbiorczyk) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10859734) * Additionally please make this sql command in phpmyadmin: `SHOW VARIABLES LIKE' auto_inc%';` * and show me results. * Thread Starter [Ciro Urdaneta](https://wordpress.org/support/users/curdaneta/) * (@curdaneta) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10859775) * Done, But returns no results found * The sql command returns this Variable_name Value auto_increment_increment 1 auto_increment_offset. 1 * [https://www.dropbox.com/s/wu4nlq717sl7e7q/sql-1.png?dl=0](https://www.dropbox.com/s/wu4nlq717sl7e7q/sql-1.png?dl=0) * Plugin Author [Mateusz Gbiorczyk](https://wordpress.org/support/users/mateuszgbiorczyk/) * (@mateuszgbiorczyk) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10859818) * 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](https://gbiorczyk.pl/img/8jYkbzF.png) * Thread Starter [Ciro Urdaneta](https://wordpress.org/support/users/curdaneta/) * (@curdaneta) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10859858) * Done, this is the result * `SELECT DISTINCT SQL_CALC_FOUND_ROWS rd45fa_wp_posts.* FROM rd45fa_wp_posts INNER JOIN rd45fa_wp_postmeta AS a ON (a.post_id = rd45fa_wp_posts.ID) INNER JOIN rd45fa_wp_postmeta AS b ON ((b.meta_id = a.meta_id + 1) AND (b.post_id = rd45fa_wp_posts.ID)) INNER JOIN rd45fa_wp_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 '%:"file"%'))) LEFT JOIN rd45fa_wp_posts AS d ON (d.ID = a.meta_value) WHERE 1=1 AND (((c.post_name = b.meta_value) AND( a.meta_value LIKE '%washer%')) OR ((rd45fa_wp_posts.post_title LIKE '%washer%') OR (rd45fa_wp_posts.post_content LIKE '%washer%') OR (rd45fa_wp_posts.post_excerpt LIKE '%washer%')) OR (d.post_title LIKE '%washer%')) AND rd45fa_wp_posts.post_type = 'parts' AND (rd45fa_wp_posts.post_status = 'publish' OR rd45fa_wp_posts.post_status = 'acf-disabled' OR rd45fa_wp_posts.post_status = 'private') ORDER BY rd45fa_wp_posts. post_title LIKE '{8290295b167a775f3456bcbdc90b18d96820f632ec17e3986acb6c8cf262675b} washer{8290295b167a775f3456bcbdc90b18d96820f632ec17e3986acb6c8cf262675b}' DESC, rd45fa_wp_posts.post_date DESC LIMIT 0, 6` * Plugin Author [Mateusz Gbiorczyk](https://wordpress.org/support/users/mateuszgbiorczyk/) * (@mateuszgbiorczyk) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10859925) * Please try use “Lite mode”. * Thread Starter [Ciro Urdaneta](https://wordpress.org/support/users/curdaneta/) * (@curdaneta) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10859946) * Returns this * `SELECT DISTINCT SQL_CALC_FOUND_ROWS rd45fa_wp_posts.* FROM rd45fa_wp_posts INNER JOIN rd45fa_wp_postmeta AS a ON (a.post_id = rd45fa_wp_posts.ID) INNER JOIN rd45fa_wp_postmeta AS b ON ((b.meta_id = a.meta_id + 1) AND (b.post_id = rd45fa_wp_posts.ID)) WHERE 1=1 AND (((b.meta_value LIKE 'field_%') AND (a.meta_value LIKE '%washer%')) OR(( rd45fa_wp_posts.post_title LIKE '%washer%') OR (rd45fa_wp_posts.post_content LIKE '%washer%') OR (rd45fa_wp_posts.post_excerpt LIKE '%washer%'))) AND rd45fa_wp_posts. post_type = 'parts' AND (rd45fa_wp_posts.post_status = 'publish' OR rd45fa_wp_posts. post_status = 'acf-disabled' OR rd45fa_wp_posts.post_status = 'private') ORDER BY rd45fa_wp_posts.post_title LIKE '{37a6be52b8e6fd52a2af9233111f63520fc6dfa6618b5fafbf0969d5151b508b} washer{37a6be52b8e6fd52a2af9233111f63520fc6dfa6618b5fafbf0969d5151b508b}' DESC, rd45fa_wp_posts.post_date DESC LIMIT 0, 6` * Plugin Author [Mateusz Gbiorczyk](https://wordpress.org/support/users/mateuszgbiorczyk/) * (@mateuszgbiorczyk) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10860904) * Please give me your database dump (only rd45fa_wp_posts and rd45fa_wp_postmeta) tables. Please delete all private data from them. * Thread Starter [Ciro Urdaneta](https://wordpress.org/support/users/curdaneta/) * (@curdaneta) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10861162) * You can grab it here * [https://www.dropbox.com/s/68yfg6yj0q3winn/db_dump.zip?dl=0](https://www.dropbox.com/s/68yfg6yj0q3winn/db_dump.zip?dl=0) * Thread Starter [Ciro Urdaneta](https://wordpress.org/support/users/curdaneta/) * (@curdaneta) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10866773) * Hello Mateusz * Any update? * Thanks Ciro * Plugin Author [Mateusz Gbiorczyk](https://wordpress.org/support/users/mateuszgbiorczyk/) * (@mateuszgbiorczyk) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10872737) * Hi [@curdaneta](https://wordpress.org/support/users/curdaneta/), * I am sorry for waiting, but I was abroad and I didn’t have time. I checked your database. You have an error. I have marked green, what ACF field looks correctly saved, and wrong in red. * Do you understand the difference? If the field isn’t saved correctly, search can’t work. * Thread Starter [Ciro Urdaneta](https://wordpress.org/support/users/curdaneta/) * (@curdaneta) * [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/#post-10872762) * Hi [@mateuszgbiorczyk](https://wordpress.org/support/users/mateuszgbiorczyk/) * Could you please show me where is the error. I can’t see any attached image/code * Thanks Ciro Viewing 15 replies - 1 through 15 (of 24 total) 1 [2](https://wordpress.org/support/topic/plugin-not-working-690/page/2/?output_format=md) [→](https://wordpress.org/support/topic/plugin-not-working-690/page/2/?output_format=md) The topic ‘Plugin not working’ is closed to new replies. * ![](https://ps.w.org/acf-better-search/assets/icon-256x256.png?rev=2636287) * [ACF: Better Search](https://wordpress.org/plugins/acf-better-search/) * [Frequently Asked Questions](https://wordpress.org/plugins/acf-better-search/#faq) * [Support Threads](https://wordpress.org/support/plugin/acf-better-search/) * [Active Topics](https://wordpress.org/support/plugin/acf-better-search/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/acf-better-search/unresolved/) * [Reviews](https://wordpress.org/support/plugin/acf-better-search/reviews/) * 24 replies * 2 participants * Last reply from: [Mateusz Gbiorczyk](https://wordpress.org/support/users/mateuszgbiorczyk/) * Last activity: [7 years, 7 months ago](https://wordpress.org/support/topic/plugin-not-working-690/page/2/#post-10879276) * Status: resolved