DB error (v3.0.0-)
-
After updating to version 3.0.0, I get an error on wp-admin.
In a test environment within the same server with subdomains it was fine.It seems that the cause is that the table required from version 3.0.0 was not created at the time of version upgrade.
The four tables below are in the database in the test environment but not in the production environment.
- wp_actionscheduler_actions
- wp_actionscheduler_claims
- wp_actionscheduler_groups
- wp_actionscheduler_logs
“データベースエラー” means “database error” in Japanese.
WordPress データベースエラー: [Unknown character set: ‘utf8mb8’]
CREATE TABLE wp_ppfuture_actions_args ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, cron_action_id bigint(20) UNSIGNED NOT NULL, post_id bigint(20) UNSIGNED NOT NULL, enabled tinyint(1) NOT NULL DEFAULT ‘0’, scheduled_date datetime NOT NULL, created_at datetime NOT NULL, args varchar(250) NOT NULL, PRIMARY KEY (id), KEY post_id (post_id, id), KEY enabled_post_id (post_id, enabled, id), KEY cron_action_id (cron_action_id, id), KEY enabled_cron_action_id (cron_action_id, enabled, id) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb8WordPress データベースエラー: [Table ‘(DB_NAME).wp_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘in-progress’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1WordPress データベースエラー: [Table ‘(DB_NAME).wp_actionscheduler_actions’ doesn’t exist]
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’action_scheduler/migration_hook’ AND a.status IN (‘pending’) ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1WordPress データベースエラー: [Table ‘(DB_NAME).wp_actionscheduler_groups’ doesn’t exist]
SELECT group_id FROM wp_actionscheduler_groups WHERE slug=’publishpress-future’WordPress データベースエラー: [Table ‘(DB_NAME).wp_actionscheduler_groups’ doesn’t exist]
SHOW FULL COLUMNS FROMwp_actionscheduler_groupsWordPress データベースエラー: [Table ‘(DB_NAME).wp_actionscheduler_actions’ doesn’t exist]
INSERT INTO wp_actionscheduler_actions (hook,status,scheduled_date_gmt,scheduled_date_local,schedule,group_id,priority,args) SELECT ‘publishpress_future/v30000_migrate_wpcron_expirations’, ‘pending’, ‘2023-06-16 03:25:52’, ‘2023-06-16 03:25:52’, ‘O:28:\”ActionScheduler_NullSchedule\”:0:{}’, 0, 10, ‘[]’ FROM DUAL WHERE ( SELECT NULL FROM DUAL ) IS NULLFatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘(DB_NAME).wp_actionscheduler_actions’ doesn’t exist in /home/(directory)/wp-content/plugins/post-expirator/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/(directory)/wp-content/plugins/post-expirator/vendor/woocommerce/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action() #1 /home/(directory)/wp-content/plugins/post-expirator/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(327): ActionScheduler_HybridStore->save_action() #2 /home/(directory)/wp-content/plugins/post-expirator/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(315): ActionScheduler_ActionFactory->store() #3 /home/(directory)/wp-content/plugins/post-expirator/vendor/woocommerce/act in /home/(directory)/wp-content/plugins/post-expirator/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php on line 44
The topic ‘DB error (v3.0.0-)’ is closed to new replies.