upgrading to 1.6

Topics: Installing Orchard, Troubleshooting
Nov 1, 2012 at 5:23 PM

I keep getting the following error, what is wrong....

 

Server Error in '/' Application.

The column name is not valid. [ Node name (if any) = sitesettin4_,Column name = SiteTimeZone ]

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlServerCe.SqlCeException: The column name is not valid. [ Node name (if any) = sitesettin4_,Column name = SiteTimeZone ]

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

[SqlCeException (0x80004005): The column name is not valid. [ Node name (if any) = sitesettin4_,Column name = SiteTimeZone ]]
   System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) +48
   System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan() +700
   System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) +542
   System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior) +19
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
   NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +279
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +255
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +181
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +126
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +136

[GenericADOException: could not execute query
[ SELECT this_.Id as Id1082_3_, this_.Number as Number1082_3_, this_.Published as Published1082_3_, this_.Latest as Latest1082_3_, this_.Data as Data1082_3_, this_.ContentItemRecord_id as ContentI6_1082_3_, contentite1_.Id as Id1081_0_, contentite1_.Data as Data1081_0_, contentite1_.ContentType_id as ContentT3_1081_0_, sitesettin4_.Id as Id1089_1_, sitesettin4_.SiteSalt as SiteSalt1089_1_, sitesettin4_.SiteName as SiteName1089_1_, sitesettin4_.SuperUser as SuperUser1089_1_, sitesettin4_.PageTitleSeparator as PageTitl5_1089_1_, sitesettin4_.HomePage as HomePage1089_1_, sitesettin4_.SiteCulture as SiteCult7_1089_1_, sitesettin4_.ResourceDebugMode as Resource8_1089_1_, sitesettin4_.PageSize as PageSize1089_1_, sitesettin4_.SiteTimeZone as SiteTim10_1089_1_, contenttyp5_.Id as Id1083_2_, contenttyp5_.Name as Name1083_2_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id left outer join Settings_SiteSettingsPartRecord sitesettin4_ on contentite1_.Id=sitesettin4_.Id left outer join Orchard_Framework_ContentTypeRecord contenttyp5_ on contentite1_.ContentType_id=contenttyp5_.Id WHERE contentite1_.Id = @p0 and this_.Published = @p1 ORDER BY GETDATE() OFFSET 0 ROWS FETCH NEXT @p2 ROWS ONLY ]
  Name:cp0 - Value:1  Name:cp1 - Value:True
[SQL: SELECT this_.Id as Id1082_3_, this_.Number as Number1082_3_, this_.Published as Published1082_3_, this_.Latest as Latest1082_3_, this_.Data as Data1082_3_, this_.ContentItemRecord_id as ContentI6_1082_3_, contentite1_.Id as Id1081_0_, contentite1_.Data as Data1081_0_, contentite1_.ContentType_id as ContentT3_1081_0_, sitesettin4_.Id as Id1089_1_, sitesettin4_.SiteSalt as SiteSalt1089_1_, sitesettin4_.SiteName as SiteName1089_1_, sitesettin4_.SuperUser as SuperUser1089_1_, sitesettin4_.PageTitleSeparator as PageTitl5_1089_1_, sitesettin4_.HomePage as HomePage1089_1_, sitesettin4_.SiteCulture as SiteCult7_1089_1_, sitesettin4_.ResourceDebugMode as Resource8_1089_1_, sitesettin4_.PageSize as PageSize1089_1_, sitesettin4_.SiteTimeZone as SiteTim10_1089_1_, contenttyp5_.Id as Id1083_2_, contenttyp5_.Name as Name1083_2_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id left outer join Settings_SiteSettingsPartRecord sitesettin4_ on contentite1_.Id=sitesettin4_.Id left outer join Orchard_Framework_ContentTypeRecord contenttyp5_ on contentite1_.ContentType_id=contenttyp5_.Id WHERE contentite1_.Id = @p0 and this_.Published = @p1 ORDER BY GETDATE() OFFSET 0 ROWS FETCH NEXT @p2 ROWS ONLY]]
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +224
   NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +18
   NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +79
   NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +642
   NHibernate.Impl.CriteriaImpl.List(IList results) +49
   NHibernate.Impl.CriteriaImpl.List() +58
   Orchard.ContentManagement.DefaultContentManager.GetManyImplementation(QueryHints hints, Action`2 predicate) in c:\Users\sebros\My Projects\Orchard\src\Orchard\ContentManagement\DefaultContentManager.cs:334
   Orchard.ContentManagement.DefaultContentManager.Get(Int32 id, VersionOptions options, QueryHints hints) in c:\Users\sebros\My Projects\Orchard\src\Orchard\ContentManagement\DefaultContentManager.cs:140
   Orchard.ContentManagement.ContentGetExtensions.Get(IContentManager manager, Int32 id, VersionOptions options, QueryHints hints) in c:\Users\sebros\My Projects\Orchard\src\Orchard\ContentManagement\ContentExtensions.cs:160
   Orchard.Core.Settings.Services.SiteService.GetSiteSettings() in c:\Users\sebros\My Projects\Orchard\src\Orchard.Web\Core\Settings\Services\SiteService.cs:46
   Orchard.Settings.CurrentSiteWorkContext.Get(String name) in c:\Users\sebros\My Projects\Orchard\src\Orchard\Settings\CurrentSiteWorkContext.cs:13
   Orchard.Environment.<>c__DisplayClass7`1.<FindResolverForState>b__2(IWorkContextStateProvider wcsp) in c:\Users\sebros\My Projects\Orchard\src\Orchard\Environment\WorkContextImplementation.cs:32
   System.Linq.WhereSelectArrayIterator`2.MoveNext() +66
   System.Linq.Enumerable.FirstOrDefault(IEnumerable`1 source, Func`2 predicate) +161
   Orchard.Environment.WorkContextImplementation.FindResolverForState(String name) in c:\Users\sebros\My Projects\Orchard\src\Orchard\Environment\WorkContextImplementation.cs:32
   System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory) +72
   Orchard.Environment.WorkContextImplementation.GetState(String name) in c:\Users\sebros\My Projects\Orchard\src\Orchard\Environment\WorkContextImplementation.cs:27
   Orchard.WorkContext.get_CurrentSite() in c:\Users\sebros\My Projects\Orchard\src\Orchard\WorkContext.cs:52
   Orchard.Localization.Services.SiteCultureSelector.GetCulture(HttpContextBase context) in c:\Users\sebros\My Projects\Orchard\src\Orchard\Localization\Services\SiteCultureSelector.cs:13
   Orchard.Localization.Services.<>c__DisplayClass8.<GetCurrentCulture>b__3(ICultureSelector x) in c:\Users\sebros\My Projects\Orchard\src\Orchard\Localization\Services\DefaultCultureManager.cs:53
   System.Linq.WhereSelectArrayIterator`2.MoveNext() +66
   System.Linq.WhereEnumerableIterator`1.MoveNext() +85
   System.Linq.Buffer`1..ctor(IEnumerable`1 source) +216
   System.Linq.<GetEnumerator>d__0.MoveNext() +110
   System.Linq.Enumerable.Count(IEnumerable`1 source) +4081813
   Orchard.Localization.Services.DefaultCultureManager.GetCurrentCulture(HttpContextBase requestContext) in c:\Users\sebros\My Projects\Orchard\src\Orchard\Localization\Services\DefaultCultureManager.cs:57
   Orchard.Localization.Services.CurrentCultureWorkContext.<Get>b__0(WorkContext ctx) in c:\Users\sebros\My Projects\Orchard\src\Orchard\Localization\Services\CurrentCultureWorkContext.cs:13
   Orchard.Environment.<>c__DisplayClass7`1.<FindResolverForState>b__5() in c:\Users\sebros\My Projects\Orchard\src\Orchard\Environment\WorkContextImplementation.cs:37
   Orchard.Environment.WorkContextImplementation.GetState(String name) in c:\Users\sebros\My Projects\Orchard\src\Orchard\Environment\WorkContextImplementation.cs:28
   Orchard.WorkContext.get_CurrentCulture() in c:\Users\sebros\My Projects\Orchard\src\Orchard\WorkContext.cs:76
   Orchard.Localization.Text.Get(String textHint, Object[] args) in c:\Users\sebros\My Projects\Orchard\src\Orchard\Localization\Text.cs:26
   Orchard.UI.Admin.AdminFilter.OnAuthorization(AuthorizationContext filterContext) in c:\Users\sebros\My Projects\Orchard\src\Orchard\UI\Admin\AdminFilter.cs:23
   System.Web.Mvc.ControllerActionInvoker.InvokeAuthorizationFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor) +97
   System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +311
   System.Web.Mvc.<>c__DisplayClass1d.<BeginExecuteCore>b__19() +23
   System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +19
   System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +10
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +55
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +39
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +23
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +55
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +29
   System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +10
   System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult) +25
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +23
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +55
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +31
   System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
   Orchard.Mvc.Routes.HttpAsyncHandler.EndProcessRequest(IAsyncResult result) in c:\Users\sebros\My Projects\Orchard\src\Orchard\Mvc\Routes\ShellRoute.cs:162
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9629708
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155



Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17929