Invalid Column Name
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
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,
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
Hi,
delete
from
[sf_meta_fields]
where
field_name
like
'%_nl'
;
delete
from
[sf_meta_fields]
where
field_name
like
'%_en%'
;