You need to change length of column passhash from table users.
First delete the user from database.
after use this:
ALTER TABLE `users` MODIFY `passhash` varchar(64) CHARACTER SET utf8 DEFAULT NULL;
after create a new account and try to login.

When I click on the index page and for example in Forum Manager and other pages in AdminCP give me error: Oops, Query error

My VPS:
Apache version: Apache/2.4.39
MySQL version: 10.1.48-MariaDB
PHP version: 7.4.9

verify sqlerr_logs folder for mysql errors.
verify apache_error.log , php_error.log