I encounter the same problem in Umbraco 4.5.2 (MySQL) while trying to copy one or multiple content nodes.
The error message is:
Error updating item: umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'DATAINT' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters) at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(String connectionString, String commandText, MySqlParameter[] parms) at umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteNonQuery(String commandText, MySqlParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) --- End of inner exception stack trace --- at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) at umbraco.cms.businesslogic.datatype.DefaultData.set_Value(Object value)
MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'DATAINT' at row 1
When I copy a folder with content in it, Umbraco fails with this bug:
MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'DATAINT' at row 1
Is this a known bug?
Hi,
I encounter the same problem in Umbraco 4.5.2 (MySQL) while trying to copy one or multiple content nodes.
The error message is:
Is there already a solution for this issue?
Best regards,
Jeroen
is working on a reply...