Slots and games casino real money.REGISTER NOW GET FREE 888 PESOS REWARDS!

Resolved yourbudweiser
(@yourbudweiser)

2 years, 8 months ago
Hello, I noticed recently that some orders are missing from WooCommerce but are being processed and approved in Authorize.net with the full order details plus Customer Billing Information. Although an order number is included in the authorize.net information, it does not exist in WooCommerce.

What can we do to pinpoint the issue? Disabling all plugins is not viable as the site is busy and we have thousands of orders but so far only two are missing. There are orders before and after the missing ones.

Here are results for the order from authorize.net:

============== Line Items ==============
Item: 145795
Description: xxxxxx
Quantity: 2
Unit Price: $xxxxxx (USD)
Item Total: $xxxxxx (USD)
```
============== RESULTS ==============
Response : This transaction has been approved.
Auth Code : xxxxxx
Transaction ID : xxxxxx
Address Verification : Street Address: Match -- First 5 Digits of Zip: Match
```
```
==== CUSTOMER BILLING INFORMATION ===
Customer ID : 0
First Name : xxxxxx 
Last Name : xxxxxx 
Company :
Address : xxxxxx 
City : xxxxxx 
State/Province : xxxxxx 
Zip/Postal Code : xxxxxx 
Country : USA
Phone : xxxxxx 
Fax :
E-Mail : xxxxxx 
```
==== CUSTOMER SHIPPING INFORMATION ===
First Name : xxxxxx
Last Name : xxxxxx
Company :
Address : xxxxxx
City : xxxxxx
State/Province : xxxxxx
Zip/Postal Code : xxxxxx
Country : xxxxxx

Viewing 7 replies - 1 through 7 (of 7 total)

Juan G. (woo-hc)

(@judagutor)

2 years, 8 months ago

Hi @yourbudweiser!

To know more about your setup and further check into your case, kindly provide us the following:

Your System Status: You can find it via WooCommerce > Status. Select ‘Get system report’ and then ‘Copy for support’. Once you do this, paste in here your response.
Fatal Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

Thanks!

Thread Starter

yourbudweiser

(@yourbudweiser)

2 years, 8 months ago


### WordPress Environment ###

WordPress address (URL): https://www.private.com
Site address (URL): https://www.private.com
WC Version: 6.2.0
REST API Version: ? 6.2.0
WC Blocks Version: ? 6.7.3
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.1.0
Log Directory Writable: ?
WP Version: 5.9.1
WP Multisite: ?
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.33
PHP Post Max Size: 50 MB
PHP Time Limit: 90
PHP Max Input Vars: 3000
cURL Version: 7.81.0
OpenSSL/1.1.1m

SUHOSIN Installed: –
MySQL Version: 5.7.37
Max Upload Size: 49 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.2.0
WC Database Prefix: wp_
Total Database Size: 4621.62MB
Database Data Size: 3215.33MB
Database Index Size: 1406.29MB
wp_woocommerce_sessions: Data: 2.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: 8.52MB + Index: 3.52MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 75.59MB + Index: 71.17MB + 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.14MB + Index: 0.16MB + 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_2_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_2_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_2_followup_coupons: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_followup_coupon_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_followup_customers: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2_followup_customer_carts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_followup_customer_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_followup_customer_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_followup_email_excludes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_followup_email_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_followup_email_orders: Data: 0.45MB + Index: 0.09MB + Engine InnoDB
wp_2_followup_email_tracking: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_2_followup_followup_history: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_followup_order_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_followup_order_items: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_followup_subscribers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_followup_subscribers_to_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_followup_subscriber_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_gf_entry: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_gf_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_moo_attribute: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_moo_category: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_moo_images: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_moo_item: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
wp_2_moo_item_group: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_moo_item_modifier_group: Data: 0.06MB + Index: 0.17MB + Engine InnoDB
wp_2_moo_item_option: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_moo_item_order: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wp_2_moo_item_tag: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_moo_item_tax_rate: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wp_2_moo_modifier: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_2_moo_modifier_group: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_moo_option: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_moo_order: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_2_moo_order_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_moo_tag: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_moo_tax_rate: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_options: Data: 2.03MB + Index: 0.03MB + Engine InnoDB
wp_2_phone_orders_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_postmeta: Data: 0.28MB + Index: 0.06MB + Engine InnoDB
wp_2_posts: Data: 0.16MB + Index: 0.06MB + Engine InnoDB
wp_2_simple_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_simple_history_contexts: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
wp_2_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_2_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_yoast_indexable: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
wp_2_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_actionscheduler_actions: Data: 686.02MB + Index: 680.47MB + 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: 583.30MB + Index: 406.66MB + 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_automatewoo_abandoned_carts: Data: 1.03MB + Index: 0.08MB + Engine InnoDB
wp_automatewoo_customers: Data: 2.48MB + Index: 3.34MB + Engine InnoDB
wp_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_automatewoo_guests: Data: 0.48MB + Index: 0.72MB + Engine InnoDB
wp_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_automatewoo_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_automatewoo_log_meta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_blogmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_blogs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_cartflows_ca_cart_abandonment: Data: 34.67MB + Index: 1.48MB + Engine InnoDB
wp_cartflows_ca_email_history: Data: 2.52MB + Index: 3.83MB + Engine InnoDB
wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_cc_abandoned_checkouts: Data: 2.02MB + Index: 0.05MB + Engine InnoDB
wp_commentmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 27.55MB + Index: 21.05MB + Engine InnoDB
wp_followup_coupons: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_coupon_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_customers: Data: 1.52MB + Index: 1.39MB + Engine InnoDB
wp_followup_customer_carts: Data: 6.28MB + Index: 0.64MB + Engine InnoDB
wp_followup_customer_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_customer_orders: Data: 1.52MB + Index: 0.42MB + Engine InnoDB
wp_followup_email_excludes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_email_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_email_orders: Data: 0.50MB + Index: 0.09MB + Engine InnoDB
wp_followup_email_tracking: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_followup_followup_history: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_order_categories: Data: 2.52MB + Index: 3.95MB + Engine InnoDB
wp_followup_order_items: Data: 2.52MB + Index: 5.48MB + Engine InnoDB
wp_followup_subscribers: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
wp_followup_subscribers_to_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_subscriber_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_gf_entry: Data: 2.52MB + Index: 0.38MB + Engine InnoDB
wp_gf_entry_meta: Data: 3.52MB + Index: 2.34MB + Engine InnoDB
wp_gf_entry_notes: Data: 1.52MB + Index: 0.27MB + Engine InnoDB
wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_form_view: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_hfcm_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_moo_attribute: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_moo_category: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_moo_images: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_moo_item: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_moo_item_group: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_moo_item_modifier_group: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_moo_item_option: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_moo_item_order: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_moo_item_tag: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_moo_item_tax_rate: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_moo_modifier: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_moo_modifier_group: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_moo_option: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_moo_order: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_moo_order_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_moo_tag: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_moo_tax_rate: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 38.34MB + Index: 3.03MB + Engine InnoDB
wp_phone_orders_log: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_pimwick_gift_card: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_pimwick_gift_card_activity: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_postmeta: Data: 1647.77MB + Index: 133.75MB + Engine InnoDB
wp_posts: Data: 12.42MB + Index: 7.84MB + Engine InnoDB
wp_registration_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + 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.09MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides: Data: 2.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides_bkp: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_sbi_feed_caches: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_sbi_instagram_feeds_posts: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_sbi_instagram_posts: Data: 0.28MB + Index: 0.00MB + Engine MyISAM
wp_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_simple_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_simple_history_contexts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_site: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_sitemeta: Data: 1.05MB + Index: 0.03MB + Engine InnoDB
wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.08MB + 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_ups_shipping_accessorial: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_account: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_config: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_delivery_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_fallback_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_license: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_logs_api: Data: 2.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_log_frontend: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_package_default: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_product_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_retry_api: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_services: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_shipments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ups_shipping_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_usermeta: Data: 26.52MB + Index: 23.06MB + Engine InnoDB
wp_users: Data: 1.52MB + Index: 0.77MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 2.52MB + Index: 1.88MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.14MB + Index: 0.19MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 10.52MB + Index: 10.80MB + Engine InnoDB
wp_wc_order_stats: Data: 2.52MB + Index: 3.47MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 1.52MB + Index: 0.56MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.05MB + 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_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfconfig: Data: 0.39MB + Index: 0.01MB + Engine MyISAM
wp_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wffilemods: Data: 1.59MB + Index: 0.32MB + Engine MyISAM
wp_wfhits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfissues: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wfknownfilelist: Data: 0.85MB + Index: 0.10MB + Engine MyISAM
wp_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wflogins: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfnotifications: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfstatus: Data: 0.04MB + Index: 0.02MB + Engine MyISAM
wp_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpmailsmtp_debug_events: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_yoast_indexable: Data: 5.52MB + Index: 6.91MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.17MB + Index: 0.23MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

acf-field: 169
acf-field-group: 18
attachment: 585
aw_workflow: 4
follow_up_email: 2
nav_menu_item: 33
oembed_cache: 1
page: 28
post: 15
product: 150
product_variation: 47
revision: 62
schema: 2
seedprod: 1
shipping_package: 2
shop_coupon: 5183
shop_order: 24709
shop_order_refund: 758
shop_subscription: 86
testimonials: 2

### Security ###

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

### Active Plugins (63) ###

Gravity Forms: by Gravity Forms – 2.5.16
Admin Columns Pro - Advanced Custom Fields (ACF): by AdminColumns.com – 2.7
ACF Autosize: by Yeah GbR – 2.0.15
Admin Columns Pro: by AdminColumns.com – 5.6.4
Advanced Custom Fields: Font Awesome: by Matt Keys – 4.0.1
Advanced Custom Fields PRO: by Delicious Brains – 5.11.4
AutomateWoo: by WooCommerce – 5.5.5
Classic Editor: by WordPress Contributors – 1.6.2
Constant Contact Forms by MailMunch: by MailMunch – 2.0.10
Constant Contact + WooCommerce: by Constant Contact – 1.4.0
Facebook for WooCommerce: by Facebook – 2.6.12
FedEx WooCommerce Shipping with Print Label: by PluginHive – 4.4.8
Header Footer Code Manager: by 99robots – 1.1.18
Smash Balloon Instagram Feed: by Smash Balloon – 6.0.4
Invisible reCaptcha: by Mihai Chelaru – 1.2.3
Jetpack: by Automattic – 10.7
Kadence WooCommerce Email Designer: by Kadence WP – 1.4.10
WooCommerce Load More Products: by BeRocket – 1.1.9.4
Page Template Dashboard: by Tom McFarlin – 1.8.0
Phone Orders for WooCommerce (Pro): by AlgolPlus – 3.6.3
PW WooCommerce Gift Cards Pro: by Pimwick
LLC – 1.362

Slider Revolution: by ThemePunch – 6.3.3
WooCommerce Side Cart: by XootiX – 2.1
WooCommerce UPS Shipping Plugin with Print Label: by PluginHive – 3.15.9
WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.13
Advanced Order Export For WooCommerce: by AlgolPlus – 3.2.2
WooCommerce Advanced Shipping Packages: by Jeroen Sormani – 1.1.8
WooCommerce Cost of Goods: by SkyVerge – 2.9.8
WooCommerce Authorize.Net Gateway: by SkyVerge – 3.2.6
WooCommerce Pixel Manager: by SweetCode – 1.14.3
WooCommerce Google Analytics Integration: by WooCommerce – 1.5.8
WooCommerce Min/Max Quantities: by WooCommerce – 2.4.15
WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.13.1
WooCommerce Smart Coupons: by StoreApps – 4.33.0
WooCommerce Subscriptions Gifting: by WooCommerce – 2.1.3
WooCommerce Subscriptions: by WooCommerce – 3.1.6
WooCommerce URL Coupons: by SkyVerge – 2.12.0
WooCommerce Variation Swatches and Photos: by Lucas Stark – 3.1.0
WooCommerce: by Automattic – 6.2.0 (update to version 6.3.0 is available)
WooThumbs for WooCommerce by Iconic: by Iconic – 4.8.0
WP HTML Mail - Email Template Designer: by Hannes Etzelstorfer // codemiq – 3.1.1
WP Mail SMTP: by WPForms – 3.3.0
Smush Pro: by WPMU DEV – 3.9.1
YITH Pre-Order for WooCommerce Premium: by YITH – 1.7.1
Advanced Custom Fields PRO: by Delicious Brains – 5.11.4
Advanced Custom Fields: Font Awesome: by Matt Keys – 4.0.1
Classic Editor: by WordPress Contributors – 1.6.2
Simple Image Sizes: by Rahe – 3.2.1
Really Simple SSL: by Really Simple Plugins – 5.2.3
Google Apps Login Enterprise: by Lever Technology LLC – 3.4.3
Disable Comments: by WPDeveloper – 2.3.3
Yoast SEO: by Team Yoast – 18.3
Schema: by Hesham – 1.7.9.4
Simple 301 Redirects: by WPDeveloper – 2.0.6
Facebook for WooCommerce: by Facebook – 2.6.12
Admin Columns Pro: by AdminColumns.com – 5.6.4
Smart Online Order for Clover: by Zaytech – 1.4.9
Follow-Up Emails: by WooCommerce – 4.9.15
WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.2.2

Phone Orders for WooCommerce (Pro): by AlgolPlus – 3.6.3
Gravity Forms Zero Spam: by GravityView – 1.2.1
MouseWheel Smooth Scroll: by KubiQ – 5.9
WooCommerce Dynamic Pricing: by Element Stark – 3.1.27

### Inactive Plugins (8) ###

Admin Columns Pro: by AdminColumns.com – 5.6.1
PW WooCommerce Gift Cards: by Pimwick
LLC – 1.201

Simple History: by P?r Thernstr?m – 3.2.0
Slider Revolution: by ThemePunch – 5.4.8.3
UPS Shipping and UPS Access Point? : Official Plugin: by UPS – 2.2.11
WooCommerce Coupon Restrictions: by WooCommerce – 1.8.3
WooCommerce UPS Shipping: by WooCommerce – 3.2.27
WPMU DEV Dashboard: by WPMU DEV – 4.10.6

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
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)
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: #115 - /shop/
Cart: #116 - /cart/
Checkout: #117 - /checkout/
My account: #118 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Key Largo Fisheries
Version: 1.0.0
Author URL: https://www.private.com
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: ?

### Templates ###

Overrides: theme/woocommerce/content-product.php
theme/woocommerce/content-product_cat.php version 2.6.1 is out of date. The core version is 4.7.0

Outdated Templates: ?
					
					
						Learn how to update

### Subscriptions ###

WCS_DEBUG: ? No
Subscriptions Mode: ? Live
Subscriptions Live URL: https://www.private.com
Subscription Statuses: trash: 1
wc-active: 81
wc-on-hold: 3
wc-cancelled: 1

WooCommerce Account Connected: ? No
Report Cache Enabled: ? Yes
Cache Update Failures: ? 0 failure

### Store Setup ###

Country / State: United States (US) — Florida

### Subscriptions by Payment Gateway ###

Authorize.Net Credit Card: wc-active: 80
wc-cancelled: 1
wc-on-hold: 3

### Payment Gateway Support ###

Authorize.Net Credit Card: products
card_types
payment_form
inline
lightbox
tokenization
token_editor
charge
charge-virtual
authorization
capture_charge
customer_decline_messages
refunds
voids
customer_id
add_payment_method
apple_pay
subscriptions
subscription_suspension
subscription_cancellation
subscription_reactivation
subscription_amount_changes
subscription_date_changes
multiple_subscriptions
subscription_payment_method_change_customer
subscription_payment_method_change_admin

### Authorize.Net Credit Card ###

Environment: Production
Tokenization Enabled: ?
Debug Mode: Off
Webhooks Enabled: ?
						No signature key configured

### Subscriptions Gifting ###

Gifted Subscriptions Count: 18
Subscriptions Gifting Template Theme Overrides: private/woocommerce/emails/recipient-new-initial-order.php

### Action Scheduler ###

Complete: 2,309,486
Oldest: 2022-02-08 14:16:14 +0000
Newest: 2022-03-09 18:51:39 +0000

Failed: 3,142
Oldest: 2022-01-10 16:36:20 +0000
Newest: 2022-03-09 16:36:43 +0000

Pending: 156
Oldest: 2022-03-09 22:05:06 +0000
Newest: 2023-03-03 20:56:40 +0000

### Status report information ###

Generated at: 2022-03-09 14:07:25 -05:00

FATAL ERRORS

2022-02-10T11:01:09+00:00 CRITICAL Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home/private/public_html/wp-content/plugins/woocommerce-pdf-invoices-packing-slips/vendor/dompdf/dompdf/src/Css/Style.php on line 883

2022-02-10T11:01:19+00:00 CRITICAL Allowed memory size of 268435456 bytes exhausted (tried to allocate 20480 bytes) in /home/private/public_html/wp-content/plugins/woocommerce-pdf-invoices-packing-slips/vendor/dompdf/dompdf/src/Css/Style.php on line 884

FATAL ERRORS

2022-02-21T13:25:52+00:00 CRITICAL Uncaught Error: Class 'WP_Optimize_Updates' not found in /home/private/public_html/wp-content/plugins/wp-optimize/wp-optimize.php:1572
Stack trace:
#0 /home/private/public_html/wp-content/plugins/wp-optimize/wp-optimize.php(532): WP_Optimize->run_updates()
#1 /home/private/public_html/wp-includes/class-wp-hook.php(303): WP_Optimize->plugins_loaded('')
#2 /home/private/public_html/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters(NULL, Array)
#3 /home/private/public_html/wp-includes/plugin.php(470): WP_Hook->do_action(Array)
#4 /home/private/public_html/wp-settings.php(441): do_action('plugins_loaded')
#5 /home/private/public_html/wp-config.php(104): require_once('/home/keylargof...')
#6 /home/private/public_html/wp-load.php(50): require_once('/home/keylargof...')
#7 /home/private/public_html/wp-blog-header.php(13): require_once('/home/keylargof...')
#8 /home/private/public_html/index.php(17): require('/home/keyl in /home/private/public_html/wp-content/plugins/wp-optimize/wp-optimize.php on line 1572

FATAL ERRORS

2022-03-04T20:38:10+00:00 CRITICAL Uncaught RuntimeException: Unable to claim actions. Database error. in /home/private/public_html/wp-content/plugins/woocommerce-smart-coupons/includes/libraries/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:675
Stack trace:
#0 /home/private/public_html/wp-content/plugins/woocommerce-smart-coupons/includes/libraries/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(599): ActionScheduler_DBStore->claim_actions(2266520, 10, NULL, Array, '')
#1 /home/private/public_html/wp-content/plugins/woocommerce-smart-coupons/includes/libraries/action-scheduler/classes/ActionScheduler_QueueRunner.php(153): ActionScheduler_DBStore->stake_claim(10)
#2 /home/private/public_html/wp-content/plugins/woocommerce-smart-coupons/includes/libraries/action-scheduler/classes/ActionScheduler_QueueRunner.php(132): ActionScheduler_QueueRunner->do_batch(10, 'Async Request')
#3 /home/private/public_html/wp-includes/class-wp-hook.php(307): ActionScheduler_QueueRunne in /home/keylargofisherie/public_html/wp-content/plugins/woocommerce-smart-coupons/includes/libraries/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 675

Juan G. (woo-hc)

(@judagutor)

2 years, 8 months ago

Thank you for sending the System Status and the Error log.

Since this seems related to the WooCommerce Authorize.Net Gateway premium extension that we support via our ticket queue at WooCommerce.com, you can contact us at WooCommerce.com > My Account > Support, and we will be happy to help further there.

You may need to log into your WooCommerce.com account before accessing that page.
?
You can include a link to this forum thread to keep track of what’s already been done.

Cheers!

Thread Starter

yourbudweiser

(@yourbudweiser)

2 years, 8 months ago

Is the order created before or after being submitted to Authorize.net? Is that the only issue you think could be responsible?

Thread Starter

yourbudweiser

(@yourbudweiser)

2 years, 8 months ago

Could you please explain why you think it’s an issue with Authorize.net? That seems to be the only thing that actually worked because the transactions was submitted with all the details and settled successfully.

Margaret S. woo-hc

(@margaretwporg)

2 years, 8 months ago

Hi @yourbudweiser

From the error logs it seems that there is a compatibility issue for sure.

You may want to run a conflict test to get to the root of the problem. Here’s the conflict test guide for reference: https://docs.woocommerce.com/document/how-to-test-for-conflicts/

We understand that it is not possible to run the test on your live production site. You can create a duplicate/staging site for the purpose, and create test orders. Many hosting providers offer site staging facilities, but if you don’t have such a feature, you can create one with the WP Staging plugin.

why you think it’s an issue with Authorize.net?

The issue may or may not be with Authorize.net. We do not have tools on this public forum to check your account, but as a premium plugin user you have access to premium support. Hope this clarifies. You can keep us posted on the progress and we will be happy to check further if required.

Thanks

Margaret S. woo-hc

(@margaretwporg)

2 years, 8 months ago

This thread has been inactive for a bit, so I’m going to mark it as closed. Hopefully, the above information was helpful!

Please feel free to open a new thread if you have any other questions.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Missing Orders’ is closed to new replies.