sirgeordie

If there’s anything extra for me to try with this issue I’d appreciate it.

Thanks for the support with this.

I disabled caching, and ran all the updates, and everything is as up to date as it could be. I used Woocommerce Tools to verify the databases, and anything else on that screen I could think of.

It’s still happening. Every time a new guest customer ticks the ‘create an account’ they get assigned old orders.

Do you have anything else for me to try to get a solution to this?

Updated report below:

### WordPress Environment ###

WordPress address (URL): https://dbtest.northernpaintsandcoatings.co.uk
Site address (URL): https://dbtest.northernpaintsandcoatings.co.uk
WC Version: 6.8.2
REST API Version: ? 6.8.2
WC Blocks Version: ? 8.0.0
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.30
PHP Post Max Size: 512 MB
PHP Time Limit: 120
PHP Max Input Vars: 8000
cURL Version: 7.71.0
OpenSSL/1.1.1p

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.35-MariaDB-log-cll-lve
Max Upload Size: 512 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.8.2
WC Database Prefix: wpgi_
Total Database Size: 51.92MB
Database Data Size: 35.92MB
Database Index Size: 16.00MB
wpgi_woocommerce_sessions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_order_items: Data: 0.13MB + Index: 0.08MB + Engine MyISAM
wpgi_woocommerce_order_itemmeta: Data: 0.88MB + Index: 0.70MB + Engine MyISAM
wpgi_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_actionscheduler_actions: Data: 0.63MB + Index: 0.31MB + Engine MyISAM
wpgi_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_actionscheduler_logs: Data: 0.43MB + Index: 0.42MB + Engine MyISAM
wpgi_aioseo_cache: Data: 0.07MB + Index: 0.01MB + Engine MyISAM
wpgi_aioseo_notifications: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_aioseo_posts: Data: 0.12MB + Index: 0.01MB + Engine MyISAM
wpgi_commentmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wpgi_comments: Data: 2.72MB + Index: 1.36MB + Engine MyISAM
wpgi_duplicator_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpgi_feedmanager_channel: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_feedmanager_country: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_feedmanager_feed_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_feedmanager_field_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpgi_feedmanager_product_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpgi_feedmanager_product_feedmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_feedmanager_source: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_litespeed_img_optm: Data: 0.23MB + Index: 0.16MB + Engine InnoDB
wpgi_litespeed_img_optming: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wpgi_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpgi_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpgi_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpgi_options: Data: 4.39MB + Index: 0.32MB + Engine MyISAM
wpgi_postmeta: Data: 21.16MB + Index: 10.35MB + Engine MyISAM
wpgi_posts: Data: 1.87MB + Index: 0.58MB + Engine MyISAM
wpgi_redirection_404: Data: 0.26MB + Index: 0.07MB + Engine MyISAM
wpgi_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_redirection_items: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wpgi_redirection_logs: Data: 0.20MB + Index: 0.03MB + Engine MyISAM
wpgi_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_termmeta: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpgi_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_term_relationships: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpgi_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_usermeta: Data: 0.22MB + Index: 0.14MB + Engine MyISAM
wpgi_users: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpgi_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpgi_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_customer_lookup: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wpgi_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_order_product_lookup: Data: 0.10MB + Index: 0.09MB + Engine MyISAM
wpgi_wc_order_stats: Data: 0.30MB + Index: 0.23MB + Engine MyISAM
wpgi_wc_order_tax_lookup: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
wpgi_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_wc_product_meta_lookup: Data: 0.02MB + Index: 0.04MB + Engine MyISAM
wpgi_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wfpklist_template_data: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wpgi_woo_shippment_provider: Data: 0.07MB + Index: 0.01MB + Engine MyISAM
wpgi_yoast_indexable: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
wpgi_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpgi_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpgi_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

acf-field: 178
acf-field-group: 15
attachment: 449
ct_template: 14
lp: 11
nav_menu_item: 25
oembed_cache: 1
page: 24
post: 5
product: 51
product_variation: 218
revision: 225
shop_coupon: 4
shop_order: 4230
shop_order_refund: 4
wpcode: 2

### Security ###

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

### Active Plugins (28) ###

Advanced Custom Fields PRO: by Delicious Brains – 5.12.3
All in One SEO: by All in One SEO Team – 4.2.4
Classic Editor: by WordPress Contributors – 1.6.2
Code Snippets: by Code Snippets Pro – 3.2.0
Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.3.1
Custom Post Type UI: by WebDevStudios – 1.12.1
Site Kit by Google: by Google – 1.81.0
WPCode - Insert Headers, Footers, and Code Snippets: by WPCode – 2.0.2
Klaviyo: by Klaviyo
Inc. – 3.0.3

Mailchimp for WooCommerce: by Mailchimp – 2.7.2
Northern Paints & Coatings Functions: by Scott Digital – 1.0.0
OptinMonster: by OptinMonster Popup Builder Team – 2.9.0
OxyNinja: by OxyNinja – 3.5.2
OxyExtras: by OxyExtras – 1.4.3
Oxygen Elements for WooCommerce: by Soflyy – 2.0
Oxygen: by Soflyy – 4.0.2
Password Protected: by WPExperts – 2.5.3
WooCommerce PDF Invoices, Packing Slips, Delivery Notes and Shipping Labels: by WebToffee – 3.0.4
Redirection: by John Godley – 5.3.2
Widgets for Trustpilot Reviews: by Trustindex.io  – 6.3.1
Trustpilot-reviews: by Trustpilot – 2.5.914
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.22.16

User Switching: by John Blackbourn & contributors – 1.7.0
Advanced Shipment Tracking for WooCommerce: by zorem – 3.4.7
WooCommerce PayPal Payments: by WooCommerce – 1.9.2
WooCommerce: by Automattic – 6.8.2
WordPress Importer: by wordpressdotorg – 0.7
Widgets for Google Reviews: by Trustindex.io  – 9.4

### Inactive Plugins (13) ###

Duplicator: by Snap Creek – 1.4.7.2
Facebook for WooCommerce: by Facebook – 2.6.21
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.7.0
LiteSpeed Cache: by LiteSpeed Technologies – 5.2
Maintenance: by WebFactory Ltd – 4.06
Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.6.5
Product Feed PRO for WooCommerce: by AdTribes.io – 11.8.4
Variation Price Display Range for WooCommerce: by WPXtension – 1.2.3
White Label CMS: by www.videousermanuals.com – 2.3
WooCommerce Google Analytics Integration: by WooCommerce – 1.5.13
WooCommerce Stripe Gateway: by WooCommerce – 6.6.0
WP Product Feed Manager: by Michel Jongbloed – 1.43.0
Yoast SEO: by Team Yoast – 19.6

### Settings ###

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

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: –
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #12622 - /shop/
Basket: #15 - /basket/
Checkout: #16 - /checkout/
My account: #17 - /my-account/
Terms and conditions: #10647 - /e-commerce-terms-and-conditions/

### Theme ###

Name: Scott Digital
Version: 1.0.0
Author URL: 
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: –

### WooCommerce PayPal Payments ###

Onboarded: ?
Shop country code: GB
WooCommerce currency supported: ?
PayPal card processing available in country: ?
Pay Later messaging available in country: ?
Webhook status: –
Vault enabled: ?
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: –

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
experimental-product-tour
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-page

Disabled Features: minified-js
settings

Daily Cron: ? Next scheduled: 2022-08-23 19:14:06 +00:00
Options: ?
Notes: 76
Onboarding: completed

### Action Scheduler ###

Complete: 2,544
Oldest: 2022-07-23 15:31:55 +0000
Newest: 2022-08-23 15:26:08 +0000

Pending: 4
Oldest: 2022-08-23 15:36:21 +0000
Newest: 2022-08-24 11:56:53 +0000

### Status report information ###

Generated at: 2022-08-23 15:27:44 +00:00

Thanks for getting back to me. The status report is below:

### WordPress Environment ###

WordPress address (URL): https://northernpaintsandcoatings.co.uk
Site address (URL): https://northernpaintsandcoatings.co.uk
WC Version: 6.8.0
REST API Version: ? 6.8.0
WC Blocks Version: ? 8.0.0
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: ?

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.30
PHP Post Max Size: 512 MB
PHP Time Limit: 120
PHP Max Input Vars: 8000
cURL Version: 7.71.0
OpenSSL/1.1.1p

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.35-MariaDB-log-cll-lve
Max Upload Size: 512 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.6.1
WC Database Prefix: wpgi_
Total Database Size: 54.89MB
Database Data Size: 39.34MB
Database Index Size: 15.55MB
wpgi_woocommerce_sessions: Data: 1.27MB + Index: 0.05MB + Engine MyISAM
wpgi_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_order_items: Data: 0.13MB + Index: 0.07MB + Engine MyISAM
wpgi_woocommerce_order_itemmeta: Data: 0.86MB + Index: 0.59MB + Engine MyISAM
wpgi_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_actionscheduler_actions: Data: 0.69MB + Index: 0.35MB + Engine MyISAM
wpgi_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_actionscheduler_logs: Data: 0.50MB + Index: 0.42MB + Engine MyISAM
wpgi_aioseo_cache: Data: 0.14MB + Index: 0.02MB + Engine MyISAM
wpgi_aioseo_notifications: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_aioseo_posts: Data: 0.12MB + Index: 0.01MB + Engine MyISAM
wpgi_commentmeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wpgi_comments: Data: 2.71MB + Index: 1.12MB + Engine MyISAM
wpgi_duplicator_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpgi_feedmanager_channel: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_feedmanager_country: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_feedmanager_feed_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_feedmanager_field_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpgi_feedmanager_product_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpgi_feedmanager_product_feedmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_feedmanager_source: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_litespeed_img_optm: Data: 0.23MB + Index: 0.13MB + Engine InnoDB
wpgi_litespeed_img_optming: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wpgi_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpgi_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpgi_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpgi_options: Data: 4.65MB + Index: 1.49MB + Engine MyISAM
wpgi_postmeta: Data: 21.13MB + Index: 8.90MB + Engine MyISAM
wpgi_posts: Data: 1.84MB + Index: 0.49MB + Engine MyISAM
wpgi_redirection_404: Data: 1.98MB + Index: 0.29MB + Engine MyISAM
wpgi_redirection_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_redirection_items: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wpgi_redirection_logs: Data: 0.31MB + Index: 0.04MB + Engine MyISAM
wpgi_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpgi_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_term_relationships: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpgi_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_usermeta: Data: 0.22MB + Index: 0.13MB + Engine MyISAM
wpgi_users: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpgi_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpgi_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_customer_lookup: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wpgi_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_order_product_lookup: Data: 0.10MB + Index: 0.09MB + Engine MyISAM
wpgi_wc_order_stats: Data: 0.30MB + Index: 0.21MB + Engine MyISAM
wpgi_wc_order_tax_lookup: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wpgi_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_wc_product_meta_lookup: Data: 0.02MB + Index: 0.04MB + Engine MyISAM
wpgi_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpgi_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpgi_wfpklist_template_data: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wpgi_woo_shippment_provider: Data: 0.07MB + Index: 0.01MB + Engine MyISAM
wpgi_yoast_indexable: Data: 1.48MB + Index: 0.33MB + Engine InnoDB
wpgi_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpgi_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpgi_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpgi_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

### Post Type Counts ###

acf-field: 178
acf-field-group: 15
attachment: 449
ct_template: 14
lp: 11
nav_menu_item: 25
oembed_cache: 1
page: 24
post: 6
product: 51
product_variation: 219
revision: 225
shop_coupon: 4
shop_order: 4209
shop_order_refund: 4
wpcode: 2

### Security ###

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

### Active Plugins (35) ###

Advanced Custom Fields PRO: by Delicious Brains – 5.12.3
All in One SEO: by All in One SEO Team – 4.2.3.1
Classic Editor: by WordPress Contributors – 1.6.2
Code Snippets: by Code Snippets Pro – 3.2.0
Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.3.1
Custom Post Type UI: by WebDevStudios – 1.12.1
Facebook for WooCommerce: by Facebook – 2.6.20
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.7.0
Site Kit by Google: by Google – 1.80.0
WPCode - Insert Headers, Footers, and Code Snippets: by WPCode – 2.0.1
Klaviyo: by Klaviyo
Inc. – 3.0.3

LiteSpeed Cache: by LiteSpeed Technologies – 5.1
Mailchimp for WooCommerce: by Mailchimp – 2.7.2
Northern Paints & Coatings Functions: by Scott Digital – 1.0.0
OptinMonster: by OptinMonster Popup Builder Team – 2.8.1
OxyNinja: by OxyNinja – 3.5.2
OxyExtras: by OxyExtras – 1.4.3
Oxygen Elements for WooCommerce: by Soflyy – 2.0
Oxygen: by Soflyy – 4.0.2
WooCommerce PDF Invoices, Packing Slips, Delivery Notes and Shipping Labels: by WebToffee – 3.0.4
Redirection: by John Godley – 5.3.2
Widgets for Trustpilot Reviews: by Trustindex.io  – 6.3.1
Trustpilot-reviews: by Trustpilot – 2.5.914
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.22.14

User Switching: by John Blackbourn & contributors – 1.7.0
Advanced Shipment Tracking for WooCommerce: by zorem – 3.4.5
Product Feed PRO for WooCommerce: by AdTribes.io – 11.8.0
Product Feed PRO for WooCommerce: by AdTribes.io – 11.8.0
WooCommerce Stripe Gateway: by WooCommerce – 6.5.1
WooCommerce Google Analytics Integration: by WooCommerce – 1.5.13
WooCommerce PayPal Payments: by WooCommerce – 1.9.2
WooCommerce: by Automattic – 6.8.0
WordPress Importer: by wordpressdotorg – 0.7
WP Product Feed Manager: by Michel Jongbloed – 1.42.0
Widgets for Google Reviews: by Trustindex.io  – 9.4

### Inactive Plugins (6) ###

Duplicator: by Snap Creek – 1.4.7.1
Maintenance: by WebFactory Ltd – 4.06
Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.6.5
Variation Price Display Range for WooCommerce: by WPXtension – 1.2.3
White Label CMS: by www.videousermanuals.com – 2.3
Yoast SEO: by Team Yoast – 19.5.1

### Dropin Plugins (1) ###

object-cache.php: object-cache.php

### Settings ###

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

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: –
Enforce Approved Product Download Directories: –

### WC Pages ###

Shop base: #12622 - /shop/
Basket: #15 - /basket/
Checkout: #16 - /checkout/
My account: #17 - /my-account/
Terms and conditions: #10647 - /e-commerce-terms-and-conditions/

### Theme ###

Name: Scott Digital
Version: 1.0.0
Author URL: 
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: –

### WooCommerce PayPal Payments ###

Onboarded: ?
Shop country code: GB
WooCommerce currency supported: ?
PayPal card processing available in country: ?
Pay Later messaging available in country: ?
Webhook status: –
Vault enabled: ?
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: –

### Admin ###

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
experimental-product-tour
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-page

Disabled Features: minified-js
settings

Daily Cron: ? Next scheduled: 2022-08-18 19:14:06 +00:00
Options: ?
Notes: 76
Onboarding: completed

### Action Scheduler ###

Complete: 2,613
Oldest: 2022-08-16 10:11:03 +0000
Newest: 2022-08-18 07:42:45 +0000

Pending: 4
Oldest: 2022-08-18 07:57:45 +0000
Newest: 2022-08-18 11:40:36 +0000

### Status report information ###

Generated at: 2022-08-18 07:43:44 +00:00

I’ll try disabling the cache and updating permalinks a few times. The issue only happens rarely, so it’s been difficult to replicate. It probably only affects 1 in every 20 orders, so it might be a while until I know if this has worked.

Thanks for the update! I followed the instructions in the message from Yani (I’d seen and done it earlier anyway) and still no luck.

That makes sense, as I’ve used the plugin for years too without issue. This is the first time I’ve migrated from a local install to a server, however, which is why I was wondering if that was the issue.

Hopefully we’ll get an update.

That worked Kathryn – thank you very much. Sorry for the slow response, but appreciate you both taking the time to help.

Thanks for the code. I was already using a child theme so it was easy to add this in.

I’ve regenerated my thumbnails however the image is still being cropped (I changed 768 to 1000 in the hope this wouldn’t crop anything). You can see it on this post.

Thanks for the replies. It wasn’t a massively important thing, I was just curious about how easy it would be to implement – obviously not very!

Thanks for taking the time to help me though, I really appreciate it.

I’ve marked this as resolved even though I couldn’t get what I was looking for, but there’s not really much to add to the discussion now.

Yes and no ?? I’d like the option to choose whether it’s going to display this way, or the default full-width style. At the moment the only way I can make images look like this is by deleting the JS script that controls full width images, but I’d like the option to have them display the default way too.

Thanks for the help, but it’s actually the opposite thing I’m trying to do.

If the image isn’t big enough to look good as a big featured image, I’d like to manually display if without stretching so it looks like this.

Oh, and somehow figure out how to implement pagination into the query and only select posts from category 18 and 42.

Anyone?

After much looking around, I’ve realised that this is what I need:

<?php

$querystr = "
SELECT wposts.*
FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key = 'rating'
AND wpostmeta.meta_value = '8'
AND wposts.post_status = 'publish'
AND wposts.post_type = 'post'
ORDER BY wposts.post_date DESC
";

$pageposts = $wpdb->get_results($querystr, OBJECT);

?>

That’s pretty much sorted. All I want to do now is show posts with a rating of 8, 9, and 10 in the same list, instead of just 8. Anyone have any ideas?

You’re right, I’m an idiot. I’ll have a look into this magic quotes thing – any pointers?

I’m having exactly the same problem. No idea what’s up. I’m hosted on my own server as well.

I’ve got two websites on there, and the other one that I’m running WordPress on works fine except for the lack of images on the visual editor – but at least I can use it!