Devart Forums

Ok I tried another simple test app using 5.20.33 trial. I get the following error;


[MySqlException (0x80004005): Incorrect datetime value: '00010101000000' for column 'timestamp' at row 1]
Devart.Data.MySql.ah.o() +270
Devart.Data.MySql.ah.c() +200
Devart.Data.MySql.t.a(ad[]& A_0, Int32& A_1) +134
Devart.Data.MySql.t.a(Byte[] A_0, Int32 A_1, Boolean A_2) +106
Devart.Data.MySql.a3.e() +188
Devart.Data.MySql.a3.o() +89
Devart.Data.MySql.MySqlCommand.a(CommandBehavior A_0, IDisposable A_1, Int32 A_2, Int32 A_3) +1376
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) +310
System.Data.Common.DbCommand.ExecuteReader() +12
Devart.Common.DbCommandBase.ExecuteNonQuery() +64
Devart.Data.Linq.Provider.DataProvider.a(String A_0, IList`1 A_1, IDbCommand& A_2) +537
Devart.Data.Linq.v.b(MetaType A_0, q A_1, Boolean A_2) +2541
Devart.Data.Linq.x.a(h A_0, Object A_1, ModifiedMemberInfo[] A_2, Boolean A_3) +423
Devart.Data.Linq.j.a(x A_0, h A_1, Boolean A_2) +143
Devart.Data.Linq.j.a(DataContext A_0, ConflictMode A_1) +2581
Devart.Data.Linq.j.b(DataContext A_0, ConflictMode A_1) +49
Devart.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode) +412
Devart.Data.Linq.DataContext.SubmitChanges() +30
CN.Index.btnSubmit_Click(Object sender, EventArgs e)
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111


using the following code



protected void btnSubmit_Click(object sender, EventArgs e)
{
using (projectdatacontext dc = new projectdatacontext())
{
account a = new account();
a.email = txtEmail.Text;
dc.accounts.InsertOnSubmit(a);
dc.SubmitChanges();
}
}



The account table has a timestamp field with "CURRENT_TIMESTAMP" as the default value NOT NULL.

I am using 5.20.33 trial. I get the following error;

[NullReferenceException: Object reference not set to an instance of an object.]
lambda_method(ExecutionScope , Object ) +29
Devart.Data.Linq.s.a(Object A_0) +57
Devart.Data.Linq.e.a(Object A_0) +40
Devart.Data.Linq.e.a(h A_0, Object A_1, Boolean A_2) +132
Devart.Data.Linq.e.a(h A_0, Object A_1, Boolean A_2, Boolean A_3) +131
Devart.Data.Linq.j.a(h A_0, Object A_1, Boolean A_2, Boolean A_3) +79
Devart.Data.Linq.j.g(h A_0) +43
Devart.Data.Linq.r.a(Object A_0, PropertyChangingEventArgs A_1) +45
cn.ProjectCore.Core.Domain.account.SendPropertyChanging()
cn.ProjectCore.Core.Domain.account.set_lastlogindate(Nullable`1 value)
cn.ProjectCore.Core.DataAccess.Impl.AccountRepository.SaveLastLogin(account account)



When excuting this code;


public void SaveLastLogin(account account)
{
using (ProjectDataContext dc = conn.GetContext())
{
account.lastlogindate = DateTime.Now;
if (account.accountid > 0)
{
dc.accounts.Attach(account, true);
}
dc.SubmitChanges();
}
}



The datetime field allows nulls. Anyone know why this occuring? Thanks.