The effects of alcohol on
sustanon 250 leucine for – real weight loss & bodybuilding benefits?
[Solved] Unknown Column
✦ Summarize Topic
✦
✦
✦
AI is analyzing the discussion...
(@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
Show original
Translating...
[#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
(@tomson)
Posts: 512
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
Show original
Translating...
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`);
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
Show original
Translating...
Hi Tom,
This worked like a charm, thank you!
Posted : 29/05/2020 2:23 pm
Super Globals
Options and Features