Copied to clipboard

Flag this post as spam?

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


  • Thomas T 66 posts 227 karma points
    Feb 17, 2015 @ 15:38
    Thomas T
    0

    Does SmartBlog support SQL CE database

    I installed SmartBlog 2.0.9 for Umbraco 7.1.6. When I click smart management console, it throws error like below... How can I resolve it...

    What are the changes should be made when I change database to MSSQL ?


    Server Error in '/' Application.


    Error running Reader: 
    SQL Statement:
    SELECT  umbracoNode.Id,umbracoNode.Text, isNull(CMSDocument.Published,0) as Published, DocType.Text as nodeTypeName  from umbracoNode Left Join cmsDocument ON umbracoNode.Id = cmsDocument.NodeId and Published = 1 INNER JOIN cmsContent ON umbracoNode.Id = cmsContent.NodeId INNER JOIN umbracoNode DocType ON cmsContent.contentType = DocType.Id and DocType.nodeObjectType = 'a2cb7800-f571-4787-9638-bc48539a0efb'  INNER JOIN cmsContentType ON cmsContent.contentType = cmsContentType.NodeId WHERE (umbracoNode.nodeObjectType = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')AND umbracoNode.ParentId <> -20And cmsContentType.alias = @Alias And isNull(CMSDocument.Published,0) = @Published

    Exception:
    System.Data.SqlServerCe.SqlCeException (0x80004005): The number of arguments specified for the function is not correct. [ Minimum argument count = 1, Maximum argument count = 1,Name of function(if known) = isNull ]
      at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
      at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
      at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
      at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior)
      at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    Feb 17, 2015 @ 15:50
    Dennis Aaen
    100

    Hi Thomas,

    Try to see this post https://our.umbraco.org/projects/starter-kits/smart-blog/help/56638-Error-on-management-on-clean-install, the SmartBlog does not works with MySQL and SQLCE. at the moment as far as I can see.

    Hope this helps,

    /Dennis

  • Thomas T 66 posts 227 karma points
    Feb 17, 2015 @ 16:21
    Thomas T
    0

    Hi Dennis,

                    I saw the post.But I can't find solution. He said sql script is not compatible with MySQL and SQLCE. Suppose if it is need to move to MSSQL, how can I do it ?

  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    Feb 17, 2015 @ 16:32
    Dennis Aaen
    0

    Hi Thomas.

    You can migrate an SQLCE database really easy if you have Microsoft Webmatrix installed on your machine, try to open up your solution in Webmatrix, and then you will see a tab in the left corner called databases, then you will get access to the database tables. From there you can mark the database file called Umbraco.sdf, and click the migrate button.

    Try to see this guide on how to do it http://www.microsoft.com/web/post/migrate-a-database-to-sql-server

    Hope this helps,

    /Dennis

  • Thomas T 66 posts 227 karma points
    Feb 17, 2015 @ 16:42
    Thomas T
    0

    Hi Dennis,

                   Currently, I am working with both local and remote sites...I can see database workspace in local site but can't in remote...In such case, how can I migrate to MSSQL ?

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Feb 17, 2015 @ 16:51
    Jan Skovgaard
    0

    Hi Thomas

    If you're running CE SQL locally then you just need to install webmatrix and then migrate to a database created on your MSSQL instance. You'll need to create an empty database first of course. But once the DB is setup you should be able to migrate it using the relevant credentials to access MSSQL.

    Does that make sense? :)

    /Jan

  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    Feb 17, 2015 @ 16:55
    Dennis Aaen
    0

    Hi Thomas,

    The approach that I think you can use is to first migrate the SQLCE database on your local machine to a MSSQL database, when you have done this, then take a backup of the MSSQL database. When you taken the backup, then login to your server on your remote sites, and install the backup of the MSSQL database.

    Remember to point the connection strings to the new MSSQL database on your different environments :-)

    Hope this helps, and make sense.

    /Dennis

  • Thomas T 66 posts 227 karma points
    Feb 18, 2015 @ 12:11
    Thomas T
    0

    Hi Dennis,

                     Migration from SQLCE  to a MSSQL database is done successfully on my local machine through MS WebMatrix.Thank you.

  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    Feb 18, 2015 @ 13:06
    Dennis Aaen
    0

    Hi Thomas,

    Great that you managed to do the migration from SQLCE to a MSSQL database through Microsoft WebMatrix.

    /Dennis

Please Sign in or register to post replies

Write your reply to:

Draft