Limited Support
Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.
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?
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.
Thanks. That fixed it. I did it in the terminal with mysql command line instead.
