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)
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 ?
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.
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 ?
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.
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 :-)
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)
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
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 ?
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
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 ?
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
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
Hi Dennis,
Migration from SQLCE to a MSSQL database is done successfully on my local machine through MS WebMatrix.Thank you.
Hi Thomas,
Great that you managed to do the migration from SQLCE to a MSSQL database through Microsoft WebMatrix.
/Dennis
is working on a reply...