After my upgrade from DNN 8 to 9.6, i had a problem with the persona bar not displaying the Pages option for the Administrator Role, on investigating the database i found that there was a missing record in PersonaBarMenuPermission for the Pages menuid. I manually inserted a row and now the Pages option is displayed.
My query is i have extra records in the PersonaBarMenu (i created a new install of dnn to compare), the additional records have an identifier like 'Link_0-232' , ModuleName LinkMenu, can i remove these records and related records from the PersonaBar tables.
MenuId Identifier ModuleName FolderName Controller ResourceKey Path Link CssClass ParentId Order AllowHost Enabled CreatedByUserId CreatedOnDate LastModifiedByUserId LastModifiedOnDate IconFile 29 Link_0_232 LinkMenu NULL Dnn.PersonaBar.UI.MenuControllers.LinkMenuController, Dnn.PersonaBar.UI Advanced Configuration Settings LinkMenu?portalId=0&tabId=232 NULL NULL 2 200 1 1 NULL 2019-08-13 12:06:21.330 NULL 2019-08-13 12:06:21.330 NULL 30 Link_0_240 LinkMenu NULL Dnn.PersonaBar.UI.MenuControllers.LinkMenuController, Dnn.PersonaBar.UI Vendors LinkMenu?portalId=0&tabId=240 NULL NULL 2 200 1 1 NULL 2019-08-13 12:06:21.413 NULL 2019-08-13 12:06:21.413 NULL 31 Link_0_241 LinkMenu NULL Dnn.PersonaBar.UI.MenuControllers.LinkMenuController, Dnn.PersonaBar.UI Site Log LinkMenu?portalId=0&tabId=241 NULL NULL 2 200 1 1 NULL 2019-08-13 12:06:21.423 NULL 2019-08-13 12:06:21.423 NULL 32 Link_0_242 LinkMenu NULL Dnn.PersonaBar.UI.MenuControllers.LinkMenuController, Dnn.PersonaBar.UI Newsletters LinkMenu?portalId=0&tabId=242 NULL NULL 2 200 1 1 NULL 2019-08-13 12:06:21.430 NULL 2019-08-13 12:06:21.430 NULL 33 Link_0_244 LinkMenu NULL Dnn.PersonaBar.UI.MenuControllers.LinkMenuController, Dnn.PersonaBar.UI Recycle Bin LinkMenu?portalId=0&tabId=244 NULL NULL 2 200 1 1 NULL 2019-08-13 12:06:21.433 NULL 2019-08-13 12:06:21.433 NULL 34 Link_0_245 LinkMenu NULL Dnn.PersonaBar.UI.MenuControllers.LinkMenuController, Dnn.PersonaBar.UI Event Viewer LinkMenu?portalId=0&tabId=245 NULL NULL 2 200 1 1 NULL 2019-08-13 12:06:21.440 NULL 2019-08-13 12:06:21.440 NULL 35 Link_0_246 LinkMenu NULL Dnn.PersonaBar.UI.MenuControllers.LinkMenuController, Dnn.PersonaBar.UI Site Wizard LinkMenu?portalId=0&tabId=246 NULL NULL 2 200 1 1 NULL 2019-08-13 12:06:21.443 NULL 2019-08-13 12:06:21.443 NULL 36 Link_0_252 LinkMenu NULL Dnn.PersonaBar.UI.MenuControllers.LinkMenuController, Dnn.PersonaBar.UI Google Analytics LinkMenu?portalId=0&tabId=252 NULL NULL 2 200 1 1 NULL 2019-08-13 12:06:21.447 NULL 2019-08-13 12:06:21.447 NULL 37 Link_-1_87 LinkMenu NULL Dnn.PersonaBar.UI.MenuControllers.LinkMenuController, Dnn.PersonaBar.UI Security Analyzer LinkMenu?portalId=-1&tabId=87 NULL NULL 2 300 1 1 NULL 2019-08-13 12:06:21.467 NULL 2019-08-13 12:06:21.467 NULL
Is there a SQL script to correct the PersonaBar tables, i.e. empty and recreate the default records.
Michael TobischDNN★MVP
Unfortunately not, i did a google search for 'upgrade dnn' which took me to https://www.dnnsoftware.c...-dotnetnuke and followed the instructions from there.
I didn't do a phase upgrade from 8.00 --> 9.01 --> 9.03 --> 9.06 but when straight from 8.00 --> 9.06
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.