Database Error and Sync Issue

  • jacobmcfarland

    (@jacobmcfarland)


    9 years, 4 months ago

    We are using a third party tool to manage inventory and order management, called Stitch. The integration has been working great till about mid Oct. Now when stitch sends over a request to change an order status it doesn’t happen (see the request and response below), and the inventory isn’t getting synced either. However when something is done inside of woo, for example a new order is made that gets sent to Stitch just fine, so it appears communication is working going our not coming in.

    I have done the following troubleshooting:

    • Had Stitch Troubleshoot their end, no issues exist
    • Disable all plugins and test, no solution
    • Disabled theme and Activated Twenty Twelve, no solution
    • Used Twenty Twelve and disabled all plugins with no soltuon
    • Reverted back to an older version of woocommerce, and went through the plugin and theme steps with no sucess
    • The final thing I did was have our hosting provider check things out and got an error code, see below
    • Also did all the above with an older version or wordpress

    My question is could these errors in our server log be the reason why Stitch can not change the orders in the database, or change the stock levels?. Is there anything that you can see that could point to a possible solution, as to why Stitch cannot update orders or inventory? Im not sure what else I can do to look for a solution or a fix so I’m at a dead end here.

    Website Url:
    https://www.littlebootpeep.com

    Woocommerce Status Report

    
### WordPress Environment ###

Home URL: https://www.littlebootpeep.com
Site URL: https://www.littlebootpeep.com
WC Version: 2.6.8
Log Directory Writable: ✔
WP Version: 4.6.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US

### Server Environment ###

Server Info: Flywheel/4.1.0
PHP Version: 5.6.28-1+deb.sury.org~precise+1
PHP Post Max Size: 100 MB
PHP Time Limit: 30
PHP Max Input Vars: 100000
cURL Version: 7.22.0
OpenSSL/1.0.1

SUHOSIN Installed: –
MySQL Version: ❌ 5.5.43 - We recommend a minimum MySQL version of 5.6. See: WordPress Requirements
Max Upload Size: 100 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 2.6.8
: 
woocommerce_sessions: ✔
woocommerce_api_keys: ✔
woocommerce_attribute_taxonomies: ✔
woocommerce_downloadable_product_permissions: ✔
woocommerce_order_items: ✔
woocommerce_order_itemmeta: ✔
woocommerce_tax_rates: ✔
woocommerce_tax_rate_locations: ✔
woocommerce_shipping_zones: ✔
woocommerce_shipping_zone_locations: ✔
woocommerce_shipping_zone_methods: ✔
woocommerce_payment_tokens: ✔
woocommerce_payment_tokenmeta: ✔

### Active Plugins (29) ###

Contact Form 7: by Takayuki Miyoshi – 4.5.1
Custom 404 Pro: by Kunal Nagar – 2.0.2
Google Analytics by MonsterInsights eCommerce tracking addon: by The MonsterInsights Team – 5.5.2
Google Analytics by MonsterInsights: by MonsterInsights – 5.5.2
Instant Search + for WooCommerce Search: by Fast Simon Inc – 1.5.8
WPBakery Visual Composer: by Michael M - WPBakery.com – 4.4.2
Maintenance: by fruitfulcode – 3.1.1
VarkTech Minimum Purchase for WooCommerce: by Vark – 1.09.7
Pinterest Verify: by Phil Derksen – 1.0.4
Postman SMTP: by Jason Hendriks – 1.7.2
Really Simple CAPTCHA: by Takayuki Miyoshi – 1.9
Slider Revolution: by ThemePunch – 5.1.6
WooCommerce Table Rate Shipping by Mangohour: by mangohour – 1.2.1
Tracking Code Manager: by IntellyWP – 1.11.1
Visual Form Builder: by Matthew Muro – 2.9.2
WooCommerce Advanced Free Shipping: by Jeroen Sormani – 1.0.11
WooCommerce Menu Extension: by August Infotech – 1.4.1
WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 1.5.37
WooCommerce Product Sort and Display LITE: by A3 Revolution – 1.7.0
WooCommerce Wholesale Pricing Plus: by IgniteWoo.com – 2.3.25
WooCommerce Wholesale Pricing: by IgniteWoo.com – 2.6.34
WooCommerce: by WooThemes – 2.6.8
WooThemes Helper: by WooThemes – 1.5.9
Yoast SEO Premium: by Team Yoast – 3.5.2
WP Max Submit Protect: by Academe Computing – 1.1.2
Yoast WooCommerce SEO: by Team Yoast – 3.2.1
YITH Infinite Scrolling: by YITHEMES – 1.0.6
YITH WooCommerce Stripe: by YIThemes – 1.2.9
YITH WooCommerce Wishlist: by YITHEMES – 2.0.16

### Settings ###

Force SSL: ✔
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2

### API ###

API Enabled: ✔

### WC Pages ###

Shop Base: #12034 - /shop/
Cart: #3030 - /cart/
Checkout: #12036 - /checkout/
My Account: #7 - /my-account/

### Taxonomies ###

Product Types: external (external)
gift-card (gift-card)
grouped (grouped)
simple (simple)
variable (variable)
wcpb (wcpb)

### Theme ###

Name: Bridge
Version: 10.1
Author URL: http://www.qodethemes.com/
Child Theme: ❌ – If you're modifying WooCommerce on a parent theme you didn't build personally
then we recommend using a child theme. See: How to create a child theme

WooCommerce Support: ✔

### Templates ###

Overrides: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: bridge/woocommerce/cart/cart-empty.php
bridge/woocommerce/cart/cart-shipping.php
bridge/woocommerce/cart/cart-totals.php
bridge/woocommerce/cart/cart.php
bridge/woocommerce/cart/shipping-calculator.php
bridge/woocommerce/checkout/form-coupon.php
bridge/woocommerce/checkout/thankyou.php
bridge/woocommerce/content-product.php
bridge/woocommerce/content-single-product.php
bridge/woocommerce/global/form-login.php
bridge/woocommerce/global/quantity-input.php
bridge/woocommerce/loop/add-to-cart.php
bridge/woocommerce/loop/loop-start.php
bridge/woocommerce/loop/pagination.php
bridge/woocommerce/loop/rating.php
bridge/woocommerce/loop/result-count.php
bridge/woocommerce/loop/sale-flash.php
bridge/woocommerce/myaccount/form-login.php
bridge/woocommerce/myaccount/form-lost-password.php
bridge/woocommerce/myaccount/my-address.php
bridge/woocommerce/myaccount/my-orders.php
bridge/woocommerce/single-product/add-to-cart/external.php
bridge/woocommerce/single-product/add-to-cart/grouped.php
bridge/woocommerce/single-product/add-to-cart/simple.php
bridge/woocommerce/single-product/add-to-cart/variable.php
bridge/woocommerce/single-product/related.php
bridge/woocommerce/single-product/sale-flash.php
bridge/woocommerce/single-product/tabs/additional-information.php
bridge/woocommerce/single-product/tabs/description.php
bridge/woocommerce/single-product/tabs/tabs.php
bridge/woocommerce/single-product/up-sells.php

    Stitch Request and Response

    
<em>Scott replied:
Hi Jacob,
I took a closer look at the raw data we get back from WooCommerce, and for some reason they are still showing the order as “processing” status when we send the “complete” status over to WooCommerce. Here is the call and response:</em>
Timestamp:
2016-11-21T14:01:30.208-08:00
SEND:
PUT /wc-api/v2/orders/23554?timestamp=1479765688.8684&consumer_key=ck_da9464f42456df7fba258d4085ff7a2115a87516&consumer_secret=cs_ea03b58e9e6c193e9ed25e68ed67376285fefb6e HTTP/1.1 Host: littlebootpeep.com User-Agent: Guzzle Content-Type: application/json Cache-Control: private, max-age=0, no-cache Pragma: no-cache Content-Length: 32 {"order":{"status":"completed"}}
RECEIVE:
HTTP/1.1 200 OK Date: Mon, 21 Nov 2016 22:01:30 GMT Content-Type: application/json; charset=UTF-8 Content-Length: 4294 Connection: keep-alive Vary: Accept-Encoding Set-Cookie: PHPSESSID=o1h64j2lattb8bi0ko0phqi8s0; path=/, wp_woocommerce_session_f4c97a8a6789c9d3954ca3f97b593e14=c76826674dc72b1340bc3e314fe4de49%7C%7C1479938489%7C%7C1479934889%7C%7C4d7ce604fed67fc24e08e7c9bd68c2a8; expires=Wed, 23-Nov-2016 22:01:29 GMT; Max-Age=172800; path=/ Pragma: no-cache X-FW-Hash: fr5n1972li Server: Flywheel/4.1.0 Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0 X-Cacheable: NO:Not Cacheable X-FW-Serve: TRUE X-Cache: MISS X-FW-Static: YES X-FW-Type: VISIT Accept-Ranges: bytes {"order":{"id":23554,[23554]order_number,“created_at”:“2016-11-21T16:25:17Z”,“updated_at”:“2016-11-21T16:25:17Z”,“completed_at”:“2016-11-21T16:25:17Z”,“status”:“processing”,“currency”:“USD”,“total”:“198.00”,“subtotal”:“198.00”,[18]total_line_items_quantity,“total_tax”:“0.00”,“total_shipping”:“0.00”,“cart_tax”:“0.00”,“shipping_tax”:“0.00”,“total_discount”:“0.00”,“shipping_methods”:“Standard Shipping Terms”,“payment_details”:{"method_id":“paypal”,“method_title”:“PayPal”,[true}]paid,“billing_address”:{"first_name":“Flare”,“last_name”:“DiChiaro”,“company”:“Interiors with Flare”,“address_1”:“3700 Madison Ave”,“address_2”:"",“city”:“Greensboro”,“state”:“NC”,“postcode”:“27403”,“country”:“US”,“email”:“interiorswithflare@yahoo.com”,“phone”:“336-500-5160”},“shipping_address”:{"first_name":“Flare”,“last_name”:“DiChiaro”,“company”:“Interiors with Flare”,“address_1”:“3352 W Friendly Ave”,“address_2”:“Suite 129”,“city”:“Greensboro”,“state”:“NC”,“postcode”:“27410”,“country”:"US"},“note”:"",“customer_ip”:“45.36.5.9”,“customer_user_agent”:“Mozilla/5.0 (iPad; CPU OS 10_0_2 like Mac OS X) AppleWebKit/602.1.50 (KHTML, like Gecko) Version/10.0 Mobile/14A456 Safari/602.1”,[1085]customer_id,“view_order_url”:“https://www.littlebootpeep.com/my-account/view-order/23554”,“line_items”;:[{"id":6826,“subtotal”:“66.00”,“subtotal_tax”:“0.00”,“total”:“66.00”,“total_tax”:“0.00”,“price”:“11.00”,[6]quantity,[null]tax_class,“name”:“Put A Bow On It Boot Topper”,[16769]product_id,“sku”:“1BWBr”,“meta”:[{"key":“option”,“label”:“Option”,“value”:"Brown"}]},{"id":6827,“subtotal”:“22.00”,“subtotal_tax”:“0.00”,“total”:“22.00”,“total_tax”:“0.00”,“price”:“11.00”,[2]quantity,[null]tax_class,“name”:“Put A Bow On It Boot Topper”,[16767]product_id,“sku”:“1BWGr”,“meta”:[{"key":“option”,“label”:“Option”,“value”:"Gray"}]},{"id":6828,“subtotal”:“22.00”,“subtotal_tax”:“0.00”,“total”:“22.00”,“total_tax”:“0.00”,“price”:“11.00”,[2]quantity,[null]tax_class,“name”:“Put A Bow On It Boot Topper”,[16768]product_id,“sku”:“1BWCh”,“meta”:[{"key":“option”,“label”:“Option”,“value”:"Charcoal"}]},{"id":6829,“subtotal”:“11.00”,“subtotal_tax”:“0.00”,“total”:“11.00”,“total_tax”:“0.00”,“price”:“11.00”,[1]quantity,[null]tax_class,“name”:“Put A Bow On It Boot Topper”,[21295]product_id,“sku”:“1BW”,“meta”:[{"key":“option”,“label”:“Option”,“value”:“Heather Brown with Batik Boho”}]},{"id":6830,“subtotal”:“22.00”,“subtotal_tax”:“0.00”,“total”:“22.00”,“total_tax”:“0.00”,“price”:“11.00”,[2]quantity,[null]tax_class,“name”:“Put A Bow On It Boot Topper”,[16764]product_id,“sku”:“1BWSc”,“meta”:[{"key":“option”,“label”:“Option”,“value”:“Sand-Camo”}]},{"id":6831,“subtotal”:“22.00”,“subtotal_tax”:“0.00”,“total”:“22.00”,“total_tax”:“0.00”,“price”:“11.00”,[2]quantity,[null]tax_class,“name”:“Put A Bow On It Boot Topper”,[16765]product_id,“sku”:“1BWBl”,“meta”:[{"key":“option”,“label”:“Option”,“value”:"Black"}]},{"id":6832,“subtotal”:“33.00”,“subtotal_tax”:“0.00”,“total”:“33.00”,“total_tax”:“0.00”,“price”:“11.00”,[3]quantity,[null]tax_class,“name”:“Put A Bow On It Boot Topper”,[16766]product_id,“sku”:“1BWCr”,“meta”:[{"key":“option”,“label”:“Option”,“value”:"Cream"}]}],“shipping_lines”:[{"id":6833,“method_id”:“free_wholesale_shipping”,“method_title”:“Standard Shipping Terms”,“total”:“0.00”}],“tax_lines”:[],“fee_lines”:[],“coupon_lines”:[],“wpo_wcpdf_invoice_number”:"",“customer”:{"id":1085,“created_at”:“2015-12-07T19:17:40Z”,“email”:“interiorswithflare@yahoo.com”,“first_name”:“Flare”,“last_name”:“DiChiaro”,“username”:“interiorswithflare@yahoo.com”,“role”:“wholesale_buyer”,“last_order_id”:“23554”,“last_order_date”:“2016-11-21T16:25:17Z”,[8]orders_count,“total_spent”:“1622.00”,“avatar_url”:“https://www.littlebootpeep.com/wp-content/plugins/speed-booster-pack/inc/images/1×1.trans.gif”,“billing_address”;:{"first_name":“Flare”,“last_name”:“DiChiaro”,“company”:“Interiors with Flare”,“address_1”:“3700 Madison Ave”,“address_2”:"",“city”:“Greensboro”,“state”:“NC”,“postcode”:“27403”,“country”:“US”,“email”:“interiorswithflare@yahoo.com”,“phone”:“336-500-5160”},“shipping_address”:{"first_name":“Flare”,“last_name”:“DiChiaro”,“company”:“Interiors with Flare”,“address_1”:“3352 W Friendly Ave”,“address_2”:“Suite 129”,“city”:“Greensboro”,“state”:“NC”,“postcode”:“27410”,“country”:"US"}}}}

<em>As you can see, we are sending the complete status over to Woo, but it’s not being registered.</em>

    Server Errors

    
[24-Nov-2016 04:29:20 UTC] WordPress database error Duplicate key name 'attribute_name' for query ALTER TABLE wp_woocommerce_attribute_taxonomies ADD KEY <code>attribute_name</code> (<code>attribute_name</code>(191)) made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[24-Nov-2016 04:29:20 UTC] WordPress database error Duplicate key name 'download_order_key_product' for query ALTER TABLE wp_woocommerce_downloadable_product_permissions ADD KEY <code>download_order_key_product</code> (<code>product_id</code>,<code>order_id</code>,<code>order_key</code>(191),<code>download_id</code>) made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[24-Nov-2016 04:29:20 UTC] WordPress database error Duplicate key name 'meta_key' for query ALTER TABLE wp_woocommerce_order_itemmeta ADD KEY <code>meta_key</code> (<code>meta_key</code>(191)) made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[24-Nov-2016 04:29:20 UTC] WordPress database error Duplicate key name 'tax_rate_country' for query ALTER TABLE wp_woocommerce_tax_rates ADD KEY <code>tax_rate_country</code> (<code>tax_rate_country</code>(191)) made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[24-Nov-2016 04:29:20 UTC] WordPress database error Duplicate key name 'tax_rate_state' for query ALTER TABLE wp_woocommerce_tax_rates ADD KEY <code>tax_rate_state</code> (<code>tax_rate_state</code>(191)) made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[24-Nov-2016 04:29:20 UTC] WordPress database error Duplicate key name 'tax_rate_class' for query ALTER TABLE wp_woocommerce_tax_rates ADD KEY <code>tax_rate_class</code> (<code>tax_rate_class</code>(191)) made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[24-Nov-2016 04:29:20 UTC] WordPress database error Duplicate key name 'location_type_code' for query ALTER TABLE wp_woocommerce_tax_rate_locations ADD KEY <code>location_type_code</code> (<code>location_type</code>(40),<code>location_code</code>(90)) made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta
[24-Nov-2016 04:29:20 UTC] WordPress database error Duplicate key name 'location_type_code' for query ALTER TABLE wp_woocommerce_shipping_zone_locations ADD KEY <code>location_type_code</code> (<code>location_type</code>(40),<code>location_code</code>(90)) made by activate_plugin, do_action('activate_woocommerce/woocommerce.php'), call_user_func_array, WC_Install::install, WC_Install::create_tables, dbDelta

The topic ‘Database Error and Sync Issue’ is closed to new replies.