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

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

Postby 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
Kai Korla
 
Posts: 19
Joined: Tue 19 Sep 2006 16:44

Postby Alexey » Wed 20 Sep 2006 08:33

We found the error. Look forward to the next build.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Kai Korla » Wed 20 Sep 2006 08:40

Thank you.

regards
Kai Korla
INDEV
Kai Korla
 
Posts: 19
Joined: Tue 19 Sep 2006 16:44

Postby Alexey » Wed 20 Sep 2006 08:48

You are welcome.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Kai Korla » Thu 21 Sep 2006 06:51

Dear,

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

regards
Kai Korla
INDEV
Kai Korla
 
Posts: 19
Joined: Tue 19 Sep 2006 16:44

Postby Alexey » Thu 21 Sep 2006 07:56

No, the 13th build was scheduled before this issue became known.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Kai Korla » Thu 21 Sep 2006 19:46

Dear,

when this bug will be fixed (date)?

regards
Kai Korla
INDEV
Kai Korla
 
Posts: 19
Joined: Tue 19 Sep 2006 16:44

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Kai Korla » Fri 06 Oct 2006 17:04

Dear,

any news about a new release?

regards
Kai Korla
Kai Korla
 
Posts: 19
Joined: Tue 19 Sep 2006 16:44

Postby Alexey » Tue 10 Oct 2006 13:51

We are going to send you new CoreLab.MySql.Web.dll. Look forward to receiving it.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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
Kai Korla
 
Posts: 19
Joined: Tue 19 Sep 2006 16:44

Postby Alexey » Wed 11 Oct 2006 15:12

I've just sent it to you. Please check.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL