View Full Version : Profile fields

07 Jan 2011, 16:48
When adding new profile fields and in this instance having 3 different options to choose from,Ive set a default option to be checked but how can i update so that all users have this option updated as its only adding the default option as checked on the new sign ups we have rather then members in the database already!

07 Jan 2011, 18:00
You'll have to go into the database and do a query to do this.

07 Jan 2011, 18:28
Thanks Lynne any ideas what the query i would need to run would be?

07 Jan 2011, 18:34
Something to do with the userfield table. Something *like*

UPDATE userfield
SET fieldx=yyy
WHERE fieldx=''I would backup the database first whenever doing something to the database. I would also do this on your test site first to make sure you have the query correct.

I have NOT run this query and have no idea if it is correct! Use at your own risk.

07 Jan 2011, 18:35
Ok thanks for the advise Lynne i will make sure to do so!