Restore Joomla Backend Menu

After an Joomla update or migration from older Joomla versions in the backend default menu entries are missing. In the components dropdown menu different entries get lost. However this happens :)

The database repair button doesn't fix this issue.

With this simple SQL statement you can restores the Joomla backend structure.

UPDATE #__menu SET menutype = 'main' WHERE menutype = 'menu';  

Replace #__ with your Database Tables Prefix.

You can execute this SQL statement in PhpMyAdmin for example.