Error when registering

[pixomaryt]

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

[Crazycat]

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;

[pixomaryt]

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

[.m.]

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;

[pixomaryt]

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

[.m.]

can you try using below query

set global sql_mode='';

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

[pixomaryt]

can you try using below query

set global sql_mode='';

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

YEssss!

[Crazycat]

Try:

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