Upgrade check stalls out

aeroflyte · 4 February 2018 00:46

When I hit the “next” button to do the system check to perform an upgrade my application returns a blank SuiteCRM screen. I also am unable to add a screenshot by hitting the add file button on this post. No idea why that is.

I am upgrading with the hope that the email template thing is fixed and that my multiple users can use the email client independently to send and receive emails in SuiteCRM. Does anyone know if that has been fixed?

I’m still on 7.9.4 Sugar Version 6.5.24 (Build 509). I have Verizon coming tomorrow to check my internet connection. But it seems fine now. at 100MBPS up and down.

I GREATLY appreciate any insight anyone may provide.

John

aeroflyte · 4 February 2018 05:33

I decided to create a new install in a separate subdomain of the new software and imported the existing database. That fixed my issue with the upgrade. I’ll delete the old install after I put some miles on the new one.

Actually, I think this was cleaner and easier than doing the upgrade. I know for sure I have all new files.

Thanks!

aeroflyte · 4 February 2018 14:18

Hi all. This is still a problem for me. The database transfer left out many field changes that I made. The new install also seems to have issues with the email module. I’d still like to try to upgrade my production version but get the same issue. It tries to do step one and then I just get a blank suitecrm screen where I can not do the next upgrade step. I can go to other modules so the software still seems to be working but the upgrade step fails.

I really need to get this fixed. I also really need to have the ability for the users to send and receive emails, use templates, campaigns, etc. This is a critical function for us.

Please advise. Thank you in advance.

John

amariussi · 4 February 2018 15:58

I believe that the most likely reasons are bad permissions and a low max_execution_time setting (try at least 3600 or more).

aeroflyte · 4 February 2018 18:56

I am posting the contents of the logs for the system and it appears you are correct. I just don’t know where to adjust the time and permissions.

Thank you for your help

John

Upgrade log:

Sun, 04 Feb 2018 12:30:23 -0500 [UpgradeWizard] - setting session variables…
Sun, 04 Feb 2018 12:30:23 -0500 [UpgradeWizard] - -----------------------------------------------------------------------------
Sun, 04 Feb 2018 12:30:23 -0500 [UpgradeWizard] - Upgrade started. At start.php
Sun, 04 Feb 2018 12:30:23 -0500 [UpgradeWizard] - at unlinkUWTempFiles()
Sun, 04 Feb 2018 12:30:23 -0500 [UpgradeWizard] - finished!
Sun, 04 Feb 2018 12:30:23 -0500 [UpgradeWizard] - resetting $_SESSION
Sun, 04 Feb 2018 12:30:34 -0500 [UpgradeWizard] - setting session variables…
Sun, 04 Feb 2018 12:30:34 -0500 [UpgradeWizard] - [At systemCheck.php]
Sun, 04 Feb 2018 12:30:34 -0500 [UpgradeWizard] - Starting file permission check…
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Finished file permission check.
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Starting database permissions check…
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Checking CREATE TABLE permissions…
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - cannot CREATE TABLE!
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Checking INSERT INTO permissions…
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - cannot INSERT INTO!
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Checking UPDATE TABLE permissions…
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - cannot UPDATE TABLE!
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Checking SELECT permissions…
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - cannot SELECT!
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Checking DELETE FROM permissions…
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - cannot DELETE FROM!
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions…
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - cannot ADD COLUMN!
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions…
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - cannot CHANGE COLUMN!
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions…
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - cannot DROP COLUMN!
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Checking DROP TABLE permissions…
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - cannot DROP TABLE!
Sun, 04 Feb 2018 12:31:07 -0500 [UpgradeWizard] - Finished database permissions check.

SuiteCRM log:

Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Query Failed: CREATE TABLE temp (id varchar(36)): MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Query Failed: INSERT INTO temp (id) VALUES (‘abcdef0123456789abcdef0123456789abcd’): MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Query Failed: UPDATE temp SET id = ‘100000000000000000000000000000000000’ WHERE id = ‘abcdef0123456789abcdef0123456789abcd’: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Query Failed: SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’ LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Get One Failed:SELECT id FROM temp WHERE id=‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Query Failed: DELETE FROM temp WHERE id = ‘100000000000000000000000000000000000’: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Query Failed: ALTER TABLE temp add COLUMN test varchar(50) NULL : MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Query Failed: ALTER TABLE temp modify COLUMN test varchar(100) NULL : MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Query Failed: ALTER TABLE temp drop COLUMN test: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Query Failed: DROP TABLE IF EXISTS temp: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Query Failed: SELECT version() version LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Get One Failed:SELECT version() version: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Exception handling in /home/compos24/public_html/SuiteCRM/dir/include/MVC/Controller/SugarController.php:397
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Sun Feb 4 12:31:07 2018 [999479][1][FATAL] backtrace:
#0 /home/compos24/public_html/SuiteCRM/dir/include/database/DBManager.php(345): sugar_die(‘Database failur…’)
#1 /home/compos24/public_html/SuiteCRM/dir/include/database/DBManager.php(321): DBManager->registerError(’ Query Failed: …’, ’ Query Failed: …’, true)
#2 /home/compos24/public_html/SuiteCRM/dir/include/database/MysqliManager.php(160): DBManager->checkError(’ Query Failed: …’, true)
#3 /home/compos24/public_html/SuiteCRM/dir/data/SugarBean.php(4916): MysqliManager->query(‘SELECT id FROM …’, true)
#4 /home/compos24/public_html/SuiteCRM/dir/modules/Administration/UpgradeHistory.php(171): SugarBean->build_related_list(‘SELECT id FROM …’, Object(UpgradeHistory))
#5 /home/compos24/public_html/SuiteCRM/dir/modules/Administration/UpgradeHistory.php(167): UpgradeHistory->getList(‘SELECT id FROM …’)
#6 /home/compos24/public_html/SuiteCRM/dir/modules/UpgradeWizard/index.php(312): UpgradeHistory->getAll()
#7 /home/compos24/public_html/SuiteCRM/dir/include/MVC/View/SugarView.php(791): include_once(’/home/compos24/…’)
#8 /home/compos24/public_html/SuiteCRM/dir/include/MVC/View/views/view.classic.php(74): SugarView->includeClassicFile(’/home/compos24/…’)
#9 /home/compos24/public_html/SuiteCRM/dir/include/MVC/View/SugarView.php(199): ViewClassic->display()
#10 /home/compos24/public_html/SuiteCRM/dir/include/MVC/Controller/SugarController.php(427): SugarView->process()
#11 /home/compos24/public_html/SuiteCRM/dir/include/MVC/Controller/SugarController.php(370): SugarController->processView()
#12 /home/compos24/public_html/SuiteCRM/dir/include/MVC/SugarApplication.php(105): SugarController->execute()
#13 /home/compos24/public_html/SuiteCRM/dir/index.php(52): SugarApplication->execute()
#14 {main}
Sun Feb 4 13:12:32 2018 [119521][1][FATAL] IP Address mismatch: SESSION IP: 173.61.121.198 CLIENT IP: 173.72.74.44

amariussi · 4 February 2018 21:04

From the logs it seems like an issue with mysql.

Are yu sure that mysql i running?

Have you change username/password in the database or in config.php?

max_execution_time can be set by editing php.ini

To set correctly permissions search the forum and you will find plenty of posts explaining how to do it (including in one of my old posts a script to do it on linux systems).

aeroflyte · 5 February 2018 20:17

I increased the time but that didn’t solve it. I think it is a permission issue. I just don’t know where to go to fix that. Here are the permission failures:

Hope someone can shed some light on this for me.

Thank you very much.

John

Mon, 05 Feb 2018 14:47:18 -0500 [UpgradeWizard] - Upgrade started. At start.php
Mon, 05 Feb 2018 14:47:18 -0500 [UpgradeWizard] - at unlinkUWTempFiles()
Mon, 05 Feb 2018 14:47:18 -0500 [UpgradeWizard] - finished!
Mon, 05 Feb 2018 14:47:18 -0500 [UpgradeWizard] - resetting $_SESSION
Mon, 05 Feb 2018 14:47:22 -0500 [UpgradeWizard] - setting session variables…
Mon, 05 Feb 2018 14:47:22 -0500 [UpgradeWizard] - [At systemCheck.php]
Mon, 05 Feb 2018 14:47:22 -0500 [UpgradeWizard] - Starting file permission check…
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Finished file permission check.
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Starting database permissions check…
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Checking CREATE TABLE permissions…
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - cannot CREATE TABLE!
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Checking INSERT INTO permissions…
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - cannot INSERT INTO!
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Checking UPDATE TABLE permissions…
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - cannot UPDATE TABLE!
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Checking SELECT permissions…
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - cannot SELECT!
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Checking DELETE FROM permissions…
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - cannot DELETE FROM!
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions…
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - cannot ADD COLUMN!
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions…
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - cannot CHANGE COLUMN!
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions…
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - cannot DROP COLUMN!
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Checking DROP TABLE permissions…
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - cannot DROP TABLE!
Mon, 05 Feb 2018 14:47:56 -0500 [UpgradeWizard] - Finished database permissions check.
Mon, 05 Feb 2018 14:54:11 -0500 [UpgradeWizard] - setting session variables…
Mon, 05 Feb 2018 14:54:11 -0500 [UpgradeWizard] -

aeroflyte · 5 February 2018 21:54

@amariussi

Have you change username/password in the database or in config.php?

I did not change it and I did check the config file and the UID and password is the one that is listed in the hosting account. Also, I’m able to use the entire application as is and I imagine it is seeing the database with no issues since all of the data is there.

Also, another instance (non production) works fine.

Really hope someone can shed some light on this. I don’t want to be stuck on this version.

Thanks
John