Hi @dannymohammad,
thank you for your answer and your suggestions. As requested, I checked if I can access the custom emoji page directly. And yes, I can. But the blue “Add Custom Emoji” Button is also missing. I created a screenshot for you:
I retrieved the information you asked for from the database:
SELECT * FROM Roles\G
*************************** 1. row ***************************
Id: 3smjtfy6zt8gtdwhibe9m1kfwh
Name: team_admin
DisplayName: authentication.roles.team_admin.name
Description: authentication.roles.team_admin.description
CreateAt: 1547759566735
UpdateAt: 1547759566735
DeleteAt: 0
Permissions: remove_user_from_team manage_team import_team manage_team_roles manage_channel_roles manage_others_webhooks manage_slash_commands manage_others_slash_commands manage_webhooks delete_post delete_others_posts
SchemeManaged: 1
BuiltIn: 1
*************************** 2. row ***************************
Id: 44zcxgrwwind5giiydireacyxh
Name: system_user
DisplayName: authentication.roles.global_user.name
Description: authentication.roles.global_user.description
CreateAt: 1547759566712
UpdateAt: 1547759566712
DeleteAt: 0
Permissions: create_direct_channel create_group_channel permanent_delete_user create_team
SchemeManaged: 1
BuiltIn: 1
*************************** 3. row ***************************
Id: 9e8ruogt47r4ib1j5jdy98hthy
Name: channel_user
DisplayName: authentication.roles.channel_user.name
Description: authentication.roles.channel_user.description
CreateAt: 1547759566755
UpdateAt: 1547759566755
DeleteAt: 0
Permissions: read_channel add_reaction remove_reaction manage_public_channel_members upload_file get_public_link create_post use_slash_commands manage_private_channel_members delete_post edit_post
SchemeManaged: 1
BuiltIn: 1
*************************** 4. row ***************************
Id: cf5aggq4qjfdxnn3d8i4iu7sxe
Name: system_admin
DisplayName: authentication.roles.global_admin.name
Description: authentication.roles.global_admin.description
CreateAt: 1547759566696
UpdateAt: 1547759566696
DeleteAt: 0
Permissions: assign_system_admin_role manage_system manage_roles manage_public_channel_properties manage_public_channel_members manage_private_channel_members delete_public_channel create_public_channel manage_private_channel_properties delete_private_channel create_private_channel manage_system_wide_oauth manage_others_webhooks edit_other_users edit_others_posts manage_oauth invite_user delete_post delete_others_posts create_team add_user_to_team list_users_without_team manage_jobs create_post_public create_post_ephemeral create_user_access_token read_user_access_token revoke_user_access_token remove_others_reactions list_team_channels join_public_channels read_public_channel view_team read_channel add_reaction remove_reaction upload_file get_public_link create_post use_slash_commands remove_user_from_team manage_team import_team manage_team_roles manage_channel_roles manage_slash_commands manage_others_slash_commands manage_webhooks edit_post
SchemeManaged: 1
BuiltIn: 1
*************************** 5. row ***************************
Id: i8aunfkm9j8iddt8ux79gk1j3c
Name: channel_admin
DisplayName: authentication.roles.channel_admin.name
Description: authentication.roles.channel_admin.description
CreateAt: 1547759566762
UpdateAt: 1547759566762
DeleteAt: 0
Permissions: manage_channel_roles
SchemeManaged: 1
BuiltIn: 1
*************************** 6. row ***************************
Id: jt7njsekcfdodkoijc8nsyppzc
Name: team_post_all_public
DisplayName: authentication.roles.team_post_all_public.name
Description: authentication.roles.team_post_all_public.description
CreateAt: 1547759566727
UpdateAt: 1547759566727
DeleteAt: 0
Permissions: create_post_public
SchemeManaged: 0
BuiltIn: 1
*************************** 7. row ***************************
Id: m8reegx4rby4imnciibf1u84go
Name: team_post_all
DisplayName: authentication.roles.team_post_all.name
Description: authentication.roles.team_post_all.description
CreateAt: 1547759566720
UpdateAt: 1547759566720
DeleteAt: 0
Permissions: create_post
SchemeManaged: 0
BuiltIn: 1
*************************** 8. row ***************************
Id: nhjbtrpiw78fp8rwkke9b3qcdw
Name: system_post_all
DisplayName: authentication.roles.system_post_all.name
Description: authentication.roles.system_post_all.description
CreateAt: 1547759566742
UpdateAt: 1547759566742
DeleteAt: 0
Permissions: create_post
SchemeManaged: 0
BuiltIn: 1
*************************** 9. row ***************************
Id: roqhauqozi83fxna9ryfbi8f4w
Name: system_post_all_public
DisplayName: authentication.roles.system_post_all_public.name
Description: authentication.roles.system_post_all_public.description
CreateAt: 1547759566748
UpdateAt: 1547759566748
DeleteAt: 0
Permissions: create_post_public
SchemeManaged: 0
BuiltIn: 1
*************************** 10. row ***************************
Id: waka463j1bg58po6zoffkqg4yy
Name: team_user
DisplayName: authentication.roles.team_user.name
Description: authentication.roles.team_user.description
CreateAt: 1547759566703
UpdateAt: 1547759566703
DeleteAt: 0
Permissions: list_team_channels join_public_channels read_public_channel view_team create_public_channel manage_public_channel_properties delete_public_channel create_private_channel manage_private_channel_properties delete_private_channel invite_user add_user_to_team
SchemeManaged: 1
BuiltIn: 1
*************************** 11. row ***************************
Id: xnrose16sf83dp6nxj4sqo713a
Name: system_user_access_token
DisplayName: authentication.roles.system_user_access_token.name
Description: authentication.roles.system_user_access_token.description
CreateAt: 1547759566688
UpdateAt: 1547759566688
DeleteAt: 0
Permissions: create_user_access_token read_user_access_token revoke_user_access_token
SchemeManaged: 0
BuiltIn: 1
11 rows in set (0,00 sec)
mysql> SELECT * FROM Systems WHERE Name = “EmojisPermissionsMigrationComplete”\G
*************************** 1. row ***************************
Name: EmojisPermissionsMigrationComplete
Value: true
1 row in set (0,00 sec)
mysql> SELECT * FROM Users WHERE Email="my_email@myprovider.de"\G
*************************** 1. row ***************************
Id: qjoc4j5p7pbtur34sym4ifz1yc
CreateAt: 1508298203222
UpdateAt: 1548970014364
DeleteAt: 0
Username: myUserName
Password: $2a$10$6Zlu5c3DBDcqER/Hc2byMegfRgPyBoIRwG.pd61sd6WRChXINpo2m
AuthData: NULL
AuthService:
Email: my_email@myprovider.de
EmailVerified: 1
Nickname:
FirstName:
LastName:
Position:
Roles: system_user system_admin
AllowMarketing: 0
Props: {}
NotifyProps: {“channel”:“true”,“desktop”:“all”,“desktop_sound”:“true”,“email”:“true”,“first_name”:“false”,“mention_keys”:“myUserName,@myUserName”,“push”:“mention”}
LastPasswordUpdate: 1523883374207
LastPictureUpdate: 0
FailedAttempts: 0
Locale: de
MfaActive: 0
MfaSecret:
Timezone: {“automaticTimezone”:"",“manualTimezone”:"",“useAutomaticTimezone”:“true”}
1 row in set (0,00 sec)