MYSQL performance wp_wc_users_voted

Hi @dnikola,

Could you please send the admin login details to info[at]gvectors.com email address to allow us to ceck and fix the issue? 

Hi @dnikola,

The issue is fixed on your clone website. If you need to fix it on the real website please follow the steps below.

• Open the wp-content/plugins/wpdiscuz/class.WpdiscuzCore.php file 
• Find the following line (line 121)

  add_action('admin_notices', array(&$this->helper, 'hashVotesNote')); 

• Comment out this line

-Thanks for your replay!

Can you tell me with never version this will be overwrite? 

@dnikola

We'll fix this issue in the next version release. You will be able to update the wpDiscuz plugin without worries. 

Great.

Thanks. 

and one more question, it is from first post on this topic

If I empty table wp_wc_users_voted will I lose a number of votes for comments or this table is just holding data to prevent user to double vote on some comments? 

I investigate on this and it holds an each vote per comment? I am right?

@dnikola

Currently, if you're not using the "separate count" value for the "Comment voting statistic mode" option and you've not installed the wpDiscuz Comment Author Info and wpDiscuz Comment Author Info addons, there won't be any problems if you empty  wp_wc_users_voted table. 

However, we don't recommend you to empty it. Probably in the future, you'll decide to use the separate count option or some add-ons. 

Hi @astghik

Thanks for your kind replay. 

Yes I am using separated count 🙂 

One question is why do you write down each vote, and just one meta filed in comments meta table, with total negative and positive values? 

are there any hooks or action which we can use to display data and on vote to update this metafields (if we try to do some own solution)

Thanks!

Hello

I have same problem again 

http://prntscr.com/pwfnyr

Hi @dnikola

Could you please show the indexes of wp_wc_users_voted table fields? And, please let us know what MySQL version you use? Also, please make sure this table engine is InnoDB.

Hi

please check this info and let me know if you need more

http://prntscr.com/pwgadz

http://prntscr.com/pwgd23

http://prntscr.com/pwgdfo

any news?

@dnikola,

You should add the changes one more time. The last update doesn't include that part. This will be included in the new major version of wpDiscuz (no ETA).

The steps you should do: 

https://gvectors.com/forum/wpdiscuz-comment-plugin-support/mysql-performance-wp_wc_users_voted/#post-17613