After some working, we tried mannually adding the sections into the umbracoApp and mannually adding the relationships to the sections in the umbracoUser2app tables. This has allowed us to log in with the admin accounts,but it seems to be a very diffuclt way to fix this type of issue.
Is there something we missed that caused this problem to occur? We had recieved the site from a vendor and hadnt had any problems until now.
Edited 10-16-2012:
To enable us to add new users to the backend, we ran this script:
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (1,'content','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (2,'media','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (3,'settings','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (4,'developer','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (5,'users','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (6,'members','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (8,'member','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (7,'translation','','','')
After running this script, we were able to add the relationship in the umbracoUser2app table which allowed us to create new users.
Problems trying to edit users
For some reason whenever our team tries to edit a user, we get an error.
In the log we just get: "Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery."
Another issue we found, is that when we change the password we are unable to log into the url/Umbraco/ with that account.
Has anyone had a similar issue? If so, how did they resolve this issue?
After some working, we tried mannually adding the sections into the umbracoApp and mannually adding the relationships to the sections in the umbracoUser2app tables. This has allowed us to log in with the admin accounts,but it seems to be a very diffuclt way to fix this type of issue.
Is there something we missed that caused this problem to occur? We had recieved the site from a vendor and hadnt had any problems until now.
Edited 10-16-2012:
To enable us to add new users to the backend, we ran this script:
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (1,'content','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (2,'media','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (3,'settings','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (4,'developer','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (5,'users','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (6,'members','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (8,'member','','','')
--INSERT INTO [Umbraco].[dbo].[umbracoApp] VALUES (7,'translation','','','')
After running this script, we were able to add the relationship in the umbracoUser2app table which allowed us to create new users.
is working on a reply...