Limited Support
Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.
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!
