ASP.NET: CoreLab.MySql.Web.dll issue

Kai Korla · Post by **Kai Korla** » Tue 19 Sep 2006 16:54

Error
Session.Abandon(); fires following Exception due to wrong SQL Syntax:

[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 '* FROM aspnet_sessions WHERE sessionid = 'abj4im55kh1yuh45gqion545' AND applicat' at line 1]
CoreLab.Common.Web.Providers.DbSessionStateStore.RemoveItem(HttpContext context, String id, Object lockId, SessionStateStoreData item) +387
System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +434
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +167
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +117

.NET Reflector gives the following output for this function:

Code: Select all

public override void RemoveItem(HttpContext context, string id, object lockId, SessionStateStoreData item)
{
      DbConnection connection1 = this.i.CreateConnection();
      connection1.ConnectionString = this.b;
      IDbCommand command1 = this.a("DELETE * FROM aspnet_sessions WHERE sessionid = :sessionid AND applicationname = :applicationname AND lockid = :lockid", connection1);
      command1.Parameters.Add(this.a("sessionid", DbType.String, 80, id));
      command1.Parameters.Add(this.a("applicationname", DbType.String, 0xff, this.ApplicationName));
      command1.Parameters.Add(this.a("lockid", DbType.Int32, lockId));
      try
      {
            connection1.Open();
            command1.ExecuteNonQuery();
      }
      catch (Exception exception1)
      {
            if (this.WriteExceptionsToEventLog)
            {
                  this.a(exception1, "RemoveItem");
                  throw new ProviderException(this.g);
            }
            throw exception1;
      }
      finally
      {
            connection1.Close();
      }
}

I think that "DELETE * FROM tablename..." is wrong syntax. It must be "DELETE FROM tablename...".
Please fix that bug asap, 'cause we need it for our web projects.

regards
Kai Korla
INDEV

Alexey · Post by **Alexey** » Wed 20 Sep 2006 08:33

We found the error. Look forward to the next build.

Kai Korla · Post by **Kai Korla** » Wed 20 Sep 2006 08:40

Thank you.

regards
Kai Korla
INDEV

Alexey · Post by **Alexey** » Wed 20 Sep 2006 08:48

You are welcome.

Kai Korla · Post by **Kai Korla** » Thu 21 Sep 2006 06:51

Dear,

is the bug above fixed in the new *.13 build?

regards
Kai Korla
INDEV

Alexey · Post by **Alexey** » Thu 21 Sep 2006 07:56

No, the 13th build was scheduled before this issue became known.

Kai Korla · Post by **Kai Korla** » Thu 21 Sep 2006 19:46

Dear,

when this bug will be fixed (date)?

regards
Kai Korla
INDEV

Alexey · Post by **Alexey** » Fri 22 Sep 2006 09:58

I can't give you the exact date. Probably it will be fixed by the end of the next week.

Kai Korla · Post by **Kai Korla** » Fri 06 Oct 2006 17:04

Dear,

any news about a new release?

regards
Kai Korla

Alexey · Post by **Alexey** » Tue 10 Oct 2006 13:51

We are going to send you new CoreLab.MySql.Web.dll. Look forward to receiving it.

Kai Korla · Post by **Kai Korla** » Wed 11 Oct 2006 14:27

Dear,

what you mean with "send you new CoreLab....."? I did not receive anything.

regards
Kai Korla

Alexey · Post by **Alexey** » Wed 11 Oct 2006 15:12

I've just sent it to you. Please check.