Forums

Locked out of site! Need to make some registration fields not required in DB

Permalink
Hi,

I have managed to lock myself out of a site. Basically I added custom user attributes that are required on login/registration.
I am completing these on the login form but it's still not letting me in! I think the issue is I have a county and country dropdowns which I am trying to populate via php/jquery from the lists/states_provinces helper.
So, I need to go into the DB and make some of these fields not required to login anymore, which table do I edit?

Thanks
madesimplemedia
 
madesimplemedia replied on at Permalink Reply
madesimplemedia
I think the attributes most likely to be an issue are these:
county - akID = 59
country - akID = 58
Where do I look to manually add values to them in the DB?
madesimplemedia replied on at Permalink Best Answer Reply
madesimplemedia
OK sorted it. I had added some blank user attributes which were select boxes with no values.

So I added some values to the atSelectedOptions table with the appropriate akID to relate to the attributes in the attributeKeys table and it's let me save those details and go login to the site! Phew!