Notifications
Clear all
Topic starter
02/06/2018 6:09 pm
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
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.
happyman reacted
Topic starter
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!