[Tut]How to fix Field 'banreason' doesn't have a default value[Noob Freindly]

[lPaul]

Well A lot of people has this error in there register site:
Field 'banreason' doesn't have a default value
Here is how to fix this.

1.Got to MySQL Query Browser (Or what ever you uses)


2. Log in to your database
3. Right click accounts and click edit table


4. Uncheck not nulled on banreason and macs (Uncheck macs or it will give you a new error)


5. Click "Ok" and it is fixed!

This is my first Guide so be easy on me!

[MentaL]

[itsreallythanh]

can you circle which to uncheck in the 2nd pic? I'm really confused x__X

[Emulation]

can you circle which to uncheck in the 2nd pic? I'm really confused x__X

Look at the square box.
That's where to uncheck.

[Innovative]

Or you could just execute:

ALTER TABLE `accounts` MODIFY COLUMN `banreason` TEXT NULL DEFAULT NULL;

and

ALTER TABLE `accounts` MODIFY COLUMN `macs` TINYTEXT NULL DEFAULT NULL;

In your mysql browser.

[Bog800]

Thank you

[FinalStory]

If it doesn't work in mysql execute the query in Navicat ._.