wfHits breaks repeatedly

  • Resolved karnerkreativ

    (@karnerkreativ)


    9 years, 2 months ago

    Every other day the wFHits table is reported as broken with this error displayed on the frontpage:

    WordPress-Datenbank-Fehler: [Duplicate entry ‘1223’ for key ‘PRIMARY’]
    INSERT INTO rk_wfHits (ctime, statusCode, isGoogle, IP, userID, newVisit, URL, referer, UA, jsRun) VALUES (‘1491469185.135853’, ‘200’, ‘0’, ‘\0\0\0\0\0\0\0\0\0\0��Uc\n’, ‘0’, ‘0’, ‘http://www.***********.at/’, ”, ‘Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko’, ‘0’)

    When I repair the table it works for a day or something then it breaks again. I already deleted all table with the “worfence assistant” plugin but that didn’t help.

Viewing 4 replies - 1 through 4 (of 4 total)
  • wfalaa

    (@wfalaa)

    9 years, 2 months ago

    Hi karnerkreativ,
    Please check (Wordfence > Tools => Diagnostics => MySQL) and make sure that MySQL user has all privileges, especially “TRUNCATE” and “ALTER” privileges.

    Does your website get high traffic rate?

    Thanks.

    Thread Starter karnerkreativ

    (@karnerkreativ)

    9 years, 1 month ago

    Hey wfalaa
    thanks for your reply. In the diagnostics all entries in the MySql sections are marked as “x fail”.

    We’re not getting high traffic no. It’s only a website of a small sports club.

    wfalaa

    (@wfalaa)

    9 years, 1 month ago

    This is something you need to report back to your hosting provider as MySQL user must have all privileges on your WordPress installation database.

    Thanks.

    wfalaa

    (@wfalaa)

    9 years ago

    Hi @karnerkreativ
    Since I haven’t heard back from you I am assuming that the instructions helped you solve your issue so I am marking this topic as resolved.

    If however, for whatever reason, you are still experiencing this issue and it is not resolved please respond to the post, which will move it back up the queue, and mark this topic as “not resolved”.

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘wfHits breaks repeatedly’ is closed to new replies.

  • 4 replies
  • 2 participants
  • Last reply from: wfalaa
  • Last activity: 9 years ago
  • Status: resolved