Search Results Bug

Resolved Nathan
(@nathan1776)

4 years, 2 months ago

Hi

Sorting is not working on my WooCommerce site. Also, each search result page is not showing the same amount of products.

How can I fix this?

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

Thread Starter

Nathan

(@nathan1776)

4 years, 2 months ago

I have 4000 products. I did start the regeneration for the product lookup tables.
How long should it take?

aetta

(@chiape)

4 years, 2 months ago

Hi @nathan1776

This takes into account some very specific details about your server!

If you go to WP Dashboard > WooCommerce > Status > Scheduled Actions and search for the hook wc_update_product_lookup_tables it will show you the time taken to complete the action through WP-Cron!

Let me know if that helps!

My very best,

Thread Starter

Nathan

(@nathan1776)

4 years, 2 months ago

Hi Andre

Thank you so much for your reply!

So the search results still do not have a working “sort” option and search result pages have a different amount of products…

I found this in the scheduled action section you suggested…

wc_update_product_lookup_tables_column	Complete	
'column' => 'min_max_price'
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:47:55 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:35 +0000
action started via Async Request
2022-04-07 14:48:35 +0000
action complete via Async Request
	wc_update_product_lookup_tables_column	Complete	
'column' => 'stock_quantity'
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:47:56 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:35 +0000
action started via Async Request
2022-04-07 14:48:36 +0000
action complete via Async Request
	wc_update_product_lookup_tables_column	Complete	
'column' => 'sku'
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:47:57 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:36 +0000
action started via Async Request
2022-04-07 14:48:38 +0000
action complete via Async Request
	wc_update_product_lookup_tables_column	Complete	
'column' => 'stock_status'
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:47:58 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:38 +0000
action started via Async Request
2022-04-07 14:48:39 +0000
action complete via Async Request
	wc_update_product_lookup_tables_column	Complete	
'column' => 'average_rating'
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:47:59 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:39 +0000
action started via Async Request
2022-04-07 14:48:41 +0000
action complete via Async Request
	wc_update_product_lookup_tables_column	Complete	
'column' => 'total_sales'
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:48:00 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:41 +0000
action started via Async Request
2022-04-07 14:48:42 +0000
action complete via Async Request
	wc_update_product_lookup_tables_column	Complete	
'column' => 'downloadable'
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:48:01 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:42 +0000
action started via Async Request
2022-04-07 14:48:43 +0000
action complete via Async Request
	wc_update_product_lookup_tables_column	Complete	
'column' => 'virtual'
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:48:02 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:43 +0000
action started via Async Request
2022-04-07 14:48:45 +0000
action complete via Async Request
	wc_update_product_lookup_tables_column	Complete	
'column' => 'onsale'
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:48:03 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:45 +0000
action started via Async Request
2022-04-07 14:48:47 +0000
action complete via Async Request
	wc_update_product_lookup_tables_column	Complete	
'column' => 'tax_class'
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:48:04 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:47 +0000
action started via Async Request
2022-04-07 14:48:49 +0000
action complete via Async Request

wc_update_product_lookup_tables_column	Complete	
'column' => 'tax_status'
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:48:05 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:49 +0000
action started via Async Request
2022-04-07 14:48:50 +0000
action complete via Async Request
	wc_update_product_lookup_tables_rating_count_batch	Complete	
'offset' => 0
'limit' => 50
wc_update_product_lookup_tables	Non-repeating	2022-04-07 14:48:05 +0000
(12 hours 34 minutes ago)	
2022-04-07 14:47:55 +0000
action created
2022-04-07 14:48:50 +0000
action started via Async Request
2022-04-07 14:48:50 +0000
action complete via Async Request

Thread Starter

Nathan

(@nathan1776)

4 years, 2 months ago

Can I provide a link privately?

Mirko P.

(@rainfallnixfig)

4 years, 2 months ago

Hi @nathan1776,

Can I provide a link privately?

Since this is a public forum we do not provide dedicated support via email or privately. You can share the link here so everyone can contribute to help you out with this issue.

* https://ww.wp.xz.cn/support/guidelines/#the-bad-stuff

In order for us to take a closer look, could you please share the following?

System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
Fatal Error Log: Share a copy of any fatal error log found under WooCommerce > Status > Logs (if available).
Screenshot: Share a screenshot of what appears on the screen when you’re sorting products. A link where we can reproduce the issue would also be helpful.

Thanks!

Thread Starter

Nathan

(@nathan1776)

4 years, 2 months ago

Here is an example of unsorted results that are not able to sort
https://brilliancejewels.com/?orderby=price&paged=1&s=piguet

However, the category is fine and you can sort it out easily
https://brilliancejewels.com/product-category/watches/?orderby=price-desc

System Status


### WordPress Environment ###

WordPress address (URL): https://brilliancejewels.com
Site address (URL): https://brilliancejewels.com
WC Version: 6.3.1
REST API Version: ✔ 6.3.1
WC Blocks Version: ✔ 6.9.0
Action Scheduler Version: ✔ 3.4.0
WC Admin Version: ✔ 3.2.1
Log Directory Writable: ✔
WP Version: 5.9.3
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 8.0.17
PHP Post Max Size: 256 MB
PHP Time Limit: 3600
PHP Max Input Vars: 10000
cURL Version: 7.74.0
OpenSSL/1.1.1n

SUHOSIN Installed: –
MySQL Version: 5.7.36-39-log
Max Upload Size: 256 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 6.3.1
WC Database Prefix: wp_
Total Database Size: 411.77MB
Database Data Size: 270.43MB
Database Index Size: 141.34MB
wp_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cerber_acl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cerber_blocks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cerber_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cerber_lab: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cerber_lab_ip: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
cerber_lab_net: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cerber_log: Data: 1.52MB + Index: 0.47MB + Engine InnoDB
cerber_qmem: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
cerber_traffic: Data: 2.52MB + Index: 0.09MB + Engine InnoDB
wp_actionscheduler_actions: Data: 22.05MB + Index: 27.00MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 9.02MB + Index: 7.41MB + Engine InnoDB
wp_cerber_files: Data: 86.80MB + Index: 0.00MB + Engine InnoDB
wp_cerber_sets: Data: 0.22MB + Index: 0.00MB + Engine InnoDB
wp_cerber_uss: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_chaty_contact_form_leads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_e_submissions: Data: 0.05MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
wp_frmt_form_entry: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_frmt_form_entry_meta: Data: 0.08MB + Index: 0.08MB + Engine InnoDB
wp_frmt_form_views: Data: 12.52MB + Index: 17.06MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 6.05MB + Index: 1.33MB + Engine InnoDB
wp_postmeta: Data: 70.59MB + Index: 39.13MB + Engine InnoDB
wp_posts: Data: 15.45MB + Index: 3.84MB + Engine InnoDB
wp_Product_stock_alert: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_analytics_gsc: Data: 21.53MB + Index: 31.67MB + Engine InnoDB
wp_rank_math_analytics_inspections: Data: 4.52MB + Index: 0.94MB + Engine InnoDB
wp_rank_math_analytics_keyword_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_analytics_objects: Data: 1.52MB + Index: 0.44MB + Engine InnoDB
wp_rank_math_internal_links: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_internal_meta: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_termmeta: Data: 0.13MB + Index: 0.16MB + Engine InnoDB
wp_terms: Data: 0.13MB + Index: 0.16MB + Engine InnoDB
wp_term_relationships: Data: 5.50MB + Index: 2.48MB + Engine InnoDB
wp_term_taxonomy: Data: 0.13MB + Index: 0.17MB + Engine InnoDB
wp_trustindex_google_reviews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_usermeta: Data: 5.52MB + Index: 5.88MB + Engine InnoDB
wp_users: Data: 1.52MB + Index: 0.64MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.42MB + Index: 0.80MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpie_template: Data: 0.09MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 15460
custom-css-js: 4
elementor_library: 9
forminator_forms: 1
nav_menu_item: 47
oembed_cache: 176
page: 36
post: 13
product: 3581
revision: 156
shop_order: 24

### Security ###

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔

### Active Plugins (18) ###

Chaty: by Premio – 2.8.3
Classic Editor: by WordPress Contributors – 1.6.2
Simple Custom CSS and JS: by SilkyPress.com – 3.39
Google Tag Manager for WordPress: by Thomas Geiger – 1.14.2
Elementor Pro: by Elementor.com – 3.6.4
Elementor: by Elementor.com – 3.6.2
Essential Addons for Elementor - Pro: by WPDeveloper – 5.0.9
Essential Addons for Elementor: by WPDeveloper – 5.0.12
Forminator: by WPMU DEV – 1.15.12
Mailchimp for WooCommerce: by Mailchimp – 2.6.2
Manage Notification E-mails: by Virgial Berveling – 1.8.2
NitroPack: by NitroPack LLC – 1.5.10
Rank Math SEO PRO: by Rank Math – 3.0.10.1
Rank Math SEO: by Rank Math – 1.0.86.1
CTX Feed: by WebAppick – 4.4.56
WooCommerce: by Automattic – 6.3.1
WP Cerber Security, Anti-spam & Malware Scan: by Cerber Tech Inc. – 8.9.6
Widgets for Google Reviews: by Trustindex.io  – 8.2.2

### Inactive Plugins (1) ###

WP Mail SMTP: by WPForms – 3.3.0

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Must Use Plugins (6) ###

Force Strong Passwords - WPE Edition: by Jason Cosper – 1.8.0
WPE ElasticPress Autosuggest Logger: by WP Engine – 1.0.0
WP Engine Cache Plugin: by WP Engine – 1.0.8
WP Engine Seamless Login Plugin: by WP Engine – 1.5.5
WP Engine Security Auditor: by wpengine – 1.0.10
WP Engine System: by WP Engine – 5.0.1

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #20 - /shop/
Cart: #21 - /cart/
Checkout: ❌ Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.
My account: #23 - /my-account/
Terms and conditions: #18051 - /terms-and-conditions/

### Theme ###

Name: Hello Elementor
Version: 2.5.0
Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ✔

### Templates ###

Overrides: –

### Action Scheduler ###

Canceled: 120
Oldest: 2022-03-21 06:14:16 +0000
Newest: 2022-03-21 11:21:52 +0000

Complete: 62,779
Oldest: 2022-03-09 16:40:42 +0000
Newest: 2022-04-08 17:18:43 +0000

Failed: 2
Oldest: –
Newest: –

Pending: 1
Oldest: 2022-04-09 03:41:00 +0000
Newest: 2022-04-09 03:41:00 +0000

### Status report information ###

Generated at: 2022-04-08 17:22:58 +00:00

This reply was modified 4 years, 2 months ago by Nathan.
This reply was modified 4 years, 2 months ago by Nathan.

Thread Starter

Nathan

(@nathan1776)

4 years, 2 months ago

This is the most recent fatal error report but I had plenty of very similar ones and I think this might be the culprit

2022-04-08T09:53:23+00:00 CRITICAL Uncaught Error: Call to undefined function disk_free_space() in /nas/content/live/brilliance2/wp-admin/includes/file.php:1666
Stack trace:
#0 /nas/content/live/brilliance2/wp-admin/includes/file.php(1586): _unzip_file_ziparchive('/tmp/chaty.2.8....', '/nas/content/li...', Array)
#1 /nas/content/live/brilliance2/wp-admin/includes/class-wp-upgrader.php(329): unzip_file('/tmp/chaty.2.8....', '/nas/content/li...')
#2 /nas/content/live/brilliance2/wp-admin/includes/class-wp-upgrader.php(780): WP_Upgrader->unpack_package('/tmp/chaty.2.8....', true)
#3 /nas/content/live/brilliance2/wp-admin/includes/class-plugin-upgrader.php(231): WP_Upgrader->run(Array)
#4 /nas/content/live/brilliance2/wp-admin/includes/class-wp-automatic-updater.php(403): Plugin_Upgrader->upgrade('chaty/cht-icons...', Array)
#5 /nas/content/live/brilliance2/wp-admin/includes/class-wp-automatic-updater.php(469): WP_Automatic_Updater->update('plugin', Object(stdClass))
#6 /nas/content/live/brilliance2/wp-includes/update.php(729): WP_Automatic_Updater->run()
#7 /nas/content/live/brilliance2/wp-includes/class-wp-hook.php(307): wp_maybe_auto_update('')
#8 /nas/content/live/brilliance2/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters('', Array)
#9 /nas/content/live/brilliance2/wp-includes/plugin.php(474): WP_Hook->do_action(Array)
#10 /nas/content/live/brilliance2/wp-includes/update.php(256): do_action('wp_maybe_auto_u...')
#11 /nas/content/live/brilliance2/wp-includes/class-wp-hook.php(307): wp_version_check()
#12 /nas/content/live/brilliance2/wp-includes/class-wp-hook.php(331): WP_Hook->apply_filters('', Array)
#13 /nas/content/live/brilliance2/wp-includes/plugin.php(522): WP_Hook->do_action(Array)
#14 /nas/content/live/brilliance2/wp-cron.php(138): do_action_ref_array('wp_version_chec...', Array)
#15 {main}
  thrown in /nas/content/live/brilliance2/wp-admin/includes/file.php on line 1666

Igor H

(@ihereira)

4 years, 2 months ago

Hello,

Does the site has any custom code added? If so, can you disable it temporarily and check again?

You can clear your browser’s cache following the instructions on this page:
https://wordpress.com/support/browser-issues/#clearing-your-browser-cache

You can perform these steps:

Temporarily switch your theme to Storefront
Disable all plugins except for WooCommerce
Repeat the action that is causing the problem

If the issue is not present after this it means you can enable plugins again one by one until the cause of the issue is found You can find a more detailed explanation on how to do a conflict test here.

Let me know if this makes a difference.

Thread Starter

Nathan

(@nathan1776)

4 years, 2 months ago

Hi Again!

I deactivated everything except WooCommerce and it seemed like Elementor PRO is causing it. They said they are working on it 🙂

https://bjdevtest.wpengine.com/