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
Can't Upgrade a Gold12SR2 DB to V9 5588 - Install is failing when getting to the DB upgrade Step
Options
Go to last post Go to first unread
Previous Topic Next Topic
rlopez397954  
#1 Posted : Friday, August 23, 2019 3:43:31 PM(UTC)
rlopez397954

Rank: Advanced Member

Groups: Authorized User, Registered, Developers, HelpDesk
Joined: 11/30/2018(UTC)
Posts: 86

Thanks: 8 times
Was thanked: 1 time(s) in 1 post(s)
We are currently in the process of upgrading a GoldR12SR2 Build 9476 DB to V9 5588. We are using Ablecommerce doc instructions, to the tee, Upgrading from Gold to Ablecommerce 9 and have found that when we get to the DB upgrade step we get an error.
Quote:
The specified database is not a valid version. This upgrade will only support Ablecommerce Gold R10 (build #8620) or a higher version.
What's strange is there is still a green button to continue and when we do proceed we get a 404 error not found.

Our DB is original from 5.5 with direct upgrades to 7.0.03 and then to Gold. We are currently up to date on GoldR12SR2 Build 9476 including all the patches. We run our DB's on a MS 2016 box and we have a V9 5588 Dev site running now that was a new install with no issues.

I've tried several different installs methods in different fashions but still cannot get this DB to upgrade. Any feedback would be great.

Ricky

Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
MikeR  
#2 Posted : Friday, August 23, 2019 3:54:11 PM(UTC)
MikeR

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, System, Admin
Joined: 10/18/2018(UTC)
Posts: 183

Thanks: 1 times
Was thanked: 6 time(s) in 6 post(s)
Hi Ricky,

Thanks for posting the details for us.

There must be something with 7.0.3 db's, I have that SAME thing on one I'm working on. That was the earliest version that Gold was able to upgrade. There must be some triggers, stored procedures or something that's throwing us off.

Here's what development found with the db I provided.

For a valid Gold R12 database we check "ac_RestockNotify" table, to confirm it's a valid R12.

Here's what we found from my attempt. Let me know if you find any of these issues.

Gold R10
The ac_GatewayPaymentProfiles table is missing, this table is not added for R10, but a column "PaymentMethodName: was added in Gold R10. but the table is not present for the provided database.

Also "ShipStationId" field is missing for "ac_OrderShipments" table, which was added in Gold R10.

R11 upgrades

PublishedBy and PublishDate columns added to ac_Webpages but
ac_RestockNotify table missing

R12 upgrades
—
'Web API Access' role missing in ac_Roles
"Web API Users" group missing in ac_Groups table

Thank you for your support!
Mike Randolph
AbleCommerce.com
Back to top
rlopez397954  
#3 Posted : Friday, August 23, 2019 4:38:43 PM(UTC)
rlopez397954

Rank: Advanced Member

Groups: Authorized User, Registered, Developers, HelpDesk
Joined: 11/30/2018(UTC)
Posts: 86

Thanks: 8 times
Was thanked: 1 time(s) in 1 post(s)
Mike thanks for the input. So I checked the DB and here is what I have.

The ac_GatewayPaymentProfiles
Quote:
(I do not have this table as well but I do have a table ac_PaymentGateways)
table is missing, this table is not added for R10, but a column "PaymentMethodName:
Quote:
(This table is not present as well Only a table named ac_PaymentMethods)
was added in Gold R10. but the table is not present for the provided database.

Also "ShipStationId"
Quote:
This field is present in ac_OrderShipments table
field is missing for "ac_OrderShipments" table, which was added in Gold R10.

R11 upgrades

PublishedBy and PublishDate columns added to ac_Webpages
Quote:
These Columns are present ok
but
ac_RestockNotify table missing
Quote:
This table is also in my DB


R12 upgrades
—
'Web API Access' role missing in ac_Roles
Quote:
This role is present ok

"Web API Users" group missing in ac_Groups table
Quote:
This role is also present ok


So it looks like I'm missing the ac_GatewayPaymentProfiles, and ac_PaymentMethodName Tables which should be there when we upgraded from Gold9 to 10.
Hopefully this helps.
Ricky
Back to top
MikeR  
#4 Posted : Friday, August 23, 2019 4:41:16 PM(UTC)
MikeR

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, System, Admin
Joined: 10/18/2018(UTC)
Posts: 183

Thanks: 1 times
Was thanked: 6 time(s) in 6 post(s)
Hi Ricky,

Thank you for those details, we'll get it sorted as soon as possible!
Thank you for your support!
Mike Randolph
AbleCommerce.com
Back to top
rlopez397954  
#5 Posted : Friday, September 13, 2019 11:21:56 PM(UTC)
rlopez397954

Rank: Advanced Member

Groups: Authorized User, Registered, Developers, HelpDesk
Joined: 11/30/2018(UTC)
Posts: 86

Thanks: 8 times
Was thanked: 1 time(s) in 1 post(s)
Checking to see if there has been any update regarding this upgrade problem we are having. Has there been any progress on resolving this issue?

Thanks again for your help.


Ricky
Back to top
MikeR  
#6 Posted : Wednesday, September 18, 2019 9:27:46 AM(UTC)
MikeR

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, System, Admin
Joined: 10/18/2018(UTC)
Posts: 183

Thanks: 1 times
Was thanked: 6 time(s) in 6 post(s)
Hi Ricky,

Some of the past upgrades had issues, since this db is live we can't really go back and try them again. We may need to just do a create table to fix the issues. I'll ask the devs to step in with some advice.
Thank you for your support!
Mike Randolph
AbleCommerce.com
Back to top
rlopez397954  
#7 Posted : Wednesday, September 18, 2019 9:50:45 AM(UTC)
rlopez397954

Rank: Advanced Member

Groups: Authorized User, Registered, Developers, HelpDesk
Joined: 11/30/2018(UTC)
Posts: 86

Thanks: 8 times
Was thanked: 1 time(s) in 1 post(s)
Mike thank you.

Ricky
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.162 seconds.