Forum

user preferences ta...
 
Notifications
Retirer tout

user preferences table

2 Posts
2 Utilisateurs
0 Reactions
3,451 Vu
(@francis2301)
Posts: 88
Active Member
Début du sujet
 
[#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.


 
Posté : 14 Nov PM 21:1111
(@babynus)
Posts: 14952
Membre 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.


 
Posté : 14 Nov PM 21:1111
Share:
Retour en haut