Turkish Language Problem
Anybody have an idea about this error ?
System: SQL Server 2005 Collocation: Turkish CI AS
I just add Turkish language as an second language
Server Error in '/destek4' Application.
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Error executing query: Telerik.OpenAccess.RT.sql.SQLException: Invalid column name 'approval_workflow_state_en'.
Invalid column name 'approval_workflow_state_tr'.
Invalid column name 'description_en'.
Invalid column name 'description_tr'.
Invalid column name 'redirect_url_en'.
Invalid column name 'redirect_url_tr'.
Invalid column name 'title_en'.
Invalid column name 'title_tr'.
Invalid column name 'url_name_en'.
Invalid column name 'url_name_tr'.
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 a.[id] AS COL1, a.[approval_workflow_state_] AS COL2, a.[approval_workflow_state_en] AS COL3, a.[approval_workflow_state_tr] AS COL4, a.[description_] AS COL5, a.[description_en] AS COL6, a.[description_tr] AS COL7, a.[redirect_url_] AS COL8, a.[redirect_url_en] AS COL9, a.[redirect_url_tr] AS COL10, a.[title_] AS COL11, a.[title_en] AS COL12, a.[title_tr] AS COL13, a.[url_name_] AS COL14, a.[url_name_en] AS COL15, a.[url_name_tr] AS COL16, a.[allow_multiple_urls] AS COL17, a.[app_name] AS COL18, a.[can_inherit_permissions] AS COL19, a.[date_created] AS COL20, a.[inherits_permissions] AS COL21, a.[last_modified] AS COL22, a.[linked_node_id] AS COL23, a.[linked_node_provider] AS COL24, a.[nme] AS COL25, a.[node_type] AS COL26, a.[open_new_window] AS COL27, a.[ordinal] AS COL28, a.[ownr] AS COL29, a.[content_id] AS COL30, a.[parent_id] AS COL31, a.[render_as_link] AS COL32, a.[root_id] AS COL33, a.[show_in_navigation] AS COL34, a.[voa_version] AS COL35 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_tr'.
Invalid column name 'description_en'.
Invalid column name 'description_tr'.
Invalid column name 'redirect_url_en'.
Invalid column name 'redirect_url_tr'.
Invalid column name 'title_en'.
Invalid column name 'title_tr'.
Invalid column name 'url_name_en'.
Invalid column name 'url_name_tr'.
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()
Source Error:
Line 25: <siteMap defaultProvider="SitefinitySiteMap">
Line 26: <providers>
Line 27: <add name="SitefinitySiteMap" type="Telerik.Sitefinity.Web.SitefinitySiteMap, Telerik.Sitefinity" taxonomyProvider="OpenAccessDataProvider" pageTaxonomy="Pages" rootNode="FrontendSiteMap" pageProvider="OpenAccessDataProvider"/>Line 28: </providers>
Line 29: </siteMap>
Source File: C:\Inetpub\wwwroot\destek.as\destek4\web.config Line: 27
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Hello Omer,
Excuse us for the belated response here, but we've already answered your support ticket a couple of days ago. So for the sake of the forum readers, here's the relevant part of our answer to your ticket:
We've dealt with a number of OpenAccess globalization issues caused by Turkish being the culture of the current thread, some of which where addressed by hotfixes, but never investigated the scenario of having Turkish as server collation.
We've installed an SQL Server instance with Turkish_CI_AS server collation and we've successfully added Turkish as a second language in Sitefinity's backend. We didn't experience any exceptions in the code (with a debugger attached), only a strange issue logging the user out, which disappeared after some time.
We've also contacted the OpenAccess team to confirm that they don't know of any issues caused by a Turkish server collation, and they've told us they even have tests running successfully on it.
Could you guide us by answering a couple of questions: