1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Invalid Column Name

Invalid Column Name

4 posts, 0 answered
  1. j8
    j8 avatar
    20 posts
    Registered:
    30 Oct 2007
    23 Feb 2011
    Link to this post

    Hi,

    A Backend user changed a language somewhere in the Backend and now the site can't be accessed anymore.

    Is there any way to change the multi-language setting back via values in the tables?

    See this errormsg;

    Server Error in '/' Application.
    --------------------------------------------------------------------------------
      
    Invalid column name 'approval_workflow_state_en'.
    Invalid column name 'approval_workflow_state_nl'.
    Invalid column name 'description_en'.
    Invalid column name 'description_nl'.
    Invalid column name 'title_en'.
    Invalid column name 'title_nl'.
    Invalid column name 'url_name_en'.
    Invalid column name 'url_name_nl'.
    Statement(s) could not be prepared. 
    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: Telerik.OpenAccess.RT.sql.SQLException: Invalid column name 'approval_workflow_state_en'.
    Invalid column name 'approval_workflow_state_nl'.
    Invalid column name 'description_en'.
    Invalid column name 'description_nl'.
    Invalid column name 'title_en'.
    Invalid column name 'title_nl'.
    Invalid column name 'url_name_en'.
    Invalid column name 'url_name_nl'.
    Statement(s) could not be prepared.
      
    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: 
      
      
    [SQLException: Invalid column name 'approval_workflow_state_en'.
    Invalid column name 'approval_workflow_state_nl'.
    Invalid column name 'description_en'.
    Invalid column name 'description_nl'.
    Invalid column name 'title_en'.
    Invalid column name 'title_nl'.
    Invalid column name 'url_name_en'.
    Invalid column name 'url_name_nl'.
    Statement(s) could not be prepared.]
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery() +573
       OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery() +85
       OpenAccessRuntime.Relational.fetch.FetchResultImp.execute() +86
      
    [DataStoreException: Error executing query: Telerik.OpenAccess.RT.sql.SQLException: Invalid column name 'approval_workflow_state_en'.
    Invalid column name 'approval_workflow_state_nl'.
    Invalid column name 'description_en'.
    Invalid column name 'description_nl'.
    Invalid column name 'title_en'.
    Invalid column name 'title_nl'.
    Invalid column name 'url_name_en'.
    Invalid column name 'url_name_nl'.
    Statement(s) could not be prepared.
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
       at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
       at OpenAccessRuntime.Relational.fetch.FetchResultImp.execute()
    SQL:
    SELECT  TOP(??T) a.[id] AS COL1, a.[approval_workflow_state_] AS COL2, a.[approval_workflow_state_en] AS COL3, a.[approval_workflow_state_nl] AS COL4, a.[description_] AS COL5, a.[description_en] AS COL6, a.[description_nl] AS COL7, a.[title_] AS COL8, a.[title_en] AS COL9, a.[title_nl] AS COL10, a.[url_name_] AS COL11, a.[url_name_en] AS COL12, a.[url_name_nl] AS COL13, a.[app_name] AS COL14, a.[id2] AS COL15, a.[can_inherit_permissions] AS COL16, a.[date_created] AS COL17, a.[inherits_permissions] AS COL18, a.[last_modified] AS COL19, a.[nme] AS COL20, a.[ordinal] AS COL21, a.[ownr] AS COL22, a.[content_id] AS COL23, a.[parent_id] AS COL24, a.[render_as_link] AS COL25, a.[root_id] AS COL26, a.[show_in_navigation] AS COL27, a.[voa_version] AS COL28 FROM [sf_page_node] a WHERE a.[app_name] = ?               AND a.[nme] = ?                Telerik.OpenAccess.RT.sql.SQLException: Invalid column name 'approval_workflow_state_en'.
    Invalid column name 'approval_workflow_state_nl'.
    Invalid column name 'description_en'.
    Invalid column name 'description_nl'.
    Invalid column name 'title_en'.
    Invalid column name 'title_nl'.
    Invalid column name 'url_name_en'.
    Invalid column name 'url_name_nl'.
    Statement(s) could not be prepared.
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
       at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
       at OpenAccessRuntime.Relational.fetch.FetchResultImp.execute()]
       Telerik.Sitefinity.Data.Linq.Oql.OqlQueryProvider`2.ExecuteKnownType(IObjectScope scope, String queryText, Boolean isEnumerable, Int32 skip, Int32 take, IList parameters, ElementOperator op) +1582
       Telerik.Sitefinity.Data.Linq.Oql.OqlQueryProvider`2.Execute(Expression expression) +897
       Telerik.Sitefinity.Data.Linq.QueryProvider`2.System.Linq.IQueryProvider.Execute(Expression expression) +113
       System.Linq.Queryable.FirstOrDefault(IQueryable`1 source, Expression`1 predicate) +580
       Telerik.Sitefinity.Web.SiteMapBase.Initialize(String name, NameValueCollection attributes) +1173
       Telerik.Sitefinity.Web.SiteMapBase.GetSiteMapProvider(String rootName) +371
       Telerik.Sitefinity.Web.SitefinityRoute.GetRouteData(HttpContextBase httpContext) +60
       System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext) +370
       System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context) +75
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +266
      
       
      
      
    --------------------------------------------------------------------------------
    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

    Regards,

      Peter

  2. Lyubomir Dokov
    Lyubomir Dokov avatar
    43 posts
    Registered:
    06 Jun 2017
    23 Feb 2011
    Link to this post

    Hi Peter,

    It is possible to edit languages "Sitefinity\Configurations" folder of your application and there is a file named "resourcesConfig.config". Generally, you can replace multilingual="true" with multilingual="false" and this will switch off multi languages in your site. You will need to restart the application after you edit this file in order to apply the changes . Also, you can remove languages from <cultures> tag.

    Greetings,
    Lyubomir Dokov
    the Telerik team
  3. j8
    j8 avatar
    20 posts
    Registered:
    30 Oct 2007
    24 Feb 2011
    Link to this post

    Lyubomir,

    That didn't work for me. I ended up deleting the records from the sf_meta_fields table.

    delete from [sf_meta_fields]
    where field_name like '%_nl';
      
    delete from [sf_meta_fields]
    where field_name like '%_en';

    After this everything started working again.

    Now I'll try and enable different languages in a test project :)

    Thanks,

      Peter

  4. ConsumentenClaim
    ConsumentenClaim avatar
    14 posts
    Registered:
    21 Oct 2010
    22 Dec 2011
    Link to this post
    Hi,

    I had the same problem. By adding a language the frontend as well as the backend crashed totally. The version I am running is 4.0.1120

    The query above (mine had _en_us instead of _en) fixed the problem.

    delete from [sf_meta_fields]
    where field_name like '%_nl';
      
    delete from [sf_meta_fields]
    where field_name like '%_en%';
4 posts, 0 answered