No Database
I have been creating a website in the Beta version and have about 150 pages created so far.
Today when I visit the site I get the "This site is under construction" message. When I attempt to log into the backend, i am prompted to create a database for the site as if starting from scratch. The only thing I can think of is that its connection to the Database was lost some how. I have no idea how this would have happened as I haven't actually logged onto the server in a couple of days.
I also have another beta site running on the server and it seems to be fine.
I can see the database on the server and still see all of the Sitefinity tables in it. Is there a way to reconnect Sitefinity to the DB? I may go crazy if I have to start over.
Update: It seems that the only file in App_Data/Sitefinity/Configuration folder is SecurityConfig. I do not have the DataCofig, PagesConfig, ProjectConfig, SystemConfig or ToolboxesConfig files found in the other project.
Is it possible to copy these files from the other project and then modify the connection string to point to the database?
Anthony
Hello Anthony,
Try the following
1. Open App_Data\Sitefinity\Configuration\DataConfig.config
2. Set <dataConfig initialized="True">
3. Set you connection string inside <connectionStrings> node
<
dataConfig
initialized
=
"True"
>
<
openAccessAssemblies
/>
<
connectionStrings
>
<
add
name
=
"Sitefinity"
connectionString
=
"data source=SERVER;Integrated Security=SSPI;initial catalog=ProjectName"
/>
</
connectionStrings
>
I have done that and changed the SERVER value to the name of the server and ProjectName to the name of the database.
going to the site I receive the page under construction page, and when I try to log into the backend I receive the following error.
An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
|
[UnauthorizedAccessException: You are not authorized to 'View a page' ('Pages').] DynamicModule.ns.Wrapped_OpenAccessPageProvider_ab81b0248551443dac385d6e9a5d2b7d.GetPageNode(Guid id) +413 Telerik.Sitefinity.Web.SiteMapBase.GetRootNodeCore(Boolean ifAccessible) +462 Telerik.Sitefinity.Web.SiteMapBase.FindSiteMapNode(String rawUrl, Boolean ifAccessible) +652 Telerik.Sitefinity.Web.SitefinityRoute.GetRouteData(HttpContextBase httpContext) +400 System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext) +370 System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context) +75 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +266 |
Hi Anthony,
There some issue with the permissions of the user you use or there is an authentication cookie has left in the browser. There should not be a problem to see this node if you are an administrator. You can take a look at you are not authorized to view a page.
Greetings,
Ivan Dimitrov
the Telerik team