Issues with New Orchard 1.6 Install

Topics: Installing Orchard
Nov 16, 2012 at 8:59 PM

I've tried to create a new install of 1.6 (without source) from the OrchardProject.net site. However, the default page isn't shown. When I check the errors, I'm getting two different errors.

First is an error that I thought was corrected with Projections:

Orchard.Data.Migration.AutomaticDataMigrations - Could not run migrations automatically on Orchard.Projections

Second is an error with nHibernate:

Orchard.Exceptions.DefaultExceptionPolicy - An unexpected exception was caught
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT this_.Id as Id524_4_, this_.Number as Number524_4_, this_.Published as Published524_4_, this_.Latest as Latest524_4_, this_.Data as Data524_4_, this_.ContentItemRecord_id as ContentI6_524_4_, titlepartr3_.Id as Id566_0_, titlepartr3_.Title as Title566_0_, titlepartr3_.ContentItemRecord_id as ContentI3_566_0_, contentite1_.Id as Id523_1_, contentite1_.Data as Data523_1_, contentite1_.ContentType_id as ContentT3_523_1_, blogpartre2_.Id as Id542_2_, blogpartre2_.Description as Descript2_542_2_, blogpartre2_.PostCount as PostCount542_2_, contenttyp8_.Id as Id525_3_, contenttyp8_.Name as Name525_3_ FROM demo_Orchard_Framework_ContentItemVersionRecord this_ inner join demo_Title_TitlePartRecord titlepartr3_ on this_.Id=titlepartr3_.Id inner join demo_Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id inner join demo_Orchard_Blogs_BlogPartRecord blogpartre2_ on contentite1_.Id=blogpartre2_.Id left outer join demo_Orchard_Framework_ContentTypeRecord contenttyp8_ on contentite1_.ContentType_id=contenttyp8_.Id WHERE this_.Published = @p0 ORDER BY titlepartr3_.Title asc ]
  Name:cp0 - Value:True
[SQL: SELECT this_.Id as Id524_4_, this_.Number as Number524_4_, this_.Published as Published524_4_, this_.Latest as Latest524_4_, this_.Data as Data524_4_, this_.ContentItemRecord_id as ContentI6_524_4_, titlepartr3_.Id as Id566_0_, titlepartr3_.Title as Title566_0_, titlepartr3_.ContentItemRecord_id as ContentI3_566_0_, contentite1_.Id as Id523_1_, contentite1_.Data as Data523_1_, contentite1_.ContentType_id as ContentT3_523_1_, blogpartre2_.Id as Id542_2_, blogpartre2_.Description as Descript2_542_2_, blogpartre2_.PostCount as PostCount542_2_, contenttyp8_.Id as Id525_3_, contenttyp8_.Name as Name525_3_ FROM demo_Orchard_Framework_ContentItemVersionRecord this_ inner join demo_Title_TitlePartRecord titlepartr3_ on this_.Id=titlepartr3_.Id inner join demo_Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id inner join demo_Orchard_Blogs_BlogPartRecord blogpartre2_ on contentite1_.Id=blogpartre2_.Id left outer join demo_Orchard_Framework_ContentTypeRecord contenttyp8_ on contentite1_.ContentType_id=contenttyp8_.Id WHERE this_.Published = @p0 ORDER BY titlepartr3_.Title asc] ---> System.Data.SqlClient.SqlException: Invalid object name 'demo_Orchard_Blogs_BlogPartRecord'.

Any insight that can be provided is appreciated.

Coordinator
Nov 17, 2012 at 1:44 AM

New install or upgrade? If new install, can you try another one, or wipe this one out and start over?

Nov 19, 2012 at 5:29 AM

If you are using MS SQL as Orchard database, then check your collation. I've noticed that there is a bug and it only works on case insensitive collations.

Coordinator
Nov 19, 2012 at 6:30 AM

Was this bug filed?

Nov 19, 2012 at 6:31 AM

Not yet

Coordinator
Nov 19, 2012 at 6:33 AM

Please do then. Thanks.

Nov 19, 2012 at 5:08 PM

I'm going to check the collation. It is on a brand new install. I've tried several times to wipe this one and start over, but it doesn't work.

Nov 19, 2012 at 9:12 PM

I've made issue ticket

http://orchard.codeplex.com/workitem/19268