Hi @mllapan, thanks for reaching out.
Are you using a backup/migration tool or plugin to import the WordPress database? If so, I would check in with their support to see if the SQL on import is getting malformed or isn’t compatible with your version of MariaDB.
Our lib/wfSchema.php file including the code for the wfBlocks7 table contains syntax that looks similar to the output you’ve shown above but the IP column line doesn’t use keyword “AS”, which is shown as part of your error message.
IP binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
blockedTime bigint(20) NOT NULL,
Let us know what you find out,
Peter.
Hi, wfpeter.
I am exporting database via phpmyadmin as a sql.
11.8.6-MariaDB
Everything works even without this, but I guess it resets blocked IPs and stuff in plugin, and I have noticed it resets the license as well.
Thanks for clarifying @mllapan.
If the database is being exported/imported through phpMyAdmin on MariaDB, this sounds more like a backup/export compatibility issue than a Wordfence plugin issue.
It might still be worth checking-in with your hosting provider if they support the phpMyAdmin and MariaDB installations on your server to see whether the export is being generated correctly.
Thanks again,
Peter.
