Hi all,
I found the reason why those modules missing from control bar.
The old module definition in DNN 4.X has no portals area using limitation. The DNN 6/7 added the new portals limitaiton for Ribbon Bar/Control Bar.
You can just assgined all preemius modules in the module settings page for those modules.
I have wrotten a sql script to complete those works under DNN7:
BEGIN TRANSACTION UpdateModuleLocations
declare @DesktopModuleID as int,@PortalDesktopModuleID as int, @PortalID as int, @UserID as int
Set @UserID = 1
DECLARE my_cursor CURSOR FOR
select pt.PortalID,dm.DesktopModuleID from {databaseOwner}[{objectQualifier}DesktopModules] dm
inner join {databaseOwner}[{objectQualifier}Packages] pa on dm.PackageID=pa.PackageID and pa.PackageType='Module'
,{databaseOwner}[{objectQualifier}Portals] pt
Where dm.DesktopModuleID not in (Select pdm.DesktopModuleID from {databaseOwner}[{objectQualifier}PortalDesktopModules] pdm)
OPEN my_cursor
-- Perform the first fetch.
FETCH NEXT FROM my_cursor INTO @PortalID, @DesktopModuleID
WHILE @@FETCH_STATUS = 0
BEGIN
exec {databaseOwner}[{objectQualifier}AddPortalDesktopModule] @PortalID,@DesktopModuleID,@UserID
Select @PortalDesktopModuleID=@@IDENTITY
exec {databaseOwner}[{objectQualifier}AddDesktopModulePermission] @PortalDesktopModuleID,7,0,@UserID,NULL,@UserID
FETCH NEXT FROM my_cursor INTO @PortalID, @DesktopModuleID
END
CLOSE my_cursor
DEALLOCATE my_cursor
COMMIT TRANSACTION UpdateModuleLocations;
Go
Please clear the cache after you run those sql scripts.
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAwUAAADJCAIAAAD9xQl8AAAUIElEQVR4nO3cXWxU953Gcd/koulNURa1QVsJy72o1AQZqIhx20QhSFGg2SpJS7UoibuNVLUKqlQREG2STRu0EWQXQwkYQgJxxPLexoEoFCcEbF6UjGNiUwJ2Y2ODKRg8HjOesfErnr34Jz7emTPHZ2bO/ObnOd+PThGczpw52E94HoztghjgQnNz8+tf2bVr19WrV2Ox2ODgYHt7++sTNDc3e/Jy5eXlw8PDo6OjY2NjyR4zNjY2MjIyMDCwbt06T14UAOBbBbm+AUwZhw4dMqPnrbfe+vQrp0+fHh9Dhw4d8uq1ysvLh4aGRkZGRkdHbycxOjo6PDzMHgIAZI49BLcGBwerq6tfT6K6unpwcNCr11q3bt2tW7cGBweHhoaG7QwNDQ0ODg4MDPT397OHAAAZYg8hNe3t7XGrqLq6ur293dtX2bRp04kTJ65du9bZ2dnZ2Xk9gTl/7dq1EydObNq0ydtXBwD4DXsIGrW2tm7dunWDC1u3bm1tbc31/QIApjb2EAAA8Dv2EAAA8Dv2EAAA8Dv2EAAA8Dv2EAAA8Dv2EAAA8Dv2EAAA8Dv2EAAA8Dv2EAAA8Dv2EAAA8Dv2EAAA8Dv2EAAA8Dsv99DChQuFn5jSNRf+f1l9La+u4/7Kzo/MxlsYAIC84dkeMo2rp3cn3RZ6bnVc3FBLabexhwAASFt295DtB2MST9qOgPGT4790f/HEO7G9N9s7T3Z7E08mu3+Hkw5PT7x5h19O+vt1c2Mu35gAAPhEFvdQqoshljBKbH/u8jop7aFJL+vyZtJ7etxTEn9M6ffr8i086UnfmjQ5Lp+V9stljnciMkGY4U/e7KFJW9b2kc5P8erkxDMTOd+8m8tmuDY83EPuT7p/T/lWGnso7p2Vc3ruBFMOYYZvebaHkk2NuDO2J9Mr+MRXdLM2bG/e+TeSZ3vI/XvKnxySM/5OSYx04hNTDf/EK7t5xWQnbX8LgEuEGb6VxY8PJXtA4skMW9/lbST77yqlm590bbi8f4c7TPwxpSu7v0Nb/OnjvIcc3s7uc2J7MtmrpBqzxGoB3CPM8C0P9pBzr8c9Jr3/ilK9jsNdOd9/eoPG2z2U4ZU9vEN/cvN+Semkw5UzvzjvRHiIMMPPsriHYl/NmrgHJJ6M+3ncnHJ+ZLKLp7eH3Nye7W/T4QY82UO2N2b7cm7uwc07xbfcvF/iTjq/F+IulSxdKZ10HzPAPcIMP9P7/an5zwA5kcYecnjupCfTqxDnV+G/HaSHMMPPdO0h27+aAMKS/XGc+PNk4ymNPoj7G7Obp0x6EnCPMMPndO0hQIlk/0AQ93PnDyal9E8MsQnlMWkxOF+cCkEaCDN8jj0EqEMHIG8QZkwV7CFABf5CjLxBmDEVsYcAAIDfsYcAAIDfsYcAAIDfsYcAAIDfsYcAAIDfsYcAAIDfsYcAAIDfsYcAy9jYWEdHR2NjYwDQp6mpifDDn7IafoM9BFg6Ojqampq6urp6enpuAtk0ODh45cqVzs7OUCg08Xw4HDY/juvt7Y1EIl1dXYFAgPAjD2gLv8EeAiwNDQ3d3d2RSKSvr6+/v/8WkDXaKoHwQ4y28BvsIcASCAQikcjAwMDw8PAIkE3aKoHwQ4y28BvsIcASCAT6+vqGh4dv3749BmSTtkog/BCjLfwGewiIhf71OxwciUdWU6etEgKBQH9//8jIyNjYWPZeBYjpC7/BHgLYQxz2R1ZTp60SAoHArVu32EMQoC38BnsIYA9x2B9ZTV2ySgiFQsFgMBQKsYeQr7SF32APAewhDvsjq6mzrYTu7u5gMPj8889PbAX2EPKMtvAb7CGAPcRhf2Q1dYmVYPpg+fLlL7300saNG8dbgT2EPKMt/AZ7CIjfQ1SCb+VwD5k+WLFixdq1a99+++39+/fv2bPHtAJ7CHlGW/gN9hDAHsKXcriHgsHg+vXrKysr33vvvQ8//LCmpubUqVPHjx8PBoPsIeQZbeE32ENAynto7ty5k55x+H+df+n+sraPdP8UJMr5x4cS8fEh5B9t4TfYQ0A6e2ji7Ij7pe3j436eeGbSJ7rEHspEbj9/iK+3h09oC7/BHgI820PJVo7DHkq8ju2DEz+k5PDIiRefdKthIvYQewgCtIXfYA8Baf57WbIfJz4m8ZfJ9pDtc+PGjfMj3TwMzthD7CEI0BZ+gz0EeLaHEn9p+xTbM84rJ9lJh/+XPZQG9hB7CAK0hd9gDwFa9tBEEx9j+3Pbfy+b9IJwlmd7KKXfC3sIYthDgFJK9lCyF3LzAOePD8GlfNpDqX6fSfYQxLCHAKXS/nr7lP5xKtlIcvg5nz8kzCd7yPa3yR6CGPYQoJSGPRTz4uvLYgkTin8sS4k/91BK4Qcyxx4ClPK2EtgfUxd7SPItAN9iDwFKebiHGENTWuZrwJMVovPw/K0N32IPAUrxTwYwMlwAOZ8sLtcM8wi5xR4ClGIPwcjjPRQevpG9e874DQ9/YQ8BSrGHYOTxHnrx6Nq23naHmzdfX8Y8ggD2EKAUewhGvu6h5t62dac3L6tdEQ6Hk9184tfbs42QJewhQCn2EAxv95Dzg72thI0n3iw7/kxVx4HDV6uOdVUd66pq6Km71NfZ3Nt2rKuqquNATeupR3eXbah9I9kVJv3+Q8wjeIU9BCjFHoIxRfdQOBxevKtsWe2KPze9WtH6SkXrKzs7Xn7/+mbzOUNtve0Vra/8uenVZbUrFu8qu9TXaXuRlL4fI5MImWAPAUqxh2BM0T1UfbamcGvpk8d+WdVx4PNwvTnMx4fMAxp66l48+1zZ8WcKt5ZWn62xvUgm35+aSYSUsIcApdhDMKboHjpYX120bf6CowsaeuqSvdy2ls0Lji4o3Fp6sL7a9gHsIYhhDwFKefKJERz5d2QYJOcHe/vxobtfmVP819JtLZvbetvN8Xm4fvxr7Bt66paeWlK4p3j6mhJP9pDkWxX5hz0EKJXz3uXQeWQYJOcHe1gJjS3nircvLNo2f96ROaVH73nq09KnPi39z/NPdA/9MxaLtfW2Lz21pPivpYV7iou3L2y52GJ7ET6fGmLYQ4BSOe9dDp1H3gTp3vfuLdw3a1rFnKUVz4WTfMl9lr7ePo03I/IeewhQKud1xaHzyKcgTauYM31Nyb7AoWQ3z/djhBj2EKBUzruKQ+eRT0H62uo5j5U/m/jBoVy9reBn7CFAu0y+xAbI+ehxOB4rf3b8M4cYQMgt9hCgHXsIGcr57snqkeu3LvIEewjQjj0EMVmqhEgkcu584+HavQwgqMUeArRjD0FMtish7Q1E+JFt7CFAO/YQxOjZQ+bxhB9i2EOAdlQCxOR2DyU+nvBDDHsI0I5KgBiBSkjpM4EIP8SwhwDtqASI0VYJhB9itIXfYA8BFioBYrRVAuGHGG3hN9hDgIVKgBhtlUD4IUZb+A32EGChEiBGWyUQfojRFn6DPQRYqASI0VYJhB9itIXfYA8BFioBYrRVAuGHGG3hN9hDgIVKgBhvK+HKfXdF1/8x8bztSVuEH2LYQ4B2VALEeFsJt39VElpUdO3nD8Sdtz1pi/BDDHsI0I5KgBiPK+G3D8RWPdL/m/s7n5h9aeki67ztSTuEH2LYQ4B2VALEeFwJqx6JrXoktvrx2OrH+3+/6Isfz234ddmX5xNP2iH8EMMeArSjEiDG20oILZjR+aNvXrnvrouzv3H+u3fWfe9bdU8vicVitidtEX6IYQ8B2lEJEONtJVwtKrhYWPD5twvqCr9+7if3j5+3PWmL8EMMewjQjkqAGG8r4WJhwScz7mj4wT1x521P2iL8EMMeArSjEiDG20r4ZMYdl/7wu8TztidtEX6IYQ8B2lEJEKOtEgg/xGgLv8EeAixUAsRoqwTCDzHawm+whwALlQAx2iqB8EOMtvAb7CHAQiVAjLZKIPwQoy38BnsIsFAJEKOtEgg/xGgLv8EeAixUAsRoqwTCDzHawm+whwALlQAx2iqB8EOMtvAb7CHAQiVAjLZKIPwQoy38BnsIsFAJEKOtEgg/xGgLv8EeAixUAsRoqwTCDzHawm+whwALlQAx2iqB8EOMtvAb7CHAQiVAjLZKIPwQoy38BnsIsFAJEKOtEgg/xGgLv8EeAixUAsRoqwTCDzHawm+whwALlQAx2iqB8EOMtvAb7CHAQiVAjLZKIPwQoy38BnsIsFAJEKOtEgg/xGgLv8EeAixUAsRoqwTCDzHawm+whwALlQAx2iqB8EOMtvAb7CHAQiVAjLZKIPwQoy38BnsIsFAJEKOtEgg/xGgLv8EeAixUAsRoqwTCDzHawm+whwALlQAx2iqB8EOMtvAb7CHAQiVAjLZKIPwQoy38BnsIsFAJEKOtEgg/xGgLv8EeAixUAsRoqwTCDzHawm+whwALlQAx2iqB8EOMtvAb7CHAQiVAjLZKIPwQoy38BnsIsFAJEKOtEgg/xGgLv8EeAixUAsRoqwTCDzHawm+whwALlQAx2iqB8EOMtvAb7CHAQiVAjLZKIPwQoy38BnsIsFAJEJO9SgiHw03hCzWtp2paTzWFL0RHom6eRfghhj0EaEclQEw2KiE6Ej1YX72x6b93NOw6WF/97j/e39Gwa0PtG/sChyZdRYQfYthDgHZUAsR4Xgltve0vHl1b0bi9rbc9OhIdGL01MHorOhJt622vaNz+4tG1bb3tDk8n/BDDHgK0oxIgxttKCIfDT//vcjOG2nrbP+5+tzV65ovoydbombbe9tbomXWnNy+rXREOh5NdgfBDDHsI0I5KgBhvK2HjiTefPv7LfR273//ngY+7342MXI6MXL7UH/joRtVHN6r2deyuaT316O6yDbVvJLsC4YcY9hCgHZUAMR5WQjgcXryrbFntiteaXt11ecP1gZZYLBYZuXzkxqbdV/607eJ/mWNZ7YrFu8o6Q9dtL0L4IYY9BGhHJUCMh5VQfbamaFvpU8ee+dPfl7dGz5iTkZHLrdEz48dHN6qeOvZM0bbS6rM1thch/BDDHgK0oxIgxsNKOFhfPbNi/kNHH3yzdXOylzt540TJ+z8s2lZ6sL7a9gGEH2LYQ4B2VALEePvxoZkV84v2Fj95+meNN+vNyXA4PP7J1G297fs6dt97oHT6mhL2EHKOPQRoRyVAjIeV0Nhyrnj7wpkV82f9peSnH//QfF194836pXUlS+tKHq6d93DtvFl/Kbm7cnbxlsUtF1tsL0L4IYY9BGhHJUCMt59P/eTO5dO3FBftLf7+3+b+R2CJ+RZE+zp2P1w7b/6H937/b3OL9hZPq5jz5M7l4SRfck/4IYY9BGhHJUCMt5Ww8/g709eUTN9SPHPfrJn7Zj1cO++how8+dPRBs4TMGJq+pmTn8XeSXYHwQwx7CNCOSoAYz78f49KK5+5cPXtaxZy7K2ffXTnbzCCzhKZVzPna6jlLK55L9sGhGOGHIPYQoB2VADGeV0Jjy7nHyp+dvqbkXzZ8uYHGj+lrSh4rf/bc+UaHpxN+iGEPAdpRCRCTjUpoudjyPwc2/Psb//azPbN++s53zPGLykc3vLM+2adRjyP8EMMeArSjEiAmS5UQiUTOnW88XLu3qqb8YO26w7V7z51vjEQikz6R8EMMewjQjkqAGG2VQPghRlv4DfYQYKESIEZbJRB+iNEWfoM9BFioBIjRVgmEH2K0hd9gDwEWKgFitFUC4YcYbeE32EOAhUqAGG2VQPghRlv4DfYQYKESIEZbJRB+iNEWfoM9BFioBIjRVgmEH2K0hd9gDwEWKgFitFUC4YcYbeE32EOAhUqAGG2VQPghRlv4DfYQYKESIEZbJRB+iNEWfoM9BFioBIjJaiVE1//R9uSV++5K9hTCDzHsIUA7KgFislcJ137+QGhRke3J278qSfYswg8x7CFAOyoBYrJRCZeWLup8Ynb/b+6PrXrE/uRvH0j2XMIPMewhQDsqAWLiKqG7uztoJxQKuamEhl+XffHjuf2/XxRb/Xhs9eNmD9mcnLCT4hB+iPE2/F5hDwEWKgFi4iohGAy+8MILK1euXLly5apVq15++eUtW7bs378/GAy6qYS6p5fUfe9b579758XZ37hy312dP/qm7cnQghnJrkD4Icbb8HuFPQRYqASIsf0rcnl5+WuvvVZZWXn48OGTJ0+m+lfkcz+5v67w659/u+BiYYHtyatFSf/MJ/wQk43wZ449BFioBIhJ/BQK0wo7duw4cuRIXV2d6YM0PoWi4Qf3fDLjDtuTE3dSHMIPMdkLfybYQ4CFSoAYUwnXr1/v6ekZ/+zRUCgUDAY/+OCD8T5IrxIu/eF3ticTd9I4wg8xWQ1/2thDgIVKgBhTCcFg8ObNm70T9PT0dHd39/T0jJ+JRCLRaJTvx4i8oS38BnsIsFAJEGMqwfzRH3EUjUbZQ8gn2sJvsIcAC5UAMaYSwuFwYgGM18BE7CHkDW3hN9hDgCUQCPT391MJEGAqIfFP/76+PvNjHIE9RPghQ1v4DfYQYPnss8/C4fDw8PDt27fHgGwylZD4R38y2a4Ewg8x2sJvsIcAS0dHR3NzczQaHR4eHgGyyVRCVyqyWgmEH2K0hd9gDwGWsbGxjo6OM2fOBAB9Lly4QPjhT1kNv8EeAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAfsceAgAAflcQKygw/wMAAPCn/wMgvz12jf9fVAAAAABJRU5ErkJggg==)