Cannot run upgrade wizard

[gglockner]

I'm trying to upgrade from SugarCRM CE 5.5.4 to 6.2.3. I realize that I need to upgrade to 6.1.0 first.

I have successfully done this for the development server on my computer. I have also updated our custom modules and web services calls so that everything is compatible with 6.2.3. No problems so far.

Next, I tried to upgrade our test LAMP server, but it has been a catastrophe. First, I had a timeout during the upgrade wizard. I believe that this can be resolved through the silent upgrade or by modifying the PHP settings. But first, I wanted to restore the server to its previous configuration: I restored the sugarcrm directory from my rsync backup, and I restored the MySQL database instance from its nightly backup. So far, so good: I can login to the restored test server and it seems to be working correctly. But now when I try to access the Upgrade Wizard, the page stalls for about 1 minute, then is blank. Restarting Apache and MySQL does not help. I don't have this behavior on our production server, and I can find nothing in sugarcrm.log or the Apache logs to indicate why I can no longer access the Upgrade Wizard. Additionally, I am unable to run the silent upgrade due to several configuration issues on the LAMP server, and I'm nervous about trying to get the silent upgrade working when I know the test SugarCRM instance has at least one serious problem that is preventing the Upgrade Wizard from loading.

I realize this is simply my test server, so I could always rebuild it from scratch, but I really would like to figure this out so that I don't have similar problems when I need to upgrade the production server.

[Angel]

Some of the more common reasons for it showing up blank are PHP settings and upgrade wizard thinking the prior occasion of its use is not complete.

For the first, I would encourage you to take a look at the PHP.INI of the working system and compare it to that of the non-working server. In particular, check out the following settings:

memory_limit
max_execution_time
max_input_time
post_max_size
upload_max_filesize

If you adjust any of them, restart Apache before attempting the upgrade again.

You should also take a look at upgradewizard.log as it might have some clues as to what might be happening.

Lastly, take a look at the cache/upload/upgrades/temp directory. Rename the file upgradeprogress.php file and try again.

[gglockner]

Angel, thanks very much - renaming upgrade_progress.php fixed the issue. It took some time to first load the upgrade wizard, but Sugar eventually recovered and prompted me for the update. I'll try the whole process again during the week.

[labynocle]

Hi there,

I'm really sorry to re-up this thread but I have exactly the same problem as gglockner... but your solution doesn't work for me.

Let me explain my context: standard Debian Squeeze with Apache/PHP/MySQL installed with the usual Debian packages + SugarCRM CE v6.4 (which I want to upgrad to 6.4.1)

Each time I launch the upgrade wizard, I have the blank page after the "System Check" step which is completed.
If I check my upgradeWizard.log to check if any error has been reported, but there is nothing as you can see:

Thu, 01 Mar 2012 12:36:20 +0100 [UpgradeWizard] - -----------------------------------------------------------------------------
Thu, 01 Mar 2012 12:36:20 +0100 [UpgradeWizard] - Upgrade started. At start.php
Thu, 01 Mar 2012 12:36:20 +0100 [UpgradeWizard] - at unlinkUWTempFiles()
Thu, 01 Mar 2012 12:36:20 +0100 [UpgradeWizard] - finished!
Thu, 01 Mar 2012 12:36:20 +0100 [UpgradeWizard] - resetting $_SESSION
Thu, 01 Mar 2012 12:36:27 +0100 [UpgradeWizard] - setting session variables...
Thu, 01 Mar 2012 12:36:27 +0100 [UpgradeWizard] - [At systemCheck.php]
Thu, 01 Mar 2012 12:36:27 +0100 [UpgradeWizard] - Starting file permission check...
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Finished file permission check.
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Starting database permissions check...
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Checking CREATE TABLE permissions...
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Checking INSERT INTO permissions...
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Checking UPDATE TABLE permissions...
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Checking SELECT permissions...
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Checking DELETE FROM permissions...
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions...
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions...
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions...
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Checking DROP TABLE permissions...
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - No permissions errors found!
Thu, 01 Mar 2012 12:36:36 +0100 [UpgradeWizard] - Finished database permissions check.
Thu, 01 Mar 2012 12:37:05 +0100 [UpgradeWizard] - setting session variables...
Thu, 01 Mar 2012 12:37:05 +0100 [UpgradeWizard] - At upload.php
Thu, 01 Mar 2012 12:37:05 +0100 [UpgradeWizard] - finding new files for upgrade

And I have nothing in my Apache logs too.

I checked my php.ini config:

memory_limit = 128M
max_execution_time = 30
max_input_time = 60
post_max_size = 15M
upload_max_filesize = 16M

But nothing seems to be wrong with this configuration.

As recommended, I also created the directories structure : cache/upload/upgrades/temp/
And renamed my upgrade_progress.php to let me try another shot... but still have the same problem...

Have you any clue to help me to upgrade my SugarCRM and to understand what's going on ?
Of course, I never have problem to do my previous upgrades

Thanks in advance !

[Angel]

max_execution_time and max_input_time should both be increased to a minimum of 300. post_maxsize and upload_max_filesize should both be increased to 40M.

Apply those changes, restart your web service and try again.

[roblaus]

Unfortunately this is not one of the usual php issues but Sugar related. I thought they would fix it with 641 but they didn't. Conclusion: An upgrade on Debian Squeeze currently doesn't work, this may be related to the php Version Debian uses. There were fixes for the module loader bug as well as for the upgrade bug and with some trial and error (and some very weird error messages) I was able to upgrade but it ain't easy.

It's getting weirder and more dangerous: I had a Suse 10.x version yesterday where the upgrade process first crippled some files (like dbmanager and mysqlmanager) by simply deleting a good part of it ad then stopped with a WSOD. This I could even reproduce.

Another uprade on another server (done by another customer himself) also yesterday (no idea about the OS): While uploading/copying the language pack Sugar cut the most important one in half - physically, he sent over what he found in the directory.

On the other hand upgrades under Ubuntu 10.04 LTS with some 5.2x php and 5.1.x mysql work nicely. I did this at least 50 times. Go figure...

In order to solve the problem of the poster above me: In modules/upgradewizard/uw_utils.php add AFTER this line (around 828)

$target_manifest = remove_file_extension( $upgrade_content ) . '-manifest.php';

this new line

$target_manifest = getUploadRelativeName( $target_manifest );

Then you most likely will get some error messages - check them and act accordingly - it will work eventually. Otherwise try a new 641 and copy your custom directory and attach the old DB. Problem here: Module loader doesn't work....

[labynocle]

First let me thank you both for taking time to answer me.

@Angel: I tried your settings but I got exactly the same behavior...

Is there a way to run the upgrade without the wizard?
And can I open a bug somewhere?

[labynocle]

...

In order to solve the problem of the poster above me: In modules/upgradewizard/uw_utils.php add AFTER this line (around 828)

$target_manifest = remove_file_extension( $upgrade_content ) . '-manifest.php';

this new line

$target_manifest = getUploadRelativeName( $target_manifest );

...

I don't really understand why but this solution works for me... even if I had some minor errors to fix !
thanks a lot !

[backe]

I have the same problem as the guy above me, however, looking into the uw_utils.php, it already has the line that someone suggested to add.

Since 6.4 I haven't been able to use module uploader. I thought that it may be solved in the 6.4.1, but now I can't even upgrade to 6.4.1.

I go to the upgrade wizard. It does the check. It says that all files are writeable and all that. When I click next I get a blank screen. Next time I click on upgrade wizard I get a blank screen straight away. When renaming upgrades folder I get the wizard again, but back to the first issue...

Would appreciate any help.

Using windows installation

Cheers,
Peter

[danelige]

same problem as people above.

Version 6.4.0RC1 (Build 7162), clicking on Admin->UgradeWizard displays a blank page.

Here http://www.sugarcrm.com/forums/f3/mo...d-blank-77768/ I found a suggestion to downgrade PHP to 5.2

Trying that now...