May 28, 2020 10:10 pm
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.
2 Replies
May 29, 2020 6:58 am
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`);
May 29, 2020 10:23 am
Hi Tom,
This worked like a charm, thank you!
