• 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 utf8mb8

    WordPress データベースエラー: [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, 1

    WordPress データベースエラー: [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, 1

    WordPress データベースエラー: [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 FROM wp_actionscheduler_groups

    WordPress データベースエラー: [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 NULL

    Fatal 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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Riza Maulana Ardiyanto

    (@rizaardiyanto)

    Hi @higeko

    Our latest version is 3.0.2. Do you mind checking if you have the same issue on 3.0.2 version?

    Thanks,

    Plugin Author Steve Burge

    (@stevejburge)

    @higeko We believe this is fixed with the release of 3.0.3. Please re-open if this remains an issue.

    Thread Starter higeko

    (@higeko)


    Sorry for the delay in trying to upgrade the plugin.

    I updated to version 3.0.6 but got the same error and WordPress stopped working.

    エラータイプ E_ERROR が /home/(directory)/wp-content/plugins/post-expirator/vendor/woocommerce/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php ファイルの 44 行目で発生しました。 エラーメッセージ: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘bluelynx76_likaman.wp_likaman_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(340): ActionScheduler_HybridStore->save_action() #2 /home/(directory)/wp-content/plugins/post-expirator/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ActionFactory.php(315): ActionScheduler_ActionFactory->store_unique_action() #3 /home/(directory)/wp-content/plugins/post-expirator/vendor/w

    I tried with WordPress versions 6.2.2 and 6.3.

    • This reply was modified 2 years, 9 months ago by higeko.
Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘DB error (v3.0.0-)’ is closed to new replies.