Hello!
Since the most recent update, we've noticed a string of errors in WP Engine in relation to missing columns
WordPress database error Unknown column 'post_id' in 'field list' for query INSERT INTO `wdw_wc_users_voted`(`user_id`, `comment_id`, `vote_type`,`is_guest`,`post_id`,`date`)
Is this a known issue? I've tried the fix tables button, but the error is still occurring.
Hi @kevin,
Please use your Hosting cPanle > phpMyAdmin Database Manager, open the WordPress website database, click on the SQL Tab and execute this query:
ALTER TABLE `wdw_wc_users_voted` ADD COLUMN `post_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, ADD COLUMN `date` INT(11) UNSIGNED NOT NULL DEFAULT 0, ADD INDEX `post_id` (`post_id`);
The red marked wdw_ part is our table prefix, if the table prefix is different you should change it. If you see an error, please copy and paste it here, then use this alternative SQL query:
ALTER TABLE `wdw_wc_users_voted` ADD `post_id` BIGINT NOT NULL AFTER `date`, ADD INDEX `post_id` (`post_id`);
Hi Tom,
This worked like a charm, thank you!
