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
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.
it was a bug in 4.7.2: http://umbraco.codeplex.com/workitem/30805?PendingVoteId=30805
will be fixed in 4.8
is working on a reply...