Both 9.0.3 installs I have upgraded to 9.0.4 this week did not execute the SQL schema changes. I had to open the SQL script from the upgrade folder and execute it manually in both cases.

We really need some sort of upgrade UI when an upgrade is executing. As it is now, there is zero feedback that an upgrade was even attempted, or failed or not found etc.

Ok, so I probably have the old/bad download. Is there a specific folder that was missing that I can look for?

I should just go the admin Upgrades->Past Upgrades and download the 9.0.4 again to get the working 9.0.4 upgrade right?

In an existing live 9.0.4 install, there is only one entry under Past Upgrades. There is no download link or button. And the Instructions button links to an invalid url that throws a 404 http://help.ablecommerce.com/upgrade/9.0.4.6750/

Technically shouldn't ALL past upgrades be shown in that list? Otherwise, what's the point of the Past Upgrades feature?

Yes, this is correct!

---

In an existing 9.0.3 install, you can download the latest upgrade zip (9.0.3 to 9.0.4) from the available upgrades list. This will contain the Upgrade Folder under App_Data.




Also, I just noticed that in your first comment you mentioned that you have found the Upgrade folder and executed the scripts manually.




Surely the upgrades section needs some improvements and we had opened a discussion for improvements.

Thanks

Edited by user Tuesday, May 4, 2021 12:47:23 AM(UTC)  | Reason: Not specified

If I can interject something here based on my post with the language strings. I was not aware that there was a cvs file under the area\install\content directory for this.

If I can suggest the following, having a text file with the manual scripts necessary to upgrade the schema in the database. It can be one text file that gets updated per version. Using Joe's example of going from 9.0.3 to 9.0.8, the text file would have an entry to upgrade the schema to 9.0.4 and if there was a schema change in 9.0.5, that information would also be listed there with the proper sql statement to run.

I do not believe that this would be a major burden on AbleCommerce, but can definitely save a lot of developers plenty of time. Maybe a directory under area\install called schema.

Just an idea,
-Ray

Thank you all for your suggestions. We have a report opened for upgrade process improvements.



After an upgrade, you will see an entry on the past upgrades page with an instruction page link.

Thanks

menu.png (16kb) downloaded 0 time(s).

Also, no info on version 9.0.3

You are still missing information, if you read Judy's post she's making reference to the readme.txt file which is nowhere to be found after the upgrade.

What's so important about this file?

For me, you have information on language string settings that you do not provide online. If you could also provide this text file included in that upgrade, that would make a tremendous difference.

I hope this helps,
-Ray

Let me be a little bit more specific, below this email message you will find the readme file for the upgrade for version 9.0.2. As you can see this file has quite a bit of information, but for me it has localization stings information.

Sometimes I'm so busy that I lose things, right now I'm missing the upgrade text file for 9.0.3, nowhere on your site can I find this file. In the future I'll be more careful, but right now I'm having some issues with the localization stings and would like to know what was added and at what version.

I hope this clarifies things - thanks


====================================
AbleCommerce version 9.0.2 - build 6218
Date of Release: March 24th, 2020.
----------------------------------------------------------\

Upgrade from AbleCommerce 9.0.1 (build 5867) to 9.0.2 (build 6218)

- Access to the server running AbleCommerce will be required.

- This release will upgrade AbleCommerce 9.0.1.5867 only.

- A valid subscription license is required; ends on or after 03/24/2020

----------------------------------------------------------\

### Installation Instructions ###

TO VERIFY THE DOWNLOAD:
**********************************************************\

1. Go to WinMD5.com or any other utility that can provide checksum validation.

2. Download the .zip file, and run the MD5 utility.

3. Select the downloaded for 'AbleCommerce Upgrade to 9.0.2'

4. In the field provided, copy the MD5 hash provided below, or displayed on the Upgrade page.

d78398f06328bca4fa407cde104aae48

5. Click Verify and confirm the number is a match.

6. If the validation fails, do NOT install the patch. Instead, open a support ticket at our website.

TO INSTALL THE UPGRADE:
**********************************************************\

7. Extract contents to a temporary location on the server.

\Lib\ --> files in this location are provided to developers; do not install these to the server.

\Website\ --> files and folders located here are installed to the website.

8. Backup the website and database to a separate location.

9. Stop the website using IIS.

10. Copy everything from \Website\ to the actual website root folder, matching folders and file locations.

11. Restart the website using IIS.

12. Login to the merchant admin so that any database changes will take effect.

----------------------------------------------------------\

### Post-Upgrade Instructions ###

A few localization strings will need to be updated manually.

1. After logging in to the admin, go to Configure > Store > Languages.
2. Click the 'Edit Resources' button to access the Resources page.
3. Use the Filter resource "Name" field to search/filter on each (total of 3) of the following:

retail.accountlogin.forgotpasswordusername_valid
Email address should be in the format of name@domain.tld.

retail.forgotpasswordpanel.if_the_email_address_entered_is_found_an_email_will_be_sent_containing_a_link_to_create_a_new_password
If the email address entered is found, an email will be sent containing a link to create a new password.

retail.mycredentials.username_regexvalidate
User name is not valid

4. For each search result, edit the resource. Change the translated string and save.

----------------------------------------------------------\