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

Options
Go to last post Go to first unread
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: 286

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.

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

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: 109

Thanks: 17 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?
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: 286

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.
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: 109

Thanks: 17 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.
Users browsing this topic
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.