Unable to delete modules after updating

From Joomla! Documentation

When a site is upgraded to 3.2, users are unable to delete modules and are shown a generic "An error has occurred" message. This also applies to trying to empty trash in the module manager.

Versions affected

Info non-talk.png
General Information

This pertains only to Joomla! version(s):- 3.2.x

What is the cause

Not reported

How to fix

In order to delete modules, you will first need to open the module(s) you want to delete for editing and save them. After this, you will be able to delete the module(s).

As an alternative you can use statements below in phpMyAdmin:

DELETE FROM #__modules_menu WHERE moduleid IN (SELECT id FROM #__modules WHERE published = -2);
DELETE FROM #__modules WHERE published = -2;

As always, replace #_ with your own prefix.