Upgrade from 2.8 to 3.1

Topics: ASP.NET 2.0, Controls
Jan 16, 2015 at 7:30 AM
Edited Jan 16, 2015 at 7:57 AM
Hi everybody!
I've just upgraded from 2.8 to 3.1. During upgrade I faced with some issues. Here I am going to explain how to fix it. May be this information will be helpful for somebody.
  1. Save basic settings under admin interface - not working - script error.
    If you faced with this issue you need to explicitly select "Set mobile theme" in the drop down. Then save should work.
  2. Not all tabs are visible even if you are admin (Dashboard, themes, packages).
    In my case I have to do following:
    • Add role "Editor" to the user
    • Add missing records into the database. In 3.1 source zip archive under setup\SQLServer\MSSQLSetup3.0.0.0.sql some required data are missing (but it presented in SQLLite version):
      Table be_Rights - ManageExtensions, ManagePackages, ManageThemes, ViewDashboard
      Table be_RightsRoles - missing records for aforementioned rights, for example there should be the record ViewDashboard - Administrator
I used this script to fix it (backup db before using it!)
INSERT [dbo].[be_Rights] ([BlogId], [RightName]) VALUES (N'27604f05-86ad-47ef-9e05-950bb762570c', N'ViewDashboard')
INSERT [dbo].[be_Rights] ([BlogId], [RightName]) VALUES (N'27604f05-86ad-47ef-9e05-950bb762570c', N'ManageExtensions')
INSERT [dbo].[be_Rights] ([BlogId], [RightName]) VALUES (N'27604f05-86ad-47ef-9e05-950bb762570c', N'ManagePackages')
INSERT [dbo].[be_Rights] ([BlogId], [RightName]) VALUES (N'27604f05-86ad-47ef-9e05-950bb762570c', N'ManageThemes')

INSERT [dbo].[be_RightRoles] ([BlogId], [RightName], [Role]) VALUES (N'27604f05-86ad-47ef-9e05-950bb762570c', N'ViewDashboard', N'Administrators')
INSERT [dbo].[be_RightRoles] ([BlogId], [RightName], [Role]) VALUES (N'27604f05-86ad-47ef-9e05-950bb762570c', N'ManageExtensions', N'Administrators')
INSERT [dbo].[be_RightRoles] ([BlogId], [RightName], [Role]) VALUES (N'27604f05-86ad-47ef-9e05-950bb762570c', N'ManagePackages', N'Administrators')
INSERT [dbo].[be_RightRoles] ([BlogId], [RightName], [Role]) VALUES (N'27604f05-86ad-47ef-9e05-950bb762570c', N'ManageThemes', N'Administrators')
Where guid is blog id. 3. Can't create new page. If you faced with this issue make sure you fill all page settings. If some settings are blank it may not saved.

In conclusion admin part in 3.1 have some bugs, but I believe guys will fix them, they did a great job.