Duplicate entry ‘\0\0\0\0\0\0\0\0’ for key PRIMARY, & Data too long filenameMD5

  • Using a SQL dump from a site that I had no prior involvement with (hence asking here) I’m getting duplicate entry errors in any wordfence tables which include the “IP” datafield, e.g. wp_wfBlockedIPLog, wp_wfBlocks, wp_wfCrawlers.
    The ‘IP’ value in each row (e.g. ‘\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0??_-?e’) appears to have prepended an escaped copy of the ‘DEFAULT’ value sepcified for the ‘IP’ field (IP binary(16) NOT NULL DEFAULT ‘\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0’, ) This results in a value longer than 16 characters so I don’t quite understand why we don’t get ‘Data too long’ errors? But I believe we see the PRIMARY KEY error because only the first 16 characters are read and these are all ‘\0\0\0\0\0\0\0\0’…. so it makes perfect sense to see that error. So my question is why/how could this could have occurred?

    Further into the SQL dump (still wordfence tables..)
    I also get the error Data too long for column ‘filenameMD5’ in the wp_wfFileMods table… I’ll add more details shortly

  • The topic ‘Duplicate entry ‘\0\0\0\0\0\0\0\0’ for key PRIMARY, & Data too long filenameMD5’ is closed to new replies.