Copied to clipboard

Flag this post as spam?

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


  • Lee Kelleher 4020 posts 15802 karma points MVP 13x admin c-trib
    Jul 19, 2011 @ 11:50
    Lee Kelleher
    0

    SQL CE4 support? (Terabyte Image Cropper)

    Just tried this out on my local Umbraco dev install (using SQL CE4) and got the following error in the Prevalue Editor:

    Error running NonQuery: 
    SQL Statement:
    insert into cmsDataTypePreValues (datatypenodeid,[value],sortorder,alias) values (@dtdefid,@value,0,'')
    
    Exception:
    System.ArgumentException: The SqlCeParameter is already contained by another SqlCeParameterCollection.
      at System.Data.SqlServerCe.SqlCeParameterCollection.Validate(Int32 index, SqlCeParameter value)
      at System.Data.SqlServerCe.SqlCeParameterCollection.AddWithoutEvents(Int32 index, SqlCeParameter value)
      at System.Data.SqlServerCe.SqlCeParameterCollection.Add(SqlCeParameter value)
      at SqlCE4Umbraco.SqlCeApplicationBlock.AttachParameters(SqlCeCommand command, SqlCeParameter[] commandParameters)
      at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

    Took a quick look at the source-code. Think it's because there are direct SQL statements being used in "ImageCropPreValue" ... these could be switched over to use the Umbraco core API (in "umbraco.cms.businesslogic.datatype.PreValue/PreValues")?

    Thanks, Lee.

Please Sign in or register to post replies

Write your reply to:

Draft