Field 'referer' doesn't have a default value

[percocet]

I'm using this skin

You must be registered for see links

When trying to regester I get the error written in the title

I did this sql ALTER TABLE users ADD referer varchar(15) NOT NULL
but that doesn't seem to work.
How do I fix this? thanks

 

[Haid]

You need to either give field referer a default value (you've just pasted that you told it it can't be null) or supply a refer when they register.

 

[Joe]

Try

ALTER TABLE `users`
MODIFY COLUMN `referer` varchar(100) NOT NULL DEFAULT '0';

Next time use Google.

 

[KylePr0zZ]

I'm using this skin

You must be registered for see links

When trying to regester I get the error written in the title

I did this sql ALTER TABLE users ADD referer varchar(15) NOT NULL
but that doesn't seem to work.
How do I fix this? thanks

ALTER TABLE `users` MODIFY COLUMN `referer` varchar(100) NOT NULL DEFAULT '0';

 

[percocet]

fuck it, i fixed it. I uncheckmarked the NOT NULL cell in the db