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
Upgrade populates searchkeywords with "MetaKeywords"
Options
Go to last post Go to first unread
Previous Topic Next Topic
judy at Web2Market  
#1 Posted : Thursday, September 23, 2021 6:57:30 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)
On the first couple of sites, I thought I had done something inadvertently, but this happened on a third site so I went digging. In an upgrade from Gold, you are populating the SearchKeywords field with the wording "MetaKeywords".
I found this in AbleCommerce_Upgrade_ACGold_AC9.SQL, line 283
IF (SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ac_Products' AND COLUMN_NAME = 'MetaKeywords') > 0
BEGIN
UPDATE ac_Products SET SearchKeywords = 'MetaKeywords'
END
Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
shaharyar  
#2 Posted : Thursday, September 23, 2021 8:14:09 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)
Thanks for pointing this out. I am registering a bug report to further investigate.
Back to top
Joe Payne2  
#3 Posted : Thursday, September 23, 2021 9:07:42 AM(UTC)
Joe Payne2

Rank: Advanced Member

Groups: HelpDesk, Developers
Joined: 11/9/2018(UTC)
Posts: 564

Thanks: 122 times
Was thanked: 26 time(s) in 25 post(s)
So every upgrade has lost all search keywords on their products. Ouch.
Back to top
judy at Web2Market  
#4 Posted : Monday, September 27, 2021 7:04:39 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)
Yes. I had noticed before we went live so I used DataExport/Import to pick them up again from the Gold sites.
Back to top
shaharyar  
#5 Posted : Tuesday, September 28, 2021 5:19:52 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)
This issue is fixed in the latest release. Ablecommerce 9.0.5
https://www.ablecommerce...e-version-9-0-5-released

Thanks for your support!
Back to top
judy at Web2Market  
#6 Posted : Tuesday, September 28, 2021 6:39:01 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)
Just out of curiosity, why was the code updating the searchkeywords anyway if it was a Gold site that already had a searchkeywords field?
Back to top
shaharyar  
#7 Posted : Tuesday, September 28, 2021 7:18:25 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)
The code was part of the upgrade script from R1-R6 to AC9. In those versions, we didn't have the SearchKeywords column so the code is creating the column and then copying the values of MetaKeywords into Searchkeywords.
Back to top
Users browsing this topic
Guest (7)
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 1.017 seconds.