thedrelle

Turns out it’s related to a plugin called InkXE Product Designer, the fundamental tool I am using for this site. I am working with the developers to determine a solution.

thanks, I will try that

re-install worked, WordPress is working again.

will do. thank you for your input. I will notify you after i reinstall and mark resolved if that is the case.

It look like the only recourse may be a clean install.

please confirm, and thank you for your time.

Figured that out, and ran as instructed.

Failed to execute SQL : SQL CREATE TABLE wp_actionscheduler_actions ( action_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, hook varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL, status varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL, scheduled_date_gmt datetime DEFAULT NULL, scheduled_date_local datetime DEFAULT NULL, args varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, schedule longtext COLLATE utf8mb4_unicode_520_ci, group_id bigint(20) unsigned NOT NULL DEFAULT ‘0’, attempts int(11) NOT NULL DEFAULT ‘0’, last_attempt_gmt datetime DEFAULT NULL, last_attempt_local datetime DEFAULT NULL, claim_id bigint(20) unsigned NOT NULL DEFAULT ‘0’, extended_args varchar(8000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, PRIMARY KEY (action_id), KEY hook (hook), KEY status (status), KEY scheduled_date_gmt (scheduled_date_gmt), KEY args (args), KEY group_id (group_id), KEY last_attempt_gmt (last_attempt_gmt), KEY claim_id (claim_id) ) CHARACTER SET latin1 COLLATE latin1_swedish_ci; failed : Table ‘wp_actionscheduler_actions’ already exists

Is it possible that this has something to do with the charset in wp-config is set to utf-8?

• This reply was modified 4 years, 7 months ago by thedrelle.

I just tried removing EVERYTHING EXCEPT the woocommerce plugin.

got this in the debug.log

[25-Aug-2020 15:05:15 UTC] PHP Notice: map_meta_cap was called incorrectly. The post type shop_order is not registered, so it may not be reliable to check the capability “read_post” against a post of that type. Please see Debugging in WordPress for more information. (This message was added in version 4.4.0.) in /home/bi-admin/public_html/wp-includes/functions.php on line 5225
[25-Aug-2020 15:05:15 UTC] PHP Notice: map_meta_cap was called incorrectly. The post type shop_order is not registered, so it may not be reliable to check the capability “read_post” against a post of that type. Please see Debugging in WordPress for more information. (This message was added in version 4.4.0.) in /home/bi-admin/public_html/wp-includes/functions.php on line 5225
[25-Aug-2020 15:05:15 UTC] PHP Notice: map_meta_cap was called incorrectly. The post type shop_order is not registered, so it may not be reliable to check the capability “read_post” against a post of that type. Please see Debugging in WordPress for more information. (This message was added in version 4.4.0.) in /home/bi-admin/public_html/wp-includes/functions.php on line 5225
[25-Aug-2020 15:05:15 UTC] PHP Notice: map_meta_cap was called incorrectly. The post type shop_order is not registered, so it may not be reliable to check the capability “edit_post” against a post of that type. Please see Debugging in WordPress for more information. (This message was added in version 4.4.0.) in /home/bi-admin/public_html/wp-includes/functions.php on line 5225
[25-Aug-2020 15:05:15 UTC] PHP Notice: map_meta_cap was called incorrectly. The post type shop_order is not registered, so it may not be reliable to check the capability “edit_post” against a post of that type. Please see Debugging in WordPress for more information. (This message was added in version 4.4.0.) in /home/bi-admin/public_html/wp-includes/functions.php on line 5225
[25-Aug-2020 15:05:15 UTC] PHP Notice: map_meta_cap was called incorrectly. The post type shop_order is not registered, so it may not be reliable to check the capability “edit_post” against a post of that type. Please see Debugging in WordPress for more information. (This message was added in version 4.4.0.) in /home/bi-admin/public_html/wp-includes/functions.php on line 5225
[25-Aug-2020 15:06:46 UTC] PHP Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/bi-admin/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44
Stack trace:
#0 /home/bi-admin/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL)
#1 /home/bi-admin/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action))
#2 /home/bi-admin/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action))
#3 /home/bi-admin/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single in /home/bi-admin/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
[25-Aug-2020 15:06:46 UTC] PHP Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Database error. in /home/bi-admin/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44

• This reply was modified 4 years, 7 months ago by thedrelle.
• This reply was modified 4 years, 7 months ago by thedrelle.

sorry, The site only shows that error. let me reinstall woocommerce and set that up for you right now.

that is the odd thing, I am seeing no PHP errors relating to the page. It looks like the update may have failed, and I never caught the error relating to that when it happened. as I cannot get into the woocommerce settings, i can’t look at and error log there, and don’t see that one was generated in the directory.

I have reinstalled woocommerce on the site right now so you can see what exactly the site does when it is installed.

What else could be the issue? it seems to be a database issue, but I have no clue what.

• This reply was modified 4 years, 7 months ago by thedrelle.

Hey Zach.

I am running PHP 7.3