Server Error in '/' Application.

Incorrect syntax near '2'.
Unclosed quotation mark after the character string '))))) ORDER BY NodeID desc'.

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: System.Data.SqlClient.SqlException: Incorrect syntax near '2'.
Unclosed quotation mark after the character string '))))) ORDER BY NodeID desc'.

Source Error:


Line 28: 
Line 29:         rptNewsList.StopProcessing = false;
Line 30:         rptNewsList.ReloadData(true);
Line 31:     }
Line 32: }

Source File: c:\inetpub\wwwroot\sbc-vietnam\CMSTemplates\ProjectCode\Tags.aspx.cs    Line: 30

Stack Trace:


[SqlException (0x80131904): Incorrect syntax near '2'.
Unclosed quotation mark after the character string '))))) ORDER BY NodeID desc'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +212
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2843
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +127
   System.Data.SqlClient.SqlDataReader.get_MetaData() +112
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6358932
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6360001
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +424
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +211
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +19
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +19
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +221
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +573
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +166
   CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +243

[Exception: [DataConnection.HandleError]: Query: SELECT  * FROM View_CONTENT_News_Joined WHERE ((((NodeSiteID = 2) AND (Published = 1)) AND (DocumentCulture = N'vi-VN')) AND ((DocumentID IN (SELECT DocumentID FROM CMS_DocumentTag WHERE TagID IN (SELECT TagID FROM CMS_Tag WHERE TagName like N'thời'' AND TagGroupID = '2'))))) ORDER BY NodeID desc: caused exception: Incorrect syntax near '2'.
Unclosed quotation mark after the character string '))))) ORDER BY NodeID desc'.]
   CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, SqlException ex) +177
   CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) +389
   CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query) +314
   CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query) +479
   CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords) +96
   CMS.DataEngine.ConnectionHelper.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords) +113
   CMS.TreeEngine.TreeProvider.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords) +159
   CMS.TreeEngine.TreeProvider.SelectNodes(NodeSelectionParameters parameters) +1422
   CMS.TreeEngine.TreeProvider.SelectNodes(String siteName, String aliasPath, String cultureCode, Boolean combineWithDefaultCulture, String classNames, String where, String orderBy, Int32 maxRelativeLevel, Boolean selectOnlyPublished, Int32 topN, String columns) +232
   CMS.Controls.CMSAbstractDataProperties.GetDataSet(String path, String where, Boolean forceReload) +3054
   CMS.Controls.CMSAbstractDataProperties.LoadData(Object& DataSource, Boolean forceReload) +138
   CMS.Controls.CMSRepeater.ReloadData(Boolean forceReload) +1548
   CMSTemplates_ProjectCode_Tags.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\sbc-vietnam\CMSTemplates\ProjectCode\Tags.aspx.cs:30
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42
   System.Web.UI.Control.OnLoad(EventArgs e) +132
   CMS.UIControls.ContentPage.OnLoad(EventArgs e) +50
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428


Version Information: Microsoft .NET Framework Version:2.0.50727.9055; ASP.NET Version:2.0.50727.9051