Missing base tables

Hi @mainguyen0204,

Thank you for sharing the System Status Report! It looks like the required WooCommerce database tables are missing. Here’s how you can troubleshoot and resolve this issue:

1. Reinstall WooCommerce

• Go to Plugins > Installed Plugins, deactivate, and delete WooCommerce.
• Reinstall and activate WooCommerce from the WordPress plugin repository.
• Activation should recreate the missing database tables automatically.

2. Enable Debug Mode to Check for Errors

• Open your wp-config.php file and add the following lines:

define('WP_DEBUG', true);
define('WP_DEBUG_LOG', true);

• This will generate a debug.log file in the wp-content directory. Check for any database-related errors.

3. Verify Database Permissions

• Ensure the database user has full permissions (e.g., CREATE, ALTER, INSERT, DELETE, SELECT) on the WordPress database. If unsure, your hosting provider can confirm or adjust this.

Once you’ve tried these steps, let me know if the issue persists. If it does, please share the contents of the debug log (wp-content/debug.log) so we can investigate further.

Hi,

I deactive but it error

WordPress database error:?[CREATE command denied to user 'tqthu_a'@'localhost' for table tqthu_shop.wp_e_events]
CREATE TABLE wp_e_events ( id bigint(20) unsigned auto_increment primary key, event_data text null, created_at datetime not null ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;

WordPress database error:?[ALTER command denied to user 'tqthu_a'@'localhost' for table tqthu_shop.wp_e_events]
ALTER TABLE wp_e_events ADD INDEX created_at_index (created_at)

WordPress database error:?[Table 'tqthu_shop.wp_actionscheduler_actions' doesn't exist]
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='fetch_patterns' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1

WordPress database error:?[Table 'tqthu_shop.wp_actionscheduler_actions' doesn't exist]
SELECT a.action_id FROM wp_actionscheduler_actions a LEFT JOIN wp_actionscheduler_groups g ON g.group_id=a.group_id WHERE 1=1 AND g.slug='gla' AND a.hook='gla/jobs/resubmit_expiring_products/start' AND a.args='[]' AND a.status IN ('in-progress') ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1

WordPress database error:?[Table 'tqthu_shop.wp_actionscheduler_actions' doesn't exist]
SELECT a.action_id FROM wp_actionscheduler_actions a LEFT JOIN wp_actionscheduler_groups g ON g.group_id=a.group_id WHERE 1=1 AND g.slug='gla' AND a.hook='gla/jobs/resubmit_expiring_products/start' AND a.args='[]' AND a.status IN ('pending') ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1

WordPress database error:?[Table 'tqthu_shop.wp_actionscheduler_actions' doesn't exist]
SELECT a.action_id FROM wp_actionscheduler_actions a LEFT JOIN wp_actionscheduler_groups g ON g.group_id=a.group_id WHERE 1=1 AND g.slug='gla' AND a.hook='gla/jobs/resubmit_expiring_products/create_batch' AND a.args='[]' AND a.status IN ('in-progress') ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1

WordPress database error:?[Table 'tqthu_shop.wp_actionscheduler_actions' doesn't exist]
SELECT a.action_id FROM wp_actionscheduler_actions a LEFT JOIN wp_actionscheduler_groups g ON g.group_id=a.group_id WHERE 1=1 AND g.slug='gla' AND a.hook='gla/jobs/resubmit_expiring_products/create_batch' AND a.args='[]' AND a.status IN ('pending') ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1

WordPress database error:?[Table 'tqthu_shop.wp_actionscheduler_actions' doesn't exist]
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='fetch_patterns' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1

WordPress database error:?[Table 'tqthu_shop.wp_actionscheduler_actions' doesn't exist]
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='fetch_patterns' AND a.status IN ('in-progress', 'pending') LIMIT 0, 1

WordPress database error:?[Table 'tqthu_shop.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 database error:?[Table 'tqthu_shop.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 database error:?[Table 'tqthu_shop.wp_wc_admin_notes' doesn't exist]
SELECT note_id FROM wp_wc_admin_notes WHERE type = 'survey' ORDER BY note_id ASC

WordPress database error:?[Table 'tqthu_shop.wp_wc_admin_notes' doesn't exist]
SELECT note_id FROM wp_wc_admin_notes WHERE name = 'surface_cart_checkout' ORDER BY note_id ASC

WordPress database error:?[Table 'tqthu_shop.wp_actionscheduler_actions' doesn't exist]
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='woocommerce_cleanup_draft_orders' AND a.status IN ('in-progress') ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1

WordPress database error:?[Table 'tqthu_shop.wp_actionscheduler_actions' doesn't exist]
SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook='woocommerce_cleanup_draft_orders' AND a.status IN ('pending') ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1

WordPress database error:?[Table 'tqthu_shop.wp_actionscheduler_groups' doesn't exist]
SELECT group_id FROM wp_actionscheduler_groups WHERE slug=''

WordPress database error:?[Table 'tqthu_shop.wp_actionscheduler_groups' doesn't exist]
SHOW FULL COLUMNS FROM wp_actionscheduler_groups

WordPress database error:?[Table 'tqthu_shop.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 'woocommerce_cleanup_draft_orders', 'pending', '2025-01-09 12:01:17', '2025-01-09 12:01:17', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0*\0scheduled_timestamp\";i:1736424077;s:18:\"\0*\0first_timestamp\";i:1736424077;s:13:\"\0*\0recurrence\";i:86400;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1736424077;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:86400;}', 0, 10, '[]' FROM DUAL WHERE ( SELECT NULL FROM DUAL ) IS NULL
Warning: Cannot modify header information - headers already sent by (output started at /home/tqthu/public_html/wp-includes/class-wpdb.php:1845) in?/home/tqthu/public_html/wp-admin/includes/misc.php?on line?1438

Warning: Cannot modify header information - headers already sent by (output started at /home/tqthu/public_html/wp-includes/class-wpdb.php:1845) in?/home/tqthu/public_html/wp-includes/functions.php?on line?7137

WordPress database error:?[Table 'tqthu_shop.wp_wc_admin_notes' doesn't exist]
SELECT note_id FROM wp_wc_admin_notes WHERE name = 'wc-update-db-reminder' ORDER BY note_id ASC
Warning: Cannot modify header information - headers already sent by (output started at /home/tqthu/public_html/wp-includes/class-wpdb.php:1845) in?/home/tqthu/public_html/wp-admin/admin-header.php?on line?9

WordPress database error:?[Table 'tqthu_shop.wp_woocommerce_shipping_zones' doesn't exist]
SELECT zone_id, zone_name, zone_order FROM wp_woocommerce_shipping_zones order by zone_order ASC, zone_id ASC;

WordPress database error:?[Table 'tqthu_shop.wp_woocommerce_shipping_zone_locations' doesn't exist]
SELECT location_code, location_type FROM wp_woocommerce_shipping_zone_locations WHERE zone_id = 0

WordPress database error:?[Table 'tqthu_shop.wp_woocommerce_shipping_zone_methods' doesn't exist]
SELECT method_id, method_order, instance_id, is_enabled FROM wp_woocommerce_shipping_zone_methods WHERE zone_id = 0 AND is_enabled = 1

Hi @mainguyen0204,

Thanks for sharing the error. Just to clarify, have you deactivated and deleted WooCommerce, then reinstalled it through the WordPress plugin repository? If not, please follow these steps:

Deactivate all plugins on your site, then uninstall WooCommerce. Reinstall and activate only WooCommerce, leaving the other plugins uninstalled. After that, go to WooCommerce > Status and select the Tools tab. Before proceeding, make sure you have a backup of your site.

Scroll down and find the “Update Database” option. Click “Update Database” to begin the process. Additionally, double-check that your website is connected to the correct database and that the user privileges are properly set.