Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter peterlukacs

    (@peterlukacs)

    Dear Till, thank you for your fast reply, i moved it to the top, and its working now!
    Please think about to add this information to your configuration description on github (at least), it would be really useful.

    I also got trouble to install it, the error message was the same. Sadly i cant use any “donor” wordpress installation.
    Whats worked for me is that i found the database shema in this file:
    /lib/wfSchema.php
    Fron the line private static $tables = array(

    You have to convert the php array to sql (basically copy the array and edit the first and the last line, for example: "wfBlocks7" => "( to CREATE TABLE wp_wfBlocks7 ( , and delete the closing ‘”‘.

    Here is the entire schema (NOTICE: i used the 7.5.11 version):

    CREATE TABLE wp_wfBlocks7 (
      <code>id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      <code>type</code> int(10) unsigned NOT NULL DEFAULT '0',
      <code>IP</code> binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
      <code>blockedTime</code> bigint(20) NOT NULL,
      <code>reason</code> varchar(255) NOT NULL,
      <code>lastAttempt</code> int(10) unsigned DEFAULT '0',
      <code>blockedHits</code> int(10) unsigned DEFAULT '0',
      <code>expiration</code> bigint(20) unsigned NOT NULL DEFAULT '0',
      <code>parameters</code> text,
      PRIMARY KEY (<code>id</code>),
      KEY <code>type</code> (<code>type</code>),
      KEY <code>IP</code> (<code>IP</code>),
      KEY <code>expiration</code> (<code>expiration</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfConfig (
      <code>name</code> varchar(100) NOT NULL,
      <code>val</code> longblob,
      <code>autoload</code> enum('no','yes') NOT NULL DEFAULT 'yes',
      PRIMARY KEY (<code>name</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfCrawlers (
      <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000',
      <code>patternSig</code> binary(16) NOT NULL,
      <code>status</code> char(8) NOT NULL,
      <code>lastUpdate</code> int(10) unsigned NOT NULL,
      <code>PTR</code> varchar(255) DEFAULT '',
      PRIMARY KEY (<code>IP</code>,<code>patternSig</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfFileChanges (
      <code>filenameHash</code> char(64) NOT NULL,
      <code>file</code> varchar(1000) NOT NULL,
      <code>md5</code> char(32) NOT NULL,
      PRIMARY KEY (<code>filenameHash</code>)
    ) CHARSET=utf8;
    CREATE TABLE wp_wfHits (
      <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT,
      <code>attackLogTime</code> double(17,6) unsigned NOT NULL,
      <code>ctime</code> double(17,6) unsigned NOT NULL,
      <code>IP</code> binary(16) DEFAULT NULL,
      <code>jsRun</code> tinyint(4) DEFAULT '0',
      <code>statusCode</code> int(11) NOT NULL DEFAULT '200',
      <code>isGoogle</code> tinyint(4) NOT NULL,
      <code>userID</code> int(10) unsigned NOT NULL,
      <code>newVisit</code> tinyint(3) unsigned NOT NULL,
      <code>URL</code> text,
      <code>referer</code> text,
      <code>UA</code> text,
      <code>action</code> varchar(64) NOT NULL DEFAULT '',
      <code>actionDescription</code> text,
      <code>actionData</code> text,
      PRIMARY KEY (<code>id</code>),
      KEY <code>k1</code> (<code>ctime</code>),
      KEY <code>k2</code> (<code>IP</code>,<code>ctime</code>),
      KEY <code>attackLogTime</code> (<code>attackLogTime</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfIssues (
      <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT,
      <code>time</code> int(10) unsigned NOT NULL,
      <code>lastUpdated</code> int(10) unsigned NOT NULL,
      <code>status</code> varchar(10) NOT NULL,
      <code>type</code> varchar(20) NOT NULL,
      <code>severity</code> tinyint(3) unsigned NOT NULL,
      <code>ignoreP</code> char(32) NOT NULL,
      <code>ignoreC</code> char(32) NOT NULL,
      <code>shortMsg</code> varchar(255) NOT NULL,
      <code>longMsg</code> text,
      <code>data</code> text,
      PRIMARY KEY (<code>id</code>),
      KEY <code>lastUpdated</code> (<code>lastUpdated</code>),
      KEY <code>status</code> (<code>status</code>),
      KEY <code>ignoreP</code> (<code>ignoreP</code>),
      KEY <code>ignoreC</code> (<code>ignoreC</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfPendingIssues (
      <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT,
      <code>time</code> int(10) unsigned NOT NULL,
      <code>lastUpdated</code> int(10) unsigned NOT NULL,
      <code>status</code> varchar(10) NOT NULL,
      <code>type</code> varchar(20) NOT NULL,
      <code>severity</code> tinyint(3) unsigned NOT NULL,
      <code>ignoreP</code> char(32) NOT NULL,
      <code>ignoreC</code> char(32) NOT NULL,
      <code>shortMsg</code> varchar(255) NOT NULL,
      <code>longMsg</code> text,
      <code>data</code> text,
      PRIMARY KEY (<code>id</code>),
      KEY <code>lastUpdated</code> (<code>lastUpdated</code>),
      KEY <code>status</code> (<code>status</code>),
      KEY <code>ignoreP</code> (<code>ignoreP</code>),
      KEY <code>ignoreC</code> (<code>ignoreC</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfTrafficRates (
      <code>eMin</code> int(10) unsigned NOT NULL,
      <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000',
      <code>hitType</code> enum('hit','404') NOT NULL DEFAULT 'hit',
      <code>hits</code> int(10) unsigned NOT NULL,
      PRIMARY KEY (<code>eMin</code>,<code>IP</code>,<code>hitType</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfLocs (
      <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000',
      <code>ctime</code> int(10) unsigned NOT NULL,
      <code>failed</code> tinyint(3) unsigned NOT NULL,
      <code>city</code> varchar(255) DEFAULT '',
      <code>region</code> varchar(255) DEFAULT '',
      <code>countryName</code> varchar(255) DEFAULT '',
      <code>countryCode</code> char(2) DEFAULT '',
      <code>lat</code> float(10,7) DEFAULT '0.0000000',
      <code>lon</code> float(10,7) DEFAULT '0.0000000',
      PRIMARY KEY (<code>IP</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfLogins (
      <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT,
      <code>hitID</code> int(11) DEFAULT NULL,
      <code>ctime</code> double(17,6) unsigned NOT NULL,
      <code>fail</code> tinyint(3) unsigned NOT NULL,
      <code>action</code> varchar(40) NOT NULL,
      <code>username</code> varchar(255) NOT NULL,
      <code>userID</code> int(10) unsigned NOT NULL,
      <code>IP</code> binary(16) DEFAULT NULL,
      <code>UA</code> text,
      PRIMARY KEY (<code>id</code>),
      KEY <code>k1</code> (<code>IP</code>,<code>fail</code>),
      KEY <code>hitID</code> (<code>hitID</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfReverseCache (
      <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000',
      <code>host</code> varchar(255) NOT NULL,
      <code>lastUpdate</code> int(10) unsigned NOT NULL,
      PRIMARY KEY (<code>IP</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfStatus (
      <code>id</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      <code>ctime</code> double(17,6) unsigned NOT NULL,
      <code>level</code> tinyint(3) unsigned NOT NULL,
      <code>type</code> char(5) NOT NULL,
      <code>msg</code> varchar(1000) NOT NULL,
      PRIMARY KEY (<code>id</code>),
      KEY <code>k1</code> (<code>ctime</code>),
      KEY <code>k2</code> (<code>type</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfHoover (
      <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT,
      <code>owner</code> text,
      <code>host</code> text,
      <code>path</code> text,
      <code>hostKey</code> varbinary(124) DEFAULT NULL,
      PRIMARY KEY (<code>id</code>),
      KEY <code>k2</code> (<code>hostKey</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfFileMods (
      <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 '00000000000000000000000000000000',
      <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>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfBlockedIPLog (
      <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000',
      <code>countryCode</code> varchar(2) NOT NULL,
      <code>blockCount</code> int(10) unsigned NOT NULL DEFAULT '0',
      <code>unixday</code> int(10) unsigned NOT NULL,
      <code>blockType</code> varchar(50) NOT NULL DEFAULT 'generic',
      PRIMARY KEY (<code>IP</code>,<code>unixday</code>,<code>blockType</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfSNIPCache (
      <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT,
      <code>IP</code> varchar(45) NOT NULL DEFAULT '',
      <code>expiration</code> timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      <code>body</code> varchar(255) NOT NULL DEFAULT '',
      <code>count</code> int(10) unsigned NOT NULL DEFAULT '0',
      <code>type</code> int(10) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (<code>id</code>),
      KEY <code>expiration</code> (<code>expiration</code>),
      KEY <code>IP</code> (<code>IP</code>),
      KEY <code>type</code> (<code>type</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfKnownFileList (
      <code>id</code> int(11) unsigned NOT NULL AUTO_INCREMENT,
      <code>path</code> text NOT NULL,
      PRIMARY KEY (<code>id</code>)
    ) DEFAULT CHARSET=utf8;
    CREATE TABLE wp_wfNotifications (
      <code>id</code> varchar(32) NOT NULL DEFAULT '',
      <code>new</code> tinyint(3) unsigned NOT NULL DEFAULT '1',
      <code>category</code> varchar(255) NOT NULL,
      <code>priority</code> int(11) NOT NULL DEFAULT '1000',
      <code>ctime</code> int(10) unsigned NOT NULL,
      <code>html</code> text NOT NULL,
      <code>links</code> text NOT NULL,
      PRIMARY KEY (<code>id</code>)
    ) DEFAULT CHARSET=utf8;;
    CREATE TABLE wp_wfLiveTrafficHuman (
      <code>IP</code> binary(16) NOT NULL DEFAULT '0000000000000000',
      <code>identifier</code> binary(32) NOT NULL DEFAULT '00000000000000000000000000000000',
      <code>expiration</code> int(10) unsigned NOT NULL,
      PRIMARY KEY (<code>IP</code>,<code>identifier</code>),
      KEY <code>expiration</code> (<code>expiration</code>)
    ) DEFAULT CHARSET=utf8;
    • This reply was modified 2 years, 4 months ago by peterlukacs.
Viewing 2 replies - 1 through 2 (of 2 total)