500 error when adding API

Hey @lancebarton70

Thanks for your post. I’d be glad to help troubleshoot with you to try and get things up and running here.

I understand you’ve already gone through checking minimum requirements and plugin troubleshooting which is great. Just so I’m completely up to speed, could you share with us the site’s WooCommerce System Status Report?

Thanks in advance for this preliminary information. I’ll keep an eye out for your reply.

– Malachite

Here is it Malachite:

### WordPress Environment ###

Home URL: https://www.advancedbiology.com
Site URL: https://www.advancedbiology.com
WC Version: 3.2.5
Log Directory Writable: ?
WP Version: 4.9.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US

### Server Environment ###

Server Info: Apache/2.4.7 (Ubuntu)
PHP Version: 7.1.12-2+ubuntu14.04.1+deb.sury.org+2
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 
SUHOSIN Installed: –
MySQL Version: ? 5.5.58 - We recommend a minimum MySQL version of 5.6. See: WordPress requirements
Max Upload Size: 2 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ? Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ?
GZip: ?
Multibyte String: ? Your server does not support the mbstring functions - this is required for better character encoding. Some fallbacks will be used instead for it.
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.2.5
WC Database Prefix: wp_
Total Database Size: 215.11MB
Database Data Size: 211.83MB
Database Index Size: 3.28MB
wp_woocommerce_sessions: Data: 0.08MB + Index: 0.01MB
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_order_items: Data: 0.01MB + Index: 0.01MB
wp_woocommerce_order_itemmeta: Data: 0.05MB + Index: 0.04MB
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_log: ? Table does not exist
wp_commentmeta: Data: 0.00MB + Index: 0.01MB
wp_comments: Data: 0.03MB + Index: 0.02MB
wp_eg_grids: Data: 0.25MB + Index: 0.02MB
wp_eg_item_elements: Data: 0.02MB + Index: 0.02MB
wp_eg_item_skins: Data: 1.17MB + Index: 0.03MB
wp_eg_navigation_skins: Data: 0.06MB + Index: 0.02MB
wp_failed_jobs: Data: 0.02MB + Index: 0.00MB
wp_links: Data: 0.00MB + Index: 0.00MB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB
wp_options: Data: 5.55MB + Index: 0.19MB
wp_postmeta: Data: 118.73MB + Index: 0.44MB
wp_posts: Data: 75.88MB + Index: 0.21MB
wp_queue: Data: 0.02MB + Index: 0.00MB
wp_redirection_404: Data: 0.16MB + Index: 0.11MB
wp_redirection_groups: Data: 0.02MB + Index: 0.03MB
wp_redirection_items: Data: 0.02MB + Index: 0.08MB
wp_redirection_logs: Data: 0.02MB + Index: 0.08MB
wp_relevanssi: Data: 0.17MB + Index: 0.28MB
wp_relevanssi_log: Data: 0.02MB + Index: 0.00MB
wp_relevanssi_stopwords: Data: 0.02MB + Index: 0.00MB
wp_revslider_css: Data: 0.09MB + Index: 0.00MB
wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB
wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB
wp_revslider_settings: Data: 0.00MB + Index: 0.00MB
wp_revslider_sliders: Data: 0.13MB + Index: 0.00MB
wp_revslider_slides: Data: 0.87MB + Index: 0.00MB
wp_revslider_static_slides: Data: 0.06MB + Index: 0.00MB
wp_termmeta: Data: 0.00MB + Index: 0.01MB
wp_terms: Data: 0.01MB + Index: 0.03MB
wp_term_relationships: Data: 0.01MB + Index: 0.02MB
wp_term_taxonomy: Data: 0.01MB + Index: 0.01MB
wp_usermeta: Data: 0.03MB + Index: 0.02MB
wp_users: Data: 0.00MB + Index: 0.01MB
wp_wfBadLeechers: Data: 0.00MB + Index: 0.00MB
wp_wfBlockedCommentLog: Data: 0.02MB + Index: 0.00MB
wp_wfBlockedIPLog: Data: 0.13MB + Index: 0.10MB
wp_wfBlocks: Data: 0.18MB + Index: 0.06MB
wp_wfBlocksAdv: Data: 0.00MB + Index: 0.00MB
wp_wfConfig: Data: 0.88MB + Index: 0.01MB
wp_wfCrawlers: Data: 0.01MB + Index: 0.00MB
wp_wfFileMods: Data: 1.00MB + Index: 0.23MB
wp_wfHits: Data: 3.56MB + Index: 0.81MB
wp_wfHoover: Data: 0.27MB + Index: 0.04MB
wp_wfIssues: Data: 0.02MB + Index: 0.00MB
wp_wfKnownFileList: Data: 1.52MB + Index: 0.00MB
wp_wfLeechers: Data: 0.03MB + Index: 0.03MB
wp_wfLockedOut: Data: 0.00MB + Index: 0.00MB
wp_wfLocs: Data: 0.01MB + Index: 0.00MB
wp_wfLogins: Data: 0.14MB + Index: 0.03MB
wp_wfNet404s: Data: 0.00MB + Index: 0.00MB
wp_wfNotifications: Data: 0.02MB + Index: 0.00MB
wp_wfReverseCache: Data: 0.00MB + Index: 0.00MB
wp_wfScanners: Data: 0.01MB + Index: 0.01MB
wp_wfSNIPCache: Data: 0.02MB + Index: 0.05MB
wp_wfStatus: Data: 0.25MB + Index: 0.09MB
wp_wfThrottleLog: Data: 0.00MB + Index: 0.00MB
wp_wfVulnScanners: Data: 0.00MB + Index: 0.00MB
wp_yoast_seo_links: Data: 0.02MB + Index: 0.02MB
wp_yoast_seo_meta: Data: 0.11MB + Index: 0.00MB

### Post Type Counts ###

acf: 1
acf-field: 2
acf-field-group: 2
attachment: 350
cs_footer: 2
cs_header: 10
cs_user_templates: 60
customize_changeset: 2
custom_css: 1
mc4wp-form: 1
nav_menu_item: 19
page: 49
post: 6
product: 1
revision: 661
shop_order: 45
shop_order_refund: 6
wpcf7_contact_form: 2

### Security ###

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

### Active Plugins (17) ###

Connects - Mailchimp Addon: by Brainstorm Force – 2.1.2
Contact Form 7: by Takayuki Miyoshi – 4.9.2
Convert Plus: by Brainstorm Force – 3.0.3
Disable Comments: by Samir Shah – 1.7.1
Duplicate Post: by Enrico Battocchi – 3.2.1
Essential Grid: by ThemePunch – 2.1.6.2.1
MailChimp for WooCommerce: by MailChimp – 2.1.2 – Not tested with the active version of WooCommerce
Really Simple SSL: by Rogier Lankhorst – 2.5.24
Redirection: by John Godley – 2.10.1
Relevanssi: by Mikko Saari – 4.0.2
SF Move Login: by Grégory Viguier – 2.5.3
Under Construction: by Themeco – 2.0.3
Woo Checkout Editor: by Themeco – 2.0.1 – Not tested with the active version of WooCommerce
WooCommerce Bulk Discount: by Rene Puchinger – 2.4.5 – Not tested with the active version of WooCommerce
WooCommerce PayPal Pro (Classic and PayFlow Editions) Gateway: by WooCommerce – 4.4.7 – 4.4.10 is available – Not tested with the active version of WooCommerce
WooCommerce Quantity Increment: by Automattic
WooThemes – 1.1.0 – Not tested with the active version of WooCommerce

WooCommerce: by Automattic – 3.2.5

### 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)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-catalog (exclude-from-catalog-2)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-1 (rated-1-2)
rated-2 (rated-2)
rated-3 (rated-3)
rated-3 (rated-3-2)
rated-4 (rated-4)
rated-4 (rated-4-2)
rated-5 (rated-5)

### WC Pages ###

Shop base: #87 - /shop/
Cart: ? Page does not contain the shortcode.
Checkout: ? Page does not contain the shortcode.
My account: #90 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Pro – Child Theme
Version: 1.0.0
Author URL: https://theme.co/
Child Theme: ?
Parent Theme Name: Pro
Parent Theme Version: 1.2.7
Parent Theme Author URL: https://theme.co/
WooCommerce Support: ?

### Templates ###

Archive Template: 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: pro/woocommerce/cart/cross-sells.php
pro/woocommerce/loop/loop-end.php
pro/woocommerce/loop/loop-start.php
pro/woocommerce/loop/pagination.php
pro/woocommerce/notices/error.php
pro/woocommerce/notices/notice.php
pro/woocommerce/notices/success.php
pro/woocommerce/single-product/related.php
pro/woocommerce/single-product/tabs/tabs.php
pro/woocommerce/single-product/up-sells.php
pro/woocommerce/single-product-reviews.php

I pasted it in a reply and it says it will be held for up to 72 hours for moderation – do you have an email address I can send it to you at so we don’t have to wait?

• This reply was modified 7 years, 2 months ago by lancebarton70.

Hey @lancebarton70

Sorry to hear about that moderation hangup. I’m afraid I don’t have the ability to speed up that process. We don’t have a direct email address but you can get a direct line to MailChimp’s Tech Support Team here: https://kb.mailchimp.com/accounts/management/mailchimp-support-options

If you have any questions, let me know.

– Malachite

Hey Malachite – looks like the post is now visible?

Thanks @lancebarton70! Looks like it is published now. Thanks for the update!

I was able to look over things and the only thing that sticks out here is that the MySQL running on the server does not meet the minimum required version for MySQL on WooCommerce and MailChimp for WooCommerce. You’ll want to update that to at least 5.6 or greater for expected functionality here.

If you could get that up to date and try installing the plugin again, I’d be glad to help investigate further if any more issues crop up!

For reference, here is a link to WooCommerce’s System Requirements. Let me know if you have any questions.

Thanks,
Malachite

We updated MySql and everything else that wasn’t up to standards in the report and all seems to be working now! Thank you so much!!!

Glad to hear it @lancebarton70 !

If you have any other questions, feel free to let us know.

– Malachite