logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

2 Pages<12
Options
Go to last post Go to first unread
charles25686713  
#21 Posted : Tuesday, May 30, 2023 2:35:05 PM(UTC)
charles25686713

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 7/1/2022(UTC)
Posts: 71

Thanks: 5 times
Was thanked: 1 time(s) in 1 post(s)
It doesn't appear that 'links' has any sort of paging on it?
shaharyar  
#22 Posted : Tuesday, April 16, 2024 7:44:36 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 704

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
Hi Charles,

Links widget does not have the standard paging control but you can change the number of links to be displayed by changing the Number of links to display option in widget settings.
Please enable CMS Edit mode and click the settings icon on the top right of the widget boundary.

I hope this will be a help!

Regards
charles25686713  
#23 Posted : Friday, April 26, 2024 2:30:52 PM(UTC)
charles25686713

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 7/1/2022(UTC)
Posts: 71

Thanks: 5 times
Was thanked: 1 time(s) in 1 post(s)
Hi, I'm resurrecting this topic.

We recently followed the logic in this thread to re-add "Article listings" to the category pages. Re-add because these are html only "non product" pages that used to appear in AC gold, but got unceremoniously disabled in AC9 without any notification to us. :(

It appeared to work, adding "article listing" to the inner template for Category Product Grid:

Annotation 2024-04-26 132656.jpg (104kb) downloaded 0 time(s).

Now we're discovering it only works for the "first page" on some entries.

After that, it either shows a 500 internal server, or, and I think this appears if an admin is logged in:

could not resolve property: IsFeatured of: CommerceBuilder.Catalog.Webpage

The error log, in both cases, shows this as the exception:

Code:
An error has occurred at (url)/page=2&SortExpression=IsFeatured DESC%2C OrderBy ASC%2C Name ASC&PageSize=12&ManufacturerId=0&CategoryId=76 IP ADDRESS: xxx View less
Exception: could not resolve property: IsFeatured of: CommerceBuilder.Catalog.Webpage Stack Trace: at NHibernate.Persister.Entity.AbstractPropertyMapping.ToType(String propertyName) at NHibernate.Persister.Entity.AbstractEntityPersister.GetSubclassPropertyTableNumber(String propertyPath) at NHibernate.Persister.Entity.BasicEntityPropertyMapping.ToColumns(String alias, String propertyName) at NHibernate.Loader.Criteria.CriteriaQueryTranslator.GetColumnAliasesUsingProjection(ICriteria subcriteria, String propertyName) at NHibernate.Criterion.Order.ToSqlString(ICriteria criteria, ICriteriaQuery criteriaQuery) at NHibernate.Loader.Criteria.CriteriaQueryTranslator.GetOrderBy() at NHibernate.Loader.Criteria.CriteriaJoinWalker..ctor(IOuterJoinLoadable persister, CriteriaQueryTranslator translator, ISessionFactoryImplementor factory, ICriteria criteria, String rootEntityName, IDictionary`2 enabledFilters) at NHibernate.Loader.Criteria.CriteriaLoader..ctor(IOuterJoinLoadable persister, ISessionFactoryImplementor factory, CriteriaImpl rootCriteria, String rootEntityName, IDictionary`2 enabledFilters) at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) at NHibernate.Impl.CriteriaImpl.List(IList results) at NHibernate.Impl.CriteriaImpl.List[T]() at AbleCommerce.Controllers.WebpageController.ArticleListing(ArticleListingWidgetParams parameters, Int32 page, String sortExpression, Int32 pageSize) at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass24_0.<InvokeActionMethodWithFilters>b__0() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) at System.Web.Mvc.Controller.ExecuteCore() at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) at System.Web.Mvc.Async.AsyncResultWrapper.<>c.<.cctor>b__15_0(IAsyncResult asyncResult, Action action) at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.<>c.<BeginProcessRequest>b__20_1(IAsyncResult asyncResult, ProcessRequestState innerState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.<>c__DisplayClass5_0.<Wrap>b__0() at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.Wrap[TResult](Func`1 func) at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride) 


I confirmed the "Article Listing" is causing the problem by removing it from the Inner Template.

Please advise.

Thanks,
Charles
Katie S  
#24 Posted : Monday, April 29, 2024 7:48:27 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 467

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Hi Charles,

I was able to add the Article Listing Widget to a stock category page using:

  • Subcategory Menu
  • Category Product Grid Multilevel
  • Article listing
  • Links


The page displays without any issues.

This error is confusing though -

could not resolve property: IsFeatured of: CommerceBuilder.Catalog.Webpage

Webpages don't have a "featured" property. Are you sure there hasn't been a customization?

I can do some more testing tomorrow, but if you happen to have a stock install that you can do a test with to confirm a customization isn't the cause.
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
charles25686713  
#25 Posted : Monday, April 29, 2024 8:19:19 PM(UTC)
charles25686713

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 7/1/2022(UTC)
Posts: 71

Thanks: 5 times
Was thanked: 1 time(s) in 1 post(s)
It works fine for me on the first page too.

It's when you page to the second page that the error comes up.

I don't think there's a customization here that I put in.
Katie S  
#26 Posted : Tuesday, April 30, 2024 12:58:47 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 467

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Do you have multiple sets of paging?
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
charles25686713  
#27 Posted : Tuesday, April 30, 2024 1:10:54 PM(UTC)
charles25686713

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 7/1/2022(UTC)
Posts: 71

Thanks: 5 times
Was thanked: 1 time(s) in 1 post(s)
Originally Posted by: Katie S Go to Quoted Post
Do you have multiple sets of paging?


I don't know what you mean by that.

The problem became evident on categories that had multiple pages of products.

Page 1 works correctly.

Page 2 gives the 500 error or the one I posted, depending on whether you are logged in and whether you are an admin or not.

Katie S  
#28 Posted : Tuesday, April 30, 2024 1:43:56 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 467

Thanks: 4 times
Was thanked: 34 time(s) in 33 post(s)
Both of these widgets have paging. I think that's where the conflict occurs.

- Category Product Grid Multilevel
- Article listing

In any case, I can reproduce the issue. When moving to the second page for the product grid, the error is occurring within the webpages (Article Listing widget) code.

I will get this reported and try to have a developer provide a fix in the meantime. It might take a few days as we are really busy right now.
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
charles25686713  
#29 Posted : Tuesday, April 30, 2024 1:53:51 PM(UTC)
charles25686713

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 7/1/2022(UTC)
Posts: 71

Thanks: 5 times
Was thanked: 1 time(s) in 1 post(s)
Thanks!
nadeem  
#30 Posted : Monday, June 10, 2024 4:55:11 AM(UTC)
nadeem

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, Authorized User, Admin, System
Joined: 10/11/2018(UTC)
Posts: 110

Thanks: 19 times
Was thanked: 18 time(s) in 18 post(s)
Hi,

There is a paging/sorting conflict with Article Listing and Category Product Grid Multilevel widgets used on a same page.

Here is a workaround to fix this issue.

Open the Website/Controllers/WebpageController.cs file,

Locate the following code on line ArticleListing Get method

Code:
if (pageSize == 0)
    pageSize = (int)parameters.MaxItems;


and replace with

Code:
if (!string.IsNullOrEmpty(sortExpression) && sortExpression.Contains("IsFeatured")) sortExpression = "PublishDate DESC";

 if (pageSize == 0)
      pageSize = (int)parameters.MaxItems;


Thanks.
Users browsing this topic
2 Pages<12
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.