[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!

 

[itsreallythanh]

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

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

 

[Emulation]

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

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]

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

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]

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

Thank you

 

[FinalStory]

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

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