starred/SuiteCRM-SuiteCRM

Fork 0

mirror of https://github.com/SuiteCRM/SuiteCRM.git synced 2026-03-02 19:16:58 -05:00

Upgrade Wizard Stucks on Repair the Database #5352

New issue

Open

opened 2026-02-20 17:00:03 -05:00 by deekerman · 1 comment

deekerman commented

2026-02-20 17:00:03 -05:00

Owner

Originally created by @juncelcarreon on GitHub (Nov 12, 2025).

Issue

When I started in the company where I am in.

Our SuiteCRM Version was 7.11.21.

We were able to upgrade it to 7.12.6 with no problem and what is currently in our Production.

After that we continued and able to update the SuiteCRM up until 7.13.1, but after that we got stuck to repair the database

This is my upgradeWizard.log

Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - call addNewSystemTabsFromUpgrade(upload://upgrades/patch/SuiteCRM-Upgrade-7.13.x-to-7.13.2-restore)
Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - check to see if new modules exist
Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - new modules to add are array (
'Home' => 'Home',
'Calendar' => 'Calendar',
'Calls' => 'Calls',
'Meetings' => 'Meetings',
'Tasks' => 'Tasks',
'Notes' => 'Notes',
'Leads' => 'Leads',
'Contacts' => 'Contacts',
'Accounts' => 'Accounts',
'Opportunities' => 'Opportunities',
'Emails' => 'Emails',
'EmailTemplates' => 'EmailTemplates',
'Campaigns' => 'Campaigns',
'Prospects' => 'Prospects',
'ProspectLists' => 'ProspectLists',
'Documents' => 'Documents',
'Cases' => 'Cases',
'Project' => 'Project',
'Bugs' => 'Bugs',
'ResourceCalendar' => 'ResourceCalendar',
'AOBH_BusinessHours' => 'AOBH_BusinessHours',
'Spots' => 'Spots',
'AM_ProjectTemplates' => 'AM_ProjectTemplates',
'AOK_Knowledge_Base_Categories' => 'AOK_Knowledge_Base_Categories',
'AOK_KnowledgeBase' => 'AOK_KnowledgeBase',
'FP_events' => 'FP_events',
'FP_Event_Locations' => 'FP_Event_Locations',
'AOR_Reports' => 'AOR_Reports',
'AOR_Scheduled_Reports' => 'AOR_Scheduled_Reports',
'AOS_Contracts' => 'AOS_Contracts',
'AOS_Invoices' => 'AOS_Invoices',
'AOS_PDF_Templates' => 'AOS_PDF_Templates',
'AOS_Product_Categories' => 'AOS_Product_Categories',
'AOS_Products' => 'AOS_Products',
'AOS_Quotes' => 'AOS_Quotes',
'AOW_WorkFlow' => 'AOW_WorkFlow',
'jjwg_Maps' => 'jjwg_Maps',
'jjwg_Markers' => 'jjwg_Markers',
'jjwg_Areas' => 'jjwg_Areas',
'jjwg_Address_Cache' => 'jjwg_Address_Cache',
'SecurityGroups' => 'SecurityGroups',
'Surveys' => 'Surveys',
'sng_CallHistory' => 'sng_CallHistory',
'AsteriskIntegration' => 'AsteriskIntegration',
'RM_RMTitles' => 'RM_RMTitles',
)
Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - module tabs updated
Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - finished addNewSystemTabsFromUpgrade
Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - Registering upgrade with UpgradeHistory
Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - Rebuilding language cache
Wed, 29 Oct 2025 16:20:13 +0000 [UpgradeWizard] - setting session variables...
Wed, 29 Oct 2025 16:21:05 +0000 [UpgradeWizard] - setting session variables...
Wed, 29 Oct 2025 16:21:11 +0000 [UpgradeWizard] - [At end.php]
Wed, 29 Oct 2025 16:21:11 +0000 [UpgradeWizard] - About to repair the database.
Wed, 29 Oct 2025 16:21:15 +0000 [UpgradeWizard] - Running sql:/* Table : surveys */
/COLUMNS/
/*MISMATCH WITH DATABASE - status - ROW [name] => 'status' [type] => 'varchar' [len] => '100' [default] => 'Draft' /
/ VARDEF - status - ROW[required] => '' [name] => 'status' [vname] => 'LBL_STATUS' [type] => 'varchar' [massupdate] => '0' [default] => 'LBL_DRAFT' [no_default] => '' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '' [inline_edit] => '1' [reportable] => '1' [unified_search] => '' [merge_filter] => 'disabled' [len] => '100' [size] => '20' [options] => 'survey_status_list' [studio] => 'visible' [dependency] => '' [dbType] => 'enum' /
/ INDEXES */
ALTER TABLE surveys modify COLUMN status varchar(100) DEFAULT 'LBL_DRAFT' NULL

Note:
I tried both SilentUpgrade and UpgradeWizard but both came up to this.

Possible Fix

I tried updating the: /modules/Surveys/vardefs.php from LBL_DRAFT to just Draft. I did not get any error but it still stucks at Repair.

Steps to Reproduce the Issue

1. Have a SuiteCRM with a Version of 7.13.1
2. Downloaded Version 7.13.2 here: 
https://suitecrm.com/wpfd_file/suitecrm-upgrade-7-13-x-to-7-13-2/
3. Imported it in Upgrade Wizard
4. Was able to finish up until Step 4 which caused the loading...

Context

I'm trying to upgrade our SuiteCRM up to Version 8 if possible.

Version

7.13.1

What browser are you currently using?

Chrome

Browser Version

Version 142.0.7444.60 (Official Build) (64-bit)

Environment Information

MySQL 8.0.27, PHP 8.0.30, Apache/2.4.6

Operating System and Version

CentOS Linux release 7.9.2009 (Core)

Originally created by @juncelcarreon on GitHub (Nov 12, 2025). ### Issue When I started in the company where I am in. Our SuiteCRM Version was **7.11.21**. We were able to upgrade it to **7.12.6** with no problem and what is currently in our Production. After that we continued and able to update the SuiteCRM up until **7.13.1**, but after that we got stuck to _repair the database_ This is my _upgradeWizard.log_ > Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - call addNewSystemTabsFromUpgrade(upload://upgrades/patch/SuiteCRM-Upgrade-7.13.x-to-7.13.2-restore) Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - check to see if new modules exist Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - new modules to add are array ( 'Home' => 'Home', 'Calendar' => 'Calendar', 'Calls' => 'Calls', 'Meetings' => 'Meetings', 'Tasks' => 'Tasks', 'Notes' => 'Notes', 'Leads' => 'Leads', 'Contacts' => 'Contacts', 'Accounts' => 'Accounts', 'Opportunities' => 'Opportunities', 'Emails' => 'Emails', 'EmailTemplates' => 'EmailTemplates', 'Campaigns' => 'Campaigns', 'Prospects' => 'Prospects', 'ProspectLists' => 'ProspectLists', 'Documents' => 'Documents', 'Cases' => 'Cases', 'Project' => 'Project', 'Bugs' => 'Bugs', 'ResourceCalendar' => 'ResourceCalendar', 'AOBH_BusinessHours' => 'AOBH_BusinessHours', 'Spots' => 'Spots', 'AM_ProjectTemplates' => 'AM_ProjectTemplates', 'AOK_Knowledge_Base_Categories' => 'AOK_Knowledge_Base_Categories', 'AOK_KnowledgeBase' => 'AOK_KnowledgeBase', 'FP_events' => 'FP_events', 'FP_Event_Locations' => 'FP_Event_Locations', 'AOR_Reports' => 'AOR_Reports', 'AOR_Scheduled_Reports' => 'AOR_Scheduled_Reports', 'AOS_Contracts' => 'AOS_Contracts', 'AOS_Invoices' => 'AOS_Invoices', 'AOS_PDF_Templates' => 'AOS_PDF_Templates', 'AOS_Product_Categories' => 'AOS_Product_Categories', 'AOS_Products' => 'AOS_Products', 'AOS_Quotes' => 'AOS_Quotes', 'AOW_WorkFlow' => 'AOW_WorkFlow', 'jjwg_Maps' => 'jjwg_Maps', 'jjwg_Markers' => 'jjwg_Markers', 'jjwg_Areas' => 'jjwg_Areas', 'jjwg_Address_Cache' => 'jjwg_Address_Cache', 'SecurityGroups' => 'SecurityGroups', 'Surveys' => 'Surveys', 'sng_CallHistory' => 'sng_CallHistory', 'AsteriskIntegration' => 'AsteriskIntegration', 'RM_RMTitles' => 'RM_RMTitles', ) Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - module tabs updated Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - finished addNewSystemTabsFromUpgrade Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - Registering upgrade with UpgradeHistory Wed, 29 Oct 2025 16:20:11 +0000 [UpgradeWizard] - Rebuilding language cache Wed, 29 Oct 2025 16:20:13 +0000 [UpgradeWizard] - setting session variables... Wed, 29 Oct 2025 16:21:05 +0000 [UpgradeWizard] - setting session variables... Wed, 29 Oct 2025 16:21:11 +0000 [UpgradeWizard] - [At end.php] Wed, 29 Oct 2025 16:21:11 +0000 [UpgradeWizard] - About to repair the database. Wed, 29 Oct 2025 16:21:15 +0000 [UpgradeWizard] - Running sql:/* Table : surveys */ /*COLUMNS*/ /*MISMATCH WITH DATABASE - status - ROW [name] => 'status' [type] => 'varchar' [len] => '100' [default] => 'Draft' */ /* VARDEF - status - ROW[required] => '' [name] => 'status' [vname] => 'LBL_STATUS' [type] => 'varchar' [massupdate] => '0' [default] => 'LBL_DRAFT' [no_default] => '' [comments] => '' [help] => '' [importable] => 'true' [duplicate_merge] => 'disabled' [duplicate_merge_dom_value] => '0' [audited] => '' [inline_edit] => '1' [reportable] => '1' [unified_search] => '' [merge_filter] => 'disabled' [len] => '100' [size] => '20' [options] => 'survey_status_list' [studio] => 'visible' [dependency] => '' [dbType] => 'enum' */ /* INDEXES */ ALTER TABLE surveys modify COLUMN `status` varchar(100) DEFAULT 'LBL_DRAFT' NULL Note: I tried both _SilentUpgrade_ and _UpgradeWizard_ but both came up to this. ### Possible Fix I tried updating the: /modules/Surveys/vardefs.php from **LBL_DRAFT** to just **Draft**. I did not get any error but it still stucks at Repair. ### Steps to Reproduce the Issue ```bash 1. Have a SuiteCRM with a Version of 7.13.1 2. Downloaded Version 7.13.2 here: https://suitecrm.com/wpfd_file/suitecrm-upgrade-7-13-x-to-7-13-2/ 3. Imported it in Upgrade Wizard 4. Was able to finish up until Step 4 which caused the loading... ``` ### Context I'm trying to upgrade our SuiteCRM up to Version 8 if possible. ### Version 7.13.1 ### What browser are you currently using? Chrome ### Browser Version Version 142.0.7444.60 (Official Build) (64-bit) ### Environment Information MySQL 8.0.27, PHP 8.0.30, Apache/2.4.6 ### Operating System and Version CentOS Linux release 7.9.2009 (Core)

deekerman added the

Type: Bug

Status: Requires Updates

Area: Upgrading

labels

2026-02-20 17:00:03 -05:00

deekerman commented

2026-02-20 17:00:05 -05:00

Author

Owner

@johnM2401 commented on GitHub (Jan 12, 2026):

Hey!

Thank you for getting in touch.

Are you still experiencing these issues?

I've noticed your Environment Information is listed as MySQL8 / PHP 8

If you're still experiencing your upgrade issues, I would recommend trying to upgrade from 7.13.1 straight to 7.14.8 using the latest package on: https://suitecrm.com/releases/
ie: https://suitecrm.com/download/141/suite714/565625/suitecrm-upgrade-7-13-x-to-7-14-8.zip
(Rather than upgrading to 7.13.2, then onward from there)

7.14.8 has much more complete support for MySQL8/PHP8, so should (hopefully) have a greater chance of success

However, if you're still experiencing upgrade issues with this package, please don't hesitate to get in touch.

If you have any further information on this, such as:
PHP Error Logs / Relevant suitecrm.log lines
Then this will further help with our investigations

Thank you again!

@johnM2401 commented on GitHub (Jan 12, 2026): Hey! Thank you for getting in touch. Are you still experiencing these issues? I've noticed your Environment Information is listed as MySQL8 / PHP 8 If you're still experiencing your upgrade issues, I would recommend trying to upgrade from 7.13.1 straight to 7.14.8 using the latest package on: https://suitecrm.com/releases/ ie: https://suitecrm.com/download/141/suite714/565625/suitecrm-upgrade-7-13-x-to-7-14-8.zip (Rather than upgrading to 7.13.2, then onward from there) 7.14.8 has much more complete support for MySQL8/PHP8, so should (hopefully) have a greater chance of success <br> However, if you're still experiencing upgrade issues with this package, please don't hesitate to get in touch. If you have any further information on this, such as: PHP Error Logs / Relevant suitecrm.log lines Then this will further help with our investigations Thank you again!