user_bio no value

[jayk]

When users try to register they get this error

You must be registered for see links

I tried to add a new staff page, the one released in the releases section and I didn't want it so deleted the page, and now this..

 

[Sledmore]

You need to give it a default value. Go into your database and assign a default value to it, I'm assuming give it empty string.

 

[jayk]

You need to give it a default value. Go into your database and assign a default value to it, I'm assuming give it empty string.

There is not a single table for it. It was imported into the 'users' table, I have set it to Empty String, but it's only for users that have registered. Where can I make it Empty for users not registered?

 

[Sledmore]

Run this query:

ALTER TABLE `users` ALTER COLUMN `owner_bio` SET DEFAULT ' ' ;

It should work.

 

[jayk]

Thanks TONS!
Now getting this error.
Field 'age' doesn't have a default value

Should I run this SQL?

ALTER TABLE `users` ALTER COLUMN `age` SET DEFAULT ' ' ;

 

[Sledmore]

Thanks TONS!
Now getting this error.
Field 'age' doesn't have a default value

Should I run this SQL?

ALTER TABLE `users` ALTER COLUMN `age` SET DEFAULT ' ' ;

I'm assuming that column is an integer, but you could try it, if not try:

ALTER TABLE `users` ALTER COLUMN `age` SET DEFAULT '0' ;

 

[jayk]

I'm assuming that column is an integer, but you could try it, if not try:

ALTER TABLE `users` ALTER COLUMN `age` SET DEFAULT '0' ;

My query worked! Thanks for your help Sledmore!
You can also close thread if need!

 

[Sledmore]

Glad it worked, no problem! Thread closed.