Jump to the post that solved this thread.
Solved: 1 Year, 2 Weeks ago Error when registering
#1
Solved: 1 Year, 2 Weeks ago
Due to this error, no one is able to register on the forum
I guess its because of OUGC Awards


Attached Files Thumbnail(s)
       
Reply
#2
Solved: 1 Year, 2 Weeks ago
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;
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM
Reply
#3
Solved: 1 Year, 2 Weeks ago
(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


Attached Files Thumbnail(s)
   
Reply
#4
Solved: 1 Year, 2 Weeks ago
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;
Reply
#5
Solved: 1 Year, 2 Weeks ago
(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
Reply
#6
Solved: 1 Year, 2 Weeks ago
can you try using below query
set global sql_mode='';
if it executes successfully then you might not get those registration errors
Reply
#7
Solved: 1 Year, 2 Weeks ago
(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!
Reply
#8
Solved: 1 Year, 2 Weeks ago
Try:
ALTER TABLE mybb_users MODIFY COLUMN ougc_awards text NOT NULL DEFAULT '';
ALTER TABLE mybb_users MODIFY COLUMN default_tab int DEFAULT 0;
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)