Copied to clipboard

Flag this post as spam?

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


  • Jordi 25 posts 47 karma points
    Jan 19, 2012 @ 13:38
    Jordi
    0

    Not working for 4.7.1

    Hello

    I have installed de datatype, but when I try to update it with new values (Parent filter and Document alias filter)  there is an error. I find this Datatype very useful for multilingual sites.

    Thanks

    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.
      en System.Data.SqlServerCe.SqlCeParameterCollection.Validate(Int32 index, SqlCeParameter value)
      en System.Data.SqlServerCe.SqlCeParameterCollection.AddWithoutEvents(Int32 index, SqlCeParameter value)
      en System.Data.SqlServerCe.SqlCeParameterCollection.Add(SqlCeParameter value)
      en SqlCE4Umbraco.SqlCeApplicationBlock.AttachParameters(SqlCeCommand command, SqlCeParameter[] commandParameters)
      en SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

    Descripción: Excepción no controlada al ejecutar la solicitud Web actual. Revise el seguimiento de la pila para obtener más información acerca del error y dónde se originó en el código.

    Detalles de la excepción: SqlCE4Umbraco.SqlCeProviderException: Error running NonQuery:
    SQL Statement:
    insert into cmsDataTypePreValues (datatypenodeid,[value],sortorder,alias) values (@dtdefid,@value,0,'')

  • Berto 105 posts 177 karma points
    Jan 19, 2012 @ 13:50
    Berto
    0

    Hi Jordi,

    I'm going to see whats wrong. 

     

    See you soon.

  • Berto 105 posts 177 karma points
    Jan 20, 2012 @ 13:20
    Berto
    0

    Hi Jordi,

    The is not the version of umbraco, mas the SqlCE. Sorry about the response time, but this was the first time that i used SqlCE and I got some problems to get it to work.

    Ok, so the SqlCE doesn't accept the Sql Parameters like the normal Sql Server, but is was a quick fix ;)

    If you wan't to get the correction now, just download this zip with the dll files and put the dll's on the bin of site (overwrite the one's already there). This were compiled on debug mode, and I also include the pdb file, just in case you need to debug.

    http://dl.dropbox.com/u/143276/Berto.UltimatePicker.Binaries.zip

    I'm going to do some more tests before I upload the new packgage.

    Thank for using this package ;)

  • Jordi 25 posts 47 karma points
    Jan 20, 2012 @ 18:49
    Jordi
    0

    Hello Berto

    Thanks for your quick response. The error database has been fixed. Nevertheless I don't get the results as expected.

    My multilingual site is like this:
    - Content
     - Web (GlobalHome)
       - es (Homepage)
         - productos (ListOfProducts)
           - producto1 (Product)
           - producto2 (Product)
       - en (Homepage)
         - products (ListOfProducts)
           - product1 (Product)
           - product2 (Product)

    The Berto Ultimate Picker is parametrized as this:
    - Database datatype: nvarchar
    - Type: checkboxlist
    - Parent Filter: ListOfProducts
    - Document Alias Filter: Product
    - ShowGrandChildren: yes

    When using a document type that uses this datatype, it appears producto1 and producto2 both in the content of 'es' and 'en'. It looks like it goes to the GlobalHome and then goes down to the first ListOfProducts that it finds, which is always in the 'es' tree.

    Am I using the DataType correctly? Is good for only one language, but not for multilingual.

    Thank you!

  • Berto 105 posts 177 karma points
    Jan 20, 2012 @ 19:07
    Berto
    0

    Hi Jordi, Are you using the data type on the "Homepage" Doc type? All the configuration you have seems ok.

    Also, I made this data type before the release of the uComponents, now for multilingual sites i use their picker, if you having trouble with this one. But nevertherless i'm going to see if my data type is working ok and i'll report to you soon.

    Thanks

  • Jordi 25 posts 47 karma points
    Jan 20, 2012 @ 21:17
    Jordi
    0

    Hello Berto

    I have followed your advise and with uComponents xPathCheckBoxList  I get the checkboxes correctly in multilingual. That's perfect.

    Thanks for all your help.

Please Sign in or register to post replies

Write your reply to:

Draft