Copied to clipboard

Flag this post as spam?

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


  • Michael Sims 119 posts 387 karma points
    Feb 17, 2013 @ 20:55
    Michael Sims
    0

    uBlogsy error after Umbraco 6 upgrade

    Hey.
    I am getting this problem after upgrading to Umbraco 6. I am getting the following error:

     

    2013-02-17 19:50:01,448 [5] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 41] Error executing query Select [value] from cmsDataTypeprevalues where id in ()

    System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)

       at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) in c:\Program Files (x86)\teamcity\buildAgent\work\e145e9ed82478b40\src\umbraco.datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line 93

       at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in c:\Program Files (x86)\teamcity\buildAgent\work\e145e9ed82478b40\src\umbraco.datalayer\SqlHelper.cs:line 250

    2013-02-17 19:50:01,573 [5] ERROR umbraco.presentation.publishingService - [Thread 41] Error publishing node 11348

    System.NullReferenceException: Object reference not set to an instance of an object.

       at uBlogsy.BusinessLogic.ConfigReader.get_Instance() in D:\_PROJECTS\Personal\uBlogsy - Blog\Branches\2.1.0.0\uBlogsy\uBlogsy.BusinessLogic\ConfigReader.cs:line 39

       at uBlogsy.BusinessLogic.EventHandlers.UmbracoExtensions.Document_AfterSave(Document sender, SaveEventArgs e) in D:\_PROJECTS\Personal\uBlogsy - Blog\Branches\2.1.0.0\uBlogsy\uBlogsy.BusinessLogic\EventHandlers\UmbracoEventHandlers.cs:line 57

       at umbraco.cms.businesslogic.web.Document.SaveEventHandler.Invoke(Document sender, SaveEventArgs e)

       at umbraco.cms.businesslogic.web.Document.FireAfterSave(SaveEventArgs e)

       at umbraco.cms.businesslogic.web.Document.SaveAndPublish(User u)

       at umbraco.presentation.publishingService.CheckPublishing(Object sender)

    Any ideas anyone?

  • Francisco 21 posts 72 karma points
    Feb 18, 2013 @ 02:33
    Francisco
    0

    I have the same error here after upgrading to v6, but it is not related to uBlogsy

     

    2013-02-18 14:27:39,327 [27] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - [Thread 7] Error executing query Select [value] from cmsDataTypeprevalues where id in ()

    System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near ')'.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

       at System.Data.SqlClient.SqlDataReader.get_MetaData()

       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

       at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)

       at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)

       at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)

  • Anthony Dang 1404 posts 2558 karma points MVP 3x c-trib
    Feb 18, 2013 @ 14:08
    Anthony Dang
    0

    uBlogsy works with v6, but the comment subscription part does not due to breaking changes in v6.

    You might be missing dlls in your bin dir?

     

  • Brandon Hines 15 posts 45 karma points
    Mar 01, 2013 @ 01:57
    Brandon Hines
    0

    Anthony,

     

    I have issues with the comments after upgrading to 6.  Is Comments supposed to be broken or just subscription?

     

    I get An error has occurred. Please try again later.   regardless of if I select subscribe or not.

  • Anthony Dang 1404 posts 2558 karma points MVP 3x c-trib
    Mar 01, 2013 @ 11:17
    Anthony Dang
    0

    Comments and subscriptions do not work because of the breaking changes in v6.

    If I were you, I'd stick with 4.11.5. Or if you really need v6, you could remove the contact control from the page and use something like disqus.

    I'm trying to figure out the best way to get the current webforms uBlogsy to work in v6, but atm I don't really have an ETA.

     

     

  • Brandon Hines 15 posts 45 karma points
    Mar 07, 2013 @ 07:10
    Brandon Hines
    0

    Trying to downgrade to 4.11.5 but having issues with the database.  Any suggestions?  At this point it looks like I may need to install fresh and try to copy data over.

  • Anthony Dang 1404 posts 2558 karma points MVP 3x c-trib
    Mar 07, 2013 @ 12:49
    Anthony Dang
    0

    Fresh install. Less pain.

     

  • Brandon Hines 15 posts 45 karma points
    Mar 07, 2013 @ 19:05
    Brandon Hines
    0

    Thanks.  I'm getting this as well on the Main Content page.  I have not done a fresh install yet though.  I'll do that and let you know.

     

    Stack Trace: 

     

     

    [NullReferenceException: Object reference not set to an instance of an object.]

       umbraco.cms.businesslogic.web.Document.get_Text() +12

       uBlogsy.Web.usercontrols.uBlogsy.dashboard.CreatePost.InitBlogRoots() in d:\_PROJECTS\Personal\uBlogsy\uBlogsy HG\uBlogsy\uBlogsy\usercontrols\uBlogsy\dashboard\CreatePost.ascx.cs:46

       uBlogsy.Web.usercontrols.uBlogsy.dashboard.CreatePost.OnLoad(EventArgs e) in d:\_PROJECTS\Personal\uBlogsy\uBlogsy HG\uBlogsy\uBlogsy\usercontrols\uBlogsy\dashboard\CreatePost.ascx.cs:20

       System.Web.UI.Control.LoadRecursive() +74

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

     

    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

  • Anthony Dang 1404 posts 2558 karma points MVP 3x c-trib
    Mar 12, 2013 @ 12:28
    Anthony Dang
    0

    This is all fixed in the latest beta for v6.

     

  • Anthony Dang 1404 posts 2558 karma points MVP 3x c-trib
    Mar 12, 2013 @ 12:28
    Anthony Dang
    0

    This is all fixed in the latest beta for v6.

     

  • Brandon Hines 15 posts 45 karma points
    Mar 13, 2013 @ 06:13
    Brandon Hines
    0

    Ok..Anthony (whomever else)...You are correct it is working now I'm having a little problem working with Razor vs Masterpages.  I know this is not the topic but any help would be appreciated.

    Structure:

    DocumentType

    • HomePage
    • TextPage (Same Level No Inheriting)
    • uBlogsy Landing (Same Level No Inheriting)
    Template
    • HomePage
    • uBlogsy Landing (Child Template)
    In masterpages I had a property named footer on the HomePage Document Type.  No Inheriting at the Docuemnt Type Level.  So I used <umbraco:Item runat="server" field="footer" recursive="true"/>  on the HomePage Template and applied the uBlogsyLanding to the Content for Blog.  This allowed the uBlosy Landing to be displayed and bubble up to the HomePage Template which had a recursive call to the footer which was on the HomePage document Type.
    This works great in Masterpages but when I use @Umbraco.Field("header", recursive:true) this only works if I select the template it is present in as the Blog Template.
    Help!

     

    Make Sense?

  • Anthony Dang 1404 posts 2558 karma points MVP 3x c-trib
    Apr 10, 2013 @ 01:33
    Anthony Dang
    0

    Sorry for the late reply. I've been ultra busy. 

    Did you resolve this? Sounds like an umbraco but to me. 

  • subhakar 18 posts 38 karma points
    Jun 29, 2015 @ 06:25
    subhakar
    0

    [NullReferenceException: Object reference not set to an instance of an object.] uBlogsy.BusinessLogic.DataService.GetValueFromLanding(IPublishedContent node, String propertyAlias) in d:_PROJECTS\Personal\uBlogsy\uBlogsy MVC\Source\uBlogsy.BusinessLogic\DataService.cs:63 uBlogsy.BusinessLogic.PostService.GetAuthors(IPublishedContent node, Boolean getAll) in d:_PROJECTS\Personal\uBlogsy\uBlogsy MVC\Source\uBlogsy.BusinessLogic\PostService.cs:320 ASP.PageViewsPartialsuBlogsyWidgetsuBlogsyWidgetListAuthorscshtml.Execute() in c:\Users\subhakar\Desktop\Blog Finder\Views\Partials\uBlogsy\Widgets\uBlogsyWidgetListAuthors.cshtml:11 System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +197 System.Web.Mvc.WebViewPage.ExecutePageHierarchy() +96 System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +88 System.Web.Mvc.RazorView.RenderView(ViewContext viewContext, TextWriter writer, Object instance) +259 System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext, TextWriter writer) +115 Umbraco.Core.Profiling.ProfilingView.Render(ViewContext viewContext, TextWriter writer) +151 System.Web.Mvc.HtmlHelper.RenderPartialInternal(String partialViewName, ViewDataDictionary viewData, Object model, TextWriter writer, ViewEngineCollection viewEngineCollection) +276 System.Web.Mvc.Html.PartialExtensions.Partial(HtmlHelper htmlHelper, String partialViewName, Object model, ViewDataDictionary viewData) +108 Umbraco.Web.<>cDisplayClass1.0() +74 Umbraco.Core.Cache.<>cDisplayClass11.<GetCacheItem>b__0() +41 System.Lazy1.CreateValue() +416 System.Lazy1.LazyInitValue() +152 System.Lazy1.getValue() +75 Umbraco.Core.Cache.HttpRuntimeCacheProvider.GetCacheItem(String cacheKey, Func1 getCacheItem, Nullable1 timeout, Boolean isSliding, CacheItemPriority priority, CacheItemRemovedCallback removedCallback, CacheDependency dependency) +990 Umbraco.Core.Cache.HttpRuntimeCacheProvider.GetCacheItem(String cacheKey, Func1 getCacheItem, Nullable1 timeout, Boolean isSliding, CacheItemPriority priority, CacheItemRemovedCallback removedCallback, String[] dependentFiles) +159 Umbraco.Core.Cache.CacheProviderExtensions.GetCacheItem(IRuntimeCacheProvider provider, String cacheKey, Func1 getCacheItem, Nullable1 timeout, Boolean isSliding, CacheItemPriority priority, CacheItemRemovedCallback removedCallback, String[] dependentFiles) +219 Umbraco.Core.CacheHelper.GetCacheItem(String cacheKey, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, TimeSpan timeout, Func1 getCacheItem) +341 Umbraco.Web.CacheHelperExtensions.CachedPartialView(CacheHelper cacheHelper, HtmlHelper htmlHelper, String partialViewName, Object model, Int32 cachedSeconds, String cacheKey, ViewDataDictionary viewData) +253 Umbraco.Web.HtmlHelperRenderExtensions.CachedPartial(HtmlHelper htmlHelper, String partialViewName, Object model, Int32 cachedSeconds, Boolean cacheByPage, Boolean cacheByMember, ViewDataDictionary viewData, Func3 contextualKeyBuilder) +568 ASP.PageViewsuBlogsyBaseBlogcshtml.PageViewsuBlogsyBaseSitecshtml.

Please Sign in or register to post replies

Write your reply to:

Draft