RE: Slow voting and database issue

cnxsoft — Thu, 30 Jul 2020 09:30:41 +0000

Thanks. That fixed it. I did it in the terminal with mysql command line instead.

RE: Slow voting and database issue

Asti — Thu, 30 Jul 2020 09:02:21 +0000

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.

Slow voting and database issue

cnxsoft — Thu, 30 Jul 2020 04:57:36 +0000

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  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  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?

Slow voting and database issue - Bug Reports

RE: Slow voting and database issue

RE: Slow voting and database issue

Slow voting and database issue