Copied to clipboard

Flag this post as spam?

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


  • MikeD 92 posts 112 karma points
    Jul 16, 2012 @ 23:11
    MikeD
    0

    mySQL Error when logging out of Admin

    Anyone have an answer for this?  It happens whenever I log out of Umbraco Admin when using mysql as the database.

     

    Server Error in '/' Application.

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE CONTEXTID = '84c91150-7245-405e-b386-bf2a41922e33'' at line 1

    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: MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE CONTEXTID = '84c91150-7245-405e-b386-bf2a41922e33'' at line 1

    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: 

    [MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE CONTEXTID = '84c91150-7245-405e-b386-bf2a41922e33'' at line 1]
       MySql.Data.MySqlClient.MySqlStream.OpenPacket() +301
       MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +59
       MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +64
       MySql.Data.MySqlClient.MySqlDataReader.NextResult() +977
       MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1829
       MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() +33
       MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters) +180
       MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms) +110
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +150
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +261
       umbraco.BasePages.BasePage.ClearLogin() +143
       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
       umbraco.BasePages.BasePage.OnLoad(EventArgs e) +19
       System.Web.UI.Control.LoadRecursive() +71
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064
    


    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
  • Paul Blair 466 posts 731 karma points
    Jul 16, 2012 @ 23:36
    Paul Blair
    0

    it was a bug in 4.7.2: http://umbraco.codeplex.com/workitem/30805?PendingVoteId=30805

    will be fixed in 4.8

Please Sign in or register to post replies

Write your reply to:

Draft