Upgrade Wizard problem

Hi,
if I try to use upgrade wizard, it will be open a page with upgrade steps. The problem is, the system check will not be done, it looks like the first 3 steps where done. So I can not upgrade my Suite 7.1.2.
Someone can help?

Thanks in advance
Krzysztof

Hi there,

What errors are you getting in your sugarcrm.log if any? What stage does the upgrade reach in the upgradeWizard.log?

Have you tried re-setting permissions and then trying to access the upgrade wizard again?

Thanks,

Will.

Hi WIll,

Thank you for youer prompt answer.

The errors in my sugarcrm.log is:
[5421][1][FATAL] Job runs too frequently, throttled to protect the system.
And this error is frequently.

In upgradeWizard.log I founf this:
[UpgradeWizard] - setting session variables…
[UpgradeWizard] - [At commit.php]
[UpgradeWizard] - Setting error_reporting() to E_ERROR while running upgrade
[UpgradeWizard] - Resetting error_reporting() to system level.
[UpgradeWizard] - Rebuilding language cache

According to your sugestion I made re-setting of permissions but it didnt change teh situation.

Regards
Krzysztof

hello,

I had the same problem when I went from 7.1.2 to 7.1.3.

The upgrade has not completed and there was a blank screen. Each call causes a blank screen.

I have the file

cache/ upgrades/ upgradewizard.php renamed in upgradewizard.php_old - or something

then I could start the upgrade wizard again and delete the upgrade to 7.1.3 and upload the 7.1.4. which went successfully.

Try it - and give feedback

good luck

4 Likes

Hi Wieland,

thank you very much for your help.It was the file upgrade_progress.php at me. I have changed the name of this file and the wizard has word correctly.
I could upgrade my Suite. Thanks a lot once more.

Regards
Krzysztof

Hello Krzyszof,

Nice to hear that it worked.

Many greetings
Werner Wieland

Hi Will… Hoping a reply from you… I believe SuiteCRM release upgrades which can be upgraded normally and don’t use cheap tactic of selling their support system.

I am simply following instructions and various forums but stucked at upload upgrade step in upgradewizard. I have following log of SuiteCRM.log

Tue Oct 4 22:13:46 2016 [15610][1][FATAL] Query Failed: SELECT id FROM upgrade_history where md5sum = ‚Äė557ad10865dd90a58e30e7fe56096152‚Äô: MySQL error 2006: MySQL server has gone away
Tue Oct 4 22:13:46 2016 [15953][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‚Äė1‚Äô AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Wed Oct 5 00:21:50 2016 [61930][1][FATAL] Query Failed: SELECT id FROM upgrade_history where md5sum = ‚Äė97cc0f83433dfaca6b4d3d57006f0813‚Äô: MySQL error 2006: MySQL server has gone away
Wed Oct 5 00:21:50 2016 [62424][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‚Äė1‚Äô AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away

and following log of updatewizard:

Wed, 05 Oct 2016 00:17:02 +0530 [UpgradeWizard] - setting session variables…
Wed, 05 Oct 2016 00:17:02 +0530 [UpgradeWizard] - -----------------------------------------------------------------------------
Wed, 05 Oct 2016 00:17:02 +0530 [UpgradeWizard] - Upgrade started. At start.php
Wed, 05 Oct 2016 00:17:02 +0530 [UpgradeWizard] - at unlinkUWTempFiles()
Wed, 05 Oct 2016 00:17:02 +0530 [UpgradeWizard] - finished!
Wed, 05 Oct 2016 00:17:02 +0530 [UpgradeWizard] - resetting $_SESSION
Wed, 05 Oct 2016 00:18:07 +0530 [UpgradeWizard] - setting session variables…
Wed, 05 Oct 2016 00:18:07 +0530 [UpgradeWizard] - [At systemCheck.php]
Wed, 05 Oct 2016 00:18:07 +0530 [UpgradeWizard] - Starting file permission check…
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Finished file permission check.
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Starting database permissions check…
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Checking CREATE TABLE permissions…
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Checking INSERT INTO permissions…
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Checking UPDATE TABLE permissions…
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Checking SELECT permissions…
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Checking DELETE FROM permissions…
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions…
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions…
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions…
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Checking DROP TABLE permissions…
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - No permissions errors found!
Wed, 05 Oct 2016 00:18:18 +0530 [UpgradeWizard] - Finished database permissions check.
Wed, 05 Oct 2016 00:18:43 +0530 [UpgradeWizard] - setting session variables…
Wed, 05 Oct 2016 00:18:43 +0530 [UpgradeWizard] - At upload.php
Wed, 05 Oct 2016 00:18:44 +0530 [UpgradeWizard] - finding new files for upgrade
Wed, 05 Oct 2016 00:18:44 +0530 [UpgradeWizard] - *** UW using [ ] as source for patch files.
Wed, 05 Oct 2016 00:21:23 +0530 [UpgradeWizard] - setting session variables…
Wed, 05 Oct 2016 00:21:23 +0530 [UpgradeWizard] - At upload.php
Wed, 05 Oct 2016 00:21:23 +0530 [UpgradeWizard] - running upload
Wed, 05 Oct 2016 00:21:27 +0530 [UpgradeWizard] - File uploaded to upload://SuiteCRM-Upgrade-7.5.x-to-7.6.7.zip
Wed, 05 Oct 2016 00:21:27 +0530 [UpgradeWizard] - extracting manifest.
Wed, 05 Oct 2016 00:21:27 +0530 [UpgradeWizard] - validating manifest.php file
Wed, 05 Oct 2016 00:21:27 +0530 [UpgradeWizard] - copying manifest.php to final destination.
Wed, 05 Oct 2016 00:21:27 +0530 [UpgradeWizard] - zip file moved to [SuiteCRM-Upgrade-7.5.x-to-7.6.7.zip]
Wed, 05 Oct 2016 00:21:49 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/Localization/Localization.php
Wed, 05 Oct 2016 00:21:49 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/uw_utils.php
Wed, 05 Oct 2016 00:21:49 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/upgradeMetaHelper.php
Wed, 05 Oct 2016 00:21:49 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/language/en_us.lang.php
Wed, 05 Oct 2016 00:21:49 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/end.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/commit.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/SugarMerge/SugarMerge.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/Localization/Localization.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/uw_utils.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/upgradeMetaHelper.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/language/en_us.lang.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/end.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/commit.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/SugarMerge/SugarMerge.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/Localization/Localization.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/Localization/Localization.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: ModuleInstall/PackageManager/PackageManager.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: ModuleInstall/PackageManager/PackageController.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: ModuleInstall/PackageManager/ListViewPackages.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: ModuleInstall/ModuleInstaller.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/uw_utils.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/upgradeMetaHelper.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/language/en_us.lang.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/end.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/commit.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/SugarMerge/SugarMerge.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/Localization/Localization.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/uw_utils.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/upgradeMetaHelper.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/language/en_us.lang.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/end.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/commit.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: modules/UpgradeWizard/SugarMerge/SugarMerge.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/Localization/Localization.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/Localization/Localization.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: ModuleInstall/PackageManager/PackageManager.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: ModuleInstall/PackageManager/PackageController.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: ModuleInstall/PackageManager/ListViewPackages.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: ModuleInstall/ModuleInstaller.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/javascript/yui/build/yuiloader/yuiloader.js
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/javascript/yui/build/yuiloader/yuiloader-min.js
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/javascript/yui/build/yuiloader-dom-event/yuiloader-dom-event.js
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/javascript/yui/build/utilities/utilities.js
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/Localization/Localization.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/upload_file.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/upload_file.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - updating UpgradeWizard code: include/utils/sugar_file_utils.php
Wed, 05 Oct 2016 00:21:50 +0530 [UpgradeWizard] - finding new files for upgrade

Can you please help ? it is very common problem of all users who have installed suiteCRM but none is finding the solution for same

I went the way Wieland proposed too, removing the upgrade_progress.php file (renaming a file is a safer practice, but does not change anything, as the full content of ./cache/upgrades/temp/ is going to be cleared by the upgrade wizard next time you will run it). It made the upgrade wizard working back. However, once again the process stalled before having been fully completed :

  • System Checks done (I had to manually repair file permissions as usual, alas !
  • Upload an Upgrade done
  • Preflight Check done
  • Commit Upgrade failed

Actually, the upgrade wizard returns back to the browser a list of files having been added, a list of custom relationships (whatever it might be) having been processed, a confirmation of the deletion of the relationship cache file, a confirmation of the update of the admin warning message, a ‚Äúdone‚ÄĚ at the end, and that‚Äôs all.

There is no next button to click on and go to step 5 (Confirm Layouts). The upgrade wizard let me stuck without clear confirmation what it the state of the CRM at the present time. The file ./cache/upgrades/temp/upgrade_progress.php and other subfolders have not been removed, as a sign that the upgrade process might not be over. However, the line ‚Äú‚Äėsuitecrm_version‚Äô => ‚Äė7.7.6‚Äô,‚ÄĚ in the config.php file let‚Äôs think that the update has been done.

I do not want to go to fast to a wrong conclusion, but it looks like the upgrade wizard is somehow broken.

I tried to switch from 7.5.2. to 7.7.6 with the archive SuiteCRM-Upgrade-7.5.x-to-7.7.6-2.zip

Any guidance on checking if the upgrade actually succeeded and possibly fixing what might have been going wrong will be appreciated.

Hello,

That sounds like Permissions Issues when writing and possibly already before, if you had the problem before the upgrade.

Is there a backup that can be restored? Then I would do that first.

How does your environment and permissions look like?

Hi Wieland ! Thanks for willing to help.

We have two backups, one having been done before the update from 7.5.2 to 7.7.6. As SuiteCRM seems to be smoothly running in 7.7.6 now, I am reluctant to replay the whole update process back and forth, by restoring the backup. However there is no certainty that the update process actually got completed to the end, as the update wizard did not display the Confirm Layouts step.

We never customised any layout within SuiteCRM, then the Confirm Layouts step might be not to much important, might it ?

Regarding the directories and files permission, I am used to fix them more than often. Have you an idea why they get messed so often, specially after running the ‚Äúrepair‚ÄĚ wizard ? Of course I corrected the permissions (www-data and 755 for everything within the ./suitecrm directory and 775 for a subset of selected sub-directories) before applying the update.

I am not sure to get your point about the environment ? SuiteCRM is running here on 15.04 server, with a coming upgrade to be done in direction to 16.04 LTS. Is it your question ?

As a side note, it is nice to see that the 7.7.6 release got us rid of the CRON error messaged which used to populate the syslogs every minute or so. I never investigated the case, but I am happy that it got fixed by the contributors to the project.

Regards.

fantastic, that work great,