Incorrect datetime value column timestamp
Posted: Wed 08 Jul 2009 21:55
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.
[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.