MyBB Community Forums

Due to this error, no one is able to register on the forum
I guess its because of OUGC Awards

Your MySQL use strict mode.
If you can remove it, do it.
If you can't, add a default value for mybb_users.ougc_awards and mybb_users.default_tab:

ALTER TABLE mybb_users ALTER ougc_awards SET DEFAULT '';
ALTER TABLE mybb_users ALTER default_tab SET DEFAULT 0;

(2020-03-31, 01:03 PM)Crazycat Wrote: [ -> ]Your MySQL use strict mode.
If you can remove it, do it.
If you can't, add a default value for mybb_users.ougc_awards and mybb_users.default_tab:

ALTER TABLE mybb_users ALTER ougc_awards SET DEFAULT '';
ALTER TABLE mybb_users ALTER default_tab SET DEFAULT 0;

Both the mysql codes returned an error, pls guide

you could have posted those errors. anyway, try below

ALTER TABLE mybb_users MODIFY COLUMN ougc_awards SET DEFAULT '';
ALTER TABLE mybb_users MODIFY COLUMN default_tab SET DEFAULT 0;

(2020-03-31, 01:16 PM).m. Wrote: [ -> ]you could have posted those errors. anyway, try below

ALTER TABLE mybb_users MODIFY COLUMN ougc_awards SET DEFAULT '';
ALTER TABLE mybb_users MODIFY COLUMN default_tab SET DEFAULT 0;

Error Again:

mysql> ALTER TABLE mybb_users MODIFY COLUMN ougc_awards SET DEFAULT '';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT ''' at line 1
mysql> ALTER TABLE mybb_users MODIFY COLUMN default_tab SET DEFAULT 0;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT 0' at line 1

can you try using below query

set global sql_mode='';

if it executes successfully then you might not get those registration errors

(2020-03-31, 01:35 PM).m. Wrote: [ -> ]can you try using below query

set global sql_mode='';

if it executes successfully then you might not get those registration errors

YEssss!

Try:

ALTER TABLE mybb_users MODIFY COLUMN ougc_awards text NOT NULL DEFAULT '';
ALTER TABLE mybb_users MODIFY COLUMN default_tab int DEFAULT 0;