500 Errors on Upgrade to 7.8.2

SuiteCRM Forum - English Language Installation & Upgrade Help
1

Hi,

Environment info: SuiteCRM 7.6, PHP 5.6, IIS 8.0.9200.16834, SQL Server 2012 R2 on Windows Server 2012 (test, production on R2)

I’m trying to upgrade from 7.6 to 7.8.2 using the upgrade wizard, and can only get part way through the process. Everything works up to step 3. When I click on step 4 to commit, a progress box is shown, then after about a minute or two, I get a 500 error.

The upgrade takes, at least partially. The version shows as 7.8.2, and everything seems to work, except when I try to run the upgrade wizard and get the 500 error again.

I tried a repair and get the following error in the suitecrm.log:
CREATE TABLE spots ([id] varchar(36) NOT NULL ,[name] nvarchar(255) NULL ,[date_entered] datetime NULL ,[date_modified] datetime NULL ,[modified_user_id] varchar(36) NULL ,[created_by] varchar(36) NULL ,[description] nvarchar(max) NULL ,[deleted] bit DEFAULT ‘0’ NULL ,[assigned_user_id] varchar(36) NULL ,[config] nvarchar(max) DEFAULT '{&quot::: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Unclosed quotation mark after the character string ‘{&quot’.

Any hints on what to do to get a clean upgrade?
Thanks,
PR

ps. The php log has these errors after trying to start the upgrade wizard:
[16-Mar-2017 16:53:15 America/New_York] PHP Strict standards: Declaration of MyCallsDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in C:\inetpub\wwwroot\CRM\modules\Calls\Dashlets\MyCallsDashlet\MyCallsDashlet.php on line 174
[16-Mar-2017 16:53:15 America/New_York] PHP Stack trace:
[16-Mar-2017 16:53:15 America/New_York] PHP 1. {main}() C:\inetpub\wwwroot\CRM\index.php:0
[16-Mar-2017 16:53:15 America/New_York] PHP 2. SugarApplication->execute() C:\inetpub\wwwroot\CRM\index.php:52
[16-Mar-2017 16:53:15 America/New_York] PHP 3. SugarController->execute() C:\inetpub\wwwroot\CRM\include\MVC\SugarApplication.php:105
[16-Mar-2017 16:53:15 America/New_York] PHP 4. SugarController->processView() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:310
[16-Mar-2017 16:53:15 America/New_York] PHP 5. SugarView->process() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:363
[16-Mar-2017 16:53:15 America/New_York] PHP 6. HomeViewList->display() C:\inetpub\wwwroot\CRM\include\MVC\View\SugarView.php:169
[16-Mar-2017 16:53:15 America/New_York] PHP 7. include() C:\inetpub\wwwroot\CRM\modules\Home\views\view.list.php:52
[16-Mar-2017 16:53:15 America/New_York] PHP Strict standards: Declaration of MyMeetingsDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in C:\inetpub\wwwroot\CRM\modules\Meetings\Dashlets\MyMeetingsDashlet\MyMeetingsDashlet.php on line 209
[16-Mar-2017 16:53:15 America/New_York] PHP Stack trace:
[16-Mar-2017 16:53:15 America/New_York] PHP 1. {main}() C:\inetpub\wwwroot\CRM\index.php:0
[16-Mar-2017 16:53:15 America/New_York] PHP 2. SugarApplication->execute() C:\inetpub\wwwroot\CRM\index.php:52
[16-Mar-2017 16:53:15 America/New_York] PHP 3. SugarController->execute() C:\inetpub\wwwroot\CRM\include\MVC\SugarApplication.php:105
[16-Mar-2017 16:53:15 America/New_York] PHP 4. SugarController->processView() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:310
[16-Mar-2017 16:53:15 America/New_York] PHP 5. SugarView->process() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:363
[16-Mar-2017 16:53:15 America/New_York] PHP 6. HomeViewList->display() C:\inetpub\wwwroot\CRM\include\MVC\View\SugarView.php:169
[16-Mar-2017 16:53:15 America/New_York] PHP 7. include() C:\inetpub\wwwroot\CRM\modules\Home\views\view.list.php:52
[16-Mar-2017 16:53:15 America/New_York] PHP Strict standards: Declaration of MyOpportunitiesDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in C:\inetpub\wwwroot\CRM\modules\Opportunities\Dashlets\MyOpportunitiesDashlet\MyOpportunitiesDashlet.php on line 90
[16-Mar-2017 16:53:15 America/New_York] PHP Stack trace:
[16-Mar-2017 16:53:15 America/New_York] PHP 1. {main}() C:\inetpub\wwwroot\CRM\index.php:0
[16-Mar-2017 16:53:15 America/New_York] PHP 2. SugarApplication->execute() C:\inetpub\wwwroot\CRM\index.php:52
[16-Mar-2017 16:53:15 America/New_York] PHP 3. SugarController->execute() C:\inetpub\wwwroot\CRM\include\MVC\SugarApplication.php:105
[16-Mar-2017 16:53:15 America/New_York] PHP 4. SugarController->processView() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:310
[16-Mar-2017 16:53:15 America/New_York] PHP 5. SugarView->process() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:363
[16-Mar-2017 16:53:15 America/New_York] PHP 6. HomeViewList->display() C:\inetpub\wwwroot\CRM\include\MVC\View\SugarView.php:169
[16-Mar-2017 16:53:15 America/New_York] PHP 7. include() C:\inetpub\wwwroot\CRM\modules\Home\views\view.list.php:52
[16-Mar-2017 16:53:15 America/New_York] PHP Strict standards: Declaration of MyAccountsDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in C:\inetpub\wwwroot\CRM\modules\Accounts\Dashlets\MyAccountsDashlet\MyAccountsDashlet.php on line 101
[16-Mar-2017 16:53:15 America/New_York] PHP Stack trace:
[16-Mar-2017 16:53:15 America/New_York] PHP 1. {main}() C:\inetpub\wwwroot\CRM\index.php:0
[16-Mar-2017 16:53:15 America/New_York] PHP 2. SugarApplication->execute() C:\inetpub\wwwroot\CRM\index.php:52
[16-Mar-2017 16:53:15 America/New_York] PHP 3. SugarController->execute() C:\inetpub\wwwroot\CRM\include\MVC\SugarApplication.php:105
[16-Mar-2017 16:53:15 America/New_York] PHP 4. SugarController->processView() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:310
[16-Mar-2017 16:53:15 America/New_York] PHP 5. SugarView->process() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:363
[16-Mar-2017 16:53:15 America/New_York] PHP 6. HomeViewList->display() C:\inetpub\wwwroot\CRM\include\MVC\View\SugarView.php:169
[16-Mar-2017 16:53:15 America/New_York] PHP 7. include() C:\inetpub\wwwroot\CRM\modules\Home\views\view.list.php:52
[16-Mar-2017 16:53:15 America/New_York] PHP Strict standards: Declaration of SugarFeedDashlet::process() should be compatible with DashletGeneric::process($lvsParams = Array, $id = NULL) in C:\inetpub\wwwroot\CRM\modules\SugarFeed\Dashlets\SugarFeedDashlet\SugarFeedDashlet.php on line 607
[16-Mar-2017 16:53:15 America/New_York] PHP Stack trace:
[16-Mar-2017 16:53:15 America/New_York] PHP 1. {main}() C:\inetpub\wwwroot\CRM\index.php:0
[16-Mar-2017 16:53:15 America/New_York] PHP 2. SugarApplication->execute() C:\inetpub\wwwroot\CRM\index.php:52
[16-Mar-2017 16:53:15 America/New_York] PHP 3. SugarController->execute() C:\inetpub\wwwroot\CRM\include\MVC\SugarApplication.php:105
[16-Mar-2017 16:53:15 America/New_York] PHP 4. SugarController->processView() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:310
[16-Mar-2017 16:53:15 America/New_York] PHP 5. SugarView->process() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:363
[16-Mar-2017 16:53:15 America/New_York] PHP 6. HomeViewList->display() C:\inetpub\wwwroot\CRM\include\MVC\View\SugarView.php:169
[16-Mar-2017 16:53:15 America/New_York] PHP 7. include() C:\inetpub\wwwroot\CRM\modules\Home\views\view.list.php:52
[16-Mar-2017 16:53:16 America/New_York] PHP Notice: Undefined property: PipelineBySalesStageDashlet::$seedBean in C:\inetpub\wwwroot\CRM\include\Dashlets\Dashlet.php on line 245
[16-Mar-2017 16:53:16 America/New_York] PHP Stack trace:
[16-Mar-2017 16:53:16 America/New_York] PHP 1. {main}() C:\inetpub\wwwroot\CRM\index.php:0
[16-Mar-2017 16:53:16 America/New_York] PHP 2. SugarApplication->execute() C:\inetpub\wwwroot\CRM\index.php:52
[16-Mar-2017 16:53:16 America/New_York] PHP 3. SugarController->execute() C:\inetpub\wwwroot\CRM\include\MVC\SugarApplication.php:105
[16-Mar-2017 16:53:16 America/New_York] PHP 4. SugarController->processView() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:310
[16-Mar-2017 16:53:16 America/New_York] PHP 5. SugarView->process() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:363
[16-Mar-2017 16:53:16 America/New_York] PHP 6. HomeViewList->display() C:\inetpub\wwwroot\CRM\include\MVC\View\SugarView.php:169
[16-Mar-2017 16:53:16 America/New_York] PHP 7. include() C:\inetpub\wwwroot\CRM\modules\Home\views\view.list.php:52
[16-Mar-2017 16:53:16 America/New_York] PHP 8. Dashlet->getHeader() C:\inetpub\wwwroot\CRM\modules\Home\index.php:239
[16-Mar-2017 16:53:16 America/New_York] PHP Notice: Trying to get property of non-object in C:\inetpub\wwwroot\CRM\include\Dashlets\Dashlet.php on line 245
[16-Mar-2017 16:53:16 America/New_York] PHP Stack trace:
[16-Mar-2017 16:53:16 America/New_York] PHP 1. {main}() C:\inetpub\wwwroot\CRM\index.php:0
[16-Mar-2017 16:53:16 America/New_York] PHP 2. SugarApplication->execute() C:\inetpub\wwwroot\CRM\index.php:52
[16-Mar-2017 16:53:16 America/New_York] PHP 3. SugarController->execute() C:\inetpub\wwwroot\CRM\include\MVC\SugarApplication.php:105
[16-Mar-2017 16:53:16 America/New_York] PHP 4. SugarController->processView() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:310
[16-Mar-2017 16:53:16 America/New_York] PHP 5. SugarView->process() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:363
[16-Mar-2017 16:53:16 America/New_York] PHP 6. HomeViewList->display() C:\inetpub\wwwroot\CRM\include\MVC\View\SugarView.php:169
[16-Mar-2017 16:53:16 America/New_York] PHP 7. include() C:\inetpub\wwwroot\CRM\modules\Home\views\view.list.php:52
[16-Mar-2017 16:53:16 America/New_York] PHP 8. Dashlet->getHeader() C:\inetpub\wwwroot\CRM\modules\Home\index.php:239
[16-Mar-2017 16:53:16 America/New_York] PHP Notice: Undefined property: SugarNewsDashlet::$seedBean in C:\inetpub\wwwroot\CRM\include\Dashlets\Dashlet.php on line 245
[16-Mar-2017 16:53:16 America/New_York] PHP Stack trace:
[16-Mar-2017 16:53:16 America/New_York] PHP 1. {main}() C:\inetpub\wwwroot\CRM\index.php:0
[16-Mar-2017 16:53:16 America/New_York] PHP 2. SugarApplication->execute() C:\inetpub\wwwroot\CRM\index.php:52
[16-Mar-2017 16:53:16 America/New_York] PHP 3. SugarController->execute() C:\inetpub\wwwroot\CRM\include\MVC\SugarApplication.php:105
[16-Mar-2017 16:53:16 America/New_York] PHP 4. SugarController->processView() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:310
[16-Mar-2017 16:53:16 America/New_York] PHP 5. SugarView->process() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:363
[16-Mar-2017 16:53:16 America/New_York] PHP 6. HomeViewList->display() C:\inetpub\wwwroot\CRM\include\MVC\View\SugarView.php:169
[16-Mar-2017 16:53:16 America/New_York] PHP 7. include() C:\inetpub\wwwroot\CRM\modules\Home\views\view.list.php:52
[16-Mar-2017 16:53:16 America/New_York] PHP 8. Dashlet->getHeader() C:\inetpub\wwwroot\CRM\modules\Home\index.php:239
[16-Mar-2017 16:53:16 America/New_York] PHP Notice: Trying to get property of non-object in C:\inetpub\wwwroot\CRM\include\Dashlets\Dashlet.php on line 245
[16-Mar-2017 16:53:16 America/New_York] PHP Stack trace:
[16-Mar-2017 16:53:16 America/New_York] PHP 1. {main}() C:\inetpub\wwwroot\CRM\index.php:0
[16-Mar-2017 16:53:16 America/New_York] PHP 2. SugarApplication->execute() C:\inetpub\wwwroot\CRM\index.php:52
[16-Mar-2017 16:53:16 America/New_York] PHP 3. SugarController->execute() C:\inetpub\wwwroot\CRM\include\MVC\SugarApplication.php:105
[16-Mar-2017 16:53:16 America/New_York] PHP 4. SugarController->processView() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:310
[16-Mar-2017 16:53:16 America/New_York] PHP 5. SugarView->process() C:\inetpub\wwwroot\CRM\include\MVC\Controller\SugarController.php:363
[16-Mar-2017 16:53:16 America/New_York] PHP 6. HomeViewList->display() C:\inetpub\wwwroot\CRM\include\MVC\View\SugarView.php:169
[16-Mar-2017 16:53:16 America/New_York] PHP 7. include() C:\inetpub\wwwroot\CRM\modules\Home\views\view.list.php:52
[16-Mar-2017 16:53:16 America/New_York] PHP 8. Dashlet->getHeader() C:\inetpub\wwwroot\CRM\modules\Home\index.php:239

2

See
https://github.com/salesagility/SuiteCRM/issues/942

specifically, my comment (pgorod) from 5 Jan, you’ll find a workaround for the PHP errors. You basically have to supply defaults for parameters so they become optional.

Normally these don’t break anything, but I’ve seen Windows installs (like yours) be unable to install just because of them. So try to start by fixing those and then we’ll see if your problem is solved or not.