search

OllieJones / fast-woo-order-lookup

WooCommerce / WordPress plugin to speed up searches for orders
GNU General Public License v2.0
13 stars 1 forks source link

plugin activated, nothing happens #27

Open rwkyyy opened 6 hours ago

rwkyyy commented 6 hours ago

Hi there, I manage multiple sites, on one it was everything ok, but on another instance installed it and nothing happened - checked the database and the table did not got created.

after some digging found this error:

WordPress database error Table 'xxx.wp_wc_orders_meta' doesn't exist for query SELECT *
FROM (
SELECT MAX(post_id) maxmeta, MIN(post_id) minmeta
FROM wp_postmeta
WHERE meta_key IN ('_billing_address_index','_shipping_address_index','_billing_last_name','_billing_email','_billing_phone')
) a
JOIN (
SELECT MAX(order_id) maxhpos, MIN(order_id) minhpos
FROM wp_wc_orders_meta WHERE meta_key IN ('_billing_address_index','_shipping_address_index')
) b ON 1=1
JOIN (
SELECT MAX(order_id) maxaddr, MIN(order_id) minaddr
FROM wp_wc_order_addresses
) c ON 1=1 made by activate_plugin, do_action('activate_fast-woo-order-lookup/fast-woo-order-lookup.php')

here is the system status:

System Status Report ``` ### WordPress Environment ### WordPress address (URL): [Redacted] Site address (URL): [Redacted] WC Version: 9.3.3 Legacy REST API Package Version: Modulul Legacy REST API nu este instalat pe acest site. Action Scheduler Version: ✔ 3.8.1 Log Directory Writable: ✔ WP Version: 6.6.2 WP Multisite: – WP Memory Limit: 256 Mo WP Debug Mode: – WP Cron: ✔ Language: ro_RO External object cache: – ### Server Environment ### Server Info: nginx/1.25.5 PHP Version: 8.3.12 PHP Post Max Size: 128 Mo PHP Time Limit: 300 PHP Max Input Vars: 10000 cURL Version: 7.68.0 OpenSSL/1.1.1f SUHOSIN Installed: – MySQL Version: 10.11.5-MariaDB-1:10.11.5+maria~ubu2004 Max Upload Size: 128 Mo Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### [REDACTED] ### Post Type Counts ### acf-field: 3 acf-field-group: 2 attachment: 960 aw_workflow: 2 br_minmax_limitation: 1 custom_css: 2 customize_changeset: 17 elementor_library: 4 nav_menu_item: 12 page: 31 post: 3 product: 37 pys_event: 11 razzi_product_tab: 3 revision: 186 shop_bogof_rule: 2 shop_order: 130085 shop_order_refund: 44 wp_global_styles: 1 wp_navigation: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (29) ### ManageWP - Worker: de GoDaddy – 4.9.20 Advanced Woo Search: de ILLID – 3.17 CurieRO: de Echipa CurieRO – 2.33.2 Comenzi duplicate xxxx: de rwky – 1.3.0 Elementor Pro: de Elementor.com – 3.24.3 Elementor: de Elementor.com – 3.24.5 Fast Woo Order Lookup: de Ollie Jones – 1.1.3 Index WP MySQL For Speed: de Oliver Jones Rick James – 1.5.2 Kadence WooCommerce Email Designer: de Kadence WP – 1.5.13 Kirki Customizer Framework: de Themeum – 5.1.0 Loco Translate: de Tim Whitlock – 2.6.11 Meta Box: de MetaBox.io – 5.10.2 Microsoft Clarity: de Microsoft – 0.10.2 PixelYourSite PRO: de PixelYourSite – 10.4.3 Post SMTP: de Post SMTP – 2.9.9 Razzi Addons: de Drfuri – 2.1.6 TinyPNG - JPEG, PNG & WebP image compression: de TinyPNG – 3.4.4 Two Factor: de Plugin Contributors – 0.9.1 Checkout Field Editor for WooCommerce: de ThemeHigh – 2.0.4 Advanced Order Export For WooCommerce: de AlgolPlus – 3.5.4 WooCommerce SmartBill Anulare: de Ciobanu George – 1.0.0 WooCommerce SmartBill: de Ciobanu George – 1.0.0 Payment Plugins for Stripe WooCommerce: de Payment Plugins support@paymentplugins.com – 3.3.75 WooCommerce Buy One Get One Free: de Oscar Gare – 5.0.3 (este disponibilă actualizarea la versiunea 5.3.5) WooCommerce PDF Watermark: de WooCommerce – 1.6.3 (este disponibilă actualizarea la versiunea 1.6.4) WooCommerce Product Bundles: de Woo – 8.1.0 (este disponibilă actualizarea la versiunea 8.1.1) WooCommerce Google Product Feed: de Ademti Software Ltd. – 10.12.5 (este disponibilă actualizarea la versiunea 11.0.14) WooCommerce: de Automattic – 9.3.3 WP 404 Auto Redirect to Similar Post: de hwk-fr – 1.0.5 ### Inactive Plugins (3) ### NETOPIA Payments Payment Gateway: de Netopia – 1.3 Urgent Cargus Printing AWB: de Uprise – 1.2.1 WooCommerce Postis: de Ciobanu George – 1.0.0 ### Dropin Plugins () ### advanced-cache.php: advanced-cache.php ### Must Use Plugins (3) ### Index WP MySQL For Speed Upgrade Filter for mu-plugins.: de – 1.4.11 Kinsta Must-use Plugins: de Kinsta Team – 3.1.1 ManageWP - Worker Loader: de GoDaddy – 1.0.0 ### Settings ### Legacy API Enabled: – Force SSL: – Currency: RON (lei) Currency Position: right_space Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: bundle (bundle) 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 de zile Level threshold: – Log directory size: 8 Mo ### WC Pages ### Bază magazin: #148971 - /magazin/ Coș: #45411 - /cos/ - Conține scurt-codul [woocommerce_cart] Finalizare: #45412 - /finalizare/ - Conține scurt-codul [woocommerce_checkout] Contul meu: #45413 - /contul-meu/ Termeni și condiții: #715 - /termeni-si-conditii/ ### Theme ### Name: XXX v4 Version: 1.0 Author URL: XXXX Child Theme: ✔ Parent Theme Name: Razzi Parent Theme Version: 2.1.6 Parent Theme Author URL: XXX WooCommerce Support: ✔ ### Templates ### Overrides: razzi/woocommerce/cart/cart-shipping.php razzi/woocommerce/cart/cart.php Versiunea razzi/woocommerce/cart/mini-cart.php a 7.9.0 este depășită. Versiunea nucleu este 9.2.0 razzi/woocommerce/checkout/review-order.php razzi-child/woocommerce/emails/email-downloads.php razzi/woocommerce/global/quantity-input.php razzi/woocommerce/myaccount/dashboard.php Versiunea razzi/woocommerce/myaccount/form-login.php a 7.0.1 este depășită. Versiunea nucleu este 9.2.0 Versiunea razzi/woocommerce/myaccount/form-lost-password.php a 9.0.0 este depășită. Versiunea nucleu este 9.2.0 Versiunea razzi/woocommerce/myaccount/orders.php a 9.1.0 este depășită. Versiunea nucleu este 9.2.0 razzi/woocommerce/order/order-details-customer.php razzi/woocommerce/order/order-details-item.php razzi/woocommerce/order/order-details.php razzi-child/woocommerce/order/order-downloads.php razzi/woocommerce/single-product/add-to-cart/external.php razzi/woocommerce/single-product/add-to-cart/grouped.php razzi/woocommerce/single-product/add-to-cart/simple.php razzi/woocommerce/single-product/add-to-cart/variable.php razzi/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php razzi/woocommerce/single-product/meta.php razzi/woocommerce/single-product/product-image.php razzi/woocommerce/single-product/product-thumbnails.php razzi/woocommerce/single-product/rating.php razzi/woocommerce/single-product/review-meta.php Outdated Templates: ❌ Află cum să actualizezi | Șterge cache-ul din starea sistemului cu informații despre temă ### WooCommerce Google Product Feed feeds ### b8a9ca30ff7730a6: Feed FB/G   Type: google   Category filter: -   Categories: - ### WooCommerce Google Product Feed options ### Include variations in feed: Enabled Send "item group ID": Enabled Expanded schema markup: - Debug key: 297178fb-cd56-4eda-a240-f58fdbd2847c ### WooCommerce Google Product Feed fields ### Title: Pre-populates from product product_title. Product description: Main product description (full preferred) plus variation description Availability (in stock products): Defaults to "in stock". Availability (backordered products): Defaults to "in stock". Availability (out of stock products): Defaults to "out of stock". Condition: Defaults to "new". Brand: Defaults to "Jurnalul unui Adam". Manufacturer Part Number (MPN): Product Type: Pre-populates from product_cat taxonomy. Google Product Category: Defaults to "Media > Books". Ships from country: Defaults to "RO". Transit time label: Defaults to "1". ### WooCommerce Google Product Feed DB status ### Database version: 17 Active database version: 17 wc_gpf_render_cache: Empty woocommerce_gpf_google_taxonomy (en-US): 5595 items ### Buy One Get One Free ### Display eligible free gift(s) on: Disable coupons: no Custom attributes: yes Rule #163337: title: "CADOU LANTISOR"; type: "buy_a_get_b"; applies_to: " All Products "; action: "add_to_cart"; free_product_id: "163336"; gift_products: " Product In list ( CADOU - lănțișor cu mesajul gravat (LNT) ) "; quantity_rules: "{"1":{"cart_quantity":1,"free_quantity":1,"discount":100,"cart_limit":1}}"; minimum_amount: "99"; exclude_coupon_validation: "1" ### Product Bundles ### Database Version: 8.1.0 Loopback Test: ✔ Template 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 navigation 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: experimental-blocks minified-js product-pre-publish-modal settings async-product-editor-category-field product-editor-template-system blueprint reactify-classic-payments-settings Daily Cron: ✔ Next scheduled: 2024-10-12 08:07:27 +03:00 Options: ✔ Notes: 53 Onboarding: completed ### Action Scheduler ### Finalizează: 4.350 Oldest: 2024-09-10 19:48:30 +0300 Newest: 2024-10-11 19:07:08 +0300 Eșuată: 30.125 Oldest: 2023-08-09 14:12:48 +0300 Newest: 2024-10-11 19:05:29 +0300 În așteptare: 4 Oldest: 2024-10-12 00:09:00 +0300 Newest: 2024-10-12 16:43:54 +0300 ### Status report information ### Generated at: 2024-10-11 19:09:05 +03:00 ```
rwkyyy commented 5 hours ago

found the cause, the wp_wc_orders_meta is a table part of the HPOS, in both cases (the one above and another one where I tested) they have the old WP postmeta system.