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.
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,'')
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.
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.
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.
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:
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.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)
Detalles de la excepción: SqlCE4Umbraco.SqlCeProviderException: Error running NonQuery:
SQL Statement:
insert into cmsDataTypePreValues (datatypenodeid,[value],sortorder,alias) values (@dtdefid,@value,0,'')
Hi Jordi,
I'm going to see whats wrong.
See you soon.
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 ;)
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!
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
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.
is working on a reply...