The effects of alcohol on sustanon 250 leucine for – real weight loss & bodybuilding benefits?
Search
Close
AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Share:
Notifications
Clear all

[Solved] Unknown Column

3 Posts
2 Users
0 Reactions
1,731 Views
Posts: 2
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
(@kevin)
New Member
Joined: 6 years ago
[#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. 


2 Replies
Tom
Posts: 509
 Tom
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
(@tomson)
Honorable Member
Joined: 10 years ago

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

 


Posts: 2
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
(@kevin)
New Member
Joined: 6 years ago

Hi Tom, 

This worked like a charm, thank you!


Share: