search

woocommerce / woocommerce

A customizable, open-source ecommerce platform built on WordPress. Build any commerce solution you can imagine.
https://woocommerce.com
9.15k stars 10.73k forks source link

Internal error when trying to connect to REST API #41866

Closed perceptions closed 5 months ago

perceptions commented 6 months ago

Prerequisites

Describe the bug

We are trying to connect an external database to Woo via an API, but every attempt to connect throws a critical error (copied from the server logs):

PHP Fatal error: Uncaught Error: Call to a member function get_id() on bool in /nas/content/live/sifts/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version1/class-wc-rest-orders-v1-controller.php:135\nStack trace:\n#0 /nas/content/live/sifts/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version3/class-wc-rest-posts-controller.php(363): WC_REST_Orders_V1_Controller->prepare_item_for_response(Object(WP_Post), Object(WP_REST_Request))\n#1 /nas/content/live/sifts/wp-includes/rest-api/class-wp-rest-server.php(1193): WC_REST_Posts_Controller->get_items(Object(WP_REST_Request))\n#2 /nas/content/live/sifts/wp-includes/rest-api/class-wp-rest-server.php(1041): WP_REST_Server->respond_to_request(Object(WP_REST_Request), '/wc/v1/orders', Array, NULL)\n#3 /nas/content/live/sifts/wp-includes/rest-api/class-wp-rest-server.php(431): WP_REST_Server->dispatch(Object(WP_REST_Request))\n#4 /nas/content/live/sifts/wp-includes/rest-api.php(424): WP_REST_Server->serve_request('/wc/v1/orders')\n#5 /nas/content/live/sifts/wp-i in /nas/content/live/sifts/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version1/class-wc-rest-orders-v1-controller.php on line 135

Oddly, this is only happening on staging and not on live, although they do differ to some degree. I have enabled the default theme, and I'm running ONLY Woo and the connector plugin (Novamodule).

Expected behavior

I expect the API connection to be successful.

Actual behavior

The attempt to connect to the Woo API returns an "internal server error," and the logs display the message in the bug description.

Steps to reproduce

  1. Create Rest API keys
  2. Insert keys into Celigo integrator.io and save the connection
  3. Test connection fails with critical "internal server error" Screenshot 2023-12-04 at 15-31-56 Celigo integrator io Integration Platform-as-a-Service (iPaaS)

WordPress Environment

`

WordPress Environment

WordPress address (URL): https://sifts.wpengine.com Site address (URL): https://sifts.wpengine.com WC Version: 8.3.1 REST API Version: ✔ 8.3.1 WC Blocks Version: ✔ 11.4.9 Action Scheduler Version: ✔ 3.6.4 Log Directory Writable: ✔ WP Version: 6.4.1 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: 7.4.33.4 PHP Post Max Size: 100 MB PHP Time Limit: 3600 PHP Max Input Vars: 10000 cURL Version: 7.74.0 OpenSSL/1.1.1w

SUHOSIN Installed: – MySQL Version: 8.0.34-26 Max Upload Size: 50 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔

Database

WC Database Version: 8.3.1 WC Database Prefix: wp_ Total Database Size: 1105.01MB Database Data Size: 789.62MB Database Index Size: 315.39MB wp_woocommerce_sessions: Data: 0.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.11MB + Index: 0.13MB + 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 wp_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_actionscheduler_actions: Data: 1.02MB + Index: 2.39MB + 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: 1.02MB + Index: 2.03MB + Engine InnoDB wp_admin_columns: Data: 0.06MB + Index: 0.02MB + Engine InnoDB wp_ahm_asset_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_ahm_assets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ahm_download_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ahm_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ahm_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ahm_social_conns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ahm_user_download_counts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_associatedAttendees: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_attendeeAnswers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_attendees: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_automatorwp_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_automatorwp_actions_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_automatorwp_automations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_automatorwp_automations_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_automatorwp_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_automatorwp_logs_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_automatorwp_triggers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_automatorwp_triggers_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_blog_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_blogmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_blogs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_cfw_acr_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.09MB + Index: 0.09MB + Engine InnoDB wp_crony_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_crony_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_fc_campaign_emails: Data: 9.52MB + Index: 10.09MB + Engine InnoDB wp_fc_campaign_url_metrics: Data: 2.52MB + Index: 1.52MB + Engine InnoDB wp_fc_campaigns: Data: 4.52MB + Index: 0.13MB + Engine InnoDB wp_fc_funnel_metrics: Data: 5.52MB + Index: 9.06MB + Engine InnoDB wp_fc_funnel_sequences: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_fc_funnel_subscribers: Data: 4.52MB + Index: 6.94MB + Engine InnoDB wp_fc_funnels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_fc_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fc_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_fc_sequence_tracker: Data: 3.52MB + Index: 8.02MB + Engine InnoDB wp_fc_smart_links: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fc_subscriber_meta: Data: 1.52MB + Index: 0.50MB + Engine InnoDB wp_fc_subscriber_notes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_fc_subscriber_pivot: Data: 9.52MB + Index: 12.55MB + Engine InnoDB wp_fc_subscribers: Data: 3.52MB + Index: 3.53MB + Engine InnoDB wp_fc_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fc_url_stores: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_ff_scheduled_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fluentform_draft_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fluentform_entry_details: Data: 0.30MB + Index: 0.00MB + Engine InnoDB wp_fluentform_form_analytics: Data: 167.69MB + Index: 0.00MB + Engine InnoDB wp_fluentform_form_meta: Data: 0.36MB + Index: 0.00MB + Engine InnoDB wp_fluentform_forms: Data: 0.30MB + Index: 0.00MB + Engine InnoDB wp_fluentform_logs: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_fluentform_order_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fluentform_submission_meta: Data: 0.14MB + Index: 0.00MB + Engine InnoDB wp_fluentform_submissions: Data: 0.36MB + Index: 0.00MB + Engine InnoDB wp_fluentform_subscriptions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fluentform_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fsmpt_email_logs: Data: 1.02MB + Index: 0.00MB + Engine InnoDB wp_groups_capability: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_groups_group: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_groups_group_capability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_groups_user_capability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_groups_user_group: Data: 0.41MB + Index: 0.25MB + Engine InnoDB wp_ld_group_workflow_interactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ld_group_workflows: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_ld_notifications_delayed_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_learndash_pro_quiz_category: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_learndash_pro_quiz_form: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_learndash_pro_quiz_lock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_learndash_pro_quiz_master: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_learndash_pro_quiz_prerequisite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_learndash_pro_quiz_question: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_learndash_pro_quiz_statistic: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_learndash_pro_quiz_statistic_ref: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_learndash_pro_quiz_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_learndash_pro_quiz_toplist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_learndash_user_activity: Data: 0.02MB + Index: 0.13MB + Engine InnoDB wp_learndash_user_activity_meta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_novashare_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_o_er_contacts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_o_er_contacts_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_o_er_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_o_er_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_o_er_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 13.11MB + Index: 0.25MB + Engine InnoDB wp_pmxe_exports: Data: 0.22MB + Index: 0.00MB + Engine InnoDB wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB wp_pmxe_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_hash: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_images: Data: 0.13MB + Index: 0.00MB + Engine InnoDB wp_pmxi_imports: Data: 0.41MB + Index: 0.00MB + Engine InnoDB wp_pmxi_posts: Data: 2.52MB + Index: 0.00MB + Engine InnoDB wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_po_plugins: Data: 0.05MB + Index: 0.06MB + Engine InnoDB wp_postmeta: Data: 352.63MB + Index: 24.00MB + Engine InnoDB wp_posts: Data: 14.48MB + Index: 7.97MB + Engine InnoDB wp_rcp_customers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_rcp_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rcp_group_members: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_rcp_groupmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_rcp_groups: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_rcp_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_rcp_membership_counts: Data: 1.52MB + Index: 0.14MB + Engine InnoDB wp_rcp_membershipmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_rcp_memberships: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_rcp_payment_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_rcp_payments: Data: 0.02MB + Index: 0.13MB + Engine InnoDB wp_rcp_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_rcp_subscription_level_meta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_registration_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_relevanssi: Data: 1.52MB + Index: 0.89MB + Engine InnoDB wp_relevanssi_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_relevanssi_stopwords: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_relevanssi_tracking: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_restrict_content_pro: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_rsvpCustomQuestionAnswers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rsvpCustomQuestionAttendees: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rsvpCustomQuestions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_rsvpQuestionTypes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_signups: Data: 0.52MB + Index: 0.61MB + Engine InnoDB wp_site: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_sitemeta: Data: 1.52MB + Index: 0.03MB + Engine InnoDB wp_snippets: Data: 0.27MB + Index: 0.03MB + Engine InnoDB wp_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tec_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tec_occurrences: Data: 0.11MB + Index: 0.06MB + Engine InnoDB wp_tec_series_relationships: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 0.39MB + Index: 0.33MB + Engine InnoDB wp_term_taxonomy: Data: 0.31MB + Index: 0.22MB + Engine InnoDB wp_termmeta: Data: 2.52MB + Index: 3.03MB + Engine InnoDB wp_terms: Data: 0.25MB + Index: 0.25MB + Engine InnoDB wp_toolset_associations: Data: 1.52MB + Index: 1.52MB + Engine InnoDB wp_toolset_connected_elements: Data: 1.52MB + Index: 0.75MB + Engine InnoDB wp_toolset_post_guid_id: Data: 1.52MB + Index: 2.80MB + Engine InnoDB wp_toolset_relationships: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_toolset_type_sets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_uap_action_log: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_uap_action_log_meta: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_uap_action_logs_view: Data: 0.00MB + Index: 0.00MB + Engine wp_uap_api_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_uap_api_log_response: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_uap_api_logs_view: Data: 0.00MB + Index: 0.00MB + Engine wp_uap_closure_log: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_uap_closure_log_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_uap_recipe_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_uap_recipe_log_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_uap_recipe_logs_view: Data: 0.00MB + Index: 0.00MB + Engine wp_uap_tokens_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_uap_trigger_log: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_uap_trigger_log_meta: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_uap_trigger_logs_view: Data: 0.00MB + Index: 0.00MB + Engine wp_usermeta: Data: 25.56MB + Index: 32.11MB + Engine InnoDB wp_users: Data: 3.52MB + Index: 4.53MB + Engine InnoDB wp_warehouse: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + 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_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_operational_data: 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_orders: Data: 0.02MB + Index: 0.13MB + Engine InnoDB wp_wc_orders_meta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + 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_wp_phpmyadmin_extension__errors_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpml_mails: Data: 4.52MB + Index: 0.02MB + Engine InnoDB wp_wpwhpro_authentication: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wsal_metadata: Data: 134.67MB + Index: 174.67MB + Engine InnoDB wp_wsal_occurrences: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wsal_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

Post Type Counts

acf-field: 63 acf-field-group: 21 attachment: 9847 custom_css: 1 customize_changeset: 3 elementor_library: 2 elesson: 195 elesson-resource: 771 en_orders_exporting: 2 external-links: 1312 fc_template: 9 gblocks_global_style: 4 gblocks_templates: 3 gp_elements: 101 groups: 2 holy-day: 224 ld-exam: 1 ld-notification: 1 lesson: 1621 lesson-plans: 318 nav_menu_item: 55 oembed_cache: 2 organization: 2187 page: 48 popup: 8 popup_theme: 2 post: 37 product: 26 product_variation: 6 promo: 10 resource: 9226 revision: 17 sfwd-assignment: 1 sfwd-certificates: 1 sfwd-courses: 7 sfwd-essays: 20 sfwd-lessons: 23 sfwd-question: 30 sfwd-quiz: 25 sfwd-topic: 23 shop_coupon: 9 shop_order: 71 shop_order_placehold: 15 tec_tc_ticket: 3 ticket-meta-fieldset: 3 tribe_event_series: 19 tribe_events: 720 tribe_organizer: 12 tribe_rsvp_attendees: 173 tribe_rsvp_tickets: 72 tribe_venue: 5 tribe_wooticket: 38 uo-recipe: 1 video: 80 view: 39 view-template: 5 waiting_list: 2 wp_block: 3 wp_global_styles: 2 wp_navigation: 1 wp_show_posts: 1 wp_template: 2 wp-types-group: 12 wpa-helper: 2 yith-product-list: 1 ywraq-pdf-template: 1 zoom-meetings: 5

Security

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

Active Plugins (4)

Novamodule : WooCommerce - NetSuite Integration Addon (Sophia Institute Press): by Novamodule – 1.0.0 Novamodule : WooCommerce - NetSuite Integration: by Nova Module – 2.4.1 WooCommerce Stripe Gateway: by WooCommerce – 7.7.0 WooCommerce: by Automattic – 8.3.1

Inactive Plugins (123)

Admin Columns Pro: by AdminColumns.com – 6.3.5 Advanced Cron Manager: by BracketSpace – 2.5.2 Advanced Custom Fields PRO: by WP Engine – 6.2.4 AffiliateWP - Affiliate Area Shortcodes: by AffiliateWP – 1.3.1 All-in-One WP Migration: by ServMask – 7.79 Another Show Hooks: by Exlac – 1.0.2 Autologin Links: by Paul Konstantin Gerke – 1.12.0 AutomatorWP: by AutomatorWP – 4.0.0 Better Search Replace: by WP Engine – 1.4.3 Categories Metabox Enhanced: by 1Fix.io – 0.7.1 Category Order and Taxonomy Terms Order: by Nsp-Code – 1.7.9 CheckoutWC: by Objectiv – 8.2.22 Classic Editor: by WordPress Contributors – 1.6.3 Code Snippets: by Code Snippets Pro – 3.6.2 Cohort Manager: by Training Spark – 1.1.11 Combined Query: by birgire – 1.2.2 Crony Cronjob Manager: by Scott Kingsley Clark – 0.5.0 Document Embedder: by bPlugins LLC – 1.8.4 Document Viewer for Office: by bPlugins LLC – 2.2.8 Download Plugins and Themes from Dashboard: by WPFactory – 1.8.5 Email Reminders: by wpdevelop oplugins – 2.0.4

Embed Any Document: by Awsm Innovations – 2.7.4 Enable Media Replace: by ShortPixel – 4.1.4 Event Calendar Newsletter: by Event Calendar Newsletter – 2.16 Event Tickets: by The Events Calendar – 5.7.0 Event Tickets Plus: by The Events Calendar – 5.8.0 FluentCRM - Marketing Automation For WordPress: by WP Email Newsletter Team - FluentCRM – 2.8.34 FluentCRM Pro: by Fluent CRM – 2.8.33 Fluent Forms: by Contact Form - WPManageNinja LLC – 5.1.5 Fluent Forms Pro Add On Pack: by Fluent Forms – 5.1.5 FluentSMTP: by FluentSMTP & WPManageNinja Team – 2.2.6 Force Regenerate Thumbnails: by Exactly WWW – 2.1.3 Free Gifts for WooCommerce: by Flintop – 9.5.0 Freight Shipping: by Sophia Institute Press – 1.0.0 GenerateBlocks: by Tom Usborne – 1.8.2 GenerateBlocks Pro: by Tom Usborne – 1.6.0 GP Premium: by Tom Usborne – 2.3.2 JSM Show Post Metadata: by JS Morisset – 3.8.0 LearnDash Instructors Tab: by WooNinjas – 1.0.2 LearnDash Licensing & Management: by LearnDash – 1.2 LearnDash LMS: by LearnDash – 4.7.0.1 LearnDash LMS - bbPress Integration: by LearnDash – 2.2.3 LearnDash LMS - Certificate Builder: by LearnDash – 1.0.3 LearnDash LMS - Groups Plus: by LearnDash – 1.1.1 LearnDash LMS - Notifications: by LearnDash – 1.6.2 LearnDash LMS - The Events Calendar Integration: by LearnDash – 1.0.1 LearnDash LMS - WooCommerce Integration: by LearnDash – 1.9.6 Live Cart by WP Engine: by WP Engine – 1.0.1 Mailchimp for WooCommerce: by Mailchimp – 3.3 Nextend Social Login: by Nextendweb – 3.1.11 Nextend Social Login Pro Addon: by Nextendweb – 3.1.7 Novashare: by forgemedia – 1.4.6 Ocean Popup Login (tweaked by Rummelhoff): by OceanWP – 2.0.1 Passwordless Login: by Cozmoslabs sareiodata – 1.1.2

Perfect Images (Optimize, Rebuild, Replace, Thumbnails, Retina): by Jordy Meow – 6.4.9 Perfmatters: by forgemedia – 2.1.3 Permalink Manager Pro: by Maciej Bis – 2.4.0 plugin load filter: by enomoto@celtislab – 4.0.17 Plugin Organizer: by Jeff Sterup – 10.1.10 Popup Maker: by Popup Maker – 1.18.2 Query Monitor: by John Blackbourn – 3.15.0 Relevanssi Premium: by Mikko Saari – 2.24.4 Repeat Order for Woocommerce: by polyres – 1.3.1 Restrict Content Pro: by Restrict Content Pro – 3.5.34 Restrict Content Pro - Group Accounts: by iThemes – 2.2.2 RSVP: by WPChill – 2.7.13 Safe SVG: by 10up – 2.2.2 Simple Image Sizes: by Rahe – 3.2.2 Simple Local Avatars: by 10up – 2.7.6 Spectra: by Brainstorm Force – 2.10.3 Sticky Block: by Senff – 1.11 String Locator: by InstaWP – 2.6.3 SVG Support: by Benbodhi – 2.5.5 Table of Contents: by Achal Jain – 1.0.2 Temporary Login Without Password: by StoreApps – 1.8.2 The Events Calendar: by The Events Calendar – 6.2.8.1 The Events Calendar: Virtual Events: by The Events Calendar – 1.15.5 The Events Calendar Pro: by The Events Calendar – 6.2.4 The SEO Framework: by The SEO Framework Team – 5.0.1 TinyPNG - JPEG, PNG & WebP image compression: by TinyPNG – 3.4.3 Toolset Blocks: by OnTheGoSystems – 1.6.10 Toolset Types: by OnTheGoSystems – 3.5.1 Transients Manager: by WPBeginner – 2.0.3 Uncanny Automator: by Uncanny Automator Uncanny Owl – 5.3

User Menus: by Code Atlantic – 1.3.2 User Role Editor Pro: by Vladimir Garagulia – 4.63.5 User Switching: by John Blackbourn & contributors – 1.7.2 Video Conferencing with Zoom: by Deepen Bajracharya – 4.3.3 Widget Shortcode: by Hassan Derakhshandeh – 0.3.5 WooCommerce Conditional Shipping and Payments: by WooCommerce – 1.14.5 WooCommerce Dynamic Pricing: by Element Stark – 3.2.1 WooCommerce Extended Coupon Features PRO: by Soft79 – 3.3.3 WooCommerce Force Sells: by Themesquad – 1.2.0 WooCommerce Free Gift Coupons: by Kathy Darling – 3.4.2 WooCommerce Google Analytics Pro: by SkyVerge – 2.0.4 WooCommerce Invoice Gateway: by Stuart Duff – 2.0.1 WooCommerce Pre-Orders: by WooCommerce – 2.0.1 WooCommerce Shipment Tracking: by WooCommerce – 2.3.1 WooCommerce Social Login: by SkyVerge – 2.13.0 WooCommerce UPS Shipping: by WooCommerce – 3.4.2 WooCommerce USPS Shipping: by WooCommerce – 4.6.3 WordPress Core: by – 1.7.2 WordPress Fix: by – WordPress Importer: by wordpressdotorg – 0.8.1 WP Activity Log: by Melapress – 4.6.1 WP Activity Log (Premium): by WP White Security – 4.3.6 WP All Export - ACF Export Add-On Pro: by Soflyy – 1.0.5 WP All Export - User Export Add-On Pro: by Soflyy – 1.0.7 WP All Export Pro: by Soflyy – 1.8.3 WP All Import - ACF Add-On: by Soflyy – 3.3.8 WP All Import - Toolset Types Add-On Pro: by Soflyy – 1.0.6 WP All Import - User Import Add-On Pro: by Soflyy – 1.1.8 WP All Import Pro: by Soflyy – 4.8.5 WP Engine Smart Plugin Manager: by WP Engine – 5.17.1 WP Mail Logging: by WP Mail Logging Team – 1.12.0 WP Mail SMTP: by WP Mail SMTP – 3.10.0 WP Migrate: by Delicious Brains – 2.3.3 WP phpMyAdmin: by Puvox.software – 5.2.1.02 WP System Cache: by WordPress – 14.2.9 WPWing Sticky Block: by WPWing – 1.0.1 YITH Easy Order Page for WooCommerce: by YITH – 1.27.0 YITH Request a Quote for WooCommerce Premium: by YITH – 4.19.1 Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5

Dropin Plugins (1)

advanced-cache.php: advanced-cache.php

Must Use Plugins (8)

Force Strong Passwords - WPE Edition: by Jason Cosper – 1.8.0 Plugin Organizer MU: by Jeff Sterup – 10.1.9 Rummelhoff Custom MU Plugin: by David Rummelhoff – 1.0.6 WP Engine Cache Plugin: by WP Engine – 1.1.5 WP Engine Seamless Login Plugin: by WP Engine – 1.6.1 WP Engine Security Auditor: by wpengine – 1.1.1 WP Engine System: by WP Engine – 5.0.1 WP Migrate DB Pro Compatibility: by Delicious Brains – 1.2

Settings

API Enabled: – Force SSL: – Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: course (course) 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 screen enabled: ✔ HPOS feature enabled: ✔ Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore HPOS data sync enabled: –

WC Pages

Shop base: #31392 - /shop/ Cart: #31393 - /cart/ Checkout: #31394 - /checkout/ My account: #31395 - /account/ Terms and conditions: ❌ Page not set

Theme

Name: Twenty Twenty-Four Version: 1.0 Author URL: https://wordpress.org 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: ❌ Not declared

Templates

Overrides: /nas/content/live/sifts/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/error.php /nas/content/live/sifts/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/notice.php /nas/content/live/sifts/wp-content/plugins/woocommerce/packages/woocommerce-blocks/templates/notices/success.php

Admin

Enabled Features: activity-panels analytics product-block-editor coupons core-profiler 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 product-variation-management remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page

Disabled Features: customize-store minified-js new-product-management-experience product-virtual-downloadable product-external-affiliate settings async-product-editor-category-field

Daily Cron: ✔ Next scheduled: 2023-12-05 14:06:25 -05:00 Options: ✔ Notes: 37 Onboarding: completed

Action Scheduler

Complete: 794 Oldest: 2023-11-04 19:00:10 -0400 Newest: 2023-12-04 14:26:11 -0500

Failed: 76 Oldest: 2023-11-06 18:00:08 -0500 Newest: 2023-12-04 15:32:12 -0500

Pending: 4 Oldest: 2023-12-04 15:37:12 -0500 Newest: 2023-12-11 11:52:08 -0500

Status report information

Generated at: 2023-12-04 15:32:48 -05:00 `

Isolating the problem

barryhughes commented 5 months ago

Hi @perceptions,

Am I right in thinking you are using REST API v1? If so, as you'll see in the docs, this version has been deprecated since our 3.0 release.

v1-rest-api-deprecated

As far as I can see, fetching orders via our V2 or V3 endpoints will not trigger this same code path. Can you investigate switching to V3/reach out to the integration provider for help with this? If I'm incorrect and you/your integration are actually using a currently supported version of the API, can you provide information about the actual request or ask the provider to do so?

barryhughes commented 5 months ago

If this is only a problem with V1, we'll probably go ahead and close this.

perceptions commented 5 months ago

I just confirmed that the integrator uses v3 for all the calls(customer, order, and products).

On Fri, Dec 8, 2023 at 7:34 PM Barry Hughes @.***> wrote:

Hi @perceptions https://github.com/perceptions,

Am I right in thinking you are using REST API v1 https://woocommerce.github.io/woocommerce-rest-api-docs/wp-api-v1.html#introduction? If so, as you'll see in the docs, this version has been deprecated since our 3.0 release. v1-rest-api-deprecated.png (view on web) https://github.com/woocommerce/woocommerce/assets/3594411/b6d17f87-03c0-4384-94a7-f09707228fe1

As far as I can see, fetching orders via our V2 or V3 endpoints will not trigger this same code path. Can you investigate switching to V3/reach out to the integration provider for help with this? If I'm incorrect and you/your integration are actually using a currently supported version of the API, can you provide information about the actual request or ask the provider to do so?

— Reply to this email directly, view it on GitHub https://github.com/woocommerce/woocommerce/issues/41866#issuecomment-1848008345, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABTW4DGR2PJO3CTBJEHIDPDYIOWYZAVCNFSM6AAAAABAGSVC6OVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNBYGAYDQMZUGU . You are receiving this because you were mentioned.Message ID: @.***>

barryhughes commented 5 months ago

I just confirmed that the integrator uses v3 for all the calls(customer, order, and products).

I'm just a bit puzzled because I see this in the stack trace you shared, which indicates an API V1 request:

WP_REST_Server->serve_request('/wc/v1/orders')

Do you see the problem for other requests (for example, if you try to use the coupons endpoint) and can you see if the same issue occurs using just WooCommerce (no Celigo/Nova Module)?

github-actions[bot] commented 5 months ago

As a part of this repository's maintenance, this issue is being marked as stale due to inactivity. Please feel free to comment on it in case we missed something.

After 7 days with no activity this issue will be automatically be closed.
github-actions[bot] commented 5 months ago

This issue was closed because it has been 14 days with no activity.