Forums (Obsolete)

Member

caspian_softdev-yahoo - 9/5/2008 7:07:07 AM

Error When Customizing product categories

When i flow u your E-Commerce Guide for customizing product category i faced with this error:

{"[QueryProvider.GetQuery]: Query CMS.Product.selectversions not found!"}

I folow up these steps acording to ur ecommerce guide:

1. Go to CMS Desk -> Content and choose Products in the content tree.
2. Click New at the document action toolbar.
3. Choose the Page(menu item) document type.
4. Enter Plasma TVs as the Page name, make sure the Use page template radio button is selected and choose Products -> Product grid view template. Click Save.

Here when i click on save this error occurs.

I have your free version of Kentico cms.

Kentico Developer

kentico_martind - 9/5/2008 10:05:18 AM

RE:Error When Customizing product categories

Hello,

It seems there is 'CMS.Product.selectversions' query missing on your instance of Kentico CMS for some reason. Could you please check if the 'selectversions' query is present in 'SiteManager -> Development -> Document types -> edit CMS.Product -> Queries' section, eventually try to add new query as specified bellow:

QueryName: selectversions
Query type: Query text
Query text: 
SELECT ##TOPN## ##COLUMNS## FROM View_CMS_Tree_Joined_Versions INNER JOIN CONTENT_Product ON View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_Product.[ProductID] WHERE (##WHERE##) AND (ClassName = 'CMS.Product') ORDER BY ##ORDERBY##

Best Regards,
Martin Dobsicek


Member	Snarrak - 10/14/2011 7:56:16 AM RE:Error When Customizing product categories I'm having the same problem, but in Kentico 6. Was there a solution for it? Thanks. Regards, Jorik


Kentico Support	kentico_jurajo - 10/15/2011 5:47:26 AM RE:Error When Customizing product categories Hi, The fix is mentioned in the post above - it seems you are missing some system SQL query and in the post above is mentioned how to add it to the system. Best regards, Juraj Ondrus


Member	Snarrak - 10/18/2011 5:59:50 AM RE:Error When Customizing product categories I'm sorry, I didn't make it clear in my previous post. I already checked for that SQL query, but it was there...


Kentico Support	kentico_jurajo - 10/19/2011 4:29:34 AM RE:Error When Customizing product categories Hi, Could you please describe us the exact steps leading to this error? Also, what is the exact version number of CMS you are using? Is it possible to post a screen shot of full error message? Best regards, Juraj Ondrus

Member

david.slavik-titio - 12/8/2011 4:31:25 AM

RE:Error When Customizing product categories

Hello,

i had same problem... There is solution how to resolve it:

1. Check Page template of page where you have this error.
2. Check all repeaters where you using document type that is written in Exception and check if you have not some spaces in column Properties of repeater > Content filter - Document types input text box. For example like this: "CMS.Product ".

It can be recognized by the break in Exception after document type name, like this:
"Query CMS.Product.selectversions not found!""

Good luck!


Member	gruber.frank-rocketmail - 5/22/2012 10:16:00 PM RE:Error When Customizing product categories thanks for the share

Certified Developer v6

kmurphy-wakefly - 9/10/2013 4:40:16 AM

RE:Error When Customizing product categories

I realize this is an old thread, but I just wanted to let you know that this error also comes up when you are manually creating a repeater using markup (like inside a nested repeater inside a transformation) and the casing is wrong.

<cc1:CMSRepeater ID="repPosts" runat="server" ClassNames="cms.blogPost" TransformationName="CMS.BlogPost.Default" DelayedLoading="true" >
</cc1:CMSRepeater>

causes the error

<cc1:CMSRepeater ID="repPosts" runat="server" ClassNames="CMS.BlogPost" TransformationName="CMS.BlogPost.Default" DelayedLoading="true" >
</cc1:CMSRepeater>

Does not.

Note.. the only difference is the casing of the ClassName.

I do hope this helps someone, I am using Kentico 7.