Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Martin 44 posts 66 karma points
    Dec 21, 2010 @ 15:49
    Martin
    0

    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?

  • Jeroen de Visser 5 posts 25 karma points
    May 10, 2011 @ 09:46
    Jeroen de Visser
    0

    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:

    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)

    Is there already a solution for this issue?

    Best regards,
    Jeroen

Please Sign in or register to post replies

Write your reply to:

Draft