Upgrade - error 500

SuiteCRM Forum - English Language Installation & Upgrade Help
#1

Hi, i am facing the same problem, trying to upgrade from 7.10.1 to 7.10.2, then i click the upgrade wizard in the admin panel first nothning happens for 20-30 seconds and then i get an error 500
from the upgrade log i have

on, 26 Mar 2018 11:11:42 +0300 [UpgradeWizard] - setting session variables...
Mon, 26 Mar 2018 11:11:44 +0300 [UpgradeWizard] - [At end.php]
Mon, 26 Mar 2018 11:11:44 +0300 [UpgradeWizard] - About to repair the database.
Mon, 26 Mar 2018 11:11:52 +0300 [UpgradeWizard] - Running sql:/* Table : oauth2clients */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - duration_value -  ROW [name] => 'duration_value'  [type] => 'int'  [len] => '11'  */
/* VARDEF - duration_value -  ROW[name] => 'duration_value'  [type] => 'integer'  [required] => ''  [reportable] => ''  [api-visible] => ''  [inline_edit] => ''  [dbType] => 'integer'  [len] => ''  */
/*MISMATCH WITH DATABASE - duration_amount -  ROW [name] => 'duration_amount'  [type] => 'int'  [len] => '11'  */
/* VARDEF - duration_amount -  ROW[name] => 'duration_amount'  [vname] => 'LBL_DURATION_AMOUNT'  [type] => 'integer'  [required] => ''  [reportable] => ''  [api-visible] => ''  [inline_edit] => ''  [dbType] => 'integer'  [len] => ''  */
/* INDEXES */
ALTER TABLE oauth2clients   modify COLUMN duration_value integer  NULL ,  modify COLUMN duration_amount integer  NULL 

Mon, 26 Mar 2018 11:11:54 +0300 [UpgradeWizard] - database repaired
Mon, 26 Mar 2018 11:11:54 +0300 [UpgradeWizard] -  Start Rebuilding the config file again
Mon, 26 Mar 2018 11:11:54 +0300 [UpgradeWizard] -  Finish Rebuilding the config file again
Mon, 26 Mar 2018 11:11:54 +0300 [UpgradeWizard] - Begin upgrade_connectors
Mon, 26 Mar 2018 11:11:54 +0300 [UpgradeWizard] - End upgrade_connectors
Mon, 26 Mar 2018 11:19:02 +0300 [UpgradeWizard] - setting session variables...
Mon, 26 Mar 2018 11:19:04 +0300 [UpgradeWizard] - [At end.php]
Mon, 26 Mar 2018 11:19:04 +0300 [UpgradeWizard] - About to repair the database.
Mon, 26 Mar 2018 11:19:11 +0300 [UpgradeWizard] - Running sql:/* Table : oauth2clients */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - duration_value -  ROW [name] => 'duration_value'  [type] => 'int'  [len] => '11'  */
/* VARDEF - duration_value -  ROW[name] => 'duration_value'  [type] => 'integer'  [required] => ''  [reportable] => ''  [api-visible] => ''  [inline_edit] => ''  [dbType] => 'integer'  [len] => ''  */
/*MISMATCH WITH DATABASE - duration_amount -  ROW [name] => 'duration_amount'  [type] => 'int'  [len] => '11'  */
/* VARDEF - duration_amount -  ROW[name] => 'duration_amount'  [vname] => 'LBL_DURATION_AMOUNT'  [type] => 'integer'  [required] => ''  [reportable] => ''  [api-visible] => ''  [inline_edit] => ''  [dbType] => 'integer'  [len] => ''  */
/* INDEXES */
ALTER TABLE oauth2clients   modify COLUMN duration_value integer  NULL ,  modify COLUMN duration_amount integer  NULL 

Mon, 26 Mar 2018 11:19:12 +0300 [UpgradeWizard] - database repaired
Mon, 26 Mar 2018 11:19:12 +0300 [UpgradeWizard] -  Start Rebuilding the config file again
Mon, 26 Mar 2018 11:19:12 +0300 [UpgradeWizard] -  Finish Rebuilding the config file again
Mon, 26 Mar 2018 11:19:12 +0300 [UpgradeWizard] - Begin upgrade_connectors
Mon, 26 Mar 2018 11:19:12 +0300 [UpgradeWizard] - End upgrade_connectors

As you can see i tried the quick repair option and still i get the same result.

#2

Hhmm this bug was already fixed, I don’t know why you are still getting it :frowning:

Try applying these changes

https://github.com/salesagility/SuiteCRM/pull/5428/commits/567b62e8146fe9281097d1c86c2feba1fae70318

#3

Hello, still the same
Mon, 26 Mar 2018 13:51:11 +0300 [UpgradeWizard] - setting session variables…
Mon, 26 Mar 2018 13:51:12 +0300 [UpgradeWizard] - [At end.php]
Mon, 26 Mar 2018 13:51:12 +0300 [UpgradeWizard] - About to repair the database.
Mon, 26 Mar 2018 13:51:16 +0300 [UpgradeWizard] - database repaired
Mon, 26 Mar 2018 13:51:16 +0300 [UpgradeWizard] - Start Rebuilding the config file again
Mon, 26 Mar 2018 13:51:16 +0300 [UpgradeWizard] - Finish Rebuilding the config file again
Mon, 26 Mar 2018 13:51:16 +0300 [UpgradeWizard] - Begin upgrade_connectors
Mon, 26 Mar 2018 13:51:16 +0300 [UpgradeWizard] - End upgrade_connectors

and in /var/log

[Mon Mar 26 13:50:36.576210 2018] [:error] [pid 29674:tid 139972621686528] [client x.x.x.x:55210] PHP Notice: Undefined index: current_db_version in /var/www/SuiteCRM/modules/UpgradeWizard/end.php on line 198, referer: http://x.x.x.x/index.php?module=Administration&action=index
[Mon Mar 26 13:50:36.576252 2018] [:error] [pid 29674:tid 139972621686528] [client x.x.x.x:55210] PHP Notice: Undefined index: current_db_version in /var/www/SuiteCRM/modules/UpgradeWizard/end.php on line 208, referer: http://x.x.x.x/index.php?module=Administration&action=index
[Mon Mar 26 13:50:48.804499 2018] [:error] [pid 29674:tid 139972621686528] [client x.x.x.x:55210] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 49152 bytes) in /var/www/SuiteCRM/cache/smarty/templates_c/%%F3^F31^F313B5E1%%reminders.tpl.php on line 189, referer: http://x.x.x.x/index.php?module=Administration&action=index
[Mon Mar 26 13:51:16.683683 2018] [:error] [pid 29674:tid 139972613293824] [client x.x.x.x:55227] PHP Notice: Undefined index: current_db_version in /var/www/SuiteCRM/modules/UpgradeWizard/end.php on line 198
[Mon Mar 26 13:51:16.683728 2018] [:error] [pid 29674:tid 139972613293824] [client x.x.x.x:55227] PHP Notice: Undefined index: current_db_version in /var/www/SuiteCRM/modules/UpgradeWizard/end.php on line 208

#4

@dipolnet I moved your posts to a new thread, please don’t hijack old threads. You say “it’s the same issue” when really there are dozens of different details, different versions, different error messages.

Your problem is that FATAL error about exhausted memory. You need to go into your php.ini and increase memory_limit to 256M or even better, 512M