Steveccc

@shameemreza No the issue isnt resolved. Currently the plugin is disabled to ensure the website runs normally. I could enable it so you can see the fault but clearly I dont want to leave the website in this state for long as customer would be affected. Please could you confirm receipt of this and suggest a possible date / time when you would be able to investigate and I will ensure the plugin is enabled just before you test. Thanks

This is a page on the site https://aerosolsdirect.co.uk/british-standard/ you will see no results found when there should be results. If we turn off the plugin it works normally.

There are no errors in the log relating to this.

` WordPress Environment</p> <p>WordPress address (URL): https://aerosolsdirect.co.uk<br>Site address (URL): https://aerosolsdirect.co.uk<br>WC Version: 9.0.2<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ? 3.7.4<br>Log Directory Writable: ?<br>WP Version: 6.5.5<br>WP Multisite: –<br>WP Memory Limit: 1 GB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_GB<br>External object cache: – Server Environment</p> <p>Server Info: Apache<br>PHP Version: 8.1.29<br>PHP Post Max Size: 8 MB<br>PHP Time Limit: 40<br>PHP Max Input Vars: 1500<br>cURL Version: 7.76.1<br>OpenSSL/3.0.7</p> <p>SUHOSIN Installed: –<br>MySQL Version: 8.0.38<br>Max Upload Size: 4 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ? Your server does not have the SoapClient class enabled – some gateway plugins which use SOAP may not work as expected.<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database</p> <p>WC Database Version: 9.0.2<br>WC Database Prefix: wp_<br>Total Database Size: 238.07MB<br>Database Data Size: 131.93MB<br>Database Index Size: 106.14MB<br>wp_woocommerce_sessions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 0.41MB + Index: 0.16MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 12.52MB + Index: 6.03MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 1.08MB + Index: 0.63MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 0.39MB + Index: 0.25MB + Engine InnoDB<br>wp_aioseo_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_aioseo_notifications: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_aioseo_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_ak_params: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ak_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ak_schedules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_ak_stats: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_ak_storage: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ak_users: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_akeeba_common: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 2.52MB + Index: 1.25MB + Engine InnoDB<br>wp_gdpr_cc_options: Data: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wp_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_budget_recommendations: Data: 0.19MB + Index: 0.14MB + Engine InnoDB<br>wp_gla_merchant_issues: Data: 9.52MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_litespeed_url: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_nf3_action_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_field_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_upgrades: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_options: Data: 8.11MB + Index: 0.19MB + Engine InnoDB<br>wp_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_pmxi_hash: Data: 0.01MB + Index: 0.01MB + Engine MyISAM<br>wp_pmxi_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_pmxi_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_pmxi_imports: Data: 0.22MB + Index: 0.00MB + Engine MyISAM<br>wp_pmxi_posts: Data: 0.04MB + Index: 0.01MB + Engine MyISAM<br>wp_pmxi_templates: Data: 0.04MB + Index: 0.00MB + Engine MyISAM<br>wp_postmeta: Data: 49.59MB + Index: 59.17MB + Engine InnoDB<br>wp_posts: Data: 4.52MB + Index: 3.88MB + Engine InnoDB<br>wp_redirection_404: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_redirection_items: Data: 0.00MB + Index: 0.02MB + Engine MyISAM<br>wp_redirection_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_term_relationships: Data: 1.52MB + Index: 1.52MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_termmeta: Data: 0.19MB + Index: 0.25MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 1.52MB + Index: 2.02MB + Engine InnoDB<br>wp_users: Data: 0.09MB + Index: 0.05MB + Engine InnoDB<br>wp_vtprd_purchase_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_vtprd_purchase_log_product: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_vtprd_purchase_log_product_rule: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_vtprd_transient_cart_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.17MB + Index: 0.13MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 0.38MB + Index: 0.39MB + Engine InnoDB<br>wp_wc_order_stats: Data: 0.22MB + Index: 0.25MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.14MB + Index: 0.14MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_product_meta_lookup: Data: 7.52MB + Index: 13.09MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wdr_order_discounts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.02MB + Engine MyISAM<br>wp_wdr_rules: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfblockediplog: Data: 0.03MB + Index: 0.02MB + Engine MyISAM<br>wp_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfconfig: Data: 4.52MB + Index: 0.02MB + Engine MyISAM<br>wp_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wffilemods: Data: 6.51MB + Index: 0.77MB + Engine MyISAM<br>wp_wfhits: Data: 1.52MB + Index: 0.13MB + Engine MyISAM<br>wp_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfissues: Data: 0.02MB + Index: 0.01MB + Engine MyISAM<br>wp_wfknownfilelist: Data: 4.72MB + Index: 0.23MB + Engine MyISAM<br>wp_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wflocs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wp_wflogins: Data: 0.55MB + Index: 0.11MB + Engine MyISAM<br>wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY<br>wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfreversecache: Data: 0.16MB + Index: 0.04MB + Engine MyISAM<br>wp_wfsecurityevents: Data: 0.19MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfstatus: Data: 0.18MB + Index: 0.07MB + Engine MyISAM<br>wp_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfwaffailures: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_debug_events: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpr_above_the_fold: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wpr_rocket_cache: Data: 2.52MB + Index: 3.86MB + Engine InnoDB<br>wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_ycd_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wapo_addons: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wapo_blocks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wapo_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wapo_options: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wapo_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wccl_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yoast_indexable: Data: 6.52MB + Index: 8.77MB + Engine InnoDB<br>wp_yoast_indexable_hierarchy: Data: 1.52MB + Index: 0.89MB + Engine InnoDB<br>wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB Post Type Counts</p> <p>acf-field: 96<br>acf-field-group: 4<br>attachment: 255<br>nav_menu_item: 40<br>nf_sub: 868<br>oembed_cache: 5<br>omapi: 2<br>page: 21<br>post: 6<br>product: 16091<br>revision: 362<br>shop_coupon: 19<br>shop_order: 1645<br>shop_order_refund: 36<br>ycdcountdown: 1 Security</p> <p>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (25)</p> <p>Advanced Custom Fields PRO: by WP Engine – 6.3.3<br>Classic Editor: by WordPress Contributors – 1.6.3<br>Yoast Duplicate Post: by Enrico Battocchi and Team Yoast – 4.5<br>Filester – File Manager Pro: by Ninja Team – 1.8.2<br>HTML Page Sitemap: by – 1.3.3<br>Ninja Forms – Campaign Monitor: by The WP Ninjas – 3.0.6<br>Ninja Forms – Conditional Logic: by The WP Ninjas – 3.0.28<br>Ninja Forms – Layout & Styles: by The WP Ninjas – 3.0.29<br>Ninja Forms: by Saturday Drive – 3.8.5<br>Redirection: by John Godley – 5.4.2<br>Show Current Template: by JOTAKI Taisuke – 0.5.2<br>Woo Discount Rules PRO 2.0: by Flycart – 2.6.1<br>Discount Rules Core: by Flycart – 2.6.4<br>Payment Plugins for Stripe WooCommerce: by Payment Plugins<br>[email protected] – 3.3.73</p> <p>Table Rate Shipping for WooCommerce: by JEM Plugins – 2.29<br>WooCommerce Free Gift Coupons: by Kathy Darling – 3.3.1 (update to version 3.7.0 is available)<br>WooCommerce Stripe Gateway: by WooCommerce – 8.4.0<br>Google Analytics for WooCommerce: by WooCommerce – 2.1.4<br>Invoices for WooCommerce: by Bas Elbers – 3.1.9<br>WooCommerce Shipment Tracking: by WooCommerce – 1.8.0 (update to version 2.5.0 is available)<br>WooCommerce: by Automattic – 9.0.2<br>Wordfence Security: by Wordfence – 7.11.6<br>Yoast SEO: by Team Yoast – 23.0<br>WP Mail SMTP: by WP Mail SMTP – 4.0.1<br>YITH WooCommerce Product Add-ons Premium: by YITH – 1.5.38 Inactive Plugins (10)</p> <p>Better Search Replace: by WP Engine – 1.4.7<br>GDPR Cookie Compliance: by Moove Agency – 4.15.2<br>Google Listings and Ads: by WooCommerce – 2.7.5<br>OptinMonster: by OptinMonster Popup Builder Team – 2.16.4<br>Password Protected: by Password Protected – 2.7.2<br>Plinkfizz Dashboard: by Plinkfizz Development Team – 1.0.5<br>Wordfence Login Security: by Wordfence – 1.1.12<br>WPForms Lite: by WPForms – 1.8.9.5<br>WP Rocket: by WP Media – 3.16.1.1<br>WP Sheet Editor – WooCommerce Products: by WP Sheet Editor – 1.8.13 Dropin Plugins ()</p> <p>advanced-cache.php: advanced-cache.php<br>maintenance.php: maintenance.php Settings</p> <p>API Enabled: –<br>Force SSL: –<br>Currency: GBP (￡)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)</p> <p>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)</p> <p>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – Logging</p> <p>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 122 KB WC Pages</p> <p>Shop base: #8 – /shop/<br>Basket: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.<br>Checkout: ? Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.<br>My account: ? Page does not contain the [woocommerce_my_account] shortcode.<br>Terms and conditions: #76475 – /terms-conditions/ Theme</p> <p>Name: Aerosols<br>Version: 1.0.0<br>Author URL: #<br>Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build<br>personally we recommend using a child theme. See: How to create a child theme</p> <p>WooCommerce Support: ? Templates</p> <p>Overrides: aerosols/woocommerce/archive-product.php version 3.4.0 is out of date. The core version is 8.6.0<br>aerosols/woocommerce/checkout/thankyou.php version 3.7.0 is out of date. The core version is 8.1.0<br>aerosols/woocommerce/content-product.php<br>aerosols/woocommerce/content-single-product.php<br>aerosols/woocommerce/single-product.php</p> <p>Outdated Templates: ?</p> <pre class=”wp-block-code”><code> Learn how to update</code></pre> <p>Admin</p> <p>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page</p> <p>Disabled Features: minified-js<br>new-product-management-experience<br>pattern-toolkit-full-composability<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>launch-your-store<br>product-editor-template-system</p> <p>Daily Cron: ? Next scheduled: 2024-07-10 12:06:56 +01:00<br>Options: ?<br>Notes: 210<br>Onboarding: completed Action Scheduler</p> <p>Complete: 1,383<br>Oldest: 2024-06-09 23:28:11 +0100<br>Newest: 2024-07-09 20:34:03 +0100</p> <p>Failed: 135<br>Oldest: 2023-05-05 16:57:06 +0100<br>Newest: 2024-07-09 04:29:03 +0100</p> <p>Pending: 6<br>Oldest: 2024-07-10 04:00:00 +0100<br>Newest: 2024-07-10 17:06:28 +0100 Status report information</p> <p>Generated at: 2024-07-09 22:26:17 +01:00<br>`

We have just rolled back and unfortunately the same thing is happening. I have output the contents of $_POST[‘keyword’] and with your plugin disabled, we just get the search term, however with it enabled we get the string below – it appears that analytics code and browser parameters are being added to the search term and hence no results are produced. I am assuming there is an error in the code or things are not being escaped properly and hence its breaking the site. Welcome your thoughts.

string(672) “https://region1.google-analytics.com/g/collect?v=2&tid=G-CRNRPTRYZ5>m=45je4730v886329415za200&_p=1720173814177&gcs=G100&gcd=13p3p3p3p5&npa=1&dma_cps=-&dma=0&tag_exp=0&gdid=dOGY3NW&cid=45455574.1720173815&ul=en-gb&sr=2560×1440&uaa=x86&uab=64&uafvl=Opera%3B111.0.5168.55%7CChromium%3B125.0.6422.143%7CNot.A%252FBrand%3B24.0.0.0&uamb=0&uam=&uap=Windows&uapv=15.0.0&uaw=0&are=1&frm=0&pscdl=denied&ngs=1&_s=1&sid=1720173814&sct=1&seg=0&dl=https%3A%2F%2Faerosolsdirect.co.uk%2Fbritish-standard%2F&dr=https%3A%2F%2Faerosolsdirect.co.uk%2F&dt=British%20Standard%20%7C%20Aerosols%20Direct&en=page_view&_fv=2&_ss=1&_c=1&_ee=1&ep.track_404=true&ep.logged_in=false&tfd=2129&_z=fetch&#8221;

It does indeed work – many thanks. I hadnt realised that it was linked to the number of posts displayed – I presumed it was showing all and then the page I was expecting wasnt present, I presumed it hadnt found it.

Thanks for your help and maybe one for your faq’s section as I presume I wont be the last

Thanks again and sorry to be a pain

the sql is

SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_postmeta AS a ON (a.post_id = wp_posts.ID) INNER JOIN wp_postmeta AS b ON ((b.meta_id = a.meta_id + @@auto_increment_increment) AND (b.post_id = wp_posts.ID)) INNER JOIN 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 ‘%:”wysiwyg”%’))) WHERE 1=1 AND (((c.post_name = b.meta_value) AND (a.meta_value LIKE ‘{df631c61fe2d2c73b07457ebd35534df4da3711fcc4ca0d1fac4aa78b7fa7e2b}power{df631c61fe2d2c73b07457ebd35534df4da3711fcc4ca0d1fac4aa78b7fa7e2b}’)) OR ((wp_posts.post_title LIKE ‘{df631c61fe2d2c73b07457ebd35534df4da3711fcc4ca0d1fac4aa78b7fa7e2b}power{df631c61fe2d2c73b07457ebd35534df4da3711fcc4ca0d1fac4aa78b7fa7e2b}’) OR (wp_posts.post_content LIKE ‘{df631c61fe2d2c73b07457ebd35534df4da3711fcc4ca0d1fac4aa78b7fa7e2b}power{df631c61fe2d2c73b07457ebd35534df4da3711fcc4ca0d1fac4aa78b7fa7e2b}’) OR (wp_posts.post_excerpt LIKE ‘{df631c61fe2d2c73b07457ebd35534df4da3711fcc4ca0d1fac4aa78b7fa7e2b}power{df631c61fe2d2c73b07457ebd35534df4da3711fcc4ca0d1fac4aa78b7fa7e2b}’))) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘case_study_item’, ‘service_item’, ‘product_item’, ‘staff_member_item’, ‘case_study_promotion’, ‘careers_item’) AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’) ORDER BY wp_posts.post_title LIKE ‘{df631c61fe2d2c73b07457ebd35534df4da3711fcc4ca0d1fac4aa78b7fa7e2b}power{df631c61fe2d2c73b07457ebd35534df4da3711fcc4ca0d1fac4aa78b7fa7e2b}’ DESC, wp_posts.post_date DESC LIMIT 0, 10

Its higher in the post 165

database dump https://we.tl/t-4SumCe583A

This is the database screenshot
https://we.tl/t-smzJdWSBUb

Apologies – i did send a mail straight back but neglected to notice it was a no reply address.

https://wetransfer.com/downloads/b4d5c8875fc201faf7dbb03b1dfb98de20190305082404/c7a77dbda3267265c33618fca23e2ec720190305082404/045254

I emailed in screenshots but I dont think they may have reached you. please can you confirm how I can get them to you directly?

I wondered if you have an update on this please, what may be wrong?

Nick

The other thing I forgot to mention is that the field concerned is stored within the acf repeater field which I have seen others have issues with. Not sure if thats significant.

Thanks for the reply – the sql, id of the post and the acf / better search versions are below

SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_postmeta AS a ON (a.post_id = wp_posts.ID) INNER JOIN wp_postmeta AS b ON ((b.meta_id = a.meta_id + @@auto_increment_increment) AND (b.post_id = wp_posts.ID)) INNER JOIN 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 '%:"wysiwyg"%'))) WHERE 1=1 AND (((c.post_name = b.meta_value) AND (a.meta_value LIKE '{f4af6f01e3a96fea4b9009f6269b3925b1aad962543dd43060db49e864edc03c}power{f4af6f01e3a96fea4b9009f6269b3925b1aad962543dd43060db49e864edc03c}')) OR ((wp_posts.post_title LIKE '{f4af6f01e3a96fea4b9009f6269b3925b1aad962543dd43060db49e864edc03c}power{f4af6f01e3a96fea4b9009f6269b3925b1aad962543dd43060db49e864edc03c}') OR (wp_posts.post_content LIKE '{f4af6f01e3a96fea4b9009f6269b3925b1aad962543dd43060db49e864edc03c}power{f4af6f01e3a96fea4b9009f6269b3925b1aad962543dd43060db49e864edc03c}') OR (wp_posts.post_excerpt LIKE '{f4af6f01e3a96fea4b9009f6269b3925b1aad962543dd43060db49e864edc03c}power{f4af6f01e3a96fea4b9009f6269b3925b1aad962543dd43060db49e864edc03c}'))) AND wp_posts.post_type IN ('post', 'page', 'attachment', 'case_study_item', 'service_item', 'product_item', 'staff_member_item', 'case_study_promotion', 'careers_item') AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private') ORDER BY wp_posts.post_title LIKE '{f4af6f01e3a96fea4b9009f6269b3925b1aad962543dd43060db49e864edc03c}power{f4af6f01e3a96fea4b9009f6269b3925b1aad962543dd43060db49e864edc03c}' DESC, wp_posts.post_date DESC LIMIT 0, 10

the ID is 165

acf version Version 5.7.12
better search Version 3.1.2

• This reply was modified 6 years ago by Jan Dembowski.
• This reply was modified 6 years ago by Jan Dembowski.

The search form is below. The form is contained within a wordpress page which has the url blog/page-project/

However when i hit search I am directed to the page url below – where project-2 is a custom post type rather than a page. I simply want the search to return to the same page.

/project/project-2/?contractperiod=sg&post_type=project&searchsubmit=Search

<form id=”searchform” action=”” method=”get”>
<input id=”contractperiod” maxlength=”6″ name=”contractperiod” size=”6″ type=”text” value=”” class=”txt” />
<input name=”post_type” type=”hidden” value=”project” />
<input id=”searchsubmit” name=”searchsubmit” class=”btn” type=”submit” value=”Search” />
</form>

Thanks

Nick