Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

user preferences ta...
 
Notifications
Clear all

user preferences table

2 Posts
2 Users
0 Reactions
3,467 Views
(@francis2301)
Posts: 88
Active Member
Topic starter
 
[#2088]

Hi,
I want to update the language set for all my users from portuguese(portugal) to portuguese(brazil) (the parameter set in users preference screen, not global parameter).

Reason:
When I started using projeqtor, default language in global parameters was set to portuguese(portugal). All users created during this period have this configuration. Now with brazilian portuguese available I've already changed the global parameter, but want to updated previous users.

Could you please inform the table name, field name and value to be set, so we can update via database?

Thanks in advance.
Kind regards.


 
Posted : 14 Nov 2014 21H08
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Table parameter. Lines with code = 'lang' and idUser is not null.

Something like :

update parameter set parameterValue='pt-br' where parameterCode='lang' and idUser is not null and parameterValue='pt';

Not tested, but except for typo errors, it should work.


 
Posted : 14 Nov 2014 21H19
Share:

Scroll to Top