Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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

Banned
Banned
Joined
Aug 14, 2008
Messages
149
Reaction score
9
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)
lPaul - [Tut]How to fix Field 'banreason' doesn't have a default value[Noob Freindly] - RaGEZONE Forums


2. Log in to your database
3. Right click accounts and click edit table
lPaul - [Tut]How to fix Field 'banreason' doesn't have a default value[Noob Freindly] - RaGEZONE Forums


4. Uncheck not nulled on banreason and macs (Uncheck macs or it will give you a new error)
lPaul - [Tut]How to fix Field 'banreason' doesn't have a default value[Noob Freindly] - RaGEZONE Forums


5. Click "Ok" and it is fixed!

This is my first Guide so be easy on me!
 
Initiate Mage
Joined
Jul 18, 2008
Messages
2
Reaction score
0
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
 
Junior Spellweaver
Joined
Jul 28, 2008
Messages
154
Reaction score
1
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.
 
om nom nom.
Member
Joined
Nov 30, 2007
Messages
299
Reaction score
9
Re: [Guide]How to fix Field 'banreason' doesn't have a default value[Noob Freindly]

Or you could just execute:
Code:
ALTER TABLE `accounts` MODIFY COLUMN `banreason` TEXT NULL DEFAULT NULL;
and
Code:
ALTER TABLE `accounts` MODIFY COLUMN `macs` TINYTEXT NULL DEFAULT NULL;
In your mysql browser.
 
Initiate Mage
Joined
Aug 24, 2008
Messages
10
Reaction score
0
Re: [Guide]How to fix Field 'banreason' doesn't have a default value[Noob Freindly]

Thank you
 
Initiate Mage
Joined
Aug 23, 2008
Messages
1
Reaction score
0
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 ._.
 
Back
Top