XenForo XF\Db\Exception: MySQL query error [1048]: Column 'ip_id' cannot be null in src/XF/Db/AbstractStatement.php at line 230

[nathanw]

I've been forced to change VPS providers and have completed the following to do so:

1. Provisioned new VPS, installed Debian 12
2. Installed Apache, PHP, MariaDB, other releated items
3. Configured MySQL accounts and databases, Apache as per existing server
4. Copied all files to the new server
5. sqldump database, upload to new server
6. Confirmed XF loads

I noticed that table xf_session was corrupt on the old host - the table was never included in the sqldump.
I created it as per...

Read more

Continue reading...