Error in Database caused by WF

Hey @jannis01,

This table relates to the file scanning feature. Can you please try completely resetting Wordfence and let me know if it helps?

https://www.wordfence.com/help/advanced/remove-or-reset/#remove-or-reset

Please let me know how it goes.

Thanks,

Gerroald

Hey @jannis01,

The code below is the SQL command to DELETE the records. If this doesn’t fix the issue you’ll want to DROP and CREATE the table, which is the second SQL command below.

DELETE FROMsl_wffilemods` (
filenameMD5 binary(16) NOT NULL,
filename varchar(1000) NOT NULL,
knownFile tinyint(3) unsigned NOT NULL,
oldMD5 binary(16) NOT NULL,
newMD5 binary(16) NOT NULL,
SHAC binary(32) NOT NULL DEFAULT ‘\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0’,
stoppedOnSignature varchar(255) NOT NULL DEFAULT ”,
stoppedOnPosition int(10) unsigned NOT NULL DEFAULT 0,
isSafeFile varchar(1) NOT NULL DEFAULT ‘?’,
PRIMARY KEY (filenameMD5)
);`

DROP TABLE sl_wffilemods;
CREATE TABLE <code>sl_wffilemods</code> (
  <code>filenameMD5</code> binary(16) NOT NULL,
  <code>filename</code> varchar(1000) NOT NULL,
  <code>knownFile</code> tinyint(3) unsigned NOT NULL,
  <code>oldMD5</code> binary(16) NOT NULL,
  <code>newMD5</code> binary(16) NOT NULL,
  <code>SHAC</code> binary(32) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  <code>stoppedOnSignature</code> varchar(255) NOT NULL DEFAULT '',
  <code>stoppedOnPosition</code> int(10) unsigned NOT NULL DEFAULT 0,
  <code>isSafeFile</code> varchar(1) NOT NULL DEFAULT '?',
  PRIMARY KEY (<code>filenameMD5</code>)
);

Please make sure to make a backup before making any database edits just_in_case.

Thanks,

Gerroald

Hey @jannis01,

You bet! However, I just noticed the formatting on the first command broke it. Below should work without error.

https://pastebin.com/vj099t1q

Thanks again,

Gerroald

• This reply was modified 5 years, 12 months ago by WFGerroald.