Old Forums
Search:
Design and CSS styles
Version 6.x > Design and CSS styles > Error when adding product page View modes: 
User avatar
Member
Member
flavio.molendini-cognitic - 2/27/2012 3:28:55 AM
   
Error when adding product page
Hello,

I'm currently trying to deploy an e-commerce website from a blank configuration.
I'm at the step where i've got to add a "Products" page, listing all my products and allowing me to add some products categories... Which is, of course, ABSOLUTLY neccessary for my shop...

Well, here is what I do : New Content --> Page --> ECommerce - Products template ...

When the page is created, i have an Application Error. Here is the stacktrace :

Message: [GeneralConnection.ExecuteQuery]: Query 'CMSProduct.Camera.selectversions' not found.
Stack Trace:
at CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns)
at CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords)
at CMS.TreeEngine.TreeProvider.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns, Int32 offset, Int32 maxRecords, Int32& totalRecords)
at CMS.TreeEngine.TreeProvider.SelectNodes(NodeSelectionParameters parameters)
at CMS.WorkflowEngine.DocumentHelper.GetDocuments(NodeSelectionParameters parameters, TreeProvider tree)
at CMS.WorkflowEngine.DocumentHelper.GetDocuments(String siteName, String aliasPath, String cultureCode, Boolean combineWithDefaultCulture, String classNames, String where, String orderBy, Int32 maxRelativeLevel, Boolean selectOnlyPublished, Int32 topN, String columns, TreeProvider tree)
at CMS.Controls.CMSAbstractDataProperties.GetDataSet(String path, String where, Boolean forceReload)
at CMS.Controls.CMSAbstractDataProperties.LoadData(Object& DataSource, Boolean forceReload)
at CMS.Controls.CMSDataList.ReloadData(Boolean forceReload)
at CMSModules_Ecommerce_Controls_Filters_ProductFilter.SetFilter()
at CMSModules_Ecommerce_Controls_Filters_ProductFilter.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)



Thanks for any help,

Best regards

User avatar
Kentico Support
Kentico Support
kentico_radekm - 2/27/2012 4:14:30 AM
   
RE:Error when adding product page
Hello.

Could you please navigate to Site Manager / Development / Document types / edit CMSProduct.Camera / Queries tab? Can you see "selectversions" query there?

Best Regards,
Radek Macalik

User avatar
Member
Member
flavio.molendini-cognitic - 2/27/2012 5:40:16 AM
   
RE:Error when adding product page
Hi Radek, firstable thanks for the help, it's very appreciated.

Well, i don't have any Document Type named Camera. I assume that's beacause i exported the E-commerce templates from the default kentico e-commerce to my blank website...

Best regards,
Flavio
User avatar
Kentico Support
Kentico Support
kentico_radekm - 2/27/2012 5:48:24 AM
   
RE:Error when adding product page
Hello.

I see. In this case, this import could explain it. I can see you also sent us an e-mail. I read my co-worker's answer and I would recommend to follow his advice. Thank you.

Best Regards,
Radek Macalik

User avatar
Member
Member
flavio.molendini-cognitic - 2/27/2012 6:43:59 AM
   
RE:Error when adding product page
Hello.

Thanks to your co-worker, i have the solution. I post it here for the people having the same issue.

I had to go in "Site Manager" -> "Development" - > "ECommerce Product" template -> "Web Parts"

and remove all occurences with CMS.Products.

Thanks a lot for the support,
Flavio

Top