[Tut] Fix 'banreason doesnt have default value'.

[buzzfizz]

Just run this script in MySQL query browser.

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.

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

Hope this helps,

Buzz.

 

[marcuschai]

Re: [Guide] Fix 'banreason doesnt have default value'.

Just run this script in MySQL query browser.

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.

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:

 

[iPwnage]

Re: [Guide] Fix 'banreason doesnt have default value'.

You could also click "Accounts" then F2. Untick banreason and mac.

 

[buzzfizz]

Re: [Guide] Fix 'banreason doesnt have default value'.

[quote=iPwnage

 

[DevDev93]

Re: [Guide] Fix 'banreason doesnt have default value'.

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

 

[buzzfizz]

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:

 

[HollowIchigo]

Re: [Guide] Fix 'banreason doesnt have default value'.

To bad I don't run a server...

 

[DevDev93]

Re: [Guide] Fix 'banreason doesnt have default value'.

To bad I don't run a server...

Yea Too Bad There Would Be Another Noob Hamachi Server Out There. xD JK

 

[iHearty]

Re: [Guide] Fix 'banreason doesnt have default value'.

Too bad , People cant just use search T_T

Good guide

 

[DevDev93]

Re: [Guide] Fix 'banreason doesnt have default value'.

xD Yea Too Bad.'

@ ihearty`s Sig: I <3 You Too.

 

[iHearty]

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

 

[buzzfizz]

Re: [Guide] Fix 'banreason doesnt have default value'.

they can just copy into notepad and change the file to .sql

 

[DevDev93]

Re: [Guide] Fix 'banreason doesnt have default value'.

xD Yea Too Bad.'

@ ihearty`s Sig: I <3 You Too.

Aww She Dont <3 Me Anymoe!

 

[vague86]

Re: [Guide] Fix 'banreason doesnt have default value'.

wow thanks that was so awesome. Thank you

 

[wafles]

Re: [Guide] Fix 'banreason doesnt have default value'.

Or you could just assign a value of "".

>_>

 

[WhiteTigerX]

Re: [Guide] Fix 'banreason doesnt have default value'.

OMG iloveyou this helped me XD

 

[Plasmic]

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.

 

[nikdimas]

Re: [Guide] Fix 'banreason doesnt have default value'.

great, now i cant login

 

[Galaxylink]

Re: [Guide] Fix 'banreason doesnt have default value'.

hahaha ty i need this sql o.o

 

[ツ Ãlan™]

Re: [Guide] Fix 'banreason doesnt have default value'.

Thx alot