You should revert the member_register templat to default it should fix the problem.
your database server is set to strict mode & it can be problematic while installing some plugins.
I'd suggest to contact your web host & request to disable strict mode of your database server.
It has been working just fine tho, i have made no changes to the web server, plugins, forum its self. Nothing. But it just broke one day, ill talk to them to try turn it off but im just unsure to why it broke when nothing was changed.
I disabled strict mode and it did fix the problem but i have gameserver databases aswell and the change made my gameserver crash a crazy amount so i had to revert back into strict mode.
Is there any other fix for this?
It's really strange how it just broke when i hadn't added/edited anything within the webserver/forums, so there must be a fix
Strict Mode is very troublesome. You'd have to give the field 'ban_user' a default value of 0.
Wait whats the ban_user field going to affect people trying to create an account or log into their exisiting account??? If this is actually a fix then where is this default value to change it?
Try the following:
ALTER TABLE mybb_users MODIFY banuser int NOT NULL default 0;
Where do i input that code?
Ok so i think i found it. I tried that code and got back: MySQL returned an empty result set (i.e. zero rows). (Query took 0.0011 seconds.)
I went looking for the ban_user field but it wasnt there as seen here
https://gyazo.com/a9e125d91ca50b9f6e814f891820f44a
Should i make a INSERT INTO function to add the ban_user field in?
I just did a insert into strawberry that added ban_user column to the table but now its saying the 'thx' column doesnt have a default value. Is this gonna happen for every field in that table?
Can you list the plugins that are activated on your board? I believe the columns MyBB is asking for are plugin-related.