Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
1364 - Field 'ougc_awards' doesn't have a default value
#1
MyBB SQL error when registering. How do I fix this?
Reply
#2
(03-29-2015, 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: ZbrcFs]
Reply
#3
(05-19-2019, 02:17 PM)chack1172 Wrote:
(03-29-2015, 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'
Reply
#4
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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)