Turkish Language Problem

Posted by Community Admin on 03-Aug-2018 09:12

Turkish Language Problem

Sitefinity - General Discussions

All Replies

Posted by Community Admin on 12-Oct-2011 00:00

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

Posted by Community Admin on 18-Oct-2011 00:00

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:

  • Are you getting this error only after adding Turkish as a second language?
  • When adding Turkish as a second language, did you set is as default?
  • Does removing Turkish resolve the issue?
  • Is your Windows, IIS, or website default culture set to Turkish?
  • Also are you using the 4.2 SP1 version?
  • What is your upgrade history?

And could you also you send us all your error and upgrade logs - the contents of the App_Data\Sitefinity\Logs directory? Also if feasible it would be a great help if you can send us your project (with any custom development included) and a backup of your database, which we'll restore on our SQL server instance with Turkish server collation.

All the best,
R. Atanasov
the Telerik team
Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

This thread is closed