Script errors while trying to use this, it was working
-
We have been using this plugin for a while alongside woocommerce bookings as for some reason that plugin doesn’t allow to export bookings. So I am using the snippets on this page – https://docs.algolplus.com/algol_order_export/woocommerce-bookings/ along with :
// you should set booking start date in "Date Range" (1st field) //remap settings add_filter('woe_settings_validate_defaults', function($settings){ if($settings['from_date']) { $settings['book_start'] = date("Ymd", strtotime($settings['from_date'])); $settings['from_date'] = ""; } return $settings; }); //filter orders add_filter( 'woe_sql_get_order_ids_where', function($where, $settings ){ global $wpdb; $where[]= "orders.ID IN ( SELECT DISTINCT post_parent FROM {$wpdb->posts} WHERE ID IN (SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key='_booking_start' AND meta_value LIKE '{$settings['book_start']}%'))"; return $where; },10,2); //filter order items add_filter( 'woe_skip_order_item', function($skip, $product, $item, $item_meta, $post ){ global $wpdb; $booking_id = $wpdb->get_var( "SELECT post_id FROM {$wpdb->postmeta} WHERE meta_key= '_booking_order_item_id' AND meta_value=" . intval( $item->get_id() ) ); if( $booking_id ) { $book_start_time = $wpdb->get_var( "SELECT meta_value FROM {$wpdb->postmeta} WHERE meta_key= '_booking_start' AND post_id=" . $booking_id ); // it's string in format 20200601000000 if( substr($book_start_time,0,8) !=WC_Order_Export_Engine::$current_job_settings['book_start']) $skip=true; } return $skip; },10,5);
This has been working great but now the export page just doesn’t load due to script errors. I have deactivated as many plugins that I can as it is a working website.
here is the system report if any help
### WordPress Environment ### WordPress address (URL): https://windmillfarmpark.co.uk Site address (URL): https://windmillfarmpark.co.uk WC Version: 5.5.2 REST API Version: ? 5.5.2 WC Blocks Version: ? 5.3.3 Action Scheduler Version: ? 3.2.1 WC Admin Version: ? 2.4.4 Log Directory Writable: ? WP Version: 5.8 WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: – WP Cron: – Language: en_GB External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.4.22 PHP Post Max Size: 1 GB PHP Time Limit: 3000 PHP Max Input Vars: 100000 cURL Version: 7.71.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 5.7.35 Max Upload Size: 1 GB 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: 5.5.2 WC Database Prefix: wp_ Total Database Size: 570.64MB Database Data Size: 484.43MB Database Index Size: 86.21MB 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: 1.52MB + Index: 0.34MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 10.52MB + Index: 8.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.08MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Data: 0.17MB + Index: 0.17MB + Engine InnoDB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_actions: Data: 4.52MB + Index: 2.50MB + 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: 3.52MB + Index: 3.03MB + Engine InnoDB wp_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_commentmeta: Data: 0.06MB + Index: 0.09MB + Engine InnoDB wp_comments: Data: 13.52MB + Index: 11.09MB + Engine InnoDB wp_duplicator_pro_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_duplicator_pro_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_gf_entry: Data: 0.34MB + Index: 0.06MB + Engine InnoDB wp_gf_entry_meta: Data: 1.52MB + Index: 0.66MB + Engine InnoDB wp_gf_entry_notes: Data: 0.19MB + Index: 0.06MB + Engine InnoDB wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_gf_form_meta: Data: 0.03MB + Index: 0.00MB + Engine InnoDB wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gf_form_view: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_litespeed_crawler: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_litespeed_crawler_blacklist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_litespeed_img_optm: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_litespeed_url_file: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailchimp_carts: Data: 0.45MB + Index: 0.00MB + Engine InnoDB wp_mailchimp_jobs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 7.39MB + Index: 0.20MB + Engine InnoDB wp_pimwick_gift_card: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_pimwick_gift_card_activity: Data: 0.08MB + Index: 0.02MB + Engine InnoDB wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_postmeta: Data: 418.63MB + Index: 46.13MB + Engine InnoDB wp_posts: Data: 9.52MB + Index: 6.06MB + Engine InnoDB wp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB wp_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 0.09MB + Index: 0.06MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_usermeta: Data: 4.52MB + Index: 4.03MB + Engine InnoDB wp_users: Data: 0.22MB + Index: 0.20MB + 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_appointments_availability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_appointment_relationships: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_bookings_availability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_bookings_availabilitymeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_booking_relationships: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 1.52MB + Index: 0.34MB + Engine InnoDB wp_wc_cvo_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.97MB + Engine InnoDB wp_wc_order_stats: Data: 1.52MB + Index: 0.77MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + 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_woocommerce_exported_csv_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_prominent_words: Data: 0.02MB + Index: 0.03MB + Engine InnoDB ### Post Type Counts ### acf-field: 16 acf-field-group: 3 attachment: 105 bookable_person: 6 bookable_resource: 1 global_product_addon: 1 nav_menu_item: 11 oembed_cache: 1 page: 17 popup: 3 popup_theme: 9 post: 4 product: 5 product_variation: 9 revision: 3 seedprod: 3 shop_coupon: 2 shop_order: 10758 shop_order_refund: 112 shop_subscription: 226 tribe_events: 2917 wc_booking: 13361 wc_membership_plan: 3 wc_product_tab: 9 wc_user_membership: 416 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (20) ### ManageWP - Worker: by GoDaddy – 4.9.9 Gravity Forms: by Gravity Forms – 2.5.8.2 Advanced Custom Fields PRO: by Delicious Brains – 5.9.9 WPBakery Page Builder: by Michael M - WPBakery.com – 6.7.0 LiteSpeed Cache: by LiteSpeed Technologies – 4.2 Mailchimp for WooCommerce: by Mailchimp – 2.5.2 PW WooCommerce Gift Cards Pro: by Pimwick LLC – 1.320 Really Simple SSL: by Really Simple Plugins – 5.0.7 FME Addons: Shop as a Customer for WooCommerce: by fmeaddons – 1.0.8 Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.9 WooCommerce Bookings: by WooCommerce – 1.15.43 WooCommerce Catalog Visibility Options: by Lucas Stark – 3.2.16 WooCommerce Checkout Field Editor: by WooCommerce – 1.6.2 WooCommerce Email Customizer: by cxThemes – 3.33 WooCommerce Stripe Gateway: by WooCommerce – 5.3.0 WooCommerce Memberships: by SkyVerge – 1.22.4 WooCommerce Product Add-ons: by WooCommerce – 4.1.0 WooCommerce Subscriptions: by WooCommerce – 3.1.4 WooCommerce Tab Manager: by SkyVerge – 1.14.1 WooCommerce: by Automattic – 5.5.2 ### Inactive Plugins (8) ### ACF Multi Dates Picker: by Nan GUO (Prodigious) – 1.1.0 Admin Columns Pro: by AdminColumns.com – 5.5.3 Admin Columns Pro - Advanced Custom Fields (ACF): by AdminColumns.com – 2.6.4 Admin Columns Pro - WooCommerce: by AdminColumns.com – 3.5.10 Admin Menu Editor Pro: by Janis Elsts – 2.15 Duplicator Pro: by Snap Creek – 4.0.3.2 Friendly User Agent for WooCommerce: by Blaze Concepts – 1.2.0 WP-Optimize Premium - Clean, Compress, Cache: by David Anderson Ruhani Rabin Team Updraft – 3.1.12 ### Must Use Plugins (1) ### installatron_hide_status_test.php: by – ### Settings ### API Enabled: – Force SSL: – Currency: GBP (£) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: appointment (appointment) booking (booking) external (external) gift-card (gift-card) grouped (grouped) pw gift card (pw-gift-card) 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: #527 - /shop/ Basket: #528 - /basket/ Checkout: #529 - /checkout/ My account: #530 - /my-account/ Terms and conditions: #12202 - /terms-conditions/ ### Theme ### Name: Windmill Farm Park Version: 1.0.0 Author URL: https://www.cagedfish.co.uk Child Theme: ? Parent Theme Name: Cagedfish Framework CFDTTHE7 Parent Theme Version: 9.15.0.1 Parent Theme Author URL: https://www.cagedfish.co.uk WooCommerce Support: ? ### Templates ### Overrides: cf-dt-the7/woocommerce/cart/cart.php cf-dt-the7/woocommerce/cart/cross-sells.php cf-dt-the7/woocommerce/cart/mini-cart.php cf-dt-the7/woocommerce/checkout/form-billing.php cf-dt-the7/woocommerce/checkout/form-checkout.php cf-dt-the7/woocommerce/checkout/form-coupon.php cf-dt-the7/woocommerce/checkout/form-login.php cf-dt-the7/woocommerce/checkout/form-shipping.php cf-dt-the7/woocommerce/checkout/review-order.php cf-dt-the7/woocommerce/checkout/thankyou.php cf-dt-the7/woocommerce/content-product.php cf-dt-the7/woocommerce/content-widget-product.php cf-dt-the7/woocommerce/content-widget-reviews.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/admin-cancelled-order.php version 3.7.0 is out of date. The core version is 4.1.0 /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/admin-failed-order.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/admin-new-order.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/customer-completed-order.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/customer-invoice.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/customer-new-account.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/customer-note.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/customer-on-hold-order.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/customer-processing-order.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/customer-refunded-order.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/customer-reset-password.php version 3.7.0 is out of date. The core version is 4.0.0 /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/email-addresses.php version 3.5.4 is out of date. The core version is 3.9.0 /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/email-customer-details.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/email-downloads.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/email-footer.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/email-header.php version 2.4.0 is out of date. The core version is 4.0.0 /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/email-order-details.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/email-order-items.php /home/windmillfarmpark/public_html/wp-content/plugins/woocommerce-email-control_dis/templates/emails/deluxe/email-styles.php version 3.3.0 is out of date. The core version is 4.0.0 cf-dt-the7/woocommerce/global/breadcrumb.php cf-dt-the7/woocommerce/global/form-login.php cf-dt-the7/woocommerce/global/quantity-input.php cf-dt-the7/woocommerce/loop/loop-end.php cf-dt-the7/woocommerce/loop/loop-start.php cf-dt-the7/woocommerce/loop/pagination.php cf-dt-the7/woocommerce/myaccount/form-login.php cf-dt-the7/woocommerce/notices/error.php cf-dt-the7/woocommerce/notices/notice.php cf-dt-the7/woocommerce/notices/success.php cf-dt-the7/woocommerce/order/order-details-customer.php cf-dt-the7/woocommerce/order/order-details.php cf-dt-the7/woocommerce/single-product/meta.php cf-dt-the7/woocommerce/single-product/price.php cf-dt-the7/woocommerce/single-product/related.php cf-dt-the7/woocommerce/single-product/up-sells.php cf-dt-the7/woocommerce/content-product_cat.php Outdated Templates: ? Learn how to update ### Memberships ### Restriction mode:: Hide content only Public content:: – Excluded from discounts:: 4 products Membership plans:: 3 Double VIP Membership:: Members: 2Access method: Manual assignment onlyAccess length: Specific length (1 years)Subscription: No Off Peak Membership:: Members: 96Access method: Product(s) purchaseAccess length: Specific length (1 days)Subscription: YesInstallment plan: No? The plan has purchasing discounts but none are active VIP Membership:: Members: 318Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: YesInstallment plan: No? The plan has purchasing discounts but none are active ### Subscriptions ### WCS_DEBUG: ? No Subscriptions Mode: ? Live Subscriptions Live URL: https://windmillfarmpark.co.uk Subscription Statuses: wc-active: 221 wc-pending-cancel: 2 wc-on-hold: 1 wc-cancelled: 2 WooCommerce Account Connected: ? No Report Cache Enabled: ? Yes Cache Update Failures: ? 0 failure ### Store Setup ### Country / State: United Kingdom (UK) ### Subscriptions by Payment Gateway ### Stripe: wc-active: 208 wc-cancelled: 2 wc-on-hold: 1 wc-pending-cancel: 2 ### Payment Gateway Support ### Stripe: products refunds tokenization add_payment_method subscriptions subscription_cancellation subscription_suspension subscription_reactivation subscription_amount_changes subscription_date_changes subscription_payment_method_change subscription_payment_method_change_customer subscription_payment_method_change_admin multiple_subscriptions pre-orders ### Action Scheduler ### Canceled: 7 Oldest: 2021-07-16 10:26:11 +0100 Newest: 2021-07-29 10:21:00 +0100 Complete: 10,303 Oldest: 2021-08-11 19:45:29 +0100 Newest: 2021-08-13 11:33:26 +0100 Failed: 200 Oldest: 2020-10-07 09:13:18 +0100 Newest: 2021-07-04 00:29:18 +0100 Pending: 402 Oldest: 2021-08-13 12:00:06 +0100 Newest: 2023-07-31 00:00:00 +0100 ### Status report information ### Generated at: 2021-08-13 11:49:18 +01:00
Any help would be greatly appreciated
The page I need help with: [log in to see the link]
Viewing 7 replies - 1 through 7 (of 7 total)
Viewing 7 replies - 1 through 7 (of 7 total)
- The topic ‘Script errors while trying to use this, it was working’ is closed to new replies.