2018-11-28, 05:01 PM
Ok, my issue was that the usernames in the DB needed to be only UPPERCASE.
The solution was to add a trigger to my mysql database.
Connect to the mysql database with correct access:
mysql -u root -p
Select the DB, in my case mybb
use mybb;
Then add the trigger for the username:
CREATE TRIGGER forceupper BEFORE INSERT ON mybb_users FOR EACH ROW SET NEW.username = UPPER(NEW.username);
In case of a mistake, remove the trigger:
DROP TRIGGER forceupper;
The solution was to add a trigger to my mysql database.
Connect to the mysql database with correct access:
mysql -u root -p
Select the DB, in my case mybb
use mybb;
Then add the trigger for the username:
CREATE TRIGGER forceupper BEFORE INSERT ON mybb_users FOR EACH ROW SET NEW.username = UPPER(NEW.username);
In case of a mistake, remove the trigger:
DROP TRIGGER forceupper;