404 Error after Fresh Install of Umbraco 6 on IIS 7.5
Hello,
I'm new to Umbraco and I'm trying to evaluate it for potential use by my organization. The server that I'm using is a Win Server 2008 R2 runing MS Sql Server 2012 Standard 64 Bit and IIS 7.5. I downloaded Umbraco 6.0 from Codeplex and unzipped the files to c:/inetpub/wwwrot/Umbraco6 and created an application within IIS by the same name using App Pool Asp.Net 4.0. I am able to install Umbraco and all the tables are created within the database without any problems. I've been selecting the Simple Starter Kit and the SweetAs skin both of which install correctly. Umbraco says installation has finished, but when I click on the 'Preview your new Website' link I get a 404 error. I am able to use the admin portal without any problems. I cannot navigate to any pages that I have created and published in Umbraco. The link to document is /Umbraco6/{pagename}.aspx. Below is the UmbracoTraceLog.txt from App_Data/logs.
2013-02-26 10:01:28,084 [25] INFO Umbraco.Core.CoreBootManager - [Thread 32] Umbraco application starting
2013-02-26 10:01:28,123 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Determining hash of code files on disk
2013-02-26 10:01:28,133 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Hash determined (took 9ms)
2013-02-26 10:01:28,228 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 13 (took 83ms)
2013-02-26 10:01:28,247 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.ICacheRefresher, found 5 (took 3ms)
2013-02-26 10:01:28,251 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.IDataType, found 35 (took 1ms)
2013-02-26 10:01:28,253 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.IMacroGuiRendering, found 13 (took 1ms)
2013-02-26 10:01:28,256 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.IPackageAction, found 12 (took 2ms)
2013-02-26 10:01:28,258 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.IAction, found 35 (took 1ms)
2013-02-26 10:01:28,260 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of Umbraco.Core.Models.IMacroPropertyType, found 0 (took 1ms)
2013-02-26 10:01:28,263 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 1ms)
2013-02-26 10:01:28,265 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 1ms)
2013-02-26 10:01:28,295 [25] INFO umbraco.content - [Thread 32] Loading content from database...
2013-02-26 10:01:28,311 [25] ERROR umbraco.cms.businesslogic.web.DocumentType - [Thread 32] Exception while trying to build DTD for Xml schema; is Umbraco installed correctly and the connection string configured?
System.InvalidOperationException: Can't find a connection string with the name 'umbracoDbDSN'
at Umbraco.Core.Persistence.Database..ctor(String connectionStringName)
at Umbraco.Core.Persistence.UmbracoDatabase..ctor(String connectionStringName)
at Umbraco.Core.Persistence.DefaultDatabaseFactory.CreateDatabase()
at Umbraco.Core.Persistence.UnitOfWork.PetaPocoUnitOfWorkProvider.GetUnitOfWork()
at Umbraco.Core.Services.ContentTypeService.GetAllContentTypes(Int32[] ids)
at umbraco.cms.businesslogic.web.DocumentType.GetAllAsList()
at umbraco.cms.businesslogic.web.DocumentType.GenerateXmlDocumentType()
2013-02-26 10:01:28,317 [25] ERROR umbraco.BusinessLogic.Application - [Thread 32] Can't instantiate SQLHelper with connectionstring ""
System.ArgumentNullException: Value cannot be null.
Parameter name: connectionString
at umbraco.DataLayer.DataLayerHelper.CreateSqlHelper(String connectionString, Boolean forceLegacyConnection)
at umbraco.BusinessLogic.Application.get_SqlHelper()
2013-02-26 10:01:28,317 [25] ERROR umbraco.BusinessLogic.Application - [Thread 32] Can't instantiate SQLHelper with connectionstring ""
System.ArgumentNullException: Value cannot be null.
Parameter name: connectionString
at umbraco.DataLayer.DataLayerHelper.CreateSqlHelper(String connectionString, Boolean forceLegacyConnection)
at umbraco.BusinessLogic.Application.get_SqlHelper()
2013-02-26 10:01:28,317 [25] ERROR umbraco.content - [Thread 32] Error Republishing
System.NullReferenceException: Object reference not set to an instance of an object.
at umbraco.content.LoadContentFromDatabase()
2013-02-26 10:01:28,324 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 3 (took 2ms)
2013-02-26 10:01:28,327 [25] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 1 (took 2ms)
2013-02-26 10:01:28,395 [25] ERROR umbraco.BusinessLogic.Application - [Thread 32] Can't instantiate SQLHelper with connectionstring ""
System.ArgumentNullException: Value cannot be null.
Parameter name: connectionString
at umbraco.DataLayer.DataLayerHelper.CreateSqlHelper(String connectionString, Boolean forceLegacyConnection)
at umbraco.BusinessLogic.Application.get_SqlHelper()
2013-02-26 10:01:28,396 [25] ERROR Umbraco.Core.PluginManager - [Thread 32] Error creating type UmbracoExamine.UmbracoEventManager
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Examine.ExamineManager' threw an exception. ---> System.Configuration.ConfigurationErrorsException: Object reference not set to an instance of an object. (C:\inetpub\wwwroot\Umbraco6\config\ExamineSettings.config line 12) ---> System.NullReferenceException: Object reference not set to an instance of an object.
at UmbracoExamine.DataServices.UmbracoContentService.GetAllUserPropertyNames()
at UmbracoExamine.Config.IndexSetExtensions.ToIndexCriteria(IndexSet set, IDataService svc)
at Examine.LuceneEngine.Providers.LuceneIndexer.Initialize(String name, NameValueCollection config)
at UmbracoExamine.BaseUmbracoIndexer.Initialize(String name, NameValueCollection config)
at UmbracoExamine.UmbracoContentIndexer.Initialize(String name, NameValueCollection config)
at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
--- End of inner exception stack trace ---
at System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
at System.Web.Configuration.ProvidersHelper.InstantiateProviders(ProviderSettingsCollection configProviders, ProviderCollection providers, Type providerType)
at Examine.ExamineManager.LoadProviders()
at Examine.ExamineManager..cctor()
--- End of inner exception stack trace ---
at UmbracoExamine.UmbracoEventManager..ctor()
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.Activator.CreateInstance(Type type)
at Umbraco.Core.PluginManager.CreateInstances[T](IEnumerable`1 types, Boolean throwException)
2013-02-26 10:01:28,399 [25] INFO Umbraco.Core.ApplicationContext - [Thread 32] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:01:28,402 [25] INFO Umbraco.Core.ApplicationContext - [Thread 32] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:01:28,432 [25] INFO Umbraco.Core.CoreBootManager - [Thread 32] Umbraco application startup complete (took 337ms)
2013-02-26 10:01:28,435 [25] INFO Umbraco.Core.ApplicationContext - [Thread 32] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:01:28,543 [25] INFO Umbraco.Core.ApplicationContext - [Thread 28] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:01:28,545 [25] WARN Umbraco.Web.UmbracoModule - [Thread 28] Umbraco is not configured
2013-02-26 10:01:48,683 [25] INFO Umbraco.Core.DatabaseContext - [Thread 18] Configured new ConnectionString: server=****\*****;database=****;user id=***;password=****
2013-02-26 10:01:48,997 [25] ERROR umbraco.BusinessLogic.Application - [Thread 28] Can't instantiate SQLHelper with connectionstring ""
System.ArgumentNullException: Value cannot be null.
Parameter name: connectionString
at umbraco.DataLayer.DataLayerHelper.CreateSqlHelper(String connectionString, Boolean forceLegacyConnection)
at umbraco.BusinessLogic.Application.get_SqlHelper()
2013-02-26 10:01:48,997 [25] ERROR umbraco.BusinessLogic.Application - [Thread 28] Can't instantiate SQLHelper with connectionstring ""
System.ArgumentNullException: Value cannot be null.
Parameter name: connectionString
at umbraco.DataLayer.DataLayerHelper.CreateSqlHelper(String connectionString, Boolean forceLegacyConnection)
at umbraco.BusinessLogic.Application.get_SqlHelper()
2013-02-26 10:01:49,000 [25] INFO Umbraco.Core.UmbracoApplicationBase - [Thread 28] Application shutdown. Reason: ConfigurationChange
2013-02-26 10:01:49,361 [15] INFO Umbraco.Core.CoreBootManager - [Thread 32] Umbraco application starting
2013-02-26 10:01:49,438 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Determining hash of code files on disk
2013-02-26 10:01:49,449 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Hash determined (took 9ms)
2013-02-26 10:01:49,472 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 13 (took 13ms)
2013-02-26 10:01:49,490 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.ICacheRefresher, found 5 (took 1ms)
2013-02-26 10:01:49,495 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.IDataType, found 35 (took 2ms)
2013-02-26 10:01:49,497 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.IMacroGuiRendering, found 13 (took 2ms)
2013-02-26 10:01:49,499 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.IPackageAction, found 12 (took 1ms)
2013-02-26 10:01:49,502 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of umbraco.interfaces.IAction, found 35 (took 2ms)
2013-02-26 10:01:49,503 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of Umbraco.Core.Models.IMacroPropertyType, found 0 (took 0ms)
2013-02-26 10:01:49,504 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 0ms)
2013-02-26 10:01:49,506 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 0ms)
2013-02-26 10:01:49,534 [15] INFO umbraco.content - [Thread 32] Loading content from database...
2013-02-26 10:01:49,624 [15] INFO Umbraco.Core.Persistence.UmbracoDatabase - [Thread 32] at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Umbraco.Core.Persistence.Database.d__7`1.MoveNext()
2013-02-26 10:01:49,628 [15] ERROR umbraco.cms.businesslogic.web.DocumentType - [Thread 32] Exception while trying to build DTD for Xml schema; is Umbraco installed correctly and the connection string configured?
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoNode'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Umbraco.Core.Persistence.Database.d__7`1.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Umbraco.Core.Persistence.Repositories.ContentTypeRepository.d__2.MoveNext()
at Umbraco.Core.Persistence.Repositories.RepositoryBase`2.GetAll(TId[] ids)
at Umbraco.Core.Services.ContentTypeService.GetAllContentTypes(Int32[] ids)
at umbraco.cms.businesslogic.web.DocumentType.GetAllAsList()
at umbraco.cms.businesslogic.web.DocumentType.GenerateXmlDocumentType()
ClientConnectionId:40965aa5-379e-48bb-837e-d2840635c0fb
2013-02-26 10:01:49,655 [15] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 32] Error executing query select umbracoNode.id, umbracoNode.parentId, umbracoNode.sortOrder, cmsContentXml.xml from umbracoNode
inner join cmsContentXml on cmsContentXml.nodeId = umbracoNode.id and umbracoNode.nodeObjectType = @type
inner join cmsDocument on cmsDocument.nodeId = umbracoNode.id
where cmsDocument.published = 1
order by umbracoNode.level, umbracoNode.sortOrder
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoNode'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
ClientConnectionId:40965aa5-379e-48bb-837e-d2840635c0fb
2013-02-26 10:01:49,657 [15] ERROR umbraco.content - [Thread 32] Error Republishing
umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader ---> System.Data.SqlClient.SqlException: Invalid object name 'umbracoNode'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
--- End of inner exception stack trace ---
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
at umbraco.content.LoadContentFromDatabase()
2013-02-26 10:01:49,663 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 3 (took 0ms)
2013-02-26 10:01:49,664 [15] INFO Umbraco.Core.PluginManager - [Thread 32] Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 1 (took 0ms)
2013-02-26 10:01:49,763 [15] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 32] Error executing query select distinct alias from cmsPropertyType order by alias
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'cmsPropertyType'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
ClientConnectionId:40965aa5-379e-48bb-837e-d2840635c0fb
2013-02-26 10:01:49,770 [15] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 32] Error executing query select distinct alias from cmsPropertyType order by alias
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'cmsPropertyType'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
ClientConnectionId:40965aa5-379e-48bb-837e-d2840635c0fb
2013-02-26 10:01:49,785 [15] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 32] Error executing query select distinct alias from cmsPropertyType order by alias
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'cmsPropertyType'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
ClientConnectionId:40965aa5-379e-48bb-837e-d2840635c0fb
2013-02-26 10:01:49,993 [15] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 32] Error executing query select
umbracoNode.id, umbracoNode.uniqueId, umbracoNode.level,
umbracoNode.parentId, umbracoNode.path, umbracoNode.sortOrder, umbracoNode.createDate,
umbracoNode.nodeUser, umbracoNode.text,
cmsMember.Email, cmsMember.LoginName, cmsMember.Password
from umbracoNode
inner join cmsContent on cmsContent.nodeId = umbracoNode.id
inner join cmsMember on cmsMember.nodeId = cmsContent.nodeId
where umbracoNode.nodeObjectType = @nodeObjectType AND 1=1
order by umbracoNode.text
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoNode'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
ClientConnectionId:40965aa5-379e-48bb-837e-d2840635c0fb
2013-02-26 10:01:49,993 [15] ERROR Umbraco.Core.PluginManager - [Thread 32] Error creating type UmbracoExamine.UmbracoEventManager
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Examine.ExamineManager' threw an exception. ---> umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader ---> System.Data.SqlClient.SqlException: Invalid object name 'umbracoNode'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
--- End of inner exception stack trace ---
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
at umbraco.cms.businesslogic.member.Member.GetAllAsList()
at UmbracoExamine.UmbracoMemberIndexer.GetXDocument(String xPath, String type)
at UmbracoExamine.BaseUmbracoIndexer.AddNodesToIndex(String xPath, String type)
at UmbracoExamine.BaseUmbracoIndexer.PerformIndexAll(String type)
at UmbracoExamine.BaseUmbracoIndexer.PerformIndexRebuild()
at Examine.ExamineManager.LoadProviders()
at Examine.ExamineManager..cctor()
--- End of inner exception stack trace ---
at UmbracoExamine.UmbracoEventManager..ctor()
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.Activator.CreateInstance(Type type)
at Umbraco.Core.PluginManager.CreateInstances[T](IEnumerable`1 types, Boolean throwException)
2013-02-26 10:01:49,997 [15] INFO Umbraco.Core.ApplicationContext - [Thread 32] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:01:50,000 [15] INFO Umbraco.Core.ApplicationContext - [Thread 32] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:01:50,026 [15] INFO Umbraco.Core.CoreBootManager - [Thread 32] Umbraco application startup complete (took 655ms)
2013-02-26 10:01:50,029 [15] INFO Umbraco.Core.ApplicationContext - [Thread 32] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:01:50,985 [15] INFO umbraco.presentation.install.utills.p - [Thread 5] Running 'installOrUpgrade' service
2013-02-26 10:01:51,348 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Initializing database schema creation
2013-02-26 10:01:51,392 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoNode] ([id] INTEGER NOT NULL IDENTITY(1,1),
[trashed] BIT NOT NULL CONSTRAINT [DF_umbracoNode_trashed] DEFAULT ('0'),
[parentID] INTEGER NOT NULL,
[nodeUser] INTEGER NULL,
[level] INTEGER NOT NULL,
[path] NVARCHAR(150) NOT NULL,
[sortOrder] INTEGER NOT NULL,
[uniqueID] UniqueIdentifier NULL,
[text] NVARCHAR(255) NULL,
[nodeObjectType] UniqueIdentifier NULL,
[createDate] DATETIME NOT NULL CONSTRAINT [DF_umbracoNode_createDate] DEFAULT (getdate()))
2013-02-26 10:01:51,395 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [umbracoNode] ADD CONSTRAINT [PK_structure] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,398 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoNode
2013-02-26 10:01:51,478 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoNode
2013-02-26 10:01:51,483 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [umbracoNode] ADD CONSTRAINT [FK_umbracoNode_umbracoNode_id] FOREIGN KEY ([parentID]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,486 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_umbracoNodeParentId] ON [umbracoNode] ([parentID])
2013-02-26 10:01:51,488 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_umbracoNodeObjectType] ON [umbracoNode] ([nodeObjectType])
2013-02-26 10:01:51,492 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoNode' was created
2013-02-26 10:01:51,495 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsTemplate] ([pk] INTEGER NOT NULL IDENTITY(1,1),
[nodeId] INTEGER NOT NULL,
[master] INTEGER NULL,
[alias] NVARCHAR(100) NULL,
[design] NTEXT NOT NULL)
2013-02-26 10:01:51,497 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsTemplate] ADD CONSTRAINT [PK_cmsTemplate] PRIMARY KEY CLUSTERED ([pk])
2013-02-26 10:01:51,497 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsTemplate
2013-02-26 10:01:51,497 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsTemplate
2013-02-26 10:01:51,499 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsTemplate] ADD CONSTRAINT [FK_cmsTemplate_umbracoNode] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,501 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsTemplate] ADD CONSTRAINT [FK_cmsTemplate_cmsTemplate] FOREIGN KEY ([master]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,501 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsTemplate_nodeId] ON [cmsTemplate] ([nodeId])
2013-02-26 10:01:51,504 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsTemplate' was created
2013-02-26 10:01:51,505 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsContent] ([pk] INTEGER NOT NULL IDENTITY(1,1),
[nodeId] INTEGER NOT NULL,
[contentType] INTEGER NOT NULL)
2013-02-26 10:01:51,508 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsContent] ADD CONSTRAINT [PK_cmsContent] PRIMARY KEY CLUSTERED ([pk])
2013-02-26 10:01:51,508 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsContent
2013-02-26 10:01:51,508 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsContent
2013-02-26 10:01:51,509 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsContent] ADD CONSTRAINT [FK_cmsContent_umbracoNode_id] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,510 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsContent] ON [cmsContent] ([nodeId])
2013-02-26 10:01:51,513 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsContent' was created
2013-02-26 10:01:51,515 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsContentVersion] ([id] INTEGER NOT NULL IDENTITY(1,1),
[ContentId] INTEGER NOT NULL,
[VersionId] UniqueIdentifier NOT NULL,
[VersionDate] DATETIME NOT NULL CONSTRAINT [DF_cmsContentVersion_VersionDate] DEFAULT (getdate()),
[LanguageLocale] NVARCHAR(10) NULL)
2013-02-26 10:01:51,530 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsContentVersion] ADD CONSTRAINT [PK_cmsContentVersion] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,530 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsContentVersion
2013-02-26 10:01:51,530 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsContentVersion
2013-02-26 10:01:51,532 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsContentVersion] ADD CONSTRAINT [FK_cmsContentVersion_cmsContent_nodeId] FOREIGN KEY ([ContentId]) REFERENCES [cmsContent] ([nodeId])
2013-02-26 10:01:51,534 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsContentVersion_VersionId] ON [cmsContentVersion] ([VersionId])
2013-02-26 10:01:51,536 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsContentVersion' was created
2013-02-26 10:01:51,549 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsDocument] ([nodeId] INTEGER NOT NULL,
[published] BIT NOT NULL,
[documentUser] INTEGER NOT NULL,
[versionId] UniqueIdentifier NOT NULL,
[text] NVARCHAR(255) NOT NULL,
[releaseDate] DATETIME NULL,
[expireDate] DATETIME NULL,
[updateDate] DATETIME NOT NULL CONSTRAINT [DF_cmsDocument_updateDate] DEFAULT (getdate()),
[templateId] INTEGER NULL,
[alias] NVARCHAR(255) NULL,
[newest] BIT NOT NULL CONSTRAINT [DF_cmsDocument_newest] DEFAULT ('0'))
2013-02-26 10:01:51,551 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsDocument] ADD CONSTRAINT [PK_cmsDocument] PRIMARY KEY CLUSTERED ([versionId])
2013-02-26 10:01:51,552 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsDocument
2013-02-26 10:01:51,552 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsDocument
2013-02-26 10:01:51,555 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsDocument] ADD CONSTRAINT [FK_cmsDocument_umbracoNode_id] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,556 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsDocument] ADD CONSTRAINT [FK_cmsDocument_cmsContent_nodeId] FOREIGN KEY ([nodeId]) REFERENCES [cmsContent] ([nodeId])
2013-02-26 10:01:51,560 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsDocument] ADD CONSTRAINT [FK_cmsDocument_cmsTemplate_nodeId] FOREIGN KEY ([templateId]) REFERENCES [cmsTemplate] ([nodeId])
2013-02-26 10:01:51,561 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsDocument] ON [cmsDocument] ([nodeId],[versionId])
2013-02-26 10:01:51,563 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsDocument' was created
2013-02-26 10:01:51,578 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsContentType] ([pk] INTEGER NOT NULL IDENTITY(1,1),
[nodeId] INTEGER NOT NULL,
[alias] NVARCHAR(255) NULL,
[icon] NVARCHAR(255) NULL,
[thumbnail] NVARCHAR(255) NOT NULL CONSTRAINT [DF_cmsContentType_thumbnail] DEFAULT ('folder.png'),
[description] NVARCHAR(1500) NULL,
[isContainer] BIT NOT NULL CONSTRAINT [DF_cmsContentType_isContainer] DEFAULT ('0'),
[allowAtRoot] BIT NOT NULL CONSTRAINT [DF_cmsContentType_allowAtRoot] DEFAULT ('0'))
2013-02-26 10:01:51,580 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsContentType] ADD CONSTRAINT [PK_cmsContentType] PRIMARY KEY CLUSTERED ([pk])
2013-02-26 10:01:51,580 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsContentType
2013-02-26 10:01:51,585 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsContentType
2013-02-26 10:01:51,590 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsContentType] ADD CONSTRAINT [FK_cmsContentType_umbracoNode_id] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,591 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsContentType] ON [cmsContentType] ([nodeId])
2013-02-26 10:01:51,593 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_cmsContentType_icon] ON [cmsContentType] ([icon])
2013-02-26 10:01:51,596 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsContentType' was created
2013-02-26 10:01:51,600 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsDocumentType] ([contentTypeNodeId] INTEGER NOT NULL,
[templateNodeId] INTEGER NOT NULL,
[IsDefault] BIT NOT NULL CONSTRAINT [DF_cmsDocumentType_IsDefault] DEFAULT ('0'))
2013-02-26 10:01:51,602 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsDocumentType] ADD CONSTRAINT [PK_cmsDocumentType] PRIMARY KEY CLUSTERED ([contentTypeNodeId], [templateNodeId])
2013-02-26 10:01:51,602 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsDocumentType
2013-02-26 10:01:51,602 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsDocumentType
2013-02-26 10:01:51,603 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsDocumentType] ADD CONSTRAINT [FK_cmsDocumentType_umbracoNode_id] FOREIGN KEY ([contentTypeNodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,604 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsDocumentType] ADD CONSTRAINT [FK_cmsDocumentType_cmsContentType_nodeId] FOREIGN KEY ([contentTypeNodeId]) REFERENCES [cmsContentType] ([nodeId])
2013-02-26 10:01:51,605 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsDocumentType] ADD CONSTRAINT [FK_cmsDocumentType_cmsTemplate_nodeId] FOREIGN KEY ([templateNodeId]) REFERENCES [cmsTemplate] ([nodeId])
2013-02-26 10:01:51,607 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsDocumentType' was created
2013-02-26 10:01:51,609 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsDataType] ([pk] INTEGER NOT NULL IDENTITY(1,1),
[nodeId] INTEGER NOT NULL,
[controlId] UniqueIdentifier NOT NULL,
[dbType] NVARCHAR(50) NOT NULL)
2013-02-26 10:01:51,611 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsDataType] ADD CONSTRAINT [PK_cmsDataType] PRIMARY KEY CLUSTERED ([pk])
2013-02-26 10:01:51,611 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsDataType
2013-02-26 10:01:51,632 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsDataType
2013-02-26 10:01:51,637 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsDataType] ADD CONSTRAINT [FK_cmsDataType_umbracoNode_id] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,639 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsDataType_nodeId] ON [cmsDataType] ([nodeId])
2013-02-26 10:01:51,641 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsDataType' was created
2013-02-26 10:01:51,641 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsDataTypePreValues] ([id] INTEGER NOT NULL IDENTITY(1,1),
[datatypeNodeId] INTEGER NOT NULL,
[value] NVARCHAR(2500) NULL,
[sortorder] INTEGER NOT NULL,
[alias] NVARCHAR(50) NULL)
2013-02-26 10:01:51,643 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsDataTypePreValues] ADD CONSTRAINT [PK_cmsDataTypePreValues] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,644 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsDataTypePreValues
2013-02-26 10:01:51,647 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsDataTypePreValues
2013-02-26 10:01:51,654 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsDataTypePreValues] ADD CONSTRAINT [FK_cmsDataTypePreValues_cmsDataType_nodeId] FOREIGN KEY ([datatypeNodeId]) REFERENCES [cmsDataType] ([nodeId])
2013-02-26 10:01:51,656 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsDataTypePreValues' was created
2013-02-26 10:01:51,659 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsDictionary] ([pk] INTEGER NOT NULL IDENTITY(1,1),
[id] UniqueIdentifier NOT NULL,
[parent] UniqueIdentifier NOT NULL,
[key] NVARCHAR(1000) NOT NULL)
2013-02-26 10:01:51,662 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsDictionary] ADD CONSTRAINT [PK_cmsDictionary] PRIMARY KEY CLUSTERED ([pk])
2013-02-26 10:01:51,662 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsDictionary
2013-02-26 10:01:51,662 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsDictionary
2013-02-26 10:01:51,663 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsDictionary_id] ON [cmsDictionary] ([id])
2013-02-26 10:01:51,665 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsDictionary' was created
2013-02-26 10:01:51,667 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsLanguageText] ([pk] INTEGER NOT NULL IDENTITY(1,1),
[languageId] INTEGER NOT NULL,
[UniqueId] UniqueIdentifier NOT NULL,
[value] NVARCHAR(1000) NOT NULL)
2013-02-26 10:01:51,669 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsLanguageText] ADD CONSTRAINT [PK_cmsLanguageText] PRIMARY KEY CLUSTERED ([pk])
2013-02-26 10:01:51,669 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsLanguageText
2013-02-26 10:01:51,669 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsLanguageText
2013-02-26 10:01:51,670 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsLanguageText] ADD CONSTRAINT [FK_cmsLanguageText_cmsDictionary_id] FOREIGN KEY ([UniqueId]) REFERENCES [cmsDictionary] ([id])
2013-02-26 10:01:51,672 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsLanguageText' was created
2013-02-26 10:01:51,673 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoLanguage] ([id] INTEGER NOT NULL IDENTITY(1,1),
[languageISOCode] NVARCHAR(10) NULL,
[languageCultureName] NVARCHAR(100) NULL)
2013-02-26 10:01:51,678 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [umbracoLanguage] ADD CONSTRAINT [PK_umbracoLanguage] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,679 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoLanguage
2013-02-26 10:01:51,681 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoLanguage
2013-02-26 10:01:51,683 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE UNIQUE NONCLUSTERED INDEX [IX_umbracoLanguage_languageISOCode] ON [umbracoLanguage] ([languageISOCode])
2013-02-26 10:01:51,686 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoLanguage' was created
2013-02-26 10:01:51,688 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoDomains] ([id] INTEGER NOT NULL IDENTITY(1,1),
[domainDefaultLanguage] INTEGER NULL,
[domainRootStructureID] INTEGER NULL,
[domainName] NVARCHAR(255) NOT NULL)
2013-02-26 10:01:51,690 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [umbracoDomains] ADD CONSTRAINT [PK_umbracoDomains] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,690 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoDomains
2013-02-26 10:01:51,690 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoDomains
2013-02-26 10:01:51,691 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [umbracoDomains] ADD CONSTRAINT [FK_umbracoDomains_umbracoNode_id] FOREIGN KEY ([domainRootStructureID]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,695 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoDomains' was created
2013-02-26 10:01:51,697 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoLog] ([id] INTEGER NOT NULL IDENTITY(1,1),
[userId] INTEGER NOT NULL,
[NodeId] INTEGER NOT NULL,
[Datestamp] DATETIME NOT NULL CONSTRAINT [DF_umbracoLog_Datestamp] DEFAULT (getdate()),
[logHeader] NVARCHAR(50) NOT NULL,
[logComment] NVARCHAR(4000) NULL)
2013-02-26 10:01:51,699 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [umbracoLog] ADD CONSTRAINT [PK_umbracoLog] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,700 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoLog
2013-02-26 10:01:51,700 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoLog
2013-02-26 10:01:51,700 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_umbracoLog] ON [umbracoLog] ([NodeId])
2013-02-26 10:01:51,703 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoLog' was created
2013-02-26 10:01:51,706 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsMacro] ([id] INTEGER NOT NULL IDENTITY(1,1),
[macroUseInEditor] BIT NOT NULL CONSTRAINT [DF_cmsMacro_macroUseInEditor] DEFAULT ('0'),
[macroRefreshRate] INTEGER NOT NULL CONSTRAINT [DF_cmsMacro_macroRefreshRate] DEFAULT ('0'),
[macroAlias] NVARCHAR(255) NOT NULL,
[macroName] NVARCHAR(255) NULL,
[macroScriptType] NVARCHAR(255) NULL,
[macroScriptAssembly] NVARCHAR(255) NULL,
[macroXSLT] NVARCHAR(255) NULL,
[macroCacheByPage] BIT NOT NULL CONSTRAINT [DF_cmsMacro_macroCacheByPage] DEFAULT ('1'),
[macroCachePersonalized] BIT NOT NULL CONSTRAINT [DF_cmsMacro_macroCachePersonalized] DEFAULT ('0'),
[macroDontRender] BIT NOT NULL CONSTRAINT [DF_cmsMacro_macroDontRender] DEFAULT ('0'),
[macroPython] NVARCHAR(255) NULL)
2013-02-26 10:01:51,710 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsMacro] ADD CONSTRAINT [PK_cmsMacro] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,710 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsMacro
2013-02-26 10:01:51,710 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsMacro
2013-02-26 10:01:51,713 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsMacro' was created
2013-02-26 10:01:51,715 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsMacroPropertyType] ([id] INTEGER NOT NULL IDENTITY(1,1),
[macroPropertyTypeAlias] NVARCHAR(50) NULL,
[macroPropertyTypeRenderAssembly] NVARCHAR(255) NULL,
[macroPropertyTypeRenderType] NVARCHAR(255) NULL,
[macroPropertyTypeBaseType] NVARCHAR(255) NULL)
2013-02-26 10:01:51,717 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsMacroPropertyType] ADD CONSTRAINT [PK_cmsMacroPropertyType] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,717 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsMacroPropertyType
2013-02-26 10:01:51,731 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsMacroPropertyType
2013-02-26 10:01:51,733 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsMacroPropertyType' was created
2013-02-26 10:01:51,737 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsMacroProperty] ([id] INTEGER NOT NULL IDENTITY(1,1),
[macroPropertyHidden] BIT NOT NULL CONSTRAINT [DF_cmsMacroProperty_macroPropertyHidden] DEFAULT ('0'),
[macroPropertyType] INTEGER NOT NULL,
[macro] INTEGER NOT NULL,
[macroPropertySortOrder] INTEGER NOT NULL CONSTRAINT [DF_cmsMacroProperty_macroPropertySortOrder] DEFAULT ('0'),
[macroPropertyAlias] NVARCHAR(50) NOT NULL,
[macroPropertyName] NVARCHAR(255) NOT NULL)
2013-02-26 10:01:51,739 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsMacroProperty] ADD CONSTRAINT [PK_cmsMacroProperty] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,740 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsMacroProperty
2013-02-26 10:01:51,740 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsMacroProperty
2013-02-26 10:01:51,741 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsMacroProperty] ADD CONSTRAINT [FK_cmsMacroProperty_cmsMacroPropertyType_id] FOREIGN KEY ([macroPropertyType]) REFERENCES [cmsMacroPropertyType] ([id])
2013-02-26 10:01:51,743 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsMacroProperty] ADD CONSTRAINT [FK_cmsMacroProperty_cmsMacro_id] FOREIGN KEY ([macro]) REFERENCES [cmsMacro] ([id])
2013-02-26 10:01:51,745 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsMacroProperty' was created
2013-02-26 10:01:51,763 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsMemberType] ([pk] INTEGER NOT NULL IDENTITY(1,1),
[NodeId] INTEGER NOT NULL,
[propertytypeId] INTEGER NOT NULL,
[memberCanEdit] BIT NOT NULL CONSTRAINT [DF_cmsMemberType_memberCanEdit] DEFAULT ('0'),
[viewOnProfile] BIT NOT NULL CONSTRAINT [DF_cmsMemberType_viewOnProfile] DEFAULT ('0'))
2013-02-26 10:01:51,766 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsMemberType] ADD CONSTRAINT [PK_cmsMemberType] PRIMARY KEY CLUSTERED ([pk])
2013-02-26 10:01:51,766 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsMemberType
2013-02-26 10:01:51,766 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsMemberType
2013-02-26 10:01:51,767 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsMemberType] ADD CONSTRAINT [FK_cmsMemberType_umbracoNode_id] FOREIGN KEY ([NodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,768 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsMemberType] ADD CONSTRAINT [FK_cmsMemberType_cmsContentType_nodeId] FOREIGN KEY ([NodeId]) REFERENCES [cmsContentType] ([nodeId])
2013-02-26 10:01:51,770 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsMemberType' was created
2013-02-26 10:01:51,773 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsMember] ([nodeId] INTEGER NOT NULL,
[Email] NVARCHAR(1000) NOT NULL CONSTRAINT [DF_cmsMember_Email] DEFAULT (''''),
[LoginName] NVARCHAR(1000) NOT NULL CONSTRAINT [DF_cmsMember_LoginName] DEFAULT (''''),
[Password] NVARCHAR(1000) NOT NULL CONSTRAINT [DF_cmsMember_Password] DEFAULT (''''))
2013-02-26 10:01:51,775 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsMember] ADD CONSTRAINT [PK_cmsMember] PRIMARY KEY CLUSTERED ([nodeId])
2013-02-26 10:01:51,775 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsMember
2013-02-26 10:01:51,775 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsMember
2013-02-26 10:01:51,779 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsMember] ADD CONSTRAINT [FK_cmsMember_umbracoNode_id] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,780 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsMember] ADD CONSTRAINT [FK_cmsMember_cmsContent_nodeId] FOREIGN KEY ([nodeId]) REFERENCES [cmsContent] ([nodeId])
2013-02-26 10:01:51,782 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsMember' was created
2013-02-26 10:01:51,784 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsMember2MemberGroup] ([Member] INTEGER NOT NULL,
[MemberGroup] INTEGER NOT NULL)
2013-02-26 10:01:51,786 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsMember2MemberGroup] ADD CONSTRAINT [PK_cmsMember2MemberGroup] PRIMARY KEY CLUSTERED ([Member], [MemberGroup])
2013-02-26 10:01:51,786 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsMember2MemberGroup
2013-02-26 10:01:51,786 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsMember2MemberGroup
2013-02-26 10:01:51,787 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsMember2MemberGroup] ADD CONSTRAINT [FK_cmsMember2MemberGroup_cmsMember_nodeId] FOREIGN KEY ([Member]) REFERENCES [cmsMember] ([nodeId])
2013-02-26 10:01:51,788 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsMember2MemberGroup] ADD CONSTRAINT [FK_cmsMember2MemberGroup_umbracoNode_id] FOREIGN KEY ([MemberGroup]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,790 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsMember2MemberGroup' was created
2013-02-26 10:01:51,792 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsContentXml] ([nodeId] INTEGER NOT NULL,
[xml] NTEXT NOT NULL)
2013-02-26 10:01:51,795 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsContentXml] ADD CONSTRAINT [PK_cmsContentXml] PRIMARY KEY CLUSTERED ([nodeId])
2013-02-26 10:01:51,795 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsContentXml
2013-02-26 10:01:51,795 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsContentXml
2013-02-26 10:01:51,796 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsContentXml] ADD CONSTRAINT [FK_cmsContentXml_cmsContent_nodeId] FOREIGN KEY ([nodeId]) REFERENCES [cmsContent] ([nodeId])
2013-02-26 10:01:51,798 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsContentXml' was created
2013-02-26 10:01:51,800 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsPreviewXml] ([nodeId] INTEGER NOT NULL,
[versionId] UniqueIdentifier NOT NULL,
[timestamp] DATETIME NOT NULL,
[xml] NTEXT NOT NULL)
2013-02-26 10:01:51,802 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsPreviewXml] ADD CONSTRAINT [PK_cmsPreviewXml] PRIMARY KEY CLUSTERED ([nodeId], [versionId])
2013-02-26 10:01:51,802 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsPreviewXml
2013-02-26 10:01:51,802 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsPreviewXml
2013-02-26 10:01:51,803 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsPreviewXml] ADD CONSTRAINT [FK_cmsPreviewXml_cmsContent_nodeId] FOREIGN KEY ([nodeId]) REFERENCES [cmsContent] ([nodeId])
2013-02-26 10:01:51,804 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsPreviewXml] ADD CONSTRAINT [FK_cmsPreviewXml_cmsContentVersion_VersionId] FOREIGN KEY ([versionId]) REFERENCES [cmsContentVersion] ([VersionId])
2013-02-26 10:01:51,806 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsPreviewXml' was created
2013-02-26 10:01:51,808 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsPropertyTypeGroup] ([id] INTEGER NOT NULL IDENTITY(1,1),
[parentGroupId] INTEGER NULL,
[contenttypeNodeId] INTEGER NOT NULL,
[text] NVARCHAR(255) NOT NULL,
[sortorder] INTEGER NOT NULL)
2013-02-26 10:01:51,809 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsPropertyTypeGroup] ADD CONSTRAINT [PK_cmsPropertyTypeGroup] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,809 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsPropertyTypeGroup
2013-02-26 10:01:51,814 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsPropertyTypeGroup
2013-02-26 10:01:51,818 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsPropertyTypeGroup] ADD CONSTRAINT [FK_cmsPropertyTypeGroup_cmsPropertyTypeGroup_id] FOREIGN KEY ([parentGroupId]) REFERENCES [cmsPropertyTypeGroup] ([id])
2013-02-26 10:01:51,822 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsPropertyTypeGroup] ADD CONSTRAINT [FK_cmsPropertyTypeGroup_cmsContentType_nodeId] FOREIGN KEY ([contenttypeNodeId]) REFERENCES [cmsContentType] ([nodeId])
2013-02-26 10:01:51,824 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsPropertyTypeGroup' was created
2013-02-26 10:01:51,827 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsPropertyType] ([id] INTEGER NOT NULL IDENTITY(1,1),
[dataTypeId] INTEGER NOT NULL,
[contentTypeId] INTEGER NOT NULL,
[propertyTypeGroupId] INTEGER NULL,
[Alias] NVARCHAR(255) NOT NULL,
[Name] NVARCHAR(255) NULL,
[helpText] NVARCHAR(1000) NULL,
[sortOrder] INTEGER NOT NULL CONSTRAINT [DF_cmsPropertyType_sortOrder] DEFAULT ('0'),
[mandatory] BIT NOT NULL CONSTRAINT [DF_cmsPropertyType_mandatory] DEFAULT ('0'),
[validationRegExp] NVARCHAR(255) NULL,
[Description] NVARCHAR(2000) NULL)
2013-02-26 10:01:51,832 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsPropertyType] ADD CONSTRAINT [PK_cmsPropertyType] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,832 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsPropertyType
2013-02-26 10:01:51,845 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsPropertyType
2013-02-26 10:01:51,861 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsPropertyType] ADD CONSTRAINT [FK_cmsPropertyType_cmsDataType_nodeId] FOREIGN KEY ([dataTypeId]) REFERENCES [cmsDataType] ([nodeId])
2013-02-26 10:01:51,864 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsPropertyType] ADD CONSTRAINT [FK_cmsPropertyType_cmsContentType_nodeId] FOREIGN KEY ([contentTypeId]) REFERENCES [cmsContentType] ([nodeId])
2013-02-26 10:01:51,867 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsPropertyType] ADD CONSTRAINT [FK_cmsPropertyType_cmsPropertyTypeGroup_id] FOREIGN KEY ([propertyTypeGroupId]) REFERENCES [cmsPropertyTypeGroup] ([id])
2013-02-26 10:01:51,870 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsPropertyType' was created
2013-02-26 10:01:51,872 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsPropertyData] ([id] INTEGER NOT NULL IDENTITY(1,1),
[contentNodeId] INTEGER NOT NULL,
[versionId] UniqueIdentifier NULL,
[propertytypeid] INTEGER NOT NULL,
[dataInt] INTEGER NULL,
[dataDate] DATETIME NULL,
[dataNvarchar] NVARCHAR(500) NULL,
[dataNtext] NTEXT NULL)
2013-02-26 10:01:51,875 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsPropertyData] ADD CONSTRAINT [PK_cmsPropertyData] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,875 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsPropertyData
2013-02-26 10:01:51,875 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsPropertyData
2013-02-26 10:01:51,876 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsPropertyData] ADD CONSTRAINT [FK_cmsPropertyData_umbracoNode_id] FOREIGN KEY ([contentNodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,877 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsPropertyData] ADD CONSTRAINT [FK_cmsPropertyData_cmsPropertyType_id] FOREIGN KEY ([propertytypeid]) REFERENCES [cmsPropertyType] ([id])
2013-02-26 10:01:51,878 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_cmsPropertyData] ON [cmsPropertyData] ([id])
2013-02-26 10:01:51,879 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_cmsPropertyData_1] ON [cmsPropertyData] ([contentNodeId])
2013-02-26 10:01:51,880 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_cmsPropertyData_2] ON [cmsPropertyData] ([versionId])
2013-02-26 10:01:51,880 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_cmsPropertyData_3] ON [cmsPropertyData] ([propertytypeid])
2013-02-26 10:01:51,883 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsPropertyData' was created
2013-02-26 10:01:51,885 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoRelationType] ([id] INTEGER NOT NULL IDENTITY(1,1),
[dual] BIT NOT NULL,
[parentObjectType] UniqueIdentifier NOT NULL,
[childObjectType] UniqueIdentifier NOT NULL,
[name] NVARCHAR(255) NOT NULL,
[alias] NVARCHAR(100) NULL)
2013-02-26 10:01:51,887 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [umbracoRelationType] ADD CONSTRAINT [PK_umbracoRelationType] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,887 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoRelationType
2013-02-26 10:01:51,890 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoRelationType
2013-02-26 10:01:51,892 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoRelationType' was created
2013-02-26 10:01:51,894 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoRelation] ([id] INTEGER NOT NULL IDENTITY(1,1),
[parentId] INTEGER NOT NULL,
[childId] INTEGER NOT NULL,
[relType] INTEGER NOT NULL,
[datetime] DATETIME NOT NULL CONSTRAINT [DF_umbracoRelation_datetime] DEFAULT (getdate()),
[comment] NVARCHAR(1000) NOT NULL)
2013-02-26 10:01:51,896 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [umbracoRelation] ADD CONSTRAINT [PK_umbracoRelation] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,897 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoRelation
2013-02-26 10:01:51,897 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoRelation
2013-02-26 10:01:51,898 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [umbracoRelation] ADD CONSTRAINT [FK_umbracoRelation_umbracoNode] FOREIGN KEY ([parentId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,899 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [umbracoRelation] ADD CONSTRAINT [FK_umbracoRelation_umbracoNode1] FOREIGN KEY ([childId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,900 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [umbracoRelation] ADD CONSTRAINT [FK_umbracoRelation_umbracoRelationType_id] FOREIGN KEY ([relType]) REFERENCES [umbracoRelationType] ([id])
2013-02-26 10:01:51,903 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoRelation' was created
2013-02-26 10:01:51,916 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsStylesheet] ([nodeId] INTEGER NOT NULL,
[filename] NVARCHAR(100) NOT NULL,
[content] NTEXT NULL)
2013-02-26 10:01:51,918 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsStylesheet] ADD CONSTRAINT [PK_cmsStylesheet] PRIMARY KEY CLUSTERED ([nodeId])
2013-02-26 10:01:51,918 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsStylesheet
2013-02-26 10:01:51,918 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsStylesheet
2013-02-26 10:01:51,919 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsStylesheet] ADD CONSTRAINT [FK_cmsStylesheet_umbracoNode_id] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,921 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsStylesheet' was created
2013-02-26 10:01:51,923 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsStylesheetProperty] ([nodeId] INTEGER NOT NULL,
[stylesheetPropertyEditor] BIT NULL,
[stylesheetPropertyAlias] NVARCHAR(50) NULL,
[stylesheetPropertyValue] NVARCHAR(400) NULL)
2013-02-26 10:01:51,927 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsStylesheetProperty] ADD CONSTRAINT [PK_cmsStylesheetProperty] PRIMARY KEY CLUSTERED ([nodeId])
2013-02-26 10:01:51,927 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsStylesheetProperty
2013-02-26 10:01:51,927 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsStylesheetProperty
2013-02-26 10:01:51,928 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsStylesheetProperty' was created
2013-02-26 10:01:51,930 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsTags] ([id] INTEGER NOT NULL IDENTITY(1,1),
[tag] NVARCHAR(200) NULL,
[ParentId] INTEGER NULL,
[group] NVARCHAR(100) NULL)
2013-02-26 10:01:51,932 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsTags] ADD CONSTRAINT [PK_cmsTags] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,932 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsTags
2013-02-26 10:01:51,932 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsTags
2013-02-26 10:01:51,933 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsTags' was created
2013-02-26 10:01:51,934 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsTagRelationship] ([nodeId] INTEGER NOT NULL,
[tagId] INTEGER NOT NULL)
2013-02-26 10:01:51,936 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsTagRelationship] ADD CONSTRAINT [PK_cmsTagRelationship] PRIMARY KEY CLUSTERED ([nodeId], [tagId])
2013-02-26 10:01:51,936 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsTagRelationship
2013-02-26 10:01:51,936 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsTagRelationship
2013-02-26 10:01:51,937 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsTagRelationship] ADD CONSTRAINT [FK_cmsTagRelationship_umbracoNode_id] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,938 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsTagRelationship] ADD CONSTRAINT [FK_cmsTagRelationship_cmsTags_id] FOREIGN KEY ([tagId]) REFERENCES [cmsTags] ([id])
2013-02-26 10:01:51,939 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsTagRelationship' was created
2013-02-26 10:01:51,941 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoUserLogins] ([contextID] UniqueIdentifier NOT NULL,
[userID] INTEGER NOT NULL,
[timeout] BIGINT NOT NULL)
2013-02-26 10:01:51,941 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoUserLogins
2013-02-26 10:01:51,941 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoUserLogins
2013-02-26 10:01:51,942 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE CLUSTERED INDEX [umbracoUserLogins_Index] ON [umbracoUserLogins] ([contextID])
2013-02-26 10:01:51,944 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoUserLogins' was created
2013-02-26 10:01:51,946 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoUserType] ([id] INTEGER NOT NULL IDENTITY(1,1),
[userTypeAlias] NVARCHAR(50) NULL,
[userTypeName] NVARCHAR(255) NOT NULL,
[userTypeDefaultPermissions] NVARCHAR(50) NULL)
2013-02-26 10:01:51,948 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [umbracoUserType] ADD CONSTRAINT [PK_umbracoUserType] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,948 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoUserType
2013-02-26 10:01:51,952 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoUserType
2013-02-26 10:01:51,954 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoUserType' was created
2013-02-26 10:01:51,957 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoUser] ([id] INTEGER NOT NULL IDENTITY(1,1),
[userDisabled] BIT NOT NULL CONSTRAINT [DF_umbracoUser_userDisabled] DEFAULT ('0'),
[userNoConsole] BIT NOT NULL CONSTRAINT [DF_umbracoUser_userNoConsole] DEFAULT ('0'),
[userType] INTEGER NOT NULL,
[startStructureID] INTEGER NOT NULL,
[startMediaID] INTEGER NULL,
[userName] NVARCHAR(255) NOT NULL,
[userLogin] NVARCHAR(125) NOT NULL,
[userPassword] NVARCHAR(125) NOT NULL,
[userEmail] NVARCHAR(255) NOT NULL,
[userDefaultPermissions] NVARCHAR(50) NULL,
[userLanguage] NVARCHAR(10) NULL,
[defaultToLiveEditing] BIT NOT NULL CONSTRAINT [DF_umbracoUser_defaultToLiveEditing] DEFAULT ('0'))
2013-02-26 10:01:51,959 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [umbracoUser] ADD CONSTRAINT [PK_user] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,959 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoUser
2013-02-26 10:01:51,963 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoUser
2013-02-26 10:01:51,968 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [umbracoUser] ADD CONSTRAINT [FK_umbracoUser_umbracoUserType_id] FOREIGN KEY ([userType]) REFERENCES [umbracoUserType] ([id])
2013-02-26 10:01:51,970 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_umbracoUser_userLogin] ON [umbracoUser] ([userLogin])
2013-02-26 10:01:51,973 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoUser' was created
2013-02-26 10:01:51,975 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsTaskType] ([id] INTEGER NOT NULL IDENTITY(1,1),
[alias] NVARCHAR(255) NOT NULL)
2013-02-26 10:01:51,976 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsTaskType] ADD CONSTRAINT [PK_cmsTaskType] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,976 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsTaskType
2013-02-26 10:01:51,978 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsTaskType
2013-02-26 10:01:51,980 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Index sql -1:
CREATE NONCLUSTERED INDEX [IX_cmsTaskType_alias] ON [cmsTaskType] ([alias])
2013-02-26 10:01:51,982 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsTaskType' was created
2013-02-26 10:01:51,986 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsTask] ([closed] BIT NOT NULL CONSTRAINT [DF_cmsTask_closed] DEFAULT ('0'),
[id] INTEGER NOT NULL IDENTITY(1,1),
[taskTypeId] INTEGER NOT NULL,
[nodeId] INTEGER NOT NULL,
[parentUserId] INTEGER NOT NULL,
[userId] INTEGER NOT NULL,
[DateTime] DATETIME NOT NULL CONSTRAINT [DF_cmsTask_DateTime] DEFAULT (getdate()),
[Comment] NVARCHAR(500) NULL)
2013-02-26 10:01:51,988 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsTask] ADD CONSTRAINT [PK_cmsTask] PRIMARY KEY CLUSTERED ([id])
2013-02-26 10:01:51,988 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsTask
2013-02-26 10:01:51,988 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsTask
2013-02-26 10:01:51,990 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsTask] ADD CONSTRAINT [FK_cmsTask_cmsTaskType_id] FOREIGN KEY ([taskTypeId]) REFERENCES [cmsTaskType] ([id])
2013-02-26 10:01:51,991 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsTask] ADD CONSTRAINT [FK_cmsTask_umbracoNode_id] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:51,992 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsTask] ADD CONSTRAINT [FK_cmsTask_umbracoUser] FOREIGN KEY ([parentUserId]) REFERENCES [umbracoUser] ([id])
2013-02-26 10:01:51,993 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsTask] ADD CONSTRAINT [FK_cmsTask_umbracoUser1] FOREIGN KEY ([userId]) REFERENCES [umbracoUser] ([id])
2013-02-26 10:01:51,995 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsTask' was created
2013-02-26 10:01:51,997 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsContentType2ContentType] ([parentContentTypeId] INTEGER NOT NULL,
[childContentTypeId] INTEGER NOT NULL)
2013-02-26 10:01:51,999 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsContentType2ContentType] ADD CONSTRAINT [PK_cmsContentType2ContentType] PRIMARY KEY CLUSTERED ([parentContentTypeId], [childContentTypeId])
2013-02-26 10:01:51,999 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsContentType2ContentType
2013-02-26 10:01:51,999 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsContentType2ContentType
2013-02-26 10:01:52,000 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsContentType2ContentType] ADD CONSTRAINT [FK_cmsContentType2ContentType_umbracoNode_parent] FOREIGN KEY ([parentContentTypeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:52,001 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsContentType2ContentType] ADD CONSTRAINT [FK_cmsContentType2ContentType_umbracoNode_child] FOREIGN KEY ([childContentTypeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:52,002 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsContentType2ContentType' was created
2013-02-26 10:01:52,004 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [cmsContentTypeAllowedContentType] ([Id] INTEGER NOT NULL,
[AllowedId] INTEGER NOT NULL,
[SortOrder] INTEGER NOT NULL CONSTRAINT df_cmsContentTypeAllowedContentType_sortOrder DEFAULT ('0'))
2013-02-26 10:01:52,006 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [cmsContentTypeAllowedContentType] ADD CONSTRAINT [PK_cmsContentTypeAllowedContentType] PRIMARY KEY CLUSTERED ([Id], [AllowedId])
2013-02-26 10:01:52,006 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table cmsContentTypeAllowedContentType
2013-02-26 10:01:52,009 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table cmsContentTypeAllowedContentType
2013-02-26 10:01:52,013 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsContentTypeAllowedContentType] ADD CONSTRAINT [FK_cmsContentTypeAllowedContentType_cmsContentType] FOREIGN KEY ([Id]) REFERENCES [cmsContentType] ([nodeId])
2013-02-26 10:01:52,016 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [cmsContentTypeAllowedContentType] ADD CONSTRAINT [FK_cmsContentTypeAllowedContentType_cmsContentType1] FOREIGN KEY ([AllowedId]) REFERENCES [cmsContentType] ([nodeId])
2013-02-26 10:01:52,017 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'cmsContentTypeAllowedContentType' was created
2013-02-26 10:01:52,019 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoUser2app] ([user] INTEGER NOT NULL,
[app] NVARCHAR(50) NOT NULL)
2013-02-26 10:01:52,021 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [umbracoUser2app] ADD CONSTRAINT [PK_user2app] PRIMARY KEY CLUSTERED ([user], [app])
2013-02-26 10:01:52,021 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoUser2app
2013-02-26 10:01:52,025 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoUser2app
2013-02-26 10:01:52,029 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [umbracoUser2app] ADD CONSTRAINT [FK_umbracoUser2app_umbracoUser_id] FOREIGN KEY ([user]) REFERENCES [umbracoUser] ([id])
2013-02-26 10:01:52,031 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoUser2app' was created
2013-02-26 10:01:52,033 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoUser2NodeNotify] ([userId] INTEGER NOT NULL,
[nodeId] INTEGER NOT NULL,
[action] NCHAR(1) NOT NULL)
2013-02-26 10:01:52,035 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [umbracoUser2NodeNotify] ADD CONSTRAINT [PK_umbracoUser2NodeNotify] PRIMARY KEY CLUSTERED ([userId], [nodeId], [action])
2013-02-26 10:01:52,035 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoUser2NodeNotify
2013-02-26 10:01:52,035 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoUser2NodeNotify
2013-02-26 10:01:52,038 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [umbracoUser2NodeNotify] ADD CONSTRAINT [FK_umbracoUser2NodeNotify_umbracoUser_id] FOREIGN KEY ([userId]) REFERENCES [umbracoUser] ([id])
2013-02-26 10:01:52,039 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [umbracoUser2NodeNotify] ADD CONSTRAINT [FK_umbracoUser2NodeNotify_umbracoNode_id] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:52,041 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoUser2NodeNotify' was created
2013-02-26 10:01:52,043 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Table sql -1:
CREATE TABLE [umbracoUser2NodePermission] ([userId] INTEGER NOT NULL,
[nodeId] INTEGER NOT NULL,
[permission] NVARCHAR(255) NOT NULL)
2013-02-26 10:01:52,045 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Primary Key sql -1:
ALTER TABLE [umbracoUser2NodePermission] ADD CONSTRAINT [PK_umbracoUser2NodePermission] PRIMARY KEY CLUSTERED ([userId], [nodeId], [permission])
2013-02-26 10:01:52,045 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Creating data in table umbracoUser2NodePermission
2013-02-26 10:01:52,045 [15] INFO Umbraco.Core.Persistence.Migrations.Initial.BaseDataCreation - [Thread 5] Done creating data in table umbracoUser2NodePermission
2013-02-26 10:01:52,046 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [umbracoUser2NodePermission] ADD CONSTRAINT [FK_umbracoUser2NodePermission_umbracoUser_id] FOREIGN KEY ([userId]) REFERENCES [umbracoUser] ([id])
2013-02-26 10:01:52,047 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] Create Foreign Key sql -1:
ALTER TABLE [umbracoUser2NodePermission] ADD CONSTRAINT [FK_umbracoUser2NodePermission_umbracoNode_id] FOREIGN KEY ([nodeId]) REFERENCES [umbracoNode] ([id])
2013-02-26 10:01:52,049 [15] INFO Umbraco.Core.Persistence.Database - [Thread 5] New table 'umbracoUser2NodePermission' was created
2013-02-26 10:01:52,077 [15] INFO umbraco.BusinessLogic.Log - [Thread 7] Log scrubbed. Removed all items older than 2012-12-28 10:01:52
2013-02-26 10:01:52,081 [15] INFO Umbraco.Core.UmbracoApplicationBase - [Thread 7] Application shutdown. Reason: ConfigurationChange
2013-02-26 10:02:18,022 [31] INFO Umbraco.Core.CoreBootManager - [Thread 1] Umbraco application starting
2013-02-26 10:02:18,080 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Determining hash of code files on disk
2013-02-26 10:02:18,084 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Hash determined (took 3ms)
2013-02-26 10:02:18,086 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 13 (took 2ms)
2013-02-26 10:02:18,101 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.ICacheRefresher, found 5 (took 1ms)
2013-02-26 10:02:18,106 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IDataType, found 35 (took 3ms)
2013-02-26 10:02:18,109 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IMacroGuiRendering, found 13 (took 2ms)
2013-02-26 10:02:18,111 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IPackageAction, found 12 (took 1ms)
2013-02-26 10:02:18,114 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IAction, found 35 (took 2ms)
2013-02-26 10:02:18,114 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Models.IMacroPropertyType, found 0 (took 0ms)
2013-02-26 10:02:18,115 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 0ms)
2013-02-26 10:02:18,116 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 0ms)
2013-02-26 10:02:18,136 [31] INFO umbraco.content - [Thread 1] Loading content from database...
2013-02-26 10:02:18,265 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 3 (took 0ms)
2013-02-26 10:02:18,266 [31] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 1 (took 0ms)
2013-02-26 10:02:18,643 [31] INFO Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:18,643 [31] INFO Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:18,644 [31] INFO Umbraco.Core.CoreBootManager - [Thread 1] Umbraco application startup complete (took 621ms)
2013-02-26 10:02:18,644 [31] INFO Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:18,651 [31] INFO umbraco.BusinessLogic.Log - [Thread 18] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] Adding examine event handlers for index providers: 3
2013-02-26 10:02:27,310 [31] INFO umbraco.BasePages.BasePage - [Thread 5] User Administrator (Id: 0) logged in
2013-02-26 10:02:45,331 [31] INFO Umbraco.Core.ApplicationContext - [Thread 5] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:45,955 [31] INFO umbraco.presentation.install.utills.p - [Thread 24] Hitting Page_Load on p.aspx for the requested 'progress' feed
2013-02-26 10:02:47,496 [31] INFO Umbraco.Core.ApplicationContext - [Thread 18] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:47,874 [31] INFO Umbraco.Core.ApplicationContext - [Thread 28] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:47,896 [31] INFO umbraco.BusinessLogic.Log - [Thread 5] Log scrubbed. Removed all items older than 2012-12-28 10:02:47
2013-02-26 10:02:47,899 [31] INFO Umbraco.Core.UmbracoApplicationBase - [Thread 5] Application shutdown. Reason: ConfigurationChange
2013-02-26 10:02:48,628 [30] INFO Umbraco.Core.CoreBootManager - [Thread 1] Umbraco application starting
2013-02-26 10:02:48,743 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Determining hash of code files on disk
2013-02-26 10:02:48,747 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Hash determined (took 3ms)
2013-02-26 10:02:48,750 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 13 (took 2ms)
2013-02-26 10:02:48,764 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.ICacheRefresher, found 5 (took 1ms)
2013-02-26 10:02:48,769 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IDataType, found 35 (took 3ms)
2013-02-26 10:02:48,772 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IMacroGuiRendering, found 13 (took 2ms)
2013-02-26 10:02:48,774 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IPackageAction, found 12 (took 1ms)
2013-02-26 10:02:48,777 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IAction, found 35 (took 3ms)
2013-02-26 10:02:48,778 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Models.IMacroPropertyType, found 0 (took 0ms)
2013-02-26 10:02:48,780 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 0ms)
2013-02-26 10:02:48,781 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 0ms)
2013-02-26 10:02:48,809 [30] INFO umbraco.content - [Thread 1] Loading content from disk cache...
2013-02-26 10:02:48,815 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 3 (took 1ms)
2013-02-26 10:02:48,816 [30] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 1 (took 0ms)
2013-02-26 10:02:49,048 [30] INFO Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:49,051 [30] INFO Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:49,072 [30] INFO umbraco.BusinessLogic.Log - [Thread 18] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] Adding examine event handlers for index providers: 3
2013-02-26 10:02:49,081 [30] INFO Umbraco.Core.CoreBootManager - [Thread 1] Umbraco application startup complete (took 452ms)
2013-02-26 10:02:49,085 [30] INFO Umbraco.Core.ApplicationContext - [Thread 1] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:49,201 [30] INFO Umbraco.Core.ApplicationContext - [Thread 5] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:49,527 [30] INFO Umbraco.Core.ApplicationContext - [Thread 18] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:51,556 [30] INFO Umbraco.Core.PluginManager - [Thread 18] Completed resolution of types of umbraco.interfaces.ITree, found 36 (took 70ms)
2013-02-26 10:02:51,665 [30] INFO umbraco.cms.businesslogic.web.Document - [Thread 18] New document 1050
2013-02-26 10:02:51,672 [30] INFO Umbraco.Core.PluginManager - [Thread 18] Completed resolution of types of umbraco.BusinessLogic.Actions.IActionHandler, found 1 (took 2ms)
2013-02-26 10:02:52,067 [30] INFO umbraco.cms.businesslogic.web.Document - [Thread 18] New document 1051
2013-02-26 10:02:52,204 [30] INFO umbraco.cms.businesslogic.web.Document - [Thread 18] New document 1052
2013-02-26 10:02:52,313 [30] INFO umbraco.cms.businesslogic.web.Document - [Thread 18] New document 1053
2013-02-26 10:02:52,498 [30] INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 18] Content 'Simple website' with Id '1050' has been published.
2013-02-26 10:02:52,498 [30] INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 18] Content 'Installing modules' with Id '1051' has been published.
2013-02-26 10:02:52,498 [30] INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 18] Content 'Go further' with Id '1052' has been published.
2013-02-26 10:02:52,498 [30] INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 18] Content 'Getting started' with Id '1053' has been published.
2013-02-26 10:02:52,565 [30] INFO Umbraco.Core.ApplicationContext - [Thread 18] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:52,565 [30] INFO Umbraco.Core.ApplicationContext - [Thread 18] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:52,585 [30] INFO Umbraco.Core.ApplicationContext - [Thread 28] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:02:52,603 [30] INFO umbraco.content - [Thread 7] Loading content from database...
2013-02-26 10:03:13,060 [30] INFO Umbraco.Core.ApplicationContext - [Thread 23] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:03:13,060 [30] INFO Umbraco.Core.ApplicationContext - [Thread 23] CurrentVersion different from configStatus: '6.0.0',''
2013-02-26 10:03:13,093 [30] INFO umbraco.content - [Thread 28] Loading content from database...
2013-02-26 10:03:13,616 [30] INFO umbraco.BusinessLogic.Log - [Thread 43] Log scrubbed. Removed all items older than 2012-12-28 10:03:13
2013-02-26 10:03:13,619 [30] INFO Umbraco.Core.UmbracoApplicationBase - [Thread 43] Application shutdown. Reason: ConfigurationChange
2013-02-26 10:03:13,974 [15] INFO Umbraco.Core.CoreBootManager - [Thread 1] Umbraco application starting
2013-02-26 10:03:14,077 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Determining hash of code files on disk
2013-02-26 10:03:14,082 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Hash determined (took 4ms)
2013-02-26 10:03:14,084 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 13 (took 2ms)
2013-02-26 10:03:14,096 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.ICacheRefresher, found 5 (took 0ms)
2013-02-26 10:03:14,099 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IDataType, found 35 (took 3ms)
2013-02-26 10:03:14,102 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IMacroGuiRendering, found 13 (took 2ms)
2013-02-26 10:03:14,103 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IPackageAction, found 12 (took 1ms)
2013-02-26 10:03:14,106 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IAction, found 35 (took 2ms)
2013-02-26 10:03:14,107 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Models.IMacroPropertyType, found 0 (took 0ms)
2013-02-26 10:03:14,108 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 0ms)
2013-02-26 10:03:14,108 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 0ms)
2013-02-26 10:03:14,118 [15] INFO umbraco.content - [Thread 1] Loading content from disk cache...
2013-02-26 10:03:14,123 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 3 (took 0ms)
2013-02-26 10:03:14,124 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 1 (took 0ms)
2013-02-26 10:03:14,347 [15] INFO umbraco.BusinessLogic.Log - [Thread 44] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] Adding examine event handlers for index providers: 3
2013-02-26 10:03:14,422 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.IApplication, found 7 (took 78ms)
2013-02-26 10:03:14,470 [15] INFO Umbraco.Core.PluginManager - [Thread 1] Completed resolution of types of umbraco.interfaces.ITree, found 27 (took 4ms)
2013-02-26 10:03:14,524 [15] INFO Umbraco.Core.CoreBootManager - [Thread 1] Umbraco application startup complete (took 549ms)
2013-02-26 10:03:15,401 [15] INFO Umbraco.Core.Configuration.ClientDependencyConfiguration - [Thread 18] Updated version number from 1 to 2
2013-02-26 10:03:15,669 [15] INFO umbraco.BusinessLogic.Log - [Thread 28] Log scrubbed. Removed all items older than 2012-12-28 10:03:15
2013-02-26 10:03:15,673 [15] INFO Umbraco.Core.UmbracoApplicationBase - [Thread 28] Application shutdown. Reason: ConfigurationChange
2013-02-26 10:03:15,883 [30] INFO Umbraco.Core.CoreBootManager - [Thread 17] Umbraco application starting
2013-02-26 10:03:15,955 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Determining hash of code files on disk
2013-02-26 10:03:15,960 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Hash determined (took 5ms)
2013-02-26 10:03:16,059 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of umbraco.interfaces.IApplicationStartupHandler, found 13 (took 96ms)
2013-02-26 10:03:16,071 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of umbraco.interfaces.ICacheRefresher, found 5 (took 2ms)
2013-02-26 10:03:16,072 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of umbraco.interfaces.IDataType, found 35 (took 2ms)
2013-02-26 10:03:16,075 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of umbraco.interfaces.IMacroGuiRendering, found 13 (took 2ms)
2013-02-26 10:03:16,078 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of umbraco.interfaces.IPackageAction, found 12 (took 2ms)
2013-02-26 10:03:16,080 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of umbraco.interfaces.IAction, found 35 (took 2ms)
2013-02-26 10:03:16,083 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of Umbraco.Core.Models.IMacroPropertyType, found 0 (took 2ms)
2013-02-26 10:03:16,085 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of Umbraco.Core.PropertyEditors.IPropertyEditorValueConverter, found 0 (took 2ms)
2013-02-26 10:03:16,088 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of Umbraco.Web.Mvc.SurfaceController, found 0 (took 2ms)
2013-02-26 10:03:16,100 [30] INFO umbraco.content - [Thread 17] Loading content from disk cache...
2013-02-26 10:03:16,107 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of Umbraco.Core.Media.IThumbnailProvider, found 3 (took 3ms)
2013-02-26 10:03:16,110 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of Umbraco.Core.Media.IImageUrlProvider, found 1 (took 2ms)
2013-02-26 10:03:16,362 [30] INFO umbraco.BusinessLogic.Log - [Thread 39] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] Adding examine event handlers for index providers: 3
2013-02-26 10:03:16,370 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of umbraco.interfaces.IApplication, found 7 (took 8ms)
2013-02-26 10:03:16,416 [30] INFO Umbraco.Core.PluginManager - [Thread 17] Completed resolution of types of umbraco.interfaces.ITree, found 27 (took 4ms)
2013-02-26 10:03:16,489 [30] INFO Umbraco.Core.CoreBootManager - [Thread 17] Umbraco application startup complete (took 604ms)
2013-02-26 10:03:16,744 [30] INFO umbraco.presentation.install.utills.p - [Thread 23] Hitting Page_Load on p.aspx for the requested 'sitebuildervids' feed
2013-02-26 10:03:16,749 [30] INFO umbraco.presentation.install.utills.p - [Thread 5] Hitting Page_Load on p.aspx for the requested 'developervids' feed
2013-02-26 10:03:42,229 [30] INFO umbraco.requestHandler - [Thread 7] NotFound url (from 'http://localhost/Umbraco6/install/?installStep=theend')
2013-02-26 10:04:20,232 [30] INFO Umbraco.Core.PluginManager - [Thread 40] Completed resolution of types of umbraco.BusinessLogic.Actions.IActionHandler, found 1 (took 4ms)
2013-02-26 10:04:20,235 [30] INFO Umbraco.Core.PluginManager - [Thread 40] Completed resolution of types of umbraco.interfaces.IAction, found 35 (took 0ms)
2013-02-26 10:04:20,388 [30] INFO Umbraco.Core.PluginManager - [Thread 40] Completed resolution of types of umbraco.interfaces.ITree, found 36 (took 2ms)
2013-02-26 10:04:49,497 [30] INFO umbraco.cms.businesslogic.web.Document - [Thread 7] New document 1054
2013-02-26 10:05:04,600 [30] INFO umbraco.cms.businesslogic.web.Document - [Thread 24] New document 1055
2013-02-26 10:05:24,133 [30] INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 28] Content 'ACSI' with Id '1054' has been published.
2013-02-26 10:05:24,239 [30] INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 28] Content 'Home' with Id '1055' has been published.
2013-02-26 10:05:31,860 [30] INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 5] Content 'Home' with Id '1055' has been published.
2013-02-26 10:06:35,527 [30] INFO umbraco.cms.businesslogic.web.Document - [Thread 43] New document 1056
2013-02-26 10:06:44,362 [30] INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 28] Content 'Employement' with Id '1056' has been published.
2013-02-26 10:06:51,412 [30] INFO umbraco.requestHandler - [Thread 40] NotFound url employement.aspx (from 'http://localhost/Umbraco6/umbraco/editContent.aspx?id=1056&isNew=true')
2013-02-26 10:07:18,481 [30] INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 44] Content 'Employment' with Id '1056' has been published.
2013-02-26 10:07:57,187 [30] INFO umbraco.requestHandler - [Thread 40] NotFound url home.aspx (from '')
2013-02-26 10:08:02,420 [30] INFO umbraco.requestHandler - [Thread 43] NotFound url (from '')
2013-02-26 10:08:11,373 [30] INFO umbraco.requestHandler - [Thread 24] NotFound url (from '')
2013-02-26 10:08:22,679 [30] INFO Umbraco.Core.PluginManager - [Thread 7] Completed resolution of types of Umbraco.Web.BaseRest.RestExtensionAttribute, found 1 (took 9ms)
I noticed that it seems to have an issue with the connection string that it can't find it within the web.config. This is the connection string section with the root web.config
It's unfortunate that this is the first encounter you're having with Umbraco since it gives you a bad experience. Unfortunately there has been some bugs in the 6.0 release, which I suspect this could be related to. But the good thing is that the core team are working insanely fast fixing the issues.
Therefore I'm wondering if you would mind to see if the above error is being fixed if you install the latest nightly of 6.0.1 from here http://nightly.umbraco.org/umbraco%206.0.1/ ?
Thank you the reply. I downloaded UmbracoCms.6.0.1-build.30.zip from the link you provided and setup the website the same as my previous attempts and I get the same result. I also tried installing 4.11.3 from Microsoft's Web Platform Installer and I get the same result. Is there configuration I need to set in IIS? Also, I've noticed that links to install a new Starter Kit on the Get Started Page are broken. They redirect to /install instead of {sitename}/install. In additional I've noticed that I can only install the Simpler Starter Kit (4.11 or 6.0). If I try to install a different skin I get an error page and the stack trace. The error message says 'Could not resolve a data type with id ...[guid]'. After the error I can still click the continue button and select a skin and then continue on to the final page. If I don't install any skins when I click on the 'Preview You Website' I get the Umbraco no pages found pages. I get this page in 4.11.3, 6.0.0, and 6.0.1. I'm starting to wonder if there isn't a problem with the folder premissions or something related to the starter kits and skins. I've given IIS_ISURS full access to the root folder for Umbraco.
Hmm, maybe there is issues with the starter kits not being compatible with Umbraco 6 for some reason.
Have you tried just making a clean installation and see if that succeeds? If so I'll recommend that you install the MVC starter kit by Chris Koiak...IF you intend to use MVC? You can have a look at the package here http://our.umbraco.org/projects/starter-kits/standard-website-mvc
If the errors are related to issues with the starter kit then it should be reported as a bug in the issue tracker.
Are there certain premissions that I need to set? Either in IIS or on the folders themselves. I tried installing the template you recommended and I'm getting what seems like a premissions with with that as well. I checked the forum for that package and another person is getting that same error as I am and the package author thinks it may be related to folder premissions. In IIS I currently have Anonymous and Forms Authethication turned on and all other authentication disabled. Is there a different user besides IIS_IUSRS that I should give folder premissions to? Thank you for all your help so far.
On the folder containing the Umbraco files you could try to give access to the everyone role - if this helps try removing the access to the everyone role and then make sure iusr and network service has full access and make sure the permissions are being inherited all the way down.
Also make sure that the app pool in IIS is being run by network service.
Thank you for all your help, but so far no luck. I'm still getting the 404 error with Umbraco 6.0.0. I did a fresh install changed the App Pool Identity to Network Service, given Everyone, Network Service, and IIS_IUSRS full control to the root Umbraco folder, but I'm still getting the same error. The App Pool running Umbraco is Integrated Pipeline, if that makes any difference. I'm going to try pull the source for 4.11.4 from codeplex and manually installing that version and see if I have any better luck with it. Again, thanks for all your help.
I've been trying different installation methods and I finally found one that works. If I install Umbraco using Microsoft's WebMatrix 2 platforum I am able to install Umbraco 4.11.3 on the development server. However, I noticed that the url that WebMatrix creates is http://localhost:[portnumber]/. Previously, I was trying to install to a different directory with a different hostname, http://localhost/Umbraco. Is there a requirement that I missed that Umbraco needs to be the root website? Thanks.
404 Error after Fresh Install of Umbraco 6 on IIS 7.5
Hello,
I'm new to Umbraco and I'm trying to evaluate it for potential use by my organization. The server that I'm using is a Win Server 2008 R2 runing MS Sql Server 2012 Standard 64 Bit and IIS 7.5. I downloaded Umbraco 6.0 from Codeplex and unzipped the files to c:/inetpub/wwwrot/Umbraco6 and created an application within IIS by the same name using App Pool Asp.Net 4.0. I am able to install Umbraco and all the tables are created within the database without any problems. I've been selecting the Simple Starter Kit and the SweetAs skin both of which install correctly. Umbraco says installation has finished, but when I click on the 'Preview your new Website' link I get a 404 error. I am able to use the admin portal without any problems. I cannot navigate to any pages that I have created and published in Umbraco. The link to document is /Umbraco6/{pagename}.aspx. Below is the UmbracoTraceLog.txt from App_Data/logs.
Hi Sean and welcome to our :)
It's unfortunate that this is the first encounter you're having with Umbraco since it gives you a bad experience. Unfortunately there has been some bugs in the 6.0 release, which I suspect this could be related to. But the good thing is that the core team are working insanely fast fixing the issues.
Therefore I'm wondering if you would mind to see if the above error is being fixed if you install the latest nightly of 6.0.1 from here http://nightly.umbraco.org/umbraco%206.0.1/ ?
Looking forward to hearing from you.
/Jan
Jan,
Thank you the reply. I downloaded UmbracoCms.6.0.1-build.30.zip from the link you provided and setup the website the same as my previous attempts and I get the same result. I also tried installing 4.11.3 from Microsoft's Web Platform Installer and I get the same result. Is there configuration I need to set in IIS? Also, I've noticed that links to install a new Starter Kit on the Get Started Page are broken. They redirect to /install instead of {sitename}/install. In additional I've noticed that I can only install the Simpler Starter Kit (4.11 or 6.0). If I try to install a different skin I get an error page and the stack trace. The error message says 'Could not resolve a data type with id ...[guid]'. After the error I can still click the continue button and select a skin and then continue on to the final page. If I don't install any skins when I click on the 'Preview You Website' I get the Umbraco no pages found pages. I get this page in 4.11.3, 6.0.0, and 6.0.1. I'm starting to wonder if there isn't a problem with the folder premissions or something related to the starter kits and skins. I've given IIS_ISURS full access to the root folder for Umbraco.
Hi Sean
Hmm, maybe there is issues with the starter kits not being compatible with Umbraco 6 for some reason.
Have you tried just making a clean installation and see if that succeeds? If so I'll recommend that you install the MVC starter kit by Chris Koiak...IF you intend to use MVC? You can have a look at the package here http://our.umbraco.org/projects/starter-kits/standard-website-mvc
If the errors are related to issues with the starter kit then it should be reported as a bug in the issue tracker.
Looking forward to hearing from you.
/Jan
Jan,
Are there certain premissions that I need to set? Either in IIS or on the folders themselves. I tried installing the template you recommended and I'm getting what seems like a premissions with with that as well. I checked the forum for that package and another person is getting that same error as I am and the package author thinks it may be related to folder premissions. In IIS I currently have Anonymous and Forms Authethication turned on and all other authentication disabled. Is there a different user besides IIS_IUSRS that I should give folder premissions to? Thank you for all your help so far.
Hi Sean
On the folder containing the Umbraco files you could try to give access to the everyone role - if this helps try removing the access to the everyone role and then make sure iusr and network service has full access and make sure the permissions are being inherited all the way down.
Also make sure that the app pool in IIS is being run by network service.
Hope this helps.
/Jan
Jan,
Thank you for all your help, but so far no luck. I'm still getting the 404 error with Umbraco 6.0.0. I did a fresh install changed the App Pool Identity to Network Service, given Everyone, Network Service, and IIS_IUSRS full control to the root Umbraco folder, but I'm still getting the same error. The App Pool running Umbraco is Integrated Pipeline, if that makes any difference. I'm going to try pull the source for 4.11.4 from codeplex and manually installing that version and see if I have any better luck with it. Again, thanks for all your help.
Jan,
I've been trying different installation methods and I finally found one that works. If I install Umbraco using Microsoft's WebMatrix 2 platforum I am able to install Umbraco 4.11.3 on the development server. However, I noticed that the url that WebMatrix creates is http://localhost:[portnumber]/. Previously, I was trying to install to a different directory with a different hostname, http://localhost/Umbraco. Is there a requirement that I missed that Umbraco needs to be the root website? Thanks.
I upgraded from 7.0.0 to 7.0.1 today and am expereincing a similar error:
"The parameterized query '(@value nvarchar(216),@dtdefid int,@alias nvarchar(4000))INSERT ' expects the parameter '@alias', which was not supplied."
is working on a reply...