Title: Database errors after last update
Last modified: April 24, 2017

---

# Database errors after last update

 *  Resolved [Edu Salgado](https://wordpress.org/support/users/riotbr/)
 * (@riotbr)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/database-errors-after-last-update/)
 * 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](https://wordpress.org/support/users/wfyann/)
 * (@wfyann)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/database-errors-after-last-update/#post-9062690)
 * Hi [@riotbr](https://wordpress.org/support/users/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](https://docs.wordfence.com/en/Wordfence_options?#Delete_Wordfence_tables_and_data_on_deactivation.3F)”
   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](https://wordpress.org/support/users/wfyann/).
      Reason: Additional info
 *  Thread Starter [Edu Salgado](https://wordpress.org/support/users/riotbr/)
 * (@riotbr)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/database-errors-after-last-update/#post-9062734)
 * 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](https://wordpress.org/support/users/wfyann/)
 * (@wfyann)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/database-errors-after-last-update/#post-9072039)
 * Hi [@riotbr](https://wordpress.org/support/users/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.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [wfyann](https://wordpress.org/support/users/wfyann/)
 * Last activity: [8 years, 11 months ago](https://wordpress.org/support/topic/database-errors-after-last-update/#post-9072039)
 * Status: resolved