Woo commerce – broken / no table found

  • lwphotography04

    (@lwphotography04)


    4 years ago

    Hi,

    After updating to the most recent Woocommerce and WP Mail SMTP, it creates a ‘critical error’. I have tested both and both cause this error.

    I have searched and tried work around table plugin’s for Woocoomerce with no success. Does anyone have these problems or a solution please?

    Please send me in the right direction if I am in the wrong forum, many thanks.

    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_actions’ doesn’t exist]?SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_groups’ doesn’t exist]?SELECT group_id FROM wp_actionscheduler_groups WHERE slug=’action-scheduler-migration’
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_groups’ doesn’t exist]?SHOW FULL COLUMNS FROM wp_actionscheduler_groups
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_actions’ doesn’t exist]?SHOW FULL COLUMNS FROM wp_actionscheduler_actions
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_actions’ doesn’t exist]?SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_actions’ doesn’t exist]?SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_groups’ doesn’t exist]?SELECT group_id FROM wp_actionscheduler_groups WHERE slug=’action-scheduler-migration’
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_groups’ doesn’t exist]?SHOW FULL COLUMNS FROM wp_actionscheduler_groups
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_actions’ doesn’t exist]?SHOW FULL COLUMNS FROM wp_actionscheduler_actions
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_actions’ doesn’t exist]?SELECT a.action_id FROM wp_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_groups’ doesn’t exist]?SELECT group_id FROM wp_actionscheduler_groups WHERE slug=’action-scheduler-migration’
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_groups’ doesn’t exist]?SHOW FULL COLUMNS FROM wp_actionscheduler_groups
    WordPress database error:?[Table ‘rcfibuxv_lwphoto.wp_actionscheduler_actions’ doesn’t exist]?SHOW FULL COLUMNS FROM wp_actionscheduler_actions

    Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Table ‘rcfibuxv_lwphoto.wp_actionscheduler_actions’ doesn’t exist in /var/www/vhosts/lucywilsonphotography.co.uk/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /var/www/vhosts/lucywilsonphotography.co.uk/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /var/www/vhosts/lucywilsonphotography.co.uk/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /var/www/vhosts/lucywilsonphotography.co.uk/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionSchedule in?/var/www/vhosts/lucywilsonphotography.co.uk/httpdocs/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php?on line?44

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Job a11n

    (@jobthomas)

    Automattic Happiness Engineer

    Hey @lwphotography04 – this means that the database tables aren’t created as they should. There are two options:

    • Go to: WooCommerce > Status > Tools and there find “Verify Database Tables”
    • Alternatively, install the plugin mentioned here in this GitHub comment
    Thread Starter lwphotography04

    (@lwphotography04)

    Hiya,

    I have tried Action Scheduler 3.1.4 and 3.1.6 both with no success.

    3.1.4 Allows to me ‘Tools, Action scheduler, see error table messages, refresh, still error’s’

    3.1.6 Doesn’t show access to the Action schedular through the Tools option, is there another option to view the actions and refresh?

    If I activate Woocommerce with or without the plugins active, it crashes the site. I must be missing something somewhere but I can’t figure where.

    Many thanks and any more suggestions would be greatly appreciated.

    Lucy

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Woo commerce – broken / no table found’ is closed to new replies.