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] Fix 'banreason doesnt have default value'.

Divine Celestial
Loyal Member
Joined
Apr 6, 2008
Messages
858
Reaction score
0
Just run this script in MySQL query browser.

Code:
ALTER TABLE `odinms`.`accounts` MODIFY COLUMN `banreason` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

If you get another error concerning macs, run this script afterwards.

Code:
ALTER TABLE `odinms`.`accounts` MODIFY COLUMN `macs` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

Hope this helps,

Buzz.
 
Newbie Spellweaver
Joined
Jun 4, 2008
Messages
51
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

Just run this script in MySQL query browser.

Code:
ALTER TABLE `odinms`.`accounts` MODIFY COLUMN `banreason` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

If you get another error concerning macs, run this script afterwards.

Code:
ALTER TABLE `odinms`.`accounts` MODIFY COLUMN `macs` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

Hope this helps,

Buzz.



nice no errors i tried already thanks a lot :jester:
 
Newbie Spellweaver
Joined
Jul 4, 2008
Messages
10
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

You could also click "Accounts" then F2. Untick banreason and mac.
 
Divine Celestial
Loyal Member
Joined
Apr 6, 2008
Messages
858
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

[quote=iPwnage
 
Junior Spellweaver
Joined
Jun 17, 2008
Messages
100
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

Thanks alot this will help alot of people that are setting up new servers :)
 
Divine Celestial
Loyal Member
Joined
Apr 6, 2008
Messages
858
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

Thanks alot this will help alot of people that are setting up new servers :)

No problem, happy to help. :jester:
 
Newbie Spellweaver
Joined
Jul 14, 2008
Messages
45
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

To bad I don't run a server...
 
Junior Spellweaver
Joined
Jul 28, 2008
Messages
131
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

Too bad , People cant just use search T_T

Good guide ;)
 
Junior Spellweaver
Joined
Jul 28, 2008
Messages
131
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

xD Gonna make a new 1

Btw , Its better if u put this in an sql file
 
Divine Celestial
Loyal Member
Joined
Apr 6, 2008
Messages
858
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

they can just copy into notepad and change the file to .sql
 
Newbie Spellweaver
Joined
Jul 14, 2008
Messages
9
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

wow thanks that was so awesome. Thank you
 
Newbie Spellweaver
Joined
Jun 21, 2008
Messages
6
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

What I do, it just click the box, type "0", click out, click it again, delete the "0", then click back out, then do the same for macs. It works for me. But I guess this works too. and is easier.
 
Initiate Mage
Joined
Apr 12, 2008
Messages
2
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

great, now i cant login
 
Newbie Spellweaver
Joined
Aug 2, 2008
Messages
41
Reaction score
0
Re: [Guide] Fix 'banreason doesnt have default value'.

hahaha ty i need this sql o.o
 
Junior Spellweaver
Joined
Aug 3, 2008
Messages
138
Reaction score
11
Re: [Guide] Fix 'banreason doesnt have default value'.

Thx alot
 
Back
Top