gVectors Team

Professional WordPress Plugins and Services. wpDiscuz, WooDiscuz, Advanced Post Pagination

AI Assistant
Forums
Plugin Support
wpDiscuz
How-To and Troubles...
Hashed IP Checking ...
 
Notifications
Clear all

Hashed IP Checking Issue

  ✦ Summarize Topic
How-To and Troubleshooting
Last Post by dkappelman 7 years ago
3 Posts
2 Users
0 Reactions
2,436 Views
RSS
 dkappelman
(@dkappelman)
New Member
Joined: 9 years ago
Posts: 3
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
09/01/2019 10:16 am   [#3363]

I run a fairly large blog with 2.7 million votes in the wp_wc_users_voted table.  On the admin page, getNotHashedIPCount is getting run a decent amount and it's slow.  We have caching, but it seems that the cache on that query might be short lived. 

We already hashed all the IP's, so I'm not sure why this is getting called on every single admin page.  There should probably be something in wp_options that indicates whether or not IPs are hashed, and check that instead of checking the entire wp_wc_users_voted table every time.



   
Quote
 Tom
(@tomson)
Famed Member Admin
Joined: 11 years ago
Posts: 4245
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
10/01/2019 2:00 pm  

Hi @dkappelman,

This issue will be fixed with netion version of wpDiscuz.

At the moment you can do a small manual change in core file to fix it. Please open this file:

/wp-content/plugins/wpdiscuz/class.WpdiscuzCore.php

Find this line:

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

Add double slashes on front, like this:

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

 



   
ReplyQuote
 dkappelman
(@dkappelman)
New Member
Joined: 9 years ago
Posts: 3
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
10/01/2019 7:07 pm  

Thanks tom! I will go ahead and do until the next release.



   
ReplyQuote
Forum Jump:
  Previous Topic
Next Topic  
Share:
Scroll to top