The effects of alcohol on sustanon 250 leucine for – real weight loss & bodybuilding benefits?
AI Assistant
Notifications
Clear all

[Solved] Unknown Column

3 Posts
2 Users
0 Reactions
1,920 Views
(@kevin)
Posts: 2
New Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 
[#197]

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. 


 
Posted : 29/05/2020 2:10 am
Topic Tags
Tom
 Tom
(@tomson)
Posts: 515
Honorable Member Support
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

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`);
WordPress database error Unknown column 'post id' in wp wc users voted table

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`);

 


 
Posted : 29/05/2020 10:58 am
(@kevin)
Posts: 2
New Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Hi Tom, 

This worked like a charm, thank you!


 
Posted : 29/05/2020 2:23 pm