Stack Overflow in R9 Search Page

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
nethrelm
Lieutenant (LT)
Lieutenant (LT)
Posts: 61
Joined: Thu May 09, 2013 4:47 pm

Stack Overflow in R9 Search Page

Post by nethrelm » Fri Oct 10, 2014 7:38 pm

We are getting a StackOverflowException from Search.aspx originating in:

CommerceBuilder.Search.Providers.SearchProviderBase.AdvancedSearchCountByManufacturer(System.String, Int32, Boolean, Boolean, Boolean, System.Decimal, System.Decimal)

Whenever the search string contains a dash/minus ('-') character.
Top
User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:
Contact mazhar

Re: Stack Overflow in R9 Search Page

Post by mazhar » Fri Oct 10, 2014 9:40 pm

Which search provider is configured on your store?
Top
nethrelm
Lieutenant (LT)
Lieutenant (LT)
Posts: 61
Joined: Thu May 09, 2013 4:47 pm

Re: Stack Overflow in R9 Search Page

Post by nethrelm » Sat Oct 11, 2014 7:16 am

Lucene. The problem also manifests when the search string contains the double-quote character, and I suspect possibly some other special characters as well. Here is an excerpt from a crash dump:

CommerceBuilder.Search.Providers.LuceneSearchProvider.UseSQLSearch(System.String)
000000000cc96310 000007fe9808ab0f CommerceBuilder.Search.Providers.LuceneSearchProvider.AdvancedSearchCountByManufacturer(System.String, Int32, Boolean, Boolean, Boolean, System.Decimal, System.Decimal, System.Collections.Generic.IList`1<CommerceBuilder.Search.ShopByChoice>)
000000000cc96490 000007fe98a898ec CommerceBuilder.Search.Providers.SearchProviderBase.AdvancedSearchCountByManufacturer(System.String, Int32, Boolean, Boolean, Boolean, System.Decimal, System.Decimal)
000000000cc96510 000007fe9808ab99 CommerceBuilder.Search.Providers.LuceneSearchProvider.AdvancedSearchCountByManufacturer(System.String, Int32, Boolean, Boolean, Boolean, System.Decimal, System.Decimal, System.Collections.Generic.IList`1<CommerceBuilder.Search.ShopByChoice>)
000000000cc96690 000007fe98a898ec CommerceBuilder.Search.Providers.SearchProviderBase.AdvancedSearchCountByManufacturer(System.String, Int32, Boolean, Boolean, Boolean, System.Decimal, System.Decimal)
000000000cc96710 000007fe9808ab99 CommerceBuilder.Search.Providers.LuceneSearchProvider.AdvancedSearchCountByManufacturer(System.String, Int32, Boolean, Boolean, Boolean, System.Decimal, System.Decimal, System.Collections.Generic.IList`1<CommerceBuilder.Search.ShopByChoice>)
000000000cc96890 000007fe98a898ec CommerceBuilder.Search.Providers.SearchProviderBase.AdvancedSearchCountByManufacturer(System.String, Int32, Boolean, Boolean, Boolean, System.Decimal, System.Decimal)
000000000cc96910 000007fe9808ab99 CommerceBuilder.Search.Providers.LuceneSearchProvider.AdvancedSearchCountByManufacturer(System.String, Int32, Boolean, Boolean, Boolean, System.Decimal, System.Decimal, System.Collections.Generic.IList`1<CommerceBuilder.Search.ShopByChoice>)
000000000cc96a90 000007fe98a898ec CommerceBuilder.Search.Providers.SearchProviderBase.AdvancedSearchCountByManufacturer(System.String, Int32, Boolean, Boolean, Boolean, System.Decimal, System.Decimal)
etc....
etc....
CommerceBuilder.Products.ProductRepository.AdvancedSearchCountByManufacturer(System.String, Int32, Boolean, Boolean, Boolean, System.Decimal, System.Decimal, System.Collections.Generic.IList`1<CommerceBuilder.Search.ShopByChoice>)
000000000cd0cf20 000007fe9808a926 CommerceBuilder.Products.ProductDataSource.AdvancedSearchCountByManufacturer(System.String, Int32, Boolean, Boolean, Boolean, System.Decimal, System.Decimal, System.Collections.Generic.IList`1<CommerceBuilder.Search.ShopByChoice>)
000000000cd0cfc0 000007fe9808a7d0
Top
User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:
Contact mazhar

Re: Stack Overflow in R9 Search Page

Post by mazhar » Mon Oct 13, 2014 3:03 am

Thanks for reporting the issue, I was able to reproduce it with Lucene, issue is reported.
Top
nethrelm
Lieutenant (LT)
Lieutenant (LT)
Posts: 61
Joined: Thu May 09, 2013 4:47 pm

Re: Stack Overflow in R9 Search Page

Post by nethrelm » Mon Dec 01, 2014 1:06 pm

Have you guys figured out the problem with this yet? Can I get a patch please?
Top
User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:
Contact Katie

Re: Stack Overflow in R9 Search Page

Post by Katie » Fri Dec 05, 2014 8:11 am

One quick and easy solution is to temporarily switch to a different search provider like SQL or FTS SQL.
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support
Top
User avatar
bkort@web2market.com
AbleCommerce Partner
AbleCommerce Partner
Posts: 113
Joined: Thu Jan 22, 2004 3:17 pm
Location: Illinois
Contact:
Contact bkort@web2market.com

Re: Stack Overflow in R9 Search Page

Post by bkort@web2market.com » Mon Jan 11, 2016 6:08 am

Was there ever a fix for this issue? We've got a R9 clients who prefers the Lucene search to SQL FTS. Also, did this effect R10 or R11?
Top
User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:
Contact mazhar

Re: Stack Overflow in R9 Search Page

Post by mazhar » Mon Jan 11, 2016 6:23 am

It was fixed in Gold R0 under AC8-2679. Entry can be found in Gold R10 change log
http://help.ablecommerce.com/upgrades/a ... to_r10.htm
Top
Post Reply

Return to “AbleCommerce GOLD”