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
Product SearchKeywords maxlenght
Options
Go to last post Go to first unread
Previous Topic Next Topic
judy at Web2Market  
#1 Posted : Monday, June 20, 2022 7:02:57 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
The field for search keywords should have an maxlength property set on the edit product page so merchant will have some indication of why a product is not saving, instead of just an entry in the error log that that the value would be truncated. That full screen width two-line box gives them the impression that they can save a lot more characters.
Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
nadeem  
#2 Posted : Monday, June 20, 2022 8:28:52 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)
The ac_Products.SearchKeywords field has the type nvarchar(max) in database and there is no restriction in code as well. So you can save a lot of keywords in this field. I am wondering if you are talking about some other field?
Back to top
judy at Web2Market  
#3 Posted : Tuesday, June 21, 2022 7:08:56 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
No, it was that field. It was a site that had started out as Able 7, so maybe the data type didn't get changed during an upgrade.
I wonder if having it nvarchar(MAX) slows down search since it can't be indexed? I had changed one of the fields in a template on another site to be small enough that it could be indexed and it made a big difference in the Shop By filtering.
Back to top
nadeem  
#4 Posted : Tuesday, June 21, 2022 12:29:03 PM(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)
Quote:
No, it was that field. It was a site that had started out as Able 7, so maybe the data type didn't get changed during an upgrade.


Yes, that makes sense.

Quote:
I wonder if having it nvarchar(MAX) slows down search since it can't be indexed? I had changed one of the fields in a template on another site to be small enough that it could be indexed and it made a big difference in the Shop By filtering.


Yes, navarchar(max) can't be indexed. You can either use the CHECKSUM method to index large size columns or set the length to some reasonable value.
Back to top
Users browsing this topic
Guest (2)
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.

Privacy Policy | Powered by YAF.NET 2.2.4.14 | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.187 seconds.