gVectors Team

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

Search
Close
AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Forums
Plugin Support
wpDiscuz
How-To and Troubles...
Update Data – 100% ...
 
Notifications
Clear all

[Solved] Update Data – 100% but keep being asked

  ✦ Summarize Topic
How-To and Troubleshooting
Last Post by happyman 8 years ago
3 Posts
2 Users
1 Reactions
2,003 Views
RSS
 happyman
(@happyman)
Active Member
Joined: 8 years ago
Posts: 5
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
02/06/2018 6:09 pm   [#2463]

I’ve updated to the latest version and when I click on the update data I get “100% Done”, and the option still remains:

“Before using wpDiscuz you should update your data
Go to update data”

In my case I have checked the wp_wc_users_voted table. There are 101 rows that do still have an IP address in the user_id field out of a total of 2,242.

I’ve also tried optimizing the table as suggested.

Just to confirm I am running 5.1.2. I upgraded straight from 5.0.7.

Any ideas ?

Please help,

Thanks



   
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
03/06/2018 11:17 pm  

You can fix this issue using the following SQL query:

UPDATE `wp_wc_users_voted` SET `user_id` = MD5(`user_id`) WHERE `user_id` LIKE '%.%' OR `user_id` LIKE '%:%';

Just change the red marked table prefix to your database table prefix. Use the [SQL] tab in phpMyAdmin to execute this command.

2018 06 03 2216


   
happyman reacted
ReplyQuote
 happyman
(@happyman)
Active Member
Joined: 8 years ago
Posts: 5
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
04/06/2018 5:51 pm  

Hi,

Thanks for your reply, my table is called the same 'wp_wc_users_voted'.

I've run it as it is and it says 63 rows affected.

I've browsed through the table and there are no longer any IP addresses showing, and that warning message has now gone.

Thanks again for your help!



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