Upgrade from 7.8.31 to current LTS

SuiteCRM Forum - English Language Installation & Upgrade Help
1

Hi, total SuiteCRM noob here, so apologies if I’m fumbling around a bit here.

I’ve just inherited what was an udocumented SuiteCRM 7.1 install on a CentOS 6.9 server that has been “broken” for the last 11 months as nobody could access it. Turns out that it was an issue with PHP and LDAP and after a few days of messing about I found and fixed the LDAP settings in the db after working out how to access MySQL (yuck; any plans to support PostgreSQL?).

I’ve brought CentOS up to something vaguely current and upgraded to PHP 5.6.40 (from 5.4.x) as this seemed the safest bet from a regression testing point of view and seemed to be supported by even the most up to date SuiteCRM release and have gone through the various SuiteCRM upgrades to get me to 7.8.31 without issue (or at least none that I can see).

I’d now like to upgrade to the current LTS version and gave it a try last night but just got a blank screen in the upgrade wizard when I tried on the cloned test server I’m playing around with. I notice, on the download page, that there is something called the “SUITECRM UPGRADE PATCH” that claims to fix upgrade issues prior to upgrading. Sounds useful but what do I do with it? I’ve downloaded it and it seems to follow a similar format to the main upgrades but if I try to load it through the upgrade wizard, the wizard just rejects it. Should I be unzipping it into the web server root or similar? Is it even necessary?

Any other gotcha’s that I’m likely to run into finishing this off?

Thanks for any advice. Matt

2

Hi @IAM,

Welcome to the community.

As stated on the release notes (https://docs.suitecrm.com/admin/releases/7.10.x/) the patch needs to be installed via Module Loader not the upgrade wizard.

Please try again.

thanks,

BrozTechnologies

3

Apologies for the delay, my real day job took over and took me away from all things SuiteCRM related.

Totally missed that entry in the release notes so thanks for pointing me in the right direction.

I’ve successfully applied it but not sure it hasn’t introduced a different problem in place of the original.

On running the Upgrade Wizard with the intent to apply the Upgrade from 7.8.x to 7.10.27 I run the initial System check. I was initially getting a warning about my PHP version (5.6.40) and advising using 7.1.x or above. I could see from the compatibility matrix that 5.6.x was still supported so thought I’d carry on but there is no “next” option to get to the upload step of the process. Only Back/Cancel/Recheck options exist.

Okay, maybe it really would prefer PHP7.1. With that in mind, I successfully upgraded PHP fro 5.6.40 to 7.1.33 and tried again. Exactly the same issue. Completes the system check and no warnings/alerts so is presumably totally happy but the only buttons available are Back/Cancel/Recheck.

Am I doing something totally stupid here? Is there some form of flag somewhere that needs resetting to allow the upgrade wizard to run again properly. Somewhat at a loss now. :confused:

wizard
wizard911×350 15.3 KB

upgrade log excerpt:

Fri, 16 Oct 2020 14:30:30 +0100 [UpgradeWizard] - setting session variables…
Fri, 16 Oct 2020 14:30:30 +0100 [UpgradeWizard] - -----------------------------------------------------------------------------
Fri, 16 Oct 2020 14:30:30 +0100 [UpgradeWizard] - Upgrade started. At start.php
Fri, 16 Oct 2020 14:30:30 +0100 [UpgradeWizard] - at unlinkUWTempFiles()
Fri, 16 Oct 2020 14:30:30 +0100 [UpgradeWizard] - finished!
Fri, 16 Oct 2020 14:30:30 +0100 [UpgradeWizard] - resetting $_SESSION
Fri, 16 Oct 2020 14:30:42 +0100 [UpgradeWizard] - setting session variables…
Fri, 16 Oct 2020 14:30:42 +0100 [UpgradeWizard] - [At systemCheck.php]
Fri, 16 Oct 2020 14:30:42 +0100 [UpgradeWizard] - Starting file permission check…
Fri, 16 Oct 2020 14:30:42 +0100 [UpgradeWizard] - Finished file permission check.
Fri, 16 Oct 2020 14:30:42 +0100 [UpgradeWizard] - Starting database permissions check…
Fri, 16 Oct 2020 14:30:42 +0100 [UpgradeWizard] - Checking CREATE TABLE permissions…
Fri, 16 Oct 2020 14:30:43 +0100 [UpgradeWizard] - Checking INSERT INTO permissions…
Fri, 16 Oct 2020 14:30:43 +0100 [UpgradeWizard] - Checking UPDATE TABLE permissions…
Fri, 16 Oct 2020 14:30:43 +0100 [UpgradeWizard] - Checking SELECT permissions…
Fri, 16 Oct 2020 14:30:43 +0100 [UpgradeWizard] - Checking DELETE FROM permissions…
Fri, 16 Oct 2020 14:30:43 +0100 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions…
Fri, 16 Oct 2020 14:30:43 +0100 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions…
Fri, 16 Oct 2020 14:30:43 +0100 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions…
Fri, 16 Oct 2020 14:30:43 +0100 [UpgradeWizard] - Checking DROP TABLE permissions…
Fri, 16 Oct 2020 14:30:43 +0100 [UpgradeWizard] - No permissions errors found!
Fri, 16 Oct 2020 14:30:43 +0100 [UpgradeWizard] - Finished database permissions check.

4

Hi,

Make sure you cleared your own browser cache, I’ve had a simialr problem that was related to my browser not the server. Quite often now I run Upgrades and maintenace with my browser set to Incongito mode to eliminate the effects of caching.

Next if that has no effect try running some SuiteCRM Repairs and Maintenance, dropping the server cache, etc., etc…

5

Also make sure you delete cache/upgrades/temp between each upgrade attempt.