[Solved] Slow voting and database issue

✦ Summarize Topic

Bug Reports

Last Post by cnxsoft 5 years ago

3 Posts

2 Users

0 Reactions

1,329 Views

RSS

Posts: 16

cnxsoft

Topic starter

Translate ▼

Jul 30, 2020 8:57 am

(@cnxsoft)

Eminent Member

Joined: 5 years ago

[#632]

I'm using wpDiscuz 7.0.5, and I've had reports of slow voting acknowledgment (10 seconds). I cannot reproduce it myself. but while looking into my logs I can see some apparently related databases errors:

2020/07/30 05:41:11 [error] 4994#4994: *2051902 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'post_id' in 'field list' for query INSERT INTO `wp_wc_users_voted`(`user_id`, `comment_id`, `vote_type`,`is_guest`,`post_id`,`date`)VALUES('807b19d8c11efce82ae178d568f8bf75',574498,-1,1,79070,1596087671); made by do_action('wp_ajax_nopriv_wpdVoteOnComment'), WP_Hook->do_action, WP_Hook->apply_filters, WpdiscuzHelperAjax->voteOnComment, WpdiscuzDBManager->addVoteType" while reading response header from upstream, client: 197.200.100.175, server: www.cnx-software.com, request: "POST /wp-admin/admin-ajax.php HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.4-fpm.sock:", host: "www.cnx-software.com", referrer: "https://www.cnx-software.com/2020/07/25/buy-rock-pi-4c-sbc-with-4gb-ram-hdmi-and-displayport/"
2020/07/30 05:41:35 [error] 4994#4994: *2051852 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'post_id' in 'field list' for query INSERT INTO `wp_wc_users_voted`(`user_id`, `comment_id`, `vote_type`,`is_guest`,`post_id`,`date`)VALUES('807b19d8c11efce82ae178d568f8bf75',574488,-1,1,79070,1596087695); made by do_action('wp_ajax_nopriv_wpdVoteOnComment'), WP_Hook->do_action, WP_Hook->apply_filters, WpdiscuzHelperAjax->voteOnComment, WpdiscuzDBManager->addVoteType" while reading response header from upstream, client: 197.200.100.175, server: www.cnx-software.com, request: "POST /wp-admin/admin-ajax.php HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.4-fpm.sock:", host: "www.cnx-software.com", referrer: "https://www.cnx-software.com/2020/07/25/buy-rock-pi-4c-sbc-with-4gb-ram-hdmi-and-displayport/"


It looks like the plygin is trying to access 'post_id' column that does not existing in 'field list'.

Is that a bug or a problem with my database?

This topic was modified 5 years ago by cnxsoft

Topic Tags

voting system comment

2 Replies

Posts: 8210

Asti

Support

Translate ▼

Jul 30, 2020 1:02 pm

(@asti)

Illustrious Member

Joined: 8 years ago

Hi @cnxsoft,

Execute the SQL query below in phpMyAdmin database manager SQL Tab. You can install phpMyAdmin plugin, or use your Hosting Service cPanel > phpMyAdmin Database Manager > Your website Database > SQL Tab:

ALTER TABLE `wp_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`);

Please check the red marked wp_ prefix. If your database table prefix is different, you should change it to yours.

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.