gerske

I switched off all plugins and this bug was gone. The problem is this plugin: WooCommerce EU/UK VAT Compliance.

Thank you. I will fix it with a code snippet that adds a shipping fee.

Any news, Ollie?

Thanks for the help. It still gets stuck with 1.1.6. ;-(

Here is the info you requested:

` wp-core

version: 6.7.2
site_language: nl_NL
user_language: nl_NL
timezone: Europe/Amsterdam
permalink: /%postname%/
https_status: true
multisite: false
user_registration: 0
blog_public: 1
default_comment_status: open
environment_type: production
user_count: 5454
dotorg_communication: true wp-paths-sizes

wordpress_path: /var/www/vhosts/popcards.nl/httpdocs
wordpress_size: 1,36 GB (1455785445 bytes)
uploads_path: /var/www/vhosts/popcards.nl/httpdocs/wp-content/uploads
uploads_size: 5,95 GB (6392039007 bytes)
themes_path: /var/www/vhosts/popcards.nl/httpdocs/wp-content/themes
themes_size: 74,43 MB (78046721 bytes)
plugins_path: /var/www/vhosts/popcards.nl/httpdocs/wp-content/plugins
plugins_size: 231,09 MB (242312375 bytes)
fonts_path: /var/www/vhosts/popcards.nl/httpdocs/wp-content/uploads/fonts
fonts_size: directory not found
database_size: 4,05 GB (4348919808 bytes)
total_size: 11,66 GB (12517103356 bytes) wp-dropins (2)

advanced-cache.php: true
maintenance.php: true wp-active-theme

name: Enfold (enfold)
version: 7.1
author: Kriesi
author_website: https://kriesi.at
parent_theme: none
theme_features: core-block-patterns, avia_exclude_bbPress, deactivate_tribe_events_calendar, avia_exclude_GFForms, avia_exclude_menu_exchange, avia_exclude_pojo_accessibility, avia_exclude_wp_accessibility, avia_exclude_relevanssi, avia_exclude_wpSEO, avia_exclude_wpml, avia_exclude_instagram_feed, avia_exclude_leaflet_map, avia_exclude_acf, avia_mega_menu, avia_improved_backend_style, avia_option_pages_toggles, avia_sidebar_manager, automatic-feed-links, post-formats, avia_post_meta_compat, force-post-thumbnails-in-widget, title-tag, nav_menus, post-thumbnails, widgets, widgets-block-editor, block-templates, menus, woocommerce, editor-styles, editor-style, customize-selective-refresh-widgets, responsive-embeds, editor-color-palette, editor-font-sizes, wc-product-gallery-zoom, wc-product-gallery-slider, avia-wc-30-product-gallery-feature
theme_path: /var/www/vhosts/popcards.nl/httpdocs/wp-content/themes/enfold wp-mu-plugins (1)

Index WP MySQL For Speed Upgrade Filter for mu-plugins.: author: (undefined), version: 1.5.3 wp-plugins-active (42)

Advanced Woo Search: version: 3.30, author: ILLID
Akismet Anti-spam: Spam Protection: version: 5.3.7, author: Automattic – Anti-spam Team
ATUM Action Logs: version: 1.4.7, author: Stock Management Labs™
ATUM Inventory Management for WooCommerce: version: 1.9.46, author: Stock Management Labs™
BEAR – Bulk Editor and Products Manager Professional for WooCommerce: version: 2.1.4.4, author: realmag777
Booster Plus for WooCommerce: version: 7.2.5, author: Pluggabl LLC
Code Snippets: version: 3.6.8, author: Code Snippets Pro
Decorator – WooCommerce Email Customizer: version: 2.0.3, author: WebToffee
Disable Cart Fragments: version: 2.3, author: Optimocha
Fast Woo Order Lookup: version: 1.1.6, author: Ollie Jones
Force Regenerate Thumbnails: version: 2.2.1, author: Exactly WWW
Iconic Sales Booster for WooCommerce: version: 1.25.0, author: Iconic
Index WP MySQL For Speed: version: 1.5.3, author: Oliver Jones, Rick James
Limit Login Attempts Reloaded: version: 2.26.18, author: Limit Login Attempts Reloaded
LiteSpeed Cache: version: 7.0.1, author: LiteSpeed Technologies
MailerLite – WooCommerce integration: version: 2.1.29, author: MailerLite
Mollie Payments for WooCommerce: version: 8.0.0, author: Mollie
MyParcel: version: 4.24.3, author: MyParcel
PDF Invoices & Packing Slips for WooCommerce: version: 4.3.0, author: WP Overnight
PDF Invoices & Packing Slips for WooCommerce – Premium Templates: version: 2.23.0, author: WP Overnight
PDF Invoices & Packing Slips for WooCommerce – Professional: version: 2.16.4, author: WP Overnight
PixelYourSite: version: 10.2.0, author: PixelYourSite
PixelYourSite Pinterest: version: 5.5.3.1, author: PixelYourSite
Postcode Checker for WooCommerce: version: 3.2.0, author: WP Overnight
Product Feed PRO for WooCommerce: version: 13.4.3, author: AdTribes.io
Rank Math SEO: version: 1.0.242, author: Rank Math SEO
Rank Math SEO PRO: version: 3.0.85, author: Rank Math SEO
Review Slider for WooCommerce: version: 1.5, author: LJ Apps
Temporary Login Without Password: version: 1.9.0, author: StoreApps
TranslatePress – Multilingual: version: 2.9.10, author: Cozmoslabs, Razvan Mocanu, Madalin Ungureanu, Cristophor Hurduban
TranslatePress – Personal: version: 1.4.4, author: Cozmoslabs, Razvan Mocanu, Madalin Ungureanu
User Role Editor: version: 4.64.4, author: Vladimir Garagulya
User Switching: version: 1.9.1, author: John Blackbourn
WebwinkelKeur: version: 3.37, author: Albert Peschar
WooCommerce: version: 9.8.1, author: Automattic
WooCommerce DYMO Print: version: 6.0.0, author: WP Fortune
WooCommerce Dynamic Pricing & Discounts: version: 2.4.6, author: RightPress
WooCommerce EU/UK VAT Compliance (Premium): version: 1.33.1, author: David Anderson
WooCommerce Extended Coupon Features PRO: version: 3.3.8, author: Soft79
Woocommerce Side Cart Premium: version: 4.0.4, author: XootiX
Woosa – bol.com for WooCommerce: version: 3.6.1, author: Woosa
WooThumbs for WooCommerce by Iconic: version: 5.12.0, author: Iconic code-snippets (45)

image_editor: WP_Image_Editor_Imagick
imagick_module_version: 1693
imagemagick_version: ImageMagick 6.9.13-10 Q16 x86_64 18376 https://legacy.imagemagick.org
imagick_version: 3.7.0
file_uploads: 1
post_max_size: 512M
upload_max_filesize: 512M
max_effective_size: 512 MB
max_file_uploads: 20
imagick_limits:
imagick::RESOURCETYPE_AREA: 93 GB
imagick::RESOURCETYPE_DISK: 9.2233720368548E+18
imagick::RESOURCETYPE_FILE: 37500
imagick::RESOURCETYPE_MAP: 47 GB
imagick::RESOURCETYPE_MEMORY: 23 GB
imagick::RESOURCETYPE_THREAD: 1
imagick::RESOURCETYPE_TIME: 0
imagemagick_file_formats: 3FR, 3G2, 3GP, A, AAI, AI, APNG, ART, ARW, AVI, AVS, B, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, C, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, EXR, FAX, FILE, FITS, FLV, FRACTAL, FTP, FTS, G, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, H, HALD, HDR, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K, K25, KDC, LABEL, M, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NRW, NULL, O, ORF, OTB, OTF, PAL, PALM, PAM, PANGO, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PS, PS2, PS3, PSB, PSD, PTIF, PWP, R, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCREENSHOT, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIDEO, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMF, WMV, WMZ, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, Y, YCbCr, YCbCrA, YUV
gd_version: bundled (2.1.0 compatible)
gd_formats: GIF, JPEG, PNG, WebP, BMP, AVIF, XPM
ghostscript_version: 9.27 wp-server

server_architecture: Linux 4.18.0-553.34.1.lve.el8.x86_64 x86_64
httpd_software: LiteSpeed
php_version: 8.3.19 64bit
php_sapi: litespeed
max_input_variables: 5000
time_limit: 300
memory_limit: 1024M
max_input_time: 300
upload_max_filesize: 512M
php_post_max_size: 512M
curl_version: 7.61.1 OpenSSL/1.1.1k
suhosin: false
imagick_availability: true
pretty_permalinks: true
htaccess_extra_rules: true
current: 2025-04-13T07:45:58+00:00
utc-time: Sunday, 13-Apr-25 07:45:58 UTC
server-time: 2025-04-13T09:45:56+02:00 wp-database

extension: mysqli
server_version: 10.11.10-MariaDB-cll-lve
client_version: mysqlnd 8.3.19
max_allowed_packet: 16777216
max_connections: 75 wp-constants

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /var/www/vhosts/popcards.nl/httpdocs/wp-content
WP_PLUGIN_DIR: /var/www/vhosts/popcards.nl/httpdocs/wp-content/plugins
WP_MEMORY_LIMIT: 1024M
WP_MAX_MEMORY_LIMIT: 1024M
WP_DEBUG: false
WP_DEBUG_DISPLAY: false
WP_DEBUG_LOG: true
SCRIPT_DEBUG: false
WP_CACHE: true
CONCATENATE_SCRIPTS: false
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: undefined
WP_DEVELOPMENT_MODE: undefined
DB_CHARSET: utf8
DB_COLLATE: undefined wp-filesystem

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
fonts: not writable
mu-plugins: writable fast-woo-order-lookup

request: Please create a support topic at https://ww.wp.xz.cn/support/plugin/fast-woo-order-lookup/ and paste this site info (all of it please) into the topic. We will take a look.
woo-features: analytics:enabled; product_block_editor:disabled; cart_checkout_blocks:disabled; rate_limit_checkout:disabled; marketplace:enabled; order_attribution:enabled; site_visibility_badge:enabled; hpos_fts_indexes:disabled; hpos_datastore_caching:disabled; remote_logging:enabled; email_improvements:disabled; blueprint:disabled; reactify-classic-payments-settings:disabled; block_email_editor:disabled; custom_order_tables:disabled; cost_of_goods_sold:disabled
trigram-table: trigrams:76830;first_id:450;last_id:9209
error0: 2025-04-13 09:09:19 event Indexing start
error1: 2025-04-12 16:44:29
event
deactivate:
Deactivate
error2: 2025-04-12 16:36:10
event
activate:
Indexing start
error3: 2025-04-12 16:33:35
event
deactivate:
Deactivate
error4: 2025-04-12 16:22:52
event
activate:
Indexing start
error5: 2025-04-12 16:21:56
event
deactivate:
Deactivate
error6: 2025-04-12 15:35:13
event
activate:
Indexing start
error7: 2025-04-12 15:35:07
event
deactivate:
Deactivate
error8: 2025-04-12 15:03:12
event
activate:
Indexing start
error9: 2025-04-08 09:27:01
indexing
get_order_metadata:
error:
(indexing V1.1.4)
UJWT8j_postmeta:
0: CREATE TABLE UJWT8j_postmeta (
meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL DEFAULT 0,
meta_key varchar(255) NOT NULL,
meta_value longtext DEFAULT NULL,
PRIMARY KEY (post_id,meta_key,meta_id),
UNIQUE KEY meta_id (meta_id),
KEY meta_key (meta_key,meta_value(32),post_id,meta_id),
KEY meta_value (meta_value(32),meta_id)
) ENGINE=InnoDB AUTO_INCREMENT=4837392 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
UJWT8j_wc_orders_meta:
0: CREATE TABLE UJWT8j_wc_orders_meta (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_id bigint(20) unsigned NOT NULL,
meta_key varchar(255) NOT NULL,
meta_value text DEFAULT NULL,
PRIMARY KEY (order_id,meta_key,id),
UNIQUE KEY id (id),
KEY meta_key_value (meta_key,meta_value(32),order_id,id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
UJWT8j_wc_orders:
0: CREATE TABLE UJWT8j_wc_orders (
id bigint(20) unsigned NOT NULL,
status varchar(20) DEFAULT NULL,
currency varchar(10) DEFAULT NULL,
type varchar(20) DEFAULT NULL,
tax_amount decimal(26,8) DEFAULT NULL,
total_amount decimal(26,8) DEFAULT NULL,
customer_id bigint(20) unsigned DEFAULT NULL,
billing_email varchar(320) DEFAULT NULL,
date_created_gmt datetime DEFAULT NULL,
date_updated_gmt datetime DEFAULT NULL,
parent_order_id bigint(20) unsigned DEFAULT NULL,
payment_method varchar(100) DEFAULT NULL,
payment_method_title text DEFAULT NULL,
transaction_id varchar(100) DEFAULT NULL,
ip_address varchar(100) DEFAULT NULL,
user_agent text DEFAULT NULL,
customer_note text DEFAULT NULL,
PRIMARY KEY (id),
KEY status (status),
KEY date_created (date_created_gmt),
KEY customer_id_billing_email (customer_id,billing_email),
KEY billing_email (billing_email),
KEY type_status (type,status),
KEY parent_order_id (parent_order_id),
KEY date_updated (date_updated_gmt)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
UJWT8j_woocommerce_order_items:
0: CREATE TABLE UJWT8j_woocommerce_order_items (
order_item_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_item_name text NOT NULL,
order_item_type varchar(200) NOT NULL DEFAULT ”,
order_id bigint(20) unsigned NOT NULL,
PRIMARY KEY (order_item_id),
KEY order_id (order_id)
) ENGINE=InnoDB AUTO_INCREMENT=243362 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
UJWT8j_wc_order_addresses:
0: CREATE TABLE UJWT8j_wc_order_addresses (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_id bigint(20) unsigned NOT NULL,
address_type varchar(20) DEFAULT NULL,
first_name text DEFAULT NULL,
last_name text DEFAULT NULL,
company text DEFAULT NULL,
address_1 text DEFAULT NULL,
address_2 text DEFAULT NULL,
city text DEFAULT NULL,
state text DEFAULT NULL,
postcode text DEFAULT NULL,
country text DEFAULT NULL,
email varchar(320) DEFAULT NULL,
phone varchar(100) DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY address_type_order_id (address_type,order_id),
KEY order_id (order_id),
KEY email (email),
KEY phone (phone)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
post-types: adt_product_feed:4;at_checkout_ob:16;attachment:1319;atum_supplier:7;avia_framework_post:18;bol_invoice:4;bol_return:133;br_sale_report:2;cartflows_flow:1;cartflows_step:2;follow_up_email:1;jetpack_migration:2;jp_img_sitemap:1;jp_sitemap:1;jp_sitemap_master:1;language_switcher:10;nav_menu_item:38;oembed_cache:2;page:26;post:1;product:374;product_variation:1;product-feed:1;revision:637;rm_content_editor:1;shop_coupon:10;shop_order:69251;shop_order_refund:78;sp_wcslider:1;user_request:1;wcst_trigger:11;wp_global_styles:1;wp_navigation:1
order-postmeta-key: error Unknown column ‘wp_postmeta.meta_id’ in ‘ON’: SELECT meta_key, COUNT() num FROM UJWT8j_postmeta JOIN UJWT8j_posts ON wp_postmeta.meta_id = wp_posts.ID WHERE post_type = ‘shop_order’ GROUP BY meta_key order-types: error : SELECT CONCAT_WS(‘/’, type , status) ts, COUNT() num FROM UJWT8j_wc_orders GROUP BY type, status
order-meta: error : SELECT meta_key, COUNT(*) num FROM UJWT8j_wc_orders_meta GROUP BY meta_key

Hello Ollie, after upgrading to 1.1.4 and doing a search in the order I get a critical error. After deactivating the plugin, search works again. When activating again the error is back. So there seems to be something wrong with this new version. The former version did work.

Here is the info requested:

fast-woo-order-lookup

request: Please create a support topic at https://ww.wp.xz.cn/support/plugin/fast-woo-order-lookup/ and paste this site info (all of it please) into the topic. We will take a look.
error0: 2025-04-08 09:27:01
indexing
get_order_metadata:
error:
(indexing V1.1.4)
error1: 2025-04-08 09:15:16
indexing
get_order_metadata:
error:
(indexing V1.1.4)
UJWT8j_postmeta:
0: CREATE TABLE UJWT8j_postmeta (
meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL DEFAULT 0,
meta_key varchar(255) NOT NULL,
meta_value longtext DEFAULT NULL,
PRIMARY KEY (post_id,meta_key,meta_id),
UNIQUE KEY meta_id (meta_id),
KEY meta_key (meta_key,meta_value(32),post_id,meta_id),
KEY meta_value (meta_value(32),meta_id)
) ENGINE=InnoDB AUTO_INCREMENT=4824150 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
UJWT8j_wc_orders_meta:
0: CREATE TABLE UJWT8j_wc_orders_meta (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_id bigint(20) unsigned NOT NULL,
meta_key varchar(255) NOT NULL,
meta_value text DEFAULT NULL,
PRIMARY KEY (order_id,meta_key,id),
UNIQUE KEY id (id),
KEY meta_key_value (meta_key,meta_value(32),order_id,id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
UJWT8j_wc_orders:
0: CREATE TABLE UJWT8j_wc_orders (
id bigint(20) unsigned NOT NULL,
status varchar(20) DEFAULT NULL,
currency varchar(10) DEFAULT NULL,
type varchar(20) DEFAULT NULL,
tax_amount decimal(26,8) DEFAULT NULL,
total_amount decimal(26,8) DEFAULT NULL,
customer_id bigint(20) unsigned DEFAULT NULL,
billing_email varchar(320) DEFAULT NULL,
date_created_gmt datetime DEFAULT NULL,
date_updated_gmt datetime DEFAULT NULL,
parent_order_id bigint(20) unsigned DEFAULT NULL,
payment_method varchar(100) DEFAULT NULL,
payment_method_title text DEFAULT NULL,
transaction_id varchar(100) DEFAULT NULL,
ip_address varchar(100) DEFAULT NULL,
user_agent text DEFAULT NULL,
customer_note text DEFAULT NULL,
PRIMARY KEY (id),
KEY status (status),
KEY date_created (date_created_gmt),
KEY customer_id_billing_email (customer_id,billing_email),
KEY billing_email (billing_email),
KEY type_status (type,status),
KEY parent_order_id (parent_order_id),
KEY date_updated (date_updated_gmt)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
UJWT8j_woocommerce_order_items:
0: CREATE TABLE UJWT8j_woocommerce_order_items (
order_item_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_item_name text NOT NULL,
order_item_type varchar(200) NOT NULL DEFAULT '',
order_id bigint(20) unsigned NOT NULL,
PRIMARY KEY (order_item_id),
KEY order_id (order_id)
) ENGINE=InnoDB AUTO_INCREMENT=242857 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
UJWT8j_wc_order_addresses:
0: CREATE TABLE UJWT8j_wc_order_addresses (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_id bigint(20) unsigned NOT NULL,
address_type varchar(20) DEFAULT NULL,
first_name text DEFAULT NULL,
last_name text DEFAULT NULL,
company text DEFAULT NULL,
address_1 text DEFAULT NULL,
address_2 text DEFAULT NULL,
city text DEFAULT NULL,
state text DEFAULT NULL,
postcode text DEFAULT NULL,
country text DEFAULT NULL,
email varchar(320) DEFAULT NULL,
phone varchar(100) DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY address_type_order_id (address_type,order_id),
KEY order_id (order_id),
KEY email (email),
KEY phone (phone)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
post-types: adt_product_feed:4;at_checkout_ob:16;attachment:1317;atum_supplier:7;avia_framework_post:18;bol_invoice:4;bol_return:133;br_sale_report:2;cartflows_flow:1;cartflows_step:2;follow_up_email:1;jetpack_migration:2;jp_img_sitemap:1;jp_sitemap:1;jp_sitemap_master:1;language_switcher:10;nav_menu_item:38;oembed_cache:2;page:26;post:4;product:374;product_variation:1;product-feed:1;revision:636;rm_content_editor:1;shop_coupon:10;shop_order:69103;shop_order_refund:78;sp_wcslider:1;user_request:1;wcst_trigger:11;wp_global_styles:1;wp_navigation:1
order-postmeta-key: error Unknown column 'wp_postmeta.meta_id' in 'ON': SELECT meta_key, COUNT() num FROM UJWT8j_postmeta JOIN UJWT8j_posts ON wp_postmeta.meta_id = wp_posts.ID WHERE post_type = 'shop_order' GROUP BY meta_key order-types: error : SELECT CONCAT_WS('/', type , status) ts, COUNT() num FROM UJWT8j_wc_orders GROUP BY type, status
order-meta: error : SELECT meta_key, COUNT(*) num FROM UJWT8j_wc_orders_meta GROUP BY meta_key

Hi Kader, here is the System Status Report.

### WordPress Environment ###

WordPress address (URL): [Redacted]
Site address (URL): [Redacted]
WC Version: 9.6.0
Legacy REST API Package Version: De Legacy REST API plugin is niet geïnstalleerd op deze site.
Action Scheduler Version: ✔ 3.9.0
Log Directory Writable: ✔
WP Version: 6.7.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: –
Language: nl_NL
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 8.3.16
PHP Post Max Size: 512 MB
PHP Time Limit: 300
PHP Max Input Vars: 5000
cURL Version: 7.61.1
OpenSSL/1.1.1k

SUHOSIN Installed: –
MySQL Version: 10.11.10-MariaDB-cll-lve
Max Upload Size: 512 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

[REDACTED]

### Post Type Counts ###

adt_product_feed: 4
at_checkout_ob: 13
attachment: 1228
atum_supplier: 7
avia_framework_post: 18
bol_invoice: 4
bol_return: 133
br_sale_report: 2
cartflows_flow: 1
cartflows_step: 2
customize_changeset: 1
follow_up_email: 1
jetpack_migration: 2
jp_img_sitemap: 1
jp_sitemap: 1
jp_sitemap_master: 1
language_switcher: 10
nav_menu_item: 38
oembed_cache: 2
page: 26
post: 4
product: 442
product_variation: 1
product-feed: 1
revision: 673
rm_content_editor: 1
shop_coupon: 10
shop_order: 66113
shop_order_refund: 73
sp_wcslider: 1
user_request: 1
wcst_trigger: 11
wp_global_styles: 1
wp_navigation: 1

### Security ###

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

### Active Plugins (42) ###

Advanced Woo Search: door ILLID – 3.25
Akismet Anti-spam: Spam Protection: door Automattic - Anti-spam Team – 5.3.5
ATUM Action Logs: door Stock Management Labs™ – 1.4.5.2
ATUM Voorraadbeheer voor WooCommerce: door Stock Management Labs ™ – 1.9.43.1
Booster Plus for WooCommerce: door Pluggabl LLC – 7.2.3
Code Snippets: door Code Snippets Pro – 3.6.6.1
Decorateur - WooCommerce E-mail Customizer: door WebToffee – 2.0.0
Disable Cart Fragments: door Optimocha – 2.3
Force Regenerate Thumbnails: door Exactly WWW – 2.2.1
Iconic Sales Booster for WooCommerce: door Iconic – 1.24.0
WooThumbs for WooCommerce by Iconic: door Iconic – 5.10.1
Limit Login Attempts Reloaded: door Limit Login Attempts Reloaded – 2.26.16
LiteSpeed Cache: door LiteSpeed Technologies – 6.5.4
Mollie Payments for WooCommerce: door Mollie – 7.9.1
PixelYourSite Pinterest: door PixelYourSite – 5.5.2
PixelYourSite: door PixelYourSite – 10.0.4
Review Slider for WooCommerce: door LJ Apps – 1.5
Rank Math SEO PRO: door Rank Math SEO – 3.0.79
Rank Math SEO: door Rank Math SEO – 1.0.236
Tijdelijke login zonder wachtwoord: door StoreApps – 1.8.5
TranslatePress - Multilingual: door Cozmoslabs
Razvan Mocanu
Madalin Ungureanu
Cristophor Hurduban – 2.9.3

TranslatePress - Personal: door Cozmoslabs
Razvan Mocanu
Madalin Ungureanu – 1.3.8

User Role Editor: door Vladimir Garagulya – 4.64.4
User Switching: door John Blackbourn – 1.9.1
WooCommerce Dynamic Pricing & Discounts: door RightPress – 2.4.6
WooCommerce NL Postcode Checker: door WP Overnight – 2.11.0
WebwinkelKeur: door Albert Peschar – 3.37
BEAR – Bulk Editor and Products Manager Professional for WooCommerce: door realmag777 – 2.1.4.4
MailerLite - WooCommerce integration: door MailerLite – 2.1.25
Product Feed PRO for WooCommerce: door AdTribes.io – 13.4.1
WooCommerce Analytics: door WooCommerce – 0.9.5
WooCommerce Extended Coupon Features PRO: door Soft79 – 3.3.8
WooCommerce DYMO Print: door WP Fortune – 6.0.0
WooCommerce EU/UK VAT Compliance (Premium): door David Anderson – 1.32.4
MyParcel: door MyParcel – 4.24.3
PDF Invoices & Packing Slips for WooCommerce: door WP Overnight – 3.9.6
PDF Invoices & Packing Slips for WooCommerce - Professional: door WP Overnight – 2.15.13
PDF Invoices & Packing Slips for WooCommerce - Premium Templates: door WP Overnight – 2.21.13
Woocommerce Side Cart Premium: door XootiX – 4.0.4
WooCommerce: door Automattic – 9.6.0
Woosa - bol.com for WooCommerce: door Woosa – 3.3.0
Woosa - Marktplaats voor WooCommerce: door Woosa – 1.8.1

### Inactive Plugins (1) ###

WooCommerce EU VAT Assistant: door Aelia – 2.1.17.241007

### Dropin Plugins () ###

advanced-cache.php: advanced-cache.php
maintenance.php: maintenance.php

### Settings ###

Legacy API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: left_space
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: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: –

### Logging ###

Enabled: ✔
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 dagen
Level threshold: –
Log directory size: 32 MB

### WC Pages ###

Winkelbasis: #11 - /winkel/
Winkelwagen: #12 - /winkelmand/ -  Bevat de [woocommerce_cart] shortcode
Afrekenen: #13 - /afrekenen/ -  Bevat de [woocommerce_checkout] shortcode
Mijn account: #14 - /mijn-account/
Algemene voorwaarden: #368 - /algemene-voorwaarden/

### Theme ###

Name: Enfold
Version: 6.0.8
Author URL: https://kriesi.at
Child Theme: ❌ – Als je WooCommerce aanpast op een hoofdthema dat je niet zelf hebt gebouwd
raden we je aan een subthema te gebruiken. Zie: Hoe maak je een subthema?

Theme type: Klassiek thema
WooCommerce Support: ✔

### Templates ###

Overrides: –

### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
onboarding
onboarding-tasks
pattern-toolkit-full-composability
product-custom-fields
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
printful
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
launch-your-store

Disabled Features: product-data-views
experimental-blocks
coming-soon-newsletter-template
minified-js
product-pre-publish-modal
settings
async-product-editor-category-field
product-editor-template-system
blueprint
reactify-classic-payments-settings
use-wp-horizon
add-to-cart-with-options-stepper-layout
blockified-add-to-cart

Daily Cron: ✔ Next scheduled: 2025-01-23 14:09:38 +01:00
Options: ✔
Notes: 16
Onboarding: completed

### Action Scheduler ###

Complete: 19.033
Oldest: 2024-12-29 22:10:15 +0100
Newest: 2025-01-23 09:29:56 +0100

Failed: 3.837
Oldest: 2020-02-14 09:20:39 +0100
Newest: 2025-01-22 11:19:52 +0100

Pending: 16
Oldest: 2025-01-23 11:16:56 +0100
Newest: 2026-01-01 00:00:01 +0100


### Status report information ###

Generated at: 2025-01-23 10:18:18 +01:00