No, you have right for free upgrades for one year after purchase date, and after one year expires, you can use it, but for next one year of upgrades you need to extend your license.
It's dedicated server?
It might mean than that you have 4 CPUs with 8 cores each, so 1 in server load average would mean it's CPU load of 3% (1/32).
It does seem you have overkill of server.
It depends how many cores you have. In load average, each core has value of 1. By that I mean, if you have 1 core, and load average shows 1, it means your server load is about 100%. If you have 10 cores, and load average is 1, server load is about 10%.
So, how many cores you have defines how to...
Okay, then I don't know. I usually use cPanel for creating DB, creating users, and giving them rights. Only after that I use mysqldump for importing data into DB
And it just works.
I guess you could try to ask your host for some advice and help, as you're probably on unmanaged hosting plan.
Also, you should create DB on new server, create user and give it full rights to DB with same names as on old server. Then, you should import DB. This is explained here with simplest...
Would it be something easy to fix? What should I do?
EDIT:
Thanks, I have found out how to add that attribute in DB, and yes, it does solve the issue with new registrations. Thank you very much for your help.
I also tried to create user manually in ACP, this is the error:
XF\Db\Exception: MySQL query error [1048]: Column 'user_id' cannot be null in src/XF/Db/AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198...
Hi, I have disabled Avatar gallery, it's this error now (basically the same issue):
XF\Db\Exception: MySQL query error [1048]: Column 'user_id' cannot be null src/XF/Db/AbstractStatement.php:230
Generated by: Unknown account Saturday - 30.12.2023 at 21:44:39
Stack trace
INSERT INTO `xf_user`...
First, to explain situation. Our host have moved us to new server. And after that move, we had some errors (I created thread here: https://xenforo.com/community/threads/errors-after-transfer-to-a-new-server.218389/).
Then they have retried to transfer forum database, which solved some errors...