Database errors after last update

  • Resolved Edu Salgado

    (@riotbr)


    8 years, 11 months ago

    Hi! Sorry about my english 😉

    I received a message from my cPanel after reaching my quota limit – an error log file with 100MB. I have a flood of errors dealing with missing columns in WF tables. This started after the last update (6.3.6). I checked the tables and the columns were actually removed. About the columns: attackLogTime in wfHits; SHAC in wfFileMods.

    So, I deactivated the plugin, removed and reinstalled, and the fields are there.

    I’m the only one who had the same problem? And what could have happened?

    Thanks in advance 😉

Viewing 3 replies - 1 through 3 (of 3 total)
  • wfyann

    (@wfyann)

    8 years, 11 months ago

    Hi @riotbr,

    Could you please check that the MySQL user has all required privileges:

    • Go to the Wordfence Tools page
    • Click the Diagnostics tab
    • Scroll down to the MySQL section

    Does it read OK for each privilege?

    Another explanation is that you have the “Delete Wordfence tables and data on deactivation” feature enabled and that by deactivating the plugin you also removed corrupted tables which were properly recreated when you reinstalled Wordfence.

    • This reply was modified 8 years, 11 months ago by wfyann. Reason: Additional info
    Thread Starter Edu Salgado

    (@riotbr)

    8 years, 11 months ago

    Hi, wfyann. Thanks for the answer.

    Except for “truncate”, all the privileges were set and ok. Btw, I don’t have the option to add the “truncate” privilege O.o

    wfyann

    (@wfyann)

    8 years, 11 months ago

    Hi @riotbr,

    The TRUNCATE privilege requires the DROP privilege as of MySQL 5.1.16. (Before 5.1.16, it requires the DELETE privilege).

    From what I understand, it seems your MySQL user already has both the DROP and DELETE privileges, so I would suggest you check with your hosting provider to find out why the TRUNCATE privilege isn’t also granted.

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

The topic ‘Database errors after last update’ is closed to new replies.