Copied to clipboard

Flag this post as spam?

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


  • Wesley Herpoelaert 52 posts 123 karma points
    Apr 22, 2015 @ 11:19
    Wesley Herpoelaert
    0

    Hi Matt,

    Thanks for updating this great package!

    When I'm using the package with a SQL CE database I reveice the following postsave error:

    {"Message":"An error has occurred.","ExceptionMessage":"Keyword not supported: 'flush interval'.","ExceptionType":"System.ArgumentException","StackTrace":"   at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)\r\n   at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)\r\n   at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)\r\n   at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)\r\n   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)\r\n   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)\r\n   at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)\r\n   at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential)\r\n   at Our.Umbraco.UnVersion.Services.UnVersionService.UnVersion(IContent content)\r\n   at Our.Umbraco.UnVersion.Bootstrap.ContentServicePublished(IPublishingStrategy sender, PublishEventArgs`1 e)\r\n   at Umbraco.Core.Events.TypedEventHandler`2.Invoke(TSender sender, TEventArgs e)\r\n   at Umbraco.Core.Services.ContentService.SaveAndPublishDo(IContent content, Int32 userId, Boolean raiseEvents)\r\n   at Umbraco.Web.Editors.ContentController.PostSave(ContentItemSave contentItem)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.<GetExecutor>b__c(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n   at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)"}
    

    Wesley

  • Arjan Woldring 124 posts 231 karma points
    May 01, 2015 @ 16:35
    Arjan Woldring
    0

    Having the same problem. Would be great if SQL CE is supported too.

  • Shola 65 posts 273 karma points
    Jul 20, 2015 @ 17:47
    Shola
    0

    Having the same exact problem as well. However, I'm starting to think the solution is to stop using SQL CE if at all possible. CE won't be compatible with Windows 10.

  • CB 10 posts 31 karma points
    May 02, 2016 @ 22:02
    CB
    0

    Add my vote as well to this issue. How can we make packages that don't support native database types that the CMS is compatible with!?

    Awesome package, but won't work on any of our sites...

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    May 03, 2016 @ 05:17
    Jan Skovgaard
    0

    Hi CB

    I get that you feel frustrated about this nice package not working with the CE SQL database. But keep in mind that it's a time consuming task to develop and maintain packages. And do keep in mind that it's something people are doing voulentarily because they create something awesome that they want others to benefit from - But sometimes one can easily forget how many databases it needs to be compatible with, which can make it more complex to make sure it works on every single database. CE SQL for instance uses a subset of the SQL that MSSQL supports, which I suspect is the reason that you guys are experiencing these issues. According to the release notes on the package page it seems that CE SQL should be supported since version 1.3 - However this package has existed for some years and a lot have happened since then so things might have changed in the CE SQL database or maybe it's something in Umbraco that has changed meaning that the package is no longer working with CE SQL. Or perhaps it's because an old version of CE SQL is being used - There can be a lot of uncovered scenarios that the package author would have no chance of knowing about.

    I say this just so that you keep in mind that the creator or the package has probably only had the best intentions but is probably struggling with keeping up supporting all the released packages he has made. I'm sure a pull request to the source code with a fix for this issue would be very much appreciated - However I'm also aware that not everyone is capable of doing that - I myself would not know where and what to look for in this case. But perhaps you have the skills to do it? Or maybe you know someone else who has the skills and can go and fix it for instance? - That would help not only you but others as well and especially the creator of the package too.

    Like I said I get that you're frustrated but keep in mind how comments can affect the motivation and willingness for people to keep contributing and do their best - that's all :)

    Ok, that being said I'm wondering what version of Umbraco that you guys are using? And is it failing locally or is it on some hosted environments that it's failing? I recall seeing this error message before in another context and perhaps the advice Sebastiaan is giving here could solve things in this scenario? https://our.umbraco.org/forum/umbraco-7/using-umbraco-7/52871-Umbraco-7-not-possible-in-production-with-sql-ce#comment-183933

    Cheers, Jan

  • Dennis Adolfi 1082 posts 6445 karma points MVP 5x c-trib
    May 03, 2016 @ 08:02
    Dennis Adolfi
    1

    Very nice read Jan, as always! :)

    I just thought I´ll chip in that one option for CB, Shola, Arjan and Wesley could be to convert their CE database to a MsSql server database. Thats what i´ve done on a few occasions when a package i really wanted did´nt support CE.

    Its might sound scary and timeconsuming, but it´s acctually not very tricky, takes less than an hour and i usally follow this great tutorial http://www.geektantra.com/2012/10/umbraco-deployment-exporting-ms-sql-ce-database-to-ms-sql-server-express/ and have never had any problems with it.

    I understand that this might not be an answer to everyone, but it might be an option for some.

    Best of luck everyone!!

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    May 03, 2016 @ 08:07
    Jan Skovgaard
    1

    Why thank you Dennis :) - Likewise!

    Yes migrating from CE SQL to MSSQL will of course solve the issue. But as you mention it might not be the solution for everyone since it can be an additional cost to have a MSSQL database, which not everyone / project / company for some reason can afford.

    Webmatrix also has a nice "migrate" feature - So if one chooses the "Database" tab then in the ribbon that appears there is a "Migrate" ribbon in the top right corner, which will become green when one has chosen the database to migrate.

    Just my 2 cents on the migrate option :)

    /Jan

  • Shola 65 posts 273 karma points
    May 03, 2016 @ 14:46
    Shola
    101

    Since MS SQL Express is free, hopefully affordability is not an issue. Furthermore, not only is CE incompatible with Windows 10, but also CE is in deprecation mode itself. I've heard from Umbraco HQ that they're working to eventually move away from CE for these reasons. Perhaps one of their alternatives is LocalDB, but my advice now is to permanently migrate off of CE if at all possible, to avoid future issues well outside of this plugin.

  • Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib
    May 03, 2016 @ 14:55
    Jan Skovgaard
    1

    Ah yes! Totally forgot about the Express edition - you're absolutely right :)

    Ooops, hit the wrong button when wanting to respons - answering from my phone and my fingers are simply too big so by mistake I marked this post as solvef, which is not the case. My bad #h5is

Please Sign in or register to post replies

Write your reply to:

Draft