Blank screen while trying to upgrade from 7.1.4 to 7.1.5

šŸ“¦ Install & Upgrade Help
1

Hello!

Iā€™m trying to upgrade my SuiteCRM installation from version 7.1.4 to 7.1.5. First of all there were errors regarding php-posix. Iā€™ve installed php-process package and the errors were gone.

Then after I tried to run UpgradeWizard I saw only blank screen. In httpd error log I saw this:

[Tue Jan 20 11:53:41 2015] [error] [client 192.168.1.13] PHP Warning: require_once(upload://upgrades/patch/SuiteCRM-Upgrade-7.1.x-to-7.1.5-manifest.php): failed to open stream: ā€œUploadStream::stream_openā€ call failed in /var/www/html/sugarcrm/modules/UpgradeWizard/uw_utils.php on line 867, referer: https://site.net/index.php?module=Administration&action=index
[Tue Jan 20 11:53:41 2015] [error] [client 192.168.1.13] PHP Fatal error: require_once(): Failed opening required ā€˜upload://upgrades/patch/SuiteCRM-Upgrade-7.1.x-to-7.1.5-manifest.phpā€™ (include_path=ā€™/var/www/html/sugarcrm/include/HTMLPurifier/standalone:/var/www/html/sugarcrm/include/ā€¦:.:/usr/share/pear:/usr/share/phpā€™) in /var/www/html/sugarcrm/modules/UpgradeWizard/uw_utils.php on line 867, referer: https://site.net/index.php?module=Administration&action=index

2

Hi Andrey,

Have you tried re-setting permissions?

Thanks,

Will.

3

I too ran into a problem with the upgrade from 7.1.2 to 7.1.5.

Everything went smoothly until the last 2 steps.

It copied the files into place without error. Then the next step of updating the database lead to a blank screen.

error log -
[Wed Jan 21 09:37:20 2015] [error] [client 192.168.14.23] FastCGI: server ā€œ/var/www/clients/client2/web5/cgi-bin/php5-fcgi--80-crm.gmnews.com" stderr: PHP message: PHP Notice: Undefined index: modlink in /var/www/clients/client2/web5/web/themes/Suite7/css/colourSelector.php on line 72, referer: http://crm.gmnews.com/index.php?module=UpgradeWizard&action=index
[Wed Jan 21 09:37:20 2015] [error] [client 192.168.14.23] FastCGI: server "/var/www/clients/client2/web5/cgi-bin/php5-fcgi--80-crm.gmnews.comā€ stderr: PHP message: PHP Notice: Undefined index: custom in /var/www/clients/client2/web5/web/themes/Suite7/css/colourSelector.php on line 97, referer: http://crm.gmnews.com/index.php?module=UpgradeWizard&action=index
[Wed Jan 21 09:41:53 2015] [error] [client 192.168.14.23] FastCGI: server ā€œ/var/www/clients/client2/web5/cgi-bin/php5-fcgi--80-crm.gmnews.com" stderr: PHP message: PHP Notice: Undefined index: current_db_version in /var/www/clients/client2/web5/web/modules/UpgradeWizard/end.php on line 241, referer: http://crm.gmnews.com/index.php?module=Administration&action=index
[Wed Jan 21 09:41:53 2015] [error] [client 192.168.14.23] FastCGI: server "/var/www/clients/client2/web5/cgi-bin/php5-fcgi--80-crm.gmnews.comā€ stderr: PHP message: PHP Notice: Undefined index: current_db_version in /var/www/clients/client2/web5/web/modules/UpgradeWizard/end.php on line 250, referer: http://crm.gmnews.com/index.php?module=Administration&action=index

Sugarcrm.log
Wed Jan 21 09:38:27 2015 [31991][c4c5d5ee-c958-b49d-cdf3-535a5f350e7c][FATAL] Query Failed: ALTER TABLE aor_fields CHANGE function field_function VARCHAR( 100 ): MySQL error 1054: Unknown column ā€˜functionā€™ in ā€˜aor_fieldsā€™

upgradewidard.log
Wed, 21 Jan 2015 09:57:22 -0500 [UpgradeWizard] - modules/AOR_Reports/aor_utils.php
Wed, 21 Jan 2015 09:57:22 -0500 [UpgradeWizard] - mobile/js/quickcrm-utils.min.js
Wed, 21 Jan 2015 09:57:22 -0500 [UpgradeWizard] - mobile/js/quickcrm-ce-3.0.0.min.js
Wed, 21 Jan 2015 09:57:22 -0500 [UpgradeWizard] - mobile/js/quickcrm-ce-3.2.2.min.js
Wed, 21 Jan 2015 09:57:22 -0500 [UpgradeWizard] - custom/Extension/modules/Contacts/Ext/Vardefs/sugarfield_facebook_username_c.php
Wed, 21 Jan 2015 09:57:22 -0500 [UpgradeWizard] - custom/Extension/modules/Opportunities/Ext/Vardefs/sugarfield_textarea_c.php
Wed, 21 Jan 2015 09:57:22 -0500 [UpgradeWizard] - modules/AOD_Index/Dashlets/AOD_IndexDashlet/AOD_IndexDashlet.meta.php
Wed, 21 Jan 2015 09:57:22 -0500 [UpgradeWizard] - modules/AOD_Index/Dashlets/AOD_IndexDashlet/AOD_IndexDashlet.php
Wed, 21 Jan 2015 09:57:22 -0500 [UpgradeWizard] - modules/AOD_IndexEvent/Dashlets/AOD_IndexEventDashlet/AOD_IndexEventDashlet.meta
Wed, 21 Jan 2015 09:57:22 -0500 [UpgradeWizard] - modules/AOD_IndexEvent/Dashlets/AOD_IndexEventDashlet/AOD_IndexEventDashlet.php

Should I manually add the function fileld to the table? If so what would be the following steps to complete?

Thanks,
Jeff

4

Hi Will,

Sure, I re-set all permissions to ā€œapacheā€ user.

drwxr-xr-x 22 apache apache 4096 Dec 22 19:12 sugarcrm

Thanks,
Andrey.

5

I everybody,
Iā€™m experiencing the same problem: blank screen when trying to upgrade from version 7.1.4
The first time I loaded the UpgradeWizard from the admin menu, and everything seemed to work: the screen with the upgrade steps appeared.
I click next to start the permission check and everything was ok, then I clicked the next button and, instead of showing the upload page, a blank screen was showed.
At this point I canā€™t do anything to upgrade suitecrm because, even if I click again on the UpgradeWizard, a black screen continues to appear (the rest of the application is still working regularly).
I have no error in the logs and what follow is what is written in the upgradeWizard.log:

Sun, 25 Jan 2015 14:00:46 +0000 [UpgradeWizard] - setting session variablesā€¦
Sun, 25 Jan 2015 14:00:46 +0000 [UpgradeWizard] - At upload.php
Sun, 25 Jan 2015 14:00:46 +0000 [UpgradeWizard] - finding new files for upgrade
Sun, 25 Jan 2015 14:00:52 +0000 [UpgradeWizard] - setting session variablesā€¦
Sun, 25 Jan 2015 14:00:52 +0000 [UpgradeWizard] - [At systemCheck.php]
Sun, 25 Jan 2015 14:00:52 +0000 [UpgradeWizard] - Starting file permission checkā€¦
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Finished file permission check.
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Starting database permissions checkā€¦
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Checking CREATE TABLE permissionsā€¦
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Checking INSERT INTO permissionsā€¦
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Checking UPDATE TABLE permissionsā€¦
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Checking SELECT permissionsā€¦
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Checking DELETE FROM permissionsā€¦
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissionsā€¦
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissionsā€¦
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissionsā€¦
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Checking DROP TABLE permissionsā€¦
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - No permissions errors found!
Sun, 25 Jan 2015 14:01:15 +0000 [UpgradeWizard] - Finished database permissions check.

Any suggestion?

Thanks
Massimiliano

6

Hello!

It seems like Iā€™ve fixed an issue by manually coppying manifest.php file for version 7.1.5 to ā€¦/upload/upgrades/patch folder. After this update finished successfully.

Thanks,
Andrey.

1 Like
7

Salerno

can you check the php error log ? this could open the door to your problem.

Ian.