woocommerce upgrade issue

Resolved

soupy

(@soupy)

4 years, 4 months ago

Hi,

I recently tried to update woocommerce from Version 5.9.0 to 6.0.0

and received the following errors.

The whole site died, could not access WP ADMIN and had to roll back from backup.

Any ideas?

” WordPress is unable to run queries on the wp_wc_admin_note_actions table.”

2021-12-17T04:42:32+00:00 CRITICAL require(): Failed opening required '/home/directau/public_html/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Features/RemoteFreeExtensions/RemoteFreeExtensionsDataSourcePoller.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/directau/public_html/wp-content/plugins/woocommerce/vendor/jetpack-autoloader/class-php-autoloader.php on line 87

2021-12-17T04:42:39+00:00 CRITICAL require(): Failed opening required '/home/directau/public_html/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Features/RemoteFreeExtensions/RemoteFreeExtensionsDataSourcePoller.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/directau/public_html/wp-content/plugins/woocommerce/vendor/jetpack-autoloader/class-php-autoloader.php on line 87

2021-12-17T04:42:55+00:00 CRITICAL Uncaught RuntimeException: Error saving action: No database selected in /home/directau/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:86
Stack trace:
#0 /home/directau/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action))
#1 /home/directau/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#2 /home/directau/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single('woocommerce_run...', Array, 1639716175, 'woocommerce-db-...')
#3 /home/directau/public_html/wp-content/plugins/woocommerce/includes/queue/class-wc-action-queue.php(44): as_schedule_single_action(1639716175, 'woocommerce_run...', Array, 'wooco in /home/directau/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 86

2021-12-17T04:42:55+00:00 CRITICAL require(): Failed opening required '/home/directau/public_html/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Features/RemoteFreeExtensions/RemoteFreeExtensionsDataSourcePoller.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/directau/public_html/wp-content/plugins/woocommerce/vendor/jetpack-autoloader/class-php-autoloader.php on line 87

2021-12-17T04:42:55+00:00 CRITICAL require(): Failed opening required '/home/directau/public_html/wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Features/RemoteFreeExtensions/RemoteFreeExtensionsDataSourcePoller.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/directau/public_html/wp-content/plugins/woocommerce/vendor/jetpack-autoloader/class-php-autoloader.php on line 87

Assistance is appreciated.

—

Thesis & Current Skin
===========================
Thesis Version: 2.10.8
Skin Name: Classic Wide 2
Skin Version: 1.1
Skin CSS: YES → 44.7kB on 01/20/2021 at 10:06:02
Skin Custom CSS: YES → 12.27kB
Skin Custom PHP: YES → 0.3kB on 01/04/2016 at 17:28:55

Thesis Filesystem
===========================
wp-content/thesis: YES
wp-content/thesis/skins: YES
wp-content/thesis/boxes: YES
wp-content/thesis/master.php: YES → 0.2kB on 03/27/2018 at 10:47:13

Thesis Skins and Boxes
===========================
Installed Skins: Classic Responsive, Classic Wide 2
Installed Boxes: Clean Up WP, Thesis Developer Tools, Fix CSS
Active Boxes: Clean Up WP, Thesis Developer Tools, Fix CSS

WordPress
===========================
WordPress Version: 5.7.5
Filesystem Method: direct
Using Multisite: NO
Active Plugins: Gravity Forms, a3rev Dashboard, All-in-One WP Migration, Autoptimize, GF Upload to Email Attachment, Really Simple SSL, Redirection, ShortPixel Image Optimizer, Patchstack, WooCommerce Email Inquiry Ultimate, WooCommerce Eway Payment Gateway, WooCommerce, WP Rocket, Schema Pro, SEOPress PRO, SEOPress

PHP
===========================
Version: 7.4.27
cURL: YES
Max Upload (according to WP): 80 MB
Memory Limit (ini): 1028M
Memory Limit (usage): 107 MB
Memory Limit (WP): 40M

Server/Database
===========================
Server Software: Apache
Options Collation: utf8_general_ci
MySQL Version: 5.5.5-10.3.32-MariaDB
PHP Handler: fpm-fcgi

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

MayKato
(@maykato)

4 years, 4 months ago
Hello,

This kind of problem is usually caused by a conflict with your theme or with another plugin. The best way to determine this is to:
- Temporarily switch your theme to Storefront
- Disable all plugins except for WooCommerce
- Test to see if the issue has been resolved
If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.
Thread Starter soupy
(@soupy)

4 years, 4 months ago

Thanks, and didn’t need to go this length. Upgrading to PHP 7.4 seems to allow things to upgrade nicely.

The cpanel WORDPRESS toolkit also provides a good safety need to manage disasters.

All good for now.

Mirko P.
(@rainfallnixfig)

4 years, 4 months ago

Hi @soupy,

All good for now.

Glad to hear it – thanks for letting us know!

I’ll mark this thread as resolved now. If you have any further questions, I recommend creating a new thread.

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

The topic ‘woocommerce upgrade issue’ is closed to new replies.