I need Cathal or someone else with a good knowledge of the DNN database to help me out with this.
This regards my live site, running DNN version 3.1.1 on shared hosting. Some time back I went through and modified the Friendly Names in the DeskTopModules table to make them a little more friendly. Everything was fine for a while, but later I noticed a problem. This may have happened when the upgrade to 3.1.1 was installed, but I'm not sure. Anyway, here's the problem:
Anytime I drop a new HTML/text module onto a page I get two instead of one. Both have whatever title I chose from the control panel. Well, unfortunately I ignored this and in many cases went ahead and used both the new modules to build out content on my sites. It's not a killer problem, but I'd like to get rid of it in case I want to give someone else Admin privileges.
In the ModuleDefinitions table the module is indeed listed twice, with ModuleDefID's of 98 and 222. They both have DeskTopModuleID's of 56 in that table. In the Modules table I have too many instances of both to go deleting modules and reinstalling them. I have full access to the database.
So... how can I fix this?