Where in the db the users preferences are stored?

[Karl]

Version 1.2:
Where in the database the users preferences are stored?

My problem: I changed "Localization" to a language which is not working. And now I can't revert that setup because without the proper language files nothing is working. So I have to change it directly in the database.

[cabeza]

Hello Karl,
 User preferences are stored in table og_user_ws_config_options and og_user_ws_config_option_values (og_ prefix may change in your installation).
To remove all localization preferences and go back to default language:
1.- backup your DB just in case
2.- Find the id in table og_user_ws_config_options for the option whose "name" is "localization".
3.- delete from og_user_ws_config_option_values where option_id is the ID your found in 2.

[Karl]

Hello cabeza,

it worked this way. Thanks for your info.

Karl

[robertpetersen]

Hello cabeza,

I would like to turn this problem around too this:
If i have changed the database default value for the future users to have    localization = da_dk (danish) and 24 hours format, how do I then change all the existing users to have those values? I must admit that a lot of my users do not have the skills to change them there selves.

[Karl]

Hei Robert,

I have the same problem. I always have to login as the new user and have to change the preferences. It isn't a good solution right now.

Maybe a future version makes this a bit more usable.

Regards
Karl