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 forums.ablecommerce.com. Please use your AbleCommerce username and password to Login. Forums Registration.

Notification

Icon
Error

Options
Go to last post Go to first unread
Joe Payne @ AbleMods LLC  
#1 Posted : Wednesday, January 20, 2021 8:19:06 AM(UTC)
Joe Payne @ AbleMods LLC

Rank: Advanced Member

Groups: HelpDesk
Joined: 11/9/2018(UTC)
Posts: 156

Thanks: 43 times
Was thanked: 7 time(s) in 7 post(s)
What is used to determine if the Able Gold db meets the upgrade requirements of v10 or higher?

I'm trying to upgrade a Gold R12SR2 install to AC9 and the upgrade page won't let me proceed. It throws up the "The specified database is not a valid version. This upgrade will only support Ablecommerce Gold R10 (build # 8620) or higer verion databases." message.

The db has many customizations but the vast majority are in new tables.

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. Forums Registration.

shaharyartiwana25816656  
#2 Posted : Thursday, January 21, 2021 12:45:24 AM(UTC)
shaharyartiwana25816656

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 433

Thanks: 1 times
Was thanked: 36 time(s) in 36 post(s)
Code:

// check for AC Gold R12 database
sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'ac_RestockNotify'";
                   
// check for AC Gold R11 database                    
sql = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'ac_LabelImages'";
                                          
// check for AC Gold R10 database                    
sql = "SELECT COUNT(*) AS NumRows FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ac_Products' AND COLUMN_NAME = 'TIC'";


These are the checks we had in our code to determine the database version. You can also review the ValidateExistingDatabase() function code in the file.
\website\areas\install\controllers\defaultcontroller.cs
thanks 1 user thanked shaharyartiwana25816656 for this useful post.
Joe Payne @ AbleMods LLC on 1/21/2021(UTC)
Joe Payne @ AbleMods LLC  
#3 Posted : Thursday, January 21, 2021 2:55:38 PM(UTC)
Joe Payne @ AbleMods LLC

Rank: Advanced Member

Groups: HelpDesk
Joined: 11/9/2018(UTC)
Posts: 156

Thanks: 43 times
Was thanked: 7 time(s) in 7 post(s)
Thanks for the quick reply. You helped me trace down the problem to a permissions issue in the SQL database.

The SQL account could access the db, so the install didn't throw an initial connection error. But the SQL user did not have db_owner rights, so the login couldn't see any tables in the database itself.

Might be worth a quick SQL count of tables found in the database after initial authentication is tested and 'upgrade' was selected. Without any tables visible to the app using the credentials provided, there's no point in proceeding and a useful error could save folks a whole lot of time.

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.