Failure upgrading from 7.1.1 to 7.1.2

📦 Install & Upgrade Help
1

I’ve spent hours yesterday and today trying to upgrade a SuiteCRM installation from 7.1.1 to 7.1.2.but it consistently fails (regardless of what repairs, cleanups I do) with following last entries in logs. After that the installation becomes useless as it only shows a WSOD (white screen of death).

upgradeWizard.log


Thu, 10 Jul 2014 17:16:54 +1000 [UpgradeWizard] - modules/AOR_Reports/aor_utils.php
Thu, 10 Jul 2014 17:16:54 +1000 [UpgradeWizard] - mobile/js/quickcrm-utils.min.js
Thu, 10 Jul 2014 17:16:54 +1000 [UpgradeWizard] - mobile/js/quickcrm-ce-3.0.0.min.js
Thu, 10 Jul 2014 17:16:54 +1000 [UpgradeWizard] - mobile/js/quickcrm-ce-3.2.2.min.js
Thu, 10 Jul 2014 17:16:54 +1000 [UpgradeWizard] - custom/Extension/modules/Contacts/Ext/Vardefs/sugarfield_facebook_username_c.php
Thu, 10 Jul 2014 17:16:54 +1000 [UpgradeWizard] - custom/Extension/modules/Opportunities/Ext/Vardefs/sugarfield_textarea_c.php
Thu, 10 Jul 2014 17:16:54 +1000 [UpgradeWizard] - modules/AOD_Index/Dashlets/AOD_IndexDashlet/AOD_IndexDashlet.meta.php
Thu, 10 Jul 2014 17:16:54 +1000 [UpgradeWizard] - modules/AOD_Index/Dashlets/AOD_IndexDashlet/AOD_IndexDashlet.php
Thu, 10 Jul 2014 17:16:54 +1000 [UpgradeWizard] - modules/AOD_IndexEvent/Dashlets/AOD_IndexEventDashlet/AOD_IndexEventDashlet.meta
Thu, 10 Jul 2014 17:16:54 +1000 [UpgradeWizard] - modules/AOD_IndexEvent/Dashlets/AOD_IndexEventDashlet/AOD_IndexEventDashlet.php
Thu, 10 Jul 2014 17:17:22 +1000 [UpgradeWizard] - Start Updating the license 
Thu, 10 Jul 2014 17:17:23 +1000 [UpgradeWizard] - End Updating the license 
Thu, 10 Jul 2014 17:17:23 +1000 [UpgradeWizard] - Cleaning up the session.  Goodbye.
Thu, 10 Jul 2014 17:17:23 +1000 [UpgradeWizard] - at unlinkUWTempFiles()
Thu, 10 Jul 2014 17:17:23 +1000 [UpgradeWizard] - finished!
Thu, 10 Jul 2014 17:17:23 +1000 [UpgradeWizard] - Cleaning up the session.  Goodbye.
Thu, 10 Jul 2014 17:17:23 +1000 [UpgradeWizard] - resetting $_SESSION

sugarcrm.log


Thu Jul 10 17:16:28 2014 [2900][1][FATAL]  Query Failed:  ALTER TABLE aor_fields CHANGE function field_function VARCHAR( 100 ): MySQL error 1054: Unknown column 'function' in 'aor_fields'

I read somewhere that SugarFTSHooks.php should not be present in custom/Extension/application/Ext/LogicHooks/ in 7.1.x… I got that file. And failure still happens even if I delete that file before upgrade.

Any help will be appreciated.

2

Really no one can help me troubleshoot this?

3

yepper,
This 2 page thread seems to examine and solve the exact same error you’re experiencing !
http://suitecrm.com/index.php?option=com_kunena&view=topic&Itemid=1136&catid=7&id=964

1 Like
4

Thanks ChrisC.

I’ve finally managed to upgrade by changing DB schema BEFORE upgrade… and renaming the column ‘field_function’ to ‘function’ in ‘aor_fields’ table.

Regards
Yepper

1 Like
5

Congratulations on getting the upgrade to work! Interesting bug ! Would you say this was a bug in the AdvancedOpen Reports module installer, or 7.1.1 to 7.1.2 upgrader ? You should probably report this bug to the AdvanceOpen Reports github page, eh ? So they can fix it for the next release?

6

It is installer bug and I am not sure where I can report it. (I know Github project but they don’t seem to do the SuiteCRM installers)

7

yepper,
you should report this bug (by reposting this thread or a link to it) on the Bug Tracker forum.

8

Hi there,

Can you list the full details of your Server/PHP/MySQL setup, permissions and any other information that would be useful so that we can resole this bug?

Thanks,

Will.

9

Will,

It is pretty standard setup. PHP 5.3.28 on Amazon Linux (AWS) with MySQL 5.5.
Guess the problem is not my setup. It is just that installer is trying to rename a column which has already been renamed in previous version.

Chris - thanks for link. I will report the bug there.