Content node is missing can't manage content without Admin User
Hi there, We have a managing contents problem on our website. Our users can't manage contents because the content node is empty. We are using the Admin user, the only user who can manage website contents. We have two systems, stress test and production. The first is ok and the second one has no content tree. We made some deploy's from one to another system and problem remains.
In the production system wich I made some checks with firebug from firefox during a session with a normal user (not Admin) and I found some errors as follows:
*************************************************************************** Server Error in '/' Application.
Invalid object name 'UCUserSettings'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'UCUserSettings'.
Did you copy the database as well? If you're copying an Umbraco instance to another instance and it does not share the same database, you need to make a copy of the database.
I found these instructions, and they work OK for me (note this is with MySql so the procedure would be slightly different using SQL Server:
1.Copy all the directories and archives of wwwroot directory in Computer 1 to wwwroot directory in Computer 2. If wwwroot had existing archives or directories, first delete them.
2.Create a new database in the test server (we use SQL server). To avoid problems, call that database as the origin database (the one wich has Computer 1). We used the steps of this guide umbraco.org/.../install-umbraco-4-on-windows-vista (Chapter 7. Sub-chapter: SQLServer ManagementStudio Express). After that you will hava a blank database created and a user asociated to it.
3.Do a backup of the origin database (Computer 1) and restore it in the test server (with the option "overwrite the exixting database").
4.In test server now you have a copy of the origin database. Delete the user asociated to the database and create a new one (with the same name and permissions... as in step 2). We have done this because we had problems running Umbraco if we don't do that...
5.Configure test server SQL Server to accept remote connections (if it isn't).
6.Change the web.config file on wwwroot of Computer 1 and Computer 2 to point to the new database created in the test server.
7.Run Umbraco... you should be able to login correctly.
$ mysqldump -u user -p db-name > db-name.out
$ mysql -u MobileCmsUmbraco -p spaceballs MobileCmsUmbraco < umbraco.out
As Paul is saying above it's probably because you have not deployed the database as well - I think the error you posted is because the macro refering to the user control is missing in the DB.
So make sure the DB is deployed as well and don't hesitate to post in here if you have any further questions.
Because we made the last content changes in the production system, we must consider this system as the one that have the good content, we cannot act under the quality system to deploy to the production system.
Can we ignore the quality system and manage the situation in the production system ?
Is the quality system totally messed up? Or is the content just different now? If the DB for the quality system is corrup how about making a copy of the one from the production system and use that on the quality system as well?
Since I suppose all new content will be created on production the content on quality (stage) will be outdated anyhow just used to test new functionality before you deploy file changes to live I think that is perhaps the way to go?
Finally we found a solution for this problem. Inside of the bin folder there was some files none of them necessary related to Courier. After removed them the tree nodes appear and now it's possible manage our website with my profile, not with admin.
The only one we keep was the Umbraco.Courier.Core.dll file.
Content node is missing can't manage content without Admin User
Hi there,
We have a managing contents problem on our website. Our users can't manage contents because the content node is empty.
We are using the Admin user, the only user who can manage website contents.
We have two systems, stress test and production. The first is ok and the second one has no content tree. We made some deploy's from one to another system and problem remains.
In the production system wich I made some checks with firebug from firefox during a session with a normal user (not Admin) and I found some errors as follows:
***************************************************************************
Server Error in '/' Application.
Invalid object name 'UCUserSettings'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'UCUserSettings'.
****************************************************************************
I found similar posts here but none applies to us.
Hi there and welcome to our :)
I'm guessing that some files are missing on the production server. What steps did you guys take in order to deploy from stage to production?
Also have you double checked that permissions have been set properly on the root folder containing Umbraco?
/Jan
Thanks Jan.
Sorry the delay but I was absent.
Here's what our systems administration has done:
Regards.
Did you copy the database as well? If you're copying an Umbraco instance to another instance and it does not share the same database, you need to make a copy of the database.
I found these instructions, and they work OK for me (note this is with MySql so the procedure would be slightly different using SQL Server:
1.Copy all the directories and archives of wwwroot directory in Computer 1 to wwwroot directory in Computer 2. If wwwroot had
existing archives or directories, first delete them.
2.Create a new database in the test server (we use SQL server). To avoid problems, call that database as the origin database
(the one wich has Computer 1). We used the steps of this guide umbraco.org/.../install-umbraco-4-on-windows-vista (Chapter 7.
Sub-chapter: SQLServer ManagementStudio Express). After that you will hava a blank database created and a user asociated to it.
3.Do a backup of the origin database (Computer 1) and restore it in the test server (with the option "overwrite the exixting
database").
4.In test server now you have a copy of the origin database. Delete the user asociated to the database and create a new one
(with the same name and permissions... as in step 2). We have done this because we had problems running Umbraco if we don't do
that...
5.Configure test server SQL Server to accept remote connections (if it isn't).
6.Change the web.config file on wwwroot of Computer 1 and Computer 2 to point to the new database created in the test server.
7.Run Umbraco... you should be able to login correctly.
$ mysqldump -u user -p db-name > db-name.out
$ mysql -u MobileCmsUmbraco -p spaceballs MobileCmsUmbraco < umbraco.out
Regards,
-- Paul
Hi
As Paul is saying above it's probably because you have not deployed the database as well - I think the error you posted is because the macro refering to the user control is missing in the DB.
So make sure the DB is deployed as well and don't hesitate to post in here if you have any further questions.
/Jan
Thank you both for your sugestions.
Because we made the last content changes in the production system, we must consider this system as the one that have the good content, we cannot act under the quality system to deploy to the production system.
Can we ignore the quality system and manage the situation in the production system ?
Regards.
Hi J. Vitor Ferrerira
Is the quality system totally messed up? Or is the content just different now? If the DB for the quality system is corrup how about making a copy of the one from the production system and use that on the quality system as well?
Since I suppose all new content will be created on production the content on quality (stage) will be outdated anyhow just used to test new functionality before you deploy file changes to live I think that is perhaps the way to go?
/Jan
Hi everybody
Finally we found a solution for this problem. Inside of the bin folder there was some files none of them necessary related to Courier. After removed them the tree nodes appear and now it's possible manage our website with my profile, not with admin.
The only one we keep was the Umbraco.Courier.Core.dll file.
Thank you all.
Here are the files:
Umbraco.Courier.Core
Umbraco.Courier.DataResolvers.dll
Umbraco.Courier.DataResolvers
Umbraco.Courier.Persistence.V4.NHibernate.dll
Umbraco.Courier.Persistence.V4.NHibernate
Umbraco.Courier.Providers.dll
Umbraco.Courier.Providers
Umbraco.Courier.RepositoryProviders.dll
Umbraco.Courier.RepositoryProviders
Umbraco.Courier.UI.dll
is working on a reply...