Failed Upgrade

SuiteCRM Forum - English Language Installation & Upgrade Help
1

I’m running Version 7.10.7
Sugar Version 6.5.25 (Build 344) Windows 10 64 bit Hosted on a shared server at InMotion Hosting.

I have the version that doesn’t increment the customer or account page list views and was under the understanding that an upgrade would remedy this.

I began the upgrade process and while it was doing a system check it threw this error:

Warning: Error while sending QUERY packet. PID=3803905 in /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/MysqliManager.php on line 137
Database failure. Please refer to suitecrm.log for details.

Here is the most recent log entry:

402
Fri Dec 7 21:18:21 2018 [3803905][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Fri Dec 7 21:18:21 2018 [3803905][1][FATAL] backtrace:
#0 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/DBManager.php(353): sugar_die(‘Database failur…’)
#1 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/DBManager.php(328): DBManager->registerError(’ Query Failed: …’, ’ Query Failed: …’, true)
#2 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/MysqliManager.php(177): DBManager->checkError(’ Query Failed: …’, true)
#3 /home/compos24/SuiteCRM1.compositeautomation.com/dir/data/SugarBean.php(5519): MysqliManager->query(‘SELECT id FROM …’, true)
#4 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/Administration/UpgradeHistory.php(171): SugarBean->build_related_list(‘SELECT id FROM …’, Object(UpgradeHistory))
#5 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/Administration/UpgradeHistory.php(167): UpgradeHistory->getList(‘SELECT id FROM …’)
#6 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/UpgradeWizard/index.php(312): UpgradeHistory->getAll()
#7 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/SugarView.php(840): include_once(’/home/compos24/…’)
#8 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/views/view.classic.php(74): SugarView->includeClassicFile(’/home/compos24/…’)
#9 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/SugarView.php(207): ViewClassic->display()
#10 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/Controller/SugarController.php(432): SugarView->process()
#11 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#12 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/SugarApplication.php(109): SugarController->execute()
#13 /home/compos24/SuiteCRM1.compositeautomation.com/dir/index.php(52): SugarApplication->execute()
#14 {main}
Fri Dec 7 21:18:58 2018 [3810058][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Fri Dec 7 21:23:47 2018 [3837232][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set

I appreciate any help anyone can provide as I am really stuck. Let me know if I can provide more information.

Thank you

John

2

Can you check mysql_error.log for the actual reason?

3

Could you direct me to the mysql_error.log? I could not find it manually or in a search.

Thank you!

Upgrade wizard log:

Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] - setting session variables…
Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] - -----------------------------------------------------------------------------
Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] - Upgrade started. At start.php
Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] - at unlinkUWTempFiles()
Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] - finished!
Thu, 13 Dec 2018 13:27:27 -0500 [UpgradeWizard] - resetting $_SESSION
Thu, 13 Dec 2018 13:27:34 -0500 [UpgradeWizard] - setting session variables…
Thu, 13 Dec 2018 13:27:34 -0500 [UpgradeWizard] - [At systemCheck.php]
Thu, 13 Dec 2018 13:27:34 -0500 [UpgradeWizard] - Starting file permission check…
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Finished file permission check.
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Starting database permissions check…
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking CREATE TABLE permissions…
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot CREATE TABLE!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking INSERT INTO permissions…
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot INSERT INTO!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking UPDATE TABLE permissions…
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot UPDATE TABLE!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking SELECT permissions…
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot SELECT!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking DELETE FROM permissions…
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot DELETE FROM!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions…
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot ADD COLUMN!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions…
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot CHANGE COLUMN!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions…
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot DROP COLUMN!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Checking DROP TABLE permissions…
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - cannot DROP TABLE!
Thu, 13 Dec 2018 13:28:19 -0500 [UpgradeWizard] - Finished database permissions check.

Suitecrm log

Thu Dec 13 13:27:22 2018 [1133600][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: CREATE TABLE temp (id varchar(36)): MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: INSERT INTO temp (id) VALUES (‘abcdef0123456789abcdef0123456789abcd’): MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: UPDATE temp SET id = ‘100000000000000000000000000000000000’ WHERE id = ‘abcdef0123456789abcdef0123456789abcd’: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’ LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Get One Failed:SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: DELETE FROM temp WHERE id = ‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: ALTER TABLE temp add COLUMN test varchar(50) NULL : MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: ALTER TABLE temp modify COLUMN test varchar(100) NULL : MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: ALTER TABLE temp drop COLUMN test: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: DROP TABLE IF EXISTS temp: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: SELECT version() version LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Get One Failed:SELECT version() version: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Mysqli_query failed.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Exception handling in /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/Controller/SugarController.php:402
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Thu Dec 13 13:28:19 2018 [1134755][1][FATAL] backtrace:
#0 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/DBManager.php(353): sugar_die(‘Database failur…’)
#1 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/DBManager.php(328): DBManager->registerError(’ Query Failed: …’, ’ Query Failed: …’, true)
#2 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/database/MysqliManager.php(177): DBManager->checkError(’ Query Failed: …’, true)
#3 /home/compos24/SuiteCRM1.compositeautomation.com/dir/data/SugarBean.php(5519): MysqliManager->query(‘SELECT id FROM …’, true)
#4 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/Administration/UpgradeHistory.php(171): SugarBean->build_related_list(‘SELECT id FROM …’, Object(UpgradeHistory))
#5 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/Administration/UpgradeHistory.php(167): UpgradeHistory->getList(‘SELECT id FROM …’)
#6 /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/UpgradeWizard/index.php(312): UpgradeHistory->getAll()
#7 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/SugarView.php(840): include_once(’/home/compos24/…’)
#8 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/views/view.classic.php(74): SugarView->includeClassicFile(’/home/compos24/…’)
#9 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/View/SugarView.php(207): ViewClassic->display()
#10 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/Controller/SugarController.php(432): SugarView->process()
#11 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#12 /home/compos24/SuiteCRM1.compositeautomation.com/dir/include/MVC/SugarApplication.php(109): SugarController->execute()
#13 /home/compos24/SuiteCRM1.compositeautomation.com/dir/index.php(52): SugarApplication->execute()
#14 {main}

4

Bump! Hey all I really need help with this as I can’t get it upgraded and there’s so much work that I did.

Please. Help!!

Thank you in advance if you can help.

John

5

That “MySQL has gone away” is a serious database crash, see here for a list of possible causes:

https://dev.mysql.com/doc/refman/8.0/en/gone-away.html

If I were you I would skip troubleshooting this and try a MySQL upgrade, as a way to make your installation sane again.

6

Update.

So, I upgraded to a VPS host on InMotion because the shared environment would time out on the DB. When I started to get ready to upgrade I did a quick repair and build and got the following:

Processing database and vardef comparison…

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 20480 bytes) in /home/compos24/SuiteCRM1.compositeautomation.com/dir/cache/modules/AOS_Quotes/AOS_Quotesvardefs.php on line 3

Tried again and got:

Processing database and vardef comparison…

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 32768 bytes) in /home/compos24/SuiteCRM1.compositeautomation.com/dir/cache/modules/AOS_Quotes/AOS_Quotesvardefs.php on line 417

Log file is empty.

Appreciate any words of help and or life wisdom!

Merry Christmas!

7

The upgrade seemed to work but it threw this error at the end:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 86016 bytes) in /home/compos24/SuiteCRM1.compositeautomation.com/dir/modules/Relationships/Relationship.php on line 249

Again, any insight or instruction is deeply appreciated.

Best
john

8

That’s easy - go in php.ini and increase your memory_limit to 512 MB (or at least 256MB). While you’re there, you might want to increase max_execution_time and post_max_size and max_upload_size.

Restart your web server.

Go in Admin / Daignostics, select phpinfo, and check if your changes became effective.

9

Thanks for your prompt reply. For some odd reason, I can’t seem to locate that file in cpanel’s file manager. I see a travis.php.ini.

I have php.ini files in other directories but not visible in the directory where SuiteCRM is installed.

Am I missing something?

Thanks again.

john

10

Go in Admin / Diagnostics, select phpinfo, and check the php.ini directory.

It’s normal for it to be outside the SuiteCRM directory, it affects your entire web server.

I don’t know if you are in a shared hosting, sometimes they don’t give you access to the php.ini, or they use some scheme where you place a smaller php.ini in your root folder, and they pick it up and include it. You’ll have to ask them.