MyBB Community Forums

MyBB Community Forums > Extensions > Plugins > Plugin Support > 1364 - Field 'ougc_awards' doesn't have a default value
Full Version: 1364 - Field 'ougc_awards' doesn't have a default value
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

forumloop

2019-05-19, 11:18 AM
MyBB SQL error when registering. How do I fix this?

chack1172

2019-05-19, 02:17 PM
(2015-03-29, 04:21 AM)Omar G. Wrote: [ -> ]You are probably running MySQL on strict mode. Will push a fix on next week. On the mean time run the following query:
ALTER TABLE mybb_users MODIFY ougc_awards text NOT NULL DEFAULT ''

Adjust mybb_ with your DB prefix.

forumloop

2019-05-19, 04:47 PM
(2019-05-19, 02:17 PM)chack1172 Wrote: [ -> ]
(2015-03-29, 04:21 AM)Omar G. Wrote: [ -> ]You are probably running MySQL on strict mode. Will push a fix on next week. On the mean time run the following query:
ALTER TABLE mybb_users MODIFY ougc_awards text NOT NULL DEFAULT ''

Adjust mybb_ with your DB prefix.
       [Image: QHrGUY.jpg]
Gives me this error '#1101 - BLOB, TEXT, GEOMETRY or JSON column 'ougc_awards' can't have a default value'

teluk

2019-08-06, 10:22 AM
So is there any solution? I get same error as forumloop...

...after bit of digging

...as suggested by chack1172 turning off strict mode solved the issue.
MyBB Community Forums > Extensions > Plugins > Plugin Support > 1364 - Field 'ougc_awards' doesn't have a default value