atifakbar
Forum Replies Created
-
Hey Guys just an update my issue has been resolved by upgrading the MySQL from version 5.5.60 to 5.7
I am not sure if moving from WordPress Managed site to standard site has also contributed here as well …. during this process my DB got upgraded and now i am good to open production page – add/remove and modify the products.
Thank you for you time.
@mohitmishra not sure how to verify the compatibility but i dont see any conflict in the status report … i assumption is it could be DB issue ?? as while retrieving product records it shows this error … customer site is fine … no issues … all products are available however in admin page i am unable to even view the products as soon as i click i get this error ….
@riaanknoetze it is not latest version but 3.7.0 … i cannot go for latest as my SQL version is 5.5.60-0 and wooCommerce is not giving me any options to upgrade.
issue happens when i click on Product, orders (on wordpress-dashboard) … i am able to retrieve categories and other options.### WordPress Environment ### WordPress address (URL): http://leathermasterstore.com Site address (URL): http://leathermasterstore.com WC Version: 3.7.0 REST API Version: ✔ 1.0.2 Log Directory Writable: ✔ WP Version: 5.4.1 WP Multisite: – WP Memory Limit: 77 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.3.17 PHP Post Max Size: 6 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.38.0 OpenSSL/1.0.1t SUHOSIN Installed: – MySQL Version: ❌ 5.5.60-0+deb7u1-log - We recommend a minimum MySQL version of 5.6. See: WordPress requirements Max Upload Size: 64 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 3.3.5 WC Database Prefix: u2y2fo4sat MaxMind GeoIP Database: ✔ Total Database Size: 148.89MB Database Data Size: 131.48MB Database Index Size: 17.41MB u2y2fo4satwoocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwoocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwoocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwoocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwoocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwoocommerce_order_itemmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM u2y2fo4satwoocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM u2y2fo4satwoocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwoocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwoocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwoocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwoocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwoocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwoocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satactionscheduler_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satactionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satactionscheduler_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satactionscheduler_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satcftemail_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satcftemail_messages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satcommentmeta: Data: 7.76MB + Index: 6.98MB + Engine MyISAM u2y2fo4satcomments: Data: 121.95MB + Index: 9.55MB + Engine MyISAM u2y2fo4satlinks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf3_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf3_action_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf3_chunks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf3_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf3_field_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf3_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf3_form_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf3_objects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf3_object_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf3_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf3_upgrades: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf_objectmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf_objects: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satnf_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satninja_forms_fav_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satninja_forms_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satoptions: Data: 1.16MB + Index: 0.55MB + Engine MyISAM u2y2fo4satpostmeta: Data: 0.43MB + Index: 0.17MB + Engine MyISAM u2y2fo4satposts: Data: 0.17MB + Index: 0.05MB + Engine MyISAM u2y2fo4satsocial_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4sattaxonomymeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM u2y2fo4sattermmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM u2y2fo4satterms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM u2y2fo4satterm_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM u2y2fo4satterm_taxonomy: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satuseful_banner_manager_banners: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satusermeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM u2y2fo4satusers: Data: 0.00MB + Index: 0.01MB + Engine MyISAM u2y2fo4satwc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satwc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM u2y2fo4satwc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM u2y2fo4satwc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satyith_wcwl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM u2y2fo4satyith_wcwl_lists: Data: 0.00MB + Index: 0.01MB + Engine MyISAM ### Security ### Secure connection (HTTPS): ❌ Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates. Hide errors from visitors: ✔ ### Active Plugins (14) ### Akismet Anti-Spam: by Automattic – 4.1.5 1&1 IONOS Address Book: by 1&1 IONOS – 1.0.1 Homepage Control: by WooThemes – 2.0.3 Jetpack by WordPress.com: by Automattic – 7.7.1 Nextend Social Login: by Nextendweb – 3.0.20 Ninja Forms: by The WP Ninjas – 3.4.20 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.1 Taxonomy Metadata: by mitcho (Michael Yoshitaka Erlewine) sirzooro – 0.5 WooCommerce Services: by Automattic – 1.21.1 WooCommerce: by Automattic – 3.7.0 WooSidebars: by WooCommerce – 1.4.5 WP Instagram Widget: by Scott Evans – 2.0.3 YITH WooCommerce Ajax Search: by YITH – 1.6.9 YITH WooCommerce Wishlist: by YITH – 2.2.13 ### Inactive Plugins (14) ### Akismet Privacy Policies: by Inpsyde GmbH – 1.1.2 Contact Form 7: by Takayuki Miyoshi – 5.1.4 Contact Form Email: by CodePeople – 1.2.94 eShop for WordPress: by Rich Pedley – 6.3.14 Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.8.1 MailPoet 2: by MailPoet – 2.12 Maps Widget for Google Maps: by WebFactory Ltd – 4.17 NextGEN Gallery: by Imagely – 3.2.18 Shariff for WordPress: by Heise Zeitschriften Verlag / Yannik Ehlert – 1.0.11 TinyMCE Advanced: by Andrew Ozz – 5.2.1 Useful Banner Manager: by Ruben Sargsyan – 1.6.1 WF Cookie Consent: by wunderfarm – 1.1.4 WP-Matomo: by André Bräkling – 1.0.22 Yoast SEO: by Team Yoast – 12.1 ### Must Use Plugins (3) ### 1&1 Managed WordPress: by 1&1 – 1.1.0 1&1 Product Subdomain: by 1&1 – 1.1.0 Alfred, the Assistant: by 1&1 IONOS – 5.5.1 ### Settings ### API Enabled: ✔ Force SSL: – Currency: CAD ($) 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-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: #4 - /shop Cart: #5 - /cart Checkout: #6 - /checkout My account: #7 - /my-account Terms and conditions: ❌ Page not set ### Theme ### Name: Flatsome Version: 2.7.4 Author URL: http://www.uxthemes.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: flatsome/woocommerce/archive-product.php flatsome/woocommerce/cart/cart-empty.php flatsome/woocommerce/cart/cart-item-data.php flatsome/woocommerce/cart/cart-shipping.php flatsome/woocommerce/cart/cart-totals.php flatsome/woocommerce/cart/cart.php flatsome/woocommerce/cart/cross-sells.php flatsome/woocommerce/cart/mini-cart.php flatsome/woocommerce/cart/proceed-to-checkout-button.php flatsome/woocommerce/cart/shipping-calculator.php flatsome/woocommerce/checkout/cart-errors.php flatsome/woocommerce/checkout/form-billing.php flatsome/woocommerce/checkout/form-checkout.php flatsome/woocommerce/checkout/form-coupon.php flatsome/woocommerce/checkout/form-login.php flatsome/woocommerce/checkout/form-pay.php flatsome/woocommerce/checkout/form-shipping.php flatsome/woocommerce/checkout/order-receipt.php flatsome/woocommerce/checkout/payment-method.php flatsome/woocommerce/checkout/payment.php flatsome/woocommerce/checkout/review-order.php flatsome/woocommerce/checkout/terms.php flatsome/woocommerce/checkout/thankyou.php flatsome/woocommerce/content-product.php flatsome/woocommerce/content-product_cat.php flatsome/woocommerce/content-single-product.php flatsome/woocommerce/content-widget-product.php flatsome/woocommerce/content-widget-reviews.php flatsome/woocommerce/global/breadcrumb.php flatsome/woocommerce/global/form-login.php flatsome/woocommerce/global/quantity-input.php flatsome/woocommerce/global/sidebar.php flatsome/woocommerce/global/wrapper-end.php flatsome/woocommerce/global/wrapper-start.php flatsome/woocommerce/loop/add-to-cart.php flatsome/woocommerce/loop/loop-end.php flatsome/woocommerce/loop/loop-start.php flatsome/woocommerce/loop/no-products-found.php flatsome/woocommerce/loop/orderby.php flatsome/woocommerce/loop/pagination.php flatsome/woocommerce/loop/price.php flatsome/woocommerce/loop/rating.php flatsome/woocommerce/loop/result-count.php flatsome/woocommerce/loop/sale-flash.php flatsome/woocommerce/myaccount/dashboard.php flatsome/woocommerce/myaccount/downloads.php flatsome/woocommerce/myaccount/form-add-payment-method.php flatsome/woocommerce/myaccount/form-edit-account.php flatsome/woocommerce/myaccount/form-edit-address.php flatsome/woocommerce/myaccount/form-login.php flatsome/woocommerce/myaccount/form-lost-password.php flatsome/woocommerce/myaccount/form-reset-password.php flatsome/woocommerce/myaccount/lost-password-confirmation.php flatsome/woocommerce/myaccount/my-account.php flatsome/woocommerce/myaccount/my-address.php flatsome/woocommerce/myaccount/my-downloads.php flatsome/woocommerce/myaccount/my-orders.php flatsome/woocommerce/myaccount/navigation.php flatsome/woocommerce/myaccount/orders.php flatsome/woocommerce/myaccount/payment-methods.php flatsome/woocommerce/myaccount/view-order.php flatsome/woocommerce/notices/error.php flatsome/woocommerce/notices/notice.php flatsome/woocommerce/notices/success.php flatsome/product-searchform.php flatsome/woocommerce/single-product/add-to-cart/external.php flatsome/woocommerce/single-product/add-to-cart/grouped.php flatsome/woocommerce/single-product/add-to-cart/simple.php flatsome/woocommerce/single-product/add-to-cart/variable.php flatsome/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php flatsome/woocommerce/single-product/add-to-cart/variation.php flatsome/woocommerce/single-product/meta.php flatsome/woocommerce/single-product/photoswipe.php flatsome/woocommerce/single-product/price.php flatsome/woocommerce/single-product/product-attributes.php flatsome/woocommerce/single-product/product-image.php flatsome/woocommerce/single-product/product-thumbnails.php flatsome/woocommerce/single-product/rating.php flatsome/woocommerce/single-product/related.php flatsome/woocommerce/single-product/review-meta.php flatsome/woocommerce/single-product/review-rating.php flatsome/woocommerce/single-product/review.php flatsome/woocommerce/single-product/sale-flash.php flatsome/woocommerce/single-product/share.php flatsome/woocommerce/single-product/short-description.php flatsome/woocommerce/single-product/stock.php flatsome/woocommerce/single-product/tabs/additional-information.php flatsome/woocommerce/single-product/tabs/description.php flatsome/woocommerce/single-product/tabs/tabs.php flatsome/woocommerce/single-product/title.php flatsome/woocommerce/single-product/up-sells.php flatsome/woocommerce/single-product-reviews.php flatsome/woocommerce/single-product.php ### Action Scheduler ### Complete: 0 Oldest: – Newest: – Pending: 0 Oldest: – Newest: – Canceled: 0 Oldest: – Newest: – In-progress: 0 Oldest: – Newest: – Failed: 0 Oldest: – Newest: –