empty Dashboard on EMM Fall 2020

[ryckmx]

After applying some pending sql updates I just get now an empty Dashboard.

On the left side menu I only get this options:
Mediapool, Layout Builder, Push notifications, Administration and my user info, CompanyID:1, 20.10.000.107

Same for all admin users. Looks like some admin settings were updated for admin group? How could I get back?

Unfortunately I can't get a DB backup since I get permission errors using OMT.sh:

DB user needs grant 'SELECT ON mysql.proc' to backup db data. (e.g. GRANT SELECT ON mysql.proc TO 'openemm'@'%';)
Cannot create database backup

MariaDB [mysql]> show grants for openemm;
+-------------------------------------------------+
| Grants for openemm@% |
+-------------------------------------------------+
| GRANT RELOAD ON *.* TO `openemm`@`%` |
| GRANT SELECT ON `mysql`.`proc` TO `openemm`@`%` |
+-------------------------------------------------+
2 rows in set (0.000 sec)


Thank you in advice,

RR

[maschoff]

Are you sure that no SQL update is missing? If you check sub-menu system status of menu administration, do you see any missing DB updates?

[ryckmx]

It was after all pending updates were applied that the Status was finally shown as green OK. Everything seems to be working just fine. Now I only see "User log" under Administration submenu.

What I see is admin_group_permission_tbl table is empty. Is there a way to reconstruct it? looks like some upgrade delete all contents after adding the permission_name field. What other tables could have been affected?

[ryckmx]

Based on userrights.sql I updated the admin_group_permission_tbl and admin_permission_tbl. Still no changes to my admin user.

Then I added same admin_permission_tbl records of user 1 to my other admin users and now I'm able to see all modules successfully.

System Status show overall and db updates all in green again.

Hope nothing else is broken by now and that this helps somebody else.

Thank you.

[ryckmx]

I've also found an extra update:

insert into admin_to_group_tbl (admin_id,admin_group_id) values (2,1) ;

The above is required since the user must belong to at least one user group.