AnsweredAssumed Answered

Upgrade from 6.5.2 to any other version by any method at all failing.

Question asked by Plutocrat Plutocrat on Mar 2, 2015
Latest reply on Apr 23, 2015 by cent cent
Some background. I was active in the SugarCRM community for several years while my clients were using the software earlier this century, but then wasn't active for the last 4 years or so. I have just inherited an old installation of 6.5.2, and have been trying to upgrade it for the last 4 days without success.

Initial attempts were through the upgrade wizard. At first I got a blank screen. Turning on PHP error reporting, I got an error about the implodeVersion function. I traced this down though some googling and found that this function should be in the /modules/UpgradeWizard/ug_utils.php file. It wasn't there in my installation which explained the error.
I decided to try the upgrade from 6.5.x to 6.5.20 using the Silent upgrader. I still got the same message, so I reasoned that the missing function might belong to an earlier version. I tried upgrades to .17, .15, .10 and finally found one that didn't give the error when I tried 6.5.x to 6.5.6.

The upgrade process seems to run and claims it has completed successfully. A line is inserted into upgrade_history table. However the files /sugar_version.php and /config.php are untouched.

Any further upgrades are impossible and it seems that the upgrade to 6.5.2 is not properly being executed.

I've tried loosening the file permissions. I've tried pasting the missing function from this page http://phpcrossref.com/xref/sugarcrm/modules/UpgradeWizard/uw_utils.php.html#implodeversion into the uw_utils.php file. I've searched around the internet for days. Any ideas?

Failing all other suggestions, what is the procedure for manually upgrading?


------------------------------- info ----------------------------
Here is the database entry
<uid> upload//upgrades/patch/SugarCE-Upgrade-6.5.x-to-6.5.6.zip 2d1254882850605d45965d3b947a1f91 patchinstalled 6.5.2SugarCE-Upgrade-6.5.x-to-6.5.6Silent Upgrade was used to upgrade the instance  NULL

Here are the lines from the upgrade log.
Mon, 02 Mar 2015 16:23:17 +0800 [UpgradeWizard] - *** SILENT UPGRADE INITIATED.
Mon, 02 Mar 2015 16:23:17 +0800 [UpgradeWizard] - *** UpgradeWizard Upgraded 
Mon, 02 Mar 2015 16:23:17 +0800 [UpgradeWizard] - Wait Timeout before change ***** 28800
Mon, 02 Mar 2015 16:23:17 +0800 [UpgradeWizard] - Wait Timeout after change ***** 28800
Mon, 02 Mar 2015 16:23:17 +0800 [UpgradeWizard] - Starting post_install()...
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - At updateVersions()... updating config table and sugar_version.php.
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - *** ERROR: no sugar_version.php file location found! - cannot complete upgrade...
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - Performing UWrebuild()...
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - Registering rebuild record: DELETE FROM versions WHERE name='Rebuild Extensions'
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - Rebuild done.
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - Registering rebuild record in versions table: INSERT INTO versions (id, deleted, date_entered, date_modified, modified_user_id, created_by, name, file_version, db_version) VALUES ('4bc12a90-4024-28d9-2b65-54f41d70730a', '0', '2015-03-02 08:23:18', '2015-03-02 08:23:18', '1', '1', 'Rebuild Extensions', '4.0.0', '4.0.0')
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - UWrebuild() done.
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - begin check default permissions .
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - end check default permissions .
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - begin check logger settings .
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - begin check logger settings .
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - begin check lead conversion settings .
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - end check lead conversion settings .
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - begin check resource settings .
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - begin check resource settings .
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - Set default_theme to Sugar
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - Set default_max_tabs to 7
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - Upgrade the sugar_version
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - post_install() done.
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - Registering upgrade with UpgradeHistory
Mon, 02 Mar 2015 16:23:18 +0800 [UpgradeWizard] - **** Potential PHP generated error messages:
Mon, 02 Mar 2015 16:23:20 +0800 [UpgradeWizard] - Upgrading user preferences start .
Mon, 02 Mar 2015 16:23:21 +0800 [UpgradeWizard] - Upgrading user preferences finish .
Mon, 02 Mar 2015 16:23:21 +0800 [UpgradeWizard] - Call deleteCache
Mon, 02 Mar 2015 16:23:21 +0800 [UpgradeWizard] - About to repair the database.
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - database repaired
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - Start rebuild relationships.
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - End rebuild relationships.
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - Begin merge_config_si_settings
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - Loading config.php file at (/correct/path/public_html/scrm/config.php) for merging.
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - config_si.php file at () could not be found.  Skip merging.
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - End merge_config_si_settings
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - Begin upgrade_connectors
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - End upgrade_connectors
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - Skipping unsupported image file type (17) for file sugar_icon.ico
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - Skipping unsupported image file type (13) for file SugarPlanet.swf
Mon, 02 Mar 2015 16:23:22 +0800 [UpgradeWizard] - Skipping unsupported image file type (17) for file sugar_icon.ico
Mon, 02 Mar 2015 16:23:24 +0800 [UpgradeWizard] - Skipping unsupported image file type (17) for file sugar_icon.ico
Mon, 02 Mar 2015 16:23:28 +0800 [UpgradeWizard] - Taking out the trash, unlinking temp files.
Mon, 02 Mar 2015 16:23:29 +0800 [UpgradeWizard] - Taking out the trash, done.
Mon, 02 Mar 2015 16:23:29 +0800 [UpgradeWizard] - **** Potential PHP generated error messages:
Mon, 02 Mar 2015 16:23:29 +0800 [UpgradeWizard] - ***** SilentUpgrade completed successfully.

Outcomes