This project is read-only.

Unable to see blog

Topics: Troubleshooting
Nov 30, 2011 at 2:26 PM

I recently just converted my site to use orchard so that I could attach a blog.  Everything worked great and deployed great except for the blog portion.  I get an Internal Server Error 500 when I try to navigate to it.  The blog works perfect locally and is using the same SQL backend.  So my thought is some file didn't get transferred on the publish.  How can I debug this appropriately? I put custom errors=Off on the web.config to try to get a stack trace but that doesn't seem to work.  Otherwise if you have ran into this problem before I would appreciate any help. 

My site is if that helps.

Nov 30, 2011 at 2:52 PM

You can check the error log files in App_Data/Logs - something should be reported in there.

Nov 30, 2011 at 3:43 PM

Thanks for the tip.  I checked the log files and there hasn't been anything recorded in those for the past five days.  The only log that I found that might relate was an log from the 22nd.

2011-11-22 13:05:18,687 [108] NHibernate.Util.ADOExceptionReporter - Invalid object name 'Orchard_Blogs_BlogPartRecord'.
2011-11-22 13:05:18,687 [108] NHibernate.Util.ADOExceptionReporter - Invalid object name 'Orchard_Blogs_BlogPartRecord'.
2011-11-22 13:05:18,690 [108] Orchard.Events.DefaultOrchardEventBus - TargetInvocationException thrown from IOrchardShellEvents.Activated by Orchard.Blogs.Routing.BlogPathConstraintUpdator
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> NHibernate.ADOException: could not execute query
[ SELECT this_.Id as Id386_3_, this_.Number as Number386_3_, this_.Published as Published386_3_, this_.Latest as Latest386_3_, this_.Data as Data386_3_, this_.ContentItemRecord_id as ContentI6_386_3_, routepartr3_.Id as Id361_0_, routepartr3_.Title as Title361_0_, routepartr3_.Slug as Slug361_0_, routepartr3_.Path as Path361_0_, routepartr3_.ContentItemRecord_id as ContentI5_361_0_, contentite1_.Id as Id385_1_, contentite1_.Data as Data385_1_, contentite1_.ContentType_id as ContentT3_385_1_, blogpartre2_.Id as Id365_2_, blogpartre2_.Description as Descript2_365_2_, blogpartre2_.PostCount as PostCount365_2_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Routable_RoutePartRecord routepartr3_ on this_.Id=routepartr3_.Id inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id inner join Orchard_Blogs_BlogPartRecord blogpartre2_ on contentite1_.Id=blogpartre2_.Id WHERE this_.Published = @p0 ORDER BY routepartr3_.Title asc ]
Positional parameters:  #0>True

This error was from before I published the site (the log file must have been copied over in the publish).  The table 'Orchard_Blogs_BlogPartRecord' exists and I tested the query and it runs successfully.  Any other tips on how I could resolve this would be greatly appreciated.

Nov 30, 2011 at 4:19 PM

Maybe there's a write permission problem and it's unable to write any new logs ... have you given write permission to appropriate directories such as this one?