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.
Unfortunately not, i did a google search for 'upgrade dnn' which took me to https://www.dnnsoftware.c...upgrading-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 for the discussion of the open source CMS DNN platform and ecosystem.
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.