Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Nik Wahlberg 639 posts 1237 karma points MVP
    Nov 16, 2010 @ 15:09
    Nik Wahlberg
    0

    SQL Error in RTE

    Hi all, I am seeing this eeror after upgrading to 4.5.2 from 4.0.3. 

    Incorrect syntax near 's'.
    Unclosed quotation mark after the character string ',@content)'.
    
    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 's'.
    Unclosed quotation mark after the character string ',@content)'.
    
    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 (0x80131904): Incorrect syntax near 's'.
    Unclosed quotation mark after the character string ',@content)'.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1951450
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849003
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2394
       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204
       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +56
       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +83
       umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) +113
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +140
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +222
       umbraco.cms.businesslogic.web.StyleSheet.MakeNew(User user, String Text, String FileName, String Content) +511
       umbraco.cms.businesslogic.web.StyleSheet.GetAll() +1368
       umbraco.editorControls.tinymce.tinyMCEPreValueConfigurator.OnLoad(EventArgs e) +3433
       System.Web.UI.Control.LoadRecursive() +50
       System.Web.UI.Control.LoadRecursive() +141
       System.Web.UI.Control.LoadRecursive() +141
       System.Web.UI.Control.LoadRecursive() +141
       System.Web.UI.Control.LoadRecursive() +141
       System.Web.UI.Control.LoadRecursive() +141
       System.Web.UI.Control.LoadRecursive() +141
       System.Web.UI.Control.LoadRecursive() +141
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

    Has any one else seen this error? Didn't find anything reported in the forums. 

    Cheers,
    Nik

  • Lee Kelleher 4026 posts 15836 karma points MVP 13x admin c-trib
    Nov 16, 2010 @ 15:25
    Lee Kelleher
    0

    Hey Nik,

    Is this happening when the content is being loaded into the RTE? or when you try to save/publish it?

    Looks like an apostrophe isn't being escaped somewhere?!

    Cheers, Lee.

  • Nik Wahlberg 639 posts 1237 karma points MVP
    Nov 16, 2010 @ 15:28
    Nik Wahlberg
    0

    Sorry, I should have been more specific, this happens in the Developer section when trying to view the details of the data type (the default Rich Text Editor dt). Very strange...other data types seem fine.

    Thanks! 

Please Sign in or register to post replies

Write your reply to:

Draft