mirror of
https://github.com/librenms/librenms.git
synced 2024-09-21 10:28:13 +00:00
fdf23631bd
Delete empty dashboards without an owner Chown dashboards that have widgets to the first admin level user fixes: #9580 DO NOT DELETE THIS TEXT #### Please note > Please read this information carefully. You can run `./scripts/pre-commit.php` to check your code before submitting. - [x] Have you followed our [code guidelines?](http://docs.librenms.org/Developing/Code-Guidelines/) #### Testers If you would like to test this pull request then please run: `./scripts/github-apply <pr_id>`, i.e `./scripts/github-apply 5926` After you are done testing, you can remove the changes with `./scripts/github-remove`. If there are schema changes, you can ask on discord how to revert.
3 lines
282 B
SQL
3 lines
282 B
SQL
DELETE FROM dashboards WHERE user_id NOT IN (SELECT user_id FROM users) AND dashboard_id NOT IN (SELECT DISTINCT dashboard_id FROM users_widgets);
|
|
UPDATE dashboards SET user_id = (SELECT user_id FROM users WHERE level = 10 LIMIT 1) WHERE user_id NOT IN (SELECT user_id FROM users);
|