Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Internal error when trying to connect to REST API #41866

Closed
4 of 5 tasks
perceptions opened this issue Dec 4, 2023 · 6 comments
Closed
4 of 5 tasks

Internal error when trying to connect to REST API #41866

perceptions opened this issue Dec 4, 2023 · 6 comments
Labels
focus: rest api Issues related to WooCommerce REST API. needs: author feedback The issue/PR needs a response from any of the parties involved in the issue. status: can't reproduce Issues that can't be reproduced. status: stale Issues that have no had any activity for some time. team: Proton type: community contribution

Comments

@perceptions
Copy link

Prerequisites

  • I have carried out troubleshooting steps and I believe I have found a bug.
  • I have searched for similar bugs in both open and closed issues and cannot find a duplicate.

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

  • I have deactivated other plugins and confirmed this bug occurs when only WooCommerce plugin is active.
  • This bug happens with a default WordPress theme active, or Storefront.
  • I can reproduce this bug consistently using the steps above.
@barryhughes barryhughes added focus: rest api Issues related to WooCommerce REST API. team: Proton labels Dec 5, 2023
@barryhughes
Copy link
Member

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 barryhughes added the needs: author feedback The issue/PR needs a response from any of the parties involved in the issue. label Dec 9, 2023
@barryhughes
Copy link
Member

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

@perceptions
Copy link
Author

perceptions commented Dec 11, 2023 via email

@github-actions github-actions bot added needs: triage feedback Issues for which we requested feedback from the author and received it. and removed needs: author feedback The issue/PR needs a response from any of the parties involved in the issue. labels Dec 11, 2023
@barryhughes
Copy link
Member

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)?

@barryhughes barryhughes added the needs: author feedback The issue/PR needs a response from any of the parties involved in the issue. label Dec 12, 2023
@jorgeatorres jorgeatorres removed the needs: triage feedback Issues for which we requested feedback from the author and received it. label Dec 19, 2023
Copy link
Contributor

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 github-actions bot added the status: stale Issues that have no had any activity for some time. label Dec 27, 2023
Copy link
Contributor

github-actions bot commented Jan 3, 2024

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

@github-actions github-actions bot added the status: can't reproduce Issues that can't be reproduced. label Jan 3, 2024
@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Jan 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
focus: rest api Issues related to WooCommerce REST API. needs: author feedback The issue/PR needs a response from any of the parties involved in the issue. status: can't reproduce Issues that can't be reproduced. status: stale Issues that have no had any activity for some time. team: Proton type: community contribution
Projects
None yet
Development

No branches or pull requests

3 participants