Portal Engine Questions on portal engine and web parts.
Version 5.x > Portal Engine > Blog Post problem View modes: 
User avatar
Member
Member
dao108-inbox - 9/20/2011 2:21:57 AM
   
Blog Post problem
I've created blog list(using repeater) like described in "Kentico CMS 5.5 Community Site Guide". When I try to open full post I become error:

[DataConnection.ExecuteQuery]: Query: SELECT CMS.Blog, CMS.BlogMonth, CMS.MenuItem, ClassName, DocumentCulture, DocumentModifiedWhen, DocumentMenuCaption, DocumentMenuClass, DocumentMenuClassHighLighted, DocumentMenuClassOver, DocumentShowInSiteMap, DocumentMenuItemHideInNavigation, DocumentMenuItemImage, DocumentMenuItemImageHighlighted, DocumentMenuItemImageOver, DocumentMenuItemInactive, DocumentMenuItemLeftImage, DocumentMenuItemLeftImageHighlighted, DocumentMenuItemLeftImageOver, DocumentMenuItemRightImage, DocumentMenuItemRightImageHighlighted, DocumentMenuItemRightImageOver, DocumentMenuJavascript, DocumentMenuRedirectUrl, DocumentMenuStyle, DocumentMenuStyleHighlighted, DocumentMenuStyleOver, DocumentName, DocumentUrlPath, NodeAliasPath, NodeID, NodeChildNodesCount, NodeClassID, NodeLevel, NodeLinkedNodeID, NodeParentID, SiteName, NodeACLID, NodeSiteID, NodeOwner, NodeXML FROM View_CMS_Tree_Joined_Versions WHERE (((SiteName = N'EXCHG') AND (Published = 1)) AND (DocumentCulture = N'en-US')) AND (((NodeLevel <= 4)) AND (NodeAliasPath IN (N'/Blogs/tes-blog--1/September-2011/test-XX', N'/Blogs/tes-blog--1/September-2011', N'/Blogs/tes-blog--1', N'/Blogs', N'/'))) ORDER BY NodeAliasPath DESC: caused exception: The multi-part identifier "CMS.Blog" could not be bound.
The multi-part identifier "CMS.BlogMonth" could not be bound.
The multi-part identifier "CMS.MenuItem" could not be bound.


Where is the problem?

User avatar
Kentico Support
Kentico Support
kentico_zdenekc - 9/28/2011 4:43:28 PM
   
RE:Blog Post problem
Hi,

Could you please confirm that your MS SQL database is using case insensitive (CI) collation?

Please see the system requirements - http://devnet.kentico.com/docs/devguide/system_requirements.htm

Similar issue was discussed some time ago in our forums.

Regards,
Zdenek C.