Hello,

I am trying to install DNN7 to Windows 7. I created a database in SQL Server Management Studio and the tables of it was created while installation. However, at the step of "Website Creation" an error occurred which is " 70% ERROR:Error creating Profile Definitions". Error Log says that "[ERROR] DotNetNuke.Services.Upgrade.Upgrade System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'fileid'. How can I solve this problem? I am too close but stuck at this point.

 King Regards

Selen

Hello, here is my error log from portals/_default/logs


2012-12-17 13:28:45,349 [h188-227-168-210][Thread:7][FATAL] DotNetNuke.Framework.PageBase - An error has occurred while loading page.
System.Web.HttpParseException (0x80004005): c:\HostingSpaces\accountname\mydomain.com\wwwroot\admin\ControlPanel\AddModule.ascx.cs(448): error CS1061: 'DotNetNuke.Entities.Modules.DesktopModuleInfo' does not contain a definition for 'Shareable' and no extension method 'Shareable' accepting a first argument of type 'DotNetNuke.Entities.Modules.DesktopModuleInfo' could be found (are you missing a using directive or an assembly reference?) ---> System.Web.HttpCompileException (0x80004005): c:\HostingSpaces\accountname\mydomain.com\wwwroot\admin\ControlPanel\AddModule.ascx.cs(448): error CS1061: 'DotNetNuke.Entities.Modules.DesktopModuleInfo' does not contain a definition for 'Shareable' and no extension method 'Shareable' accepting a first argument of type 'DotNetNuke.Entities.Modules.DesktopModuleInfo' could be found (are you missing a using directive or an assembly reference?)
at System.Web.Compilation.BuildManager.PostProcessFoundBuildResult(BuildResult result, Boolean keyFromVPP, VirtualPath virtualPath)
at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.UI.BaseTemplateParser.GetReferencedType(VirtualPath virtualPath, Boolean allowNoCompile)
at System.Web.UI.BaseTemplateParser.GetUserControlType(VirtualPath virtualPath)
at System.Web.UI.MainTagNameToTypeMapper.ProcessUserControlRegistration(UserControlRegisterEntry ucRegisterEntry)
at System.Web.UI.BaseTemplateParser.ProcessDirective(String directiveName, IDictionary directive)
at System.Web.UI.TemplateControlParser.ProcessDirective(String directiveName, IDictionary directive)
at System.Web.UI.TemplateParser.ParseStringInternal(String text, Encoding fileEncoding)
at System.Web.UI.TemplateParser.ProcessException(Exception ex)
at System.Web.UI.TemplateParser.ParseStringInternal(String text, Encoding fileEncoding)
at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding)
at System.Web.UI.TemplateParser.ParseFile(String physicalPath, VirtualPath virtualPath)
at System.Web.UI.TemplateParser.ParseInternal()
at System.Web.UI.TemplateParser.Parse()
at System.Web.Compilation.BaseTemplateBuildProvider.get_CodeCompilerType()
at System.Web.Compilation.BuildProvider.GetCompilerTypeFromBuildProvider(BuildProvider buildProvider)
at System.Web.Compilation.BuildProvidersCompiler.ProcessBuildProviders()
at System.Web.Compilation.BuildProvidersCompiler.PerformBuild()
at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath)
at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath)
at DotNetNuke.UI.ControlUtilities.LoadControl[T](TemplateControl containerControl, String ControlSrc)
at DotNetNuke.UI.Skins.Skin.InjectControlPanel()
at DotNetNuke.UI.Skins.Skin.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.AddedControl(Control control, Int32 index)
at System.Web.UI.ControlCollection.Add(Control child)
at DotNetNuke.Framework.DefaultPage.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2012-12-17 13:28:46,036 [h188-227-168-210][Thread:7][ERROR] DotNetNuke.Services.Exceptions.ErrorPage - c:\HostingSpaces\accountname\mydomain.com\wwwroot\admin\ControlPanel\AddModule.ascx.cs(448): error CS1061: 'DotNetNuke.Entities.Modules.DesktopModuleInfo' does not contain a definition for 'Shareable' and no extension method 'Shareable' accepting a first argument of type 'DotNetNuke.Entities.Modules.DesktopModuleInfo' could be found (are you missing a using directive or an assembly reference?)
DotNetNuke.Services.Exceptions.PageLoadException: c:\HostingSpaces\accountname\mydomain.com\wwwroot\admin\ControlPanel\AddModule.ascx.cs(448): error CS1061: 'DotNetNuke.Entities.Modules.DesktopModuleInfo' does not contain a definition for 'Shareable' and no extension method 'Shareable' accepting a first argument of type 'DotNetNuke.Entities.Modules.DesktopModuleInfo' could be found (are you missing a using directive or an assembly reference?) ---> System.Web.HttpParseException: c:\HostingSpaces\accountname\mydomain.com\wwwroot\admin\ControlPanel\AddModule.ascx.cs(448): error CS1061: 'DotNetNuke.Entities.Modules.DesktopModuleInfo' does not contain a definition for 'Shareable' and no extension method 'Shareable' accepting a first argument of type 'DotNetNuke.Entities.Modules.DesktopModuleInfo' could be found (are you missing a using directive or an assembly reference?) ---> System.Web.HttpCompileException: c:\HostingSpaces\accountname\mydomain.com\wwwroot\admin\ControlPanel\AddModule.ascx.cs(448): error CS1061: 'DotNetNuke.Entities.Modules.DesktopModuleInfo' does not contain a definition for 'Shareable' and no extension method 'Shareable' accepting a first argument of type 'DotNetNuke.Entities.Modules.DesktopModuleInfo' could be found (are you missing a using directive or an assembly reference?)
at System.Web.Compilation.BuildManager.PostProcessFoundBuildResult(BuildResult result, Boolean keyFromVPP, VirtualPath virtualPath)
at System.Web.Compilation.BuildManager.GetBuildResultFromCacheInternal(String cacheKey, Boolean keyFromVPP, VirtualPath virtualPath, Int64 hashCode, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVPathBuildResultFromCacheInternal(VirtualPath virtualPath, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.UI.BaseTemplateParser.GetReferencedType(VirtualPath virtualPath, Boolean allowNoCompile)
at System.Web.UI.BaseTemplateParser.GetUserControlType(VirtualPath virtualPath)
at System.Web.UI.MainTagNameToTypeMapper.ProcessUserControlRegistration(UserControlRegisterEntry ucRegisterEntry)
at System.Web.UI.BaseTemplateParser.ProcessDirective(String directiveName, IDictionary directive)
at System.Web.UI.TemplateControlParser.ProcessDirective(String directiveName, IDictionary directive)
at System.Web.UI.TemplateParser.ParseStringInternal(String text, Encoding fileEncoding)
--- End of inner exception stack trace ---
at System.Web.UI.TemplateParser.ProcessException(Exception ex)
at System.Web.UI.TemplateParser.ParseStringInternal(String text, Encoding fileEncoding)
at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding)
at System.Web.UI.TemplateParser.ParseFile(String physicalPath, VirtualPath virtualPath)
at System.Web.UI.TemplateParser.ParseInternal()
at System.Web.UI.TemplateParser.Parse()
at System.Web.Compilation.BaseTemplateBuildProvider.get_CodeCompilerType()
at System.Web.Compilation.BuildProvider.GetCompilerTypeFromBuildProvider(BuildProvider buildProvider)
at System.Web.Compilation.BuildProvidersCompiler.ProcessBuildProviders()
at System.Web.Compilation.BuildProvidersCompiler.PerformBuild()
at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath)
at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath)
at DotNetNuke.UI.ControlUtilities.LoadControl[T](TemplateControl containerControl, String ControlSrc)
at DotNetNuke.UI.Skins.Skin.InjectControlPanel()
at DotNetNuke.UI.Skins.Skin.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.AddedControl(Control control, Int32 index)
at System.Web.UI.ControlCollection.Add(Control child)
at DotNetNuke.Framework.DefaultPage.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---

Hi Sebastian, thank you for your help - i am in a hosted environment... so, not sure how to set the collation? The current setting is "Latin1_General_CI_AS" the settings are below: Version 10.50.1600.1 Product level RTM Edition Web Edition (64-bit) Resource version 10.50.1600 Resource last update time Apr 2 2010 5:38PM CLR version v2.0.50727 Language English (United States) License License type DISABLED Number of licenses Hardware Platform NT x64 Processor count 8 Processor type Physical memory 32758 (MB) Configuration Collation Latin1_General_CI_AS Is clustered false Is full-text installed true Integrated security only false SQL character set iso_1 SQL sort order bin_ascii_8