[SqlException (0x80131904): Invalid column name 'isCyrillic'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3335088
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4679
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +89
System.Data.SqlClient.SqlDataReader.get_MetaData() +101
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +624
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3392
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +725
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +312
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +214
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +180
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +126
CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +228
[Exception: [DataConnection.HandleError]: Query: SELECT [PA_SummarizeInformation].[ItemID]
,[PA_SummarizeInformation].[ExhibitorID]
,[PA_SummarizeInformation].[ProjectID] AS ProjectID
,IIF(COALESCE([NameRu],[PA_Exhibitor].[Name]) = '', [PA_Exhibitor].[Name],COALESCE([NameRu],[PA_Exhibitor].[Name])) AS [NameRu]
,IIF(COALESCE([NameEn],[PA_Exhibitor].[Name]) = '', [PA_Exhibitor].[Name],COALESCE([NameEn],[PA_Exhibitor].[Name])) AS [NameEn]
,(SELECT [NameRu] FROM [PA_Country] WHERE [ItemID] = [CountryRu]) AS CountryRu
,(SELECT [NameEn] FROM [PA_Country] WHERE [ItemID] = [CountryEn]) AS CountryEn
,(SELECT [NameRu] FROM [PA_Pavilion] WHERE [ItemID] = [PA_ExhibitorProject].[PlaceOnePavilionID]) AS [PavilionRu]
,(SELECT [NameEn] FROM [PA_Pavilion] WHERE [ItemID] = [PA_ExhibitorProject].[PlaceOnePavilionID]) AS [PavilionEn]
,[PA_ExhibitorProject].[PlaceOnePavilionID] AS PavilionID
,[PA_ExhibitorProject].[PlaceOneStand] AS Stand
,(SELECT [NameRu] FROM [PA_Pavilion] WHERE [ItemID] = [PA_ExhibitorProject].[PlaceTwoPavilionID]) AS [Pavilion2Ru]
,(SELECT [NameEn] FROM [PA_Pavilion] WHERE [ItemID] = [PA_ExhibitorProject].[PlaceTwoPavilionID]) AS [Pavilion2En]
,[PA_ExhibitorProject].[PlaceTwoPavilionID] AS PavilionID2
,[PA_ExhibitorProject].[PlaceTwoStand] AS Stand2
,(SELECT [NameRu] FROM [PA_Pavilion] WHERE [ItemID] = [PA_ExhibitorProject].[PlaceThreePavilionID]) AS [Pavilion3Ru]
,(SELECT [NameEn] FROM [PA_Pavilion] WHERE [ItemID] = [PA_ExhibitorProject].[PlaceThreePavilionID]) AS [Pavilion3En]
,[PA_ExhibitorProject].[PlaceThreePavilionID] AS PavilionID3
,[PA_ExhibitorProject].[PlaceThreeStand] AS Stand3
,[PA_SummarizeInformation].[Condition]
FROM [PA_ExhibitorProject]
LEFT JOIN [PA_SummarizeInformation] ON [PA_SummarizeInformation].[ProjectID] = [PA_ExhibitorProject].[ProjectID] AND [PA_SummarizeInformation].[ExhibitorID] = [PA_ExhibitorProject].[ExhibitorID]
LEFT JOIN [PA_Exhibitor] ON [PA_Exhibitor].[ItemID] = [PA_ExhibitorProject].[ExhibitorID]
WHERE [PA_ExhibitorProject].[ProjectID] = '148'
ORDER BY [isCyrillic] DESC, REPLACE(IIF(COALESCE([NameRu],[PA_Exhibitor].[Name]) = '', [PA_Exhibitor].[Name],COALESCE([NameRu],[PA_Exhibitor].[Name])),'"','') ASC: caused exception: Invalid column name 'isCyrillic'.]
CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, SqlException ex) +119
CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +317
CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query) +268
CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query) +498
CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords) +110
CMS.Controls.CMSAbstractQueryProperties.LoadData(Boolean forceReload, Int32 offset, Int32 maxRecords, Int32& totalRecords) +2150
CMS.Controls.CMSQueryDataSource.GetDataSource(Int32 offset, Int32 maxRecords) +171
CMS.Controls.CMSBaseDataSource.get_DataSource() +26
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender(EventArgs e) in e:\www\MSK\CMSWebParts\Viewers\Basic\BasicRepeater.ascx.cs:465
System.Web.UI.Control.PreRenderRecursiveInternal() +132
System.Web.UI.Control.PreRenderRecursiveInternal() +227
System.Web.UI.Control.PreRenderRecursiveInternal() +227
System.Web.UI.Control.PreRenderRecursiveInternal() +227
System.Web.UI.Control.PreRenderRecursiveInternal() +227
System.Web.UI.Control.PreRenderRecursiveInternal() +227
System.Web.UI.Control.PreRenderRecursiveInternal() +227
System.Web.UI.Control.PreRenderRecursiveInternal() +227
System.Web.UI.Control.PreRenderRecursiveInternal() +227
System.Web.UI.Control.PreRenderRecursiveInternal() +227
System.Web.UI.Control.PreRenderRecursiveInternal() +227
System.Web.UI.Control.PreRenderRecursiveInternal() +227
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3671
|