i cant flush my site either. looking for a way.
i think it used to have its own table in the database but now i cant find it.
It is stored somewhere on the “postmeta” table. Just hope a fix can be released as I don’t really feel confortable deleting stuff on that since since i got over 3000 posts.
i sent a donation to the developer and asked for help, well work the money, he hooked me up with a fix and now i have it for you.
Select wp_postmeta table in your database, click on search, use meta_key as LIKE %..% and value as _kksr. Delete all the results that show up.
i acually had to type %_kksr% in the seach field, after i deleted a few pages i was able to use the built in flush.
he also posted this:
You can also use the following code: I have not tested for syntax errors but this will be safe to run. Note to run it only once.
global $wpdb;
$wpdb->query(“
DELETE FROM $wpdb->postmeta
WHERE meta_key LIKE ‘%_kksr%’
“);
i was able to delete all the postmeta data and even with a boatload (10’s of thousands of votes on about 1500 products didnt amount to much of anything in the database size.
im leaving it bloated until i figure out how to bot-vote my pages or get a new auto vote code that works better.
i hope this helps.
Sweet tecvoid! Thanks a lot 🙂
That piece of code you also posted here `global $wpdb;
$wpdb->query(“
DELETE FROM $wpdb->postmeta
WHERE meta_key LIKE ‘%_kksr%’
“);`
how do you run it? paste it on a file and run that file? Just want to know in case i decide to clear my votes as well 🙂
i didnt run it because after i did a manual search and delete of about 15 pages, the built in cache clear worked.
ill update here if i ever run it on better instructions.
Thanks man 🙂 Appreciate it
