Cannot Upgrade

📦 Install & Upgrade Help
1

Hi Everyone

I have been having several issues with Suite not displaying correctly. Decided I could try to solve them by upgrading from 7.10.7 to 7.10.10 but does not allow me to progress to part 2 it stops on a blank screen.

myinstance/index.php?module=Administration&action=index

I get the following error code

Mon Nov 5 10:53:47 2018 [911][388e38d3-1a5e-3fe8-27c1-5b7bdfb42298][ERROR] error: no ieID
Mon Nov 5 10:53:51 2018 [32617][388e38d3-1a5e-3fe8-27c1-5b7bdfb42298][ERROR] Missing email ID
Mon Nov 5 10:53:51 2018 [32617][388e38d3-1a5e-3fe8-27c1-5b7bdfb42298][ERROR] Email address save error

I have run numerous repairs, but have not found a way to square this.

Princeps

2

I found these error codes as well.

Mon Nov 5 10:58:49 2018 [911][388e38d3-1a5e-3fe8-27c1-5b7bdfb42298][FATAL] Mysqli_query failed.
Mon Nov 5 10:58:49 2018 [911][388e38d3-1a5e-3fe8-27c1-5b7bdfb42298][FATAL] Query Failed: DESCRIBE versions: MySQL error 1146: Table ‘suitecrmdata.versions’ doesn’t exist
Mon Nov 5 10:58:49 2018 [911][388e38d3-1a5e-3fe8-27c1-5b7bdfb42298][FATAL] Mysqli_query failed.
Mon Nov 5 10:58:49 2018 [911][388e38d3-1a5e-3fe8-27c1-5b7bdfb42298][FATAL] Query Failed: SHOW INDEX FROM versions: MySQL error 1146: Table ‘suitecrmdata.versions’ doesn’t exist
Mon Nov 5 10:58:49 2018 [911][388e38d3-1a5e-3fe8-27c1-5b7bdfb42298][FATAL] Mysqli_query failed.
Mon Nov 5 10:58:49 2018 [911][388e38d3-1a5e-3fe8-27c1-5b7bdfb42298][FATAL] Query Failed: select * from versions: MySQL error 1146: Table ‘suitecrmdata.versions’ doesn’t exist

3

Found the following in my php_errors.log

[05-Nov-2018 11:28:36 UTC] PHP Fatal error: require_once(): Failed opening required ‘upload://upgrades/module/Test2018_09_21_075831-manifest.php’ (include_path=’/var/www/html:/var/www/html/include/…:.:/usr/share/pear:/usr/share/php’) in /var/www/html/modules/UpgradeWizard/uw_utils.php on line 953
[05-Nov-2018 11:29:50 UTC] PHP Warning: require_once(upload://upgrades/module/Test2018_09_21_075831-manifest.php): failed to open stream: “UploadStream::stream_open” call failed in /var/www/html/modules/UpgradeWizard/uw_utils.php on line 953
[05-Nov-2018 11:29:50 UTC] PHP Fatal error: require_once(): Failed opening required ‘upload://upgrades/module/Test2018_09_21_075831-manifest.php’ (include_path=’/var/www/html:/var/www/html/include/…:.:/usr/share/pear:/usr/share/php’) in /var/www/html/modules/UpgradeWizard/uw_utils.php on line 953

:frowning: :frowning: :frowning:

4

Rechecking my file permissions and SQL database haven’t reset themselves now.

5

I found a new error code in my error log that indicates this is the issue in my module/survey/survey.php

Undefined index: survey_questions_names in /var/www/html/modules/Surveys/Surveys.php on line 155
public function save($check_notify = false)
 
   {
        $res = parent::save($check_notify);
        if (empty($_REQUEST['survey_questions_supplied'])) {
            return $res;
        }

        foreach ($_REQUEST['survey_questions_names'] as $key => $val) {
            if (!empty($_REQUEST['survey_questions_ids'][$key])) {
                $question = BeanFactory::getBean('SurveyQuestions', $_REQUEST['survey_questions_ids'][$key]);
            } else {
                $question = BeanFactory::newBean('SurveyQuestions');
            }
            $question->name = $val;
            $question->type = $_REQUEST['survey_questions_types'][$key];
            $question->sort_order = $_REQUEST['survey_questions_sortorder'][$key];
            $question->survey_id = $this->id;
            $question->deleted = $_REQUEST['survey_questions_deleted'][$key];
            $question->save();
            if (!empty($_REQUEST['survey_questions_options'][$key])) {
                $this->saveOptions(
                    $_REQUEST['survey_questions_options'][$key],
                    $_REQUEST['survey_questions_options_id'][$key],
                    $_REQUEST['survey_questions_options_deleted'][$key],
                    $question->id
                );
            }
        }

        return $res;
    }
6

Hi

Managed to progress on this by using the technique from this previous post

https://suitecrm.com/suitecrm/forum/installation-upgrade-help/3276-blank-screen-while-trying-to-upgrade-from-7-1-4-to-7-1-5

“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.”

I did the above and moved to the next stage then blanked again.

Frustrating!

Princeps

7

I am attempting to drop the full unzipped file into patch and then put it zipped into full part of the upgrade folder.

Not sure why it is not working.

Princeps

8

Ok now getting error

/var/www/html/modules/UpgradeWizard/systemCheck.php on line 98

and

[07-Nov-2018 16:56:54 UTC] PHP Warning: fopen(custom/application/Ext/Include//modules.ext.php): failed to open stream: Permission denied in /var/www/html/include/utils/sugar_file_utils.php on line 127
[07-Nov-2018 16:56:54 UTC] PHP Warning: fwrite() expects parameter 1 to be resource, boolean given in /var/www/html/ModuleInstall/ModuleInstaller.php on line 1883
[07-Nov-2018 16:56:54 UTC] PHP Warning: fclose() expects parameter 1 to be resource, boolean given in /var/www/html/ModuleInstall/ModuleInstaller.php on line 1884

Is this a permissions issue, I thought I had resolved any!

Gosh these permissions are either tricky or I am missing a key part of a modeul.

Princeps