Viewing 6 replies - 1 through 6 (of 6 total)
  • 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

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘How to remove all rating history?’ is closed to new replies.