WIndows Live Writer Publishing Issue SQLCE

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

What operating system were you running when the bug appeared?
What database platform is your site using?
What version of mojoPortal are you running?
What version of .NET do you use?
What steps are necessary to reproduce the issue? Compare expected results vs actual results.

This thread is closed to new posts. You must sign in to post in the forums.

7/19/2010 4:26:11 AM

loginitin

Total Posts 47

View Posts

Windows Live Writer Publishing Issue SQLCE

Namaste :)

When we publish a post thru windows live writer in 'Blog' (SQL CE) the post is not visible in the site. Query tool shows that the ModuleID field of the new record is 6 instead of usual '1' screenshot: http://img837.imageshack.us/img837/600/97980189.png

After updating the record :http://img840.imageshack.us/img840/6021/23430892.png the post is visible in the blog :). Is there any setting i'm missing out in live writer?

thanks,

nitin

7/20/2010 9:48:46 AM

loginitin

Total Posts 47

View Posts

Re: WIndows Live Writer Publishing Issue SQLCE

UPdate:

The post shows in the 'List' page but not in the individual post page, it shows a blank page with just the site header and footer.

System Info:

mojoPortal Version 2.3.4.8 SqlCe

Operating System Microsoft Windows NT 6.0.6002 Service Pack 2

ASP.NET Version v4.0.30319 Running in Full Trust

Server Time Zone Central Daylight Time

any help would be nice :)

thanks n regards,

nitin

7/20/2010 10:16:43 AM

Joe Audette

Total Posts 18439

View Posts

Re: WIndows Live Writer Publishing Issue SQLCE

Hi Nitin,

There is nothing special about the moduleid it will vary depending on when the module instance is created. It is just an autoidentity integer column, so when any module instance of any feature is created it increments to give the module a new id.

I just tested on my local machine and Live Writer worked fine. Maybe if your local machine is using different time zone than the site it could be the post is created with a future start date and will only show up after the publish time. If your site and your user profile are configured to the same time zone as your local machine and the time is correct on your local machine and on the server it should work.

Hope it helps,

Joe

7/20/2010 8:33:02 PM

loginitin

Total Posts 47

View Posts

Re: WIndows Live Writer Publishing Issue SQLCE

Thanks for the reply :)

The issue doesn't seem to be related to 'Publishing date' i've set the date to the past month and its still not showing. Please note only the posts added thru live writer are not showing on the post page but are visible in the blog's post list page. Downloaded the database and trying to delete the post when we get the error.

There was an error parsing the query. [ Token line number = 1,Token line offset = 43,Token in error = SELECT ]

will delete the post using SQL and check locally if they are showing fine then will upload :)

Ps. dunno wht's wrong with live writer, used to work fine with the Mojo SQLite

thanks for your time :)

7/20/2010 8:42:24 PM

loginitin

Total Posts 47

View Posts

Re: Windows Live Writer Publishing Issue SQLCE

Detailed exception

	[SqlCeException: There was an error parsing the query. [ Token line number = 1,Token line offset = 43,Token in error = SELECT ]]
   System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) +29
   System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan() +607
   System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) +587
   System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery() +21
   mojoPortal.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +136
   mojoPortal.Data.DBBlog.UpdateCommentStats(Int32 moduleId) +239
   mojoPortal.Business.Blog.Delete() +32
   mojoPortal.Web.BlogUI.BlogEdit.btnDelete_Click(Object sender, EventArgs e) +82
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Hope it helps go through the issue,

thanks,

nitin

7/21/2010 7:57:00 AM

Joe Audette

Total Posts 18439

View Posts

Re: WIndows Live Writer Publishing Issue SQLCE

Hi Nitin,

Thanks for that, I was able to find the syntax mistake. I've updated the code in the repository and will try to make an updated package for SQL CE soon.

Not sure why it would be any different using Live Writer vs the web page to create posts, the syntax error should have happened in both cases.

Please let me know if you find any other errors.

Best,

Joe

7/23/2010 8:09:42 AM

Joe Audette

Total Posts 18439

View Posts

Re: WIndows Live Writer Publishing Issue SQLCE

Hi Nitin,

I've updated the package mojoportal-2-3-4-8-sqlce-net40-deploymentfiles.zip. If you download it again it has this issue fixed.

Thanks,

Joe

7/23/2010 9:54:42 AM

loginitin

Total Posts 47

View Posts

Re: WIndows Live Writer Publishing Issue SQLCE

thanks Joe,

for a quick solution and ur time n effort :)

You must sign in to post in the forums. This thread is closed to new posts.