Uppgrade Wizard - Upgrade prerequisites

📦 Install & Upgrade Help
1

Am i correct to assume that the upgrade wizard takes care of all the Upgrade prerequisites?

In the upgrade manual it tells me to

ncrease the default value of the parameters listed below before you begin the upgrade process if you are using Zend Core 2.0:
Navigate to C:\Program Files\Zend\Core\etc\fastcgi.conf and increase the default value for ConnectionTimeout to 3000 seconds and RequestTimeout to 6000 seconds.
Navigate to the php.ini file and increase the default value of max_execution_time to 6000 seconds.
Perform the following for the large size of the upgrade files:
Modify and save the value of Maximum upload size to 21000000 (20MB) in the Advanced section of the System Settings page of your current SuiteCRM installation.
Navigate to the php.ini file on your web server and configure the parameters listed below in the Advanced section of the System Settings page of your current SuiteCRM installation:
Set post_max_size to at least 60MB
Set upload_max_filesize settings to at least 60MB
Set max_input_time to a large number
Set memory_limit to 256MB

But this is handled by the Wizard so i dont have to do it manually?

BR
Emilkl

2

It seems as though your default parameters are lower than required for the upgrade. If you follow the instruction stated it should work OK.
The upgrade wizard needs a minimum value to work but once that is set it will upgrade everything for you.

Have a look here for more info:
https://suitecrm.com/wiki/index.php/Upgrade

3

Hello Cameron and thank you.

I have tried to follow the upgrade guide but i encounter some issues.
I have installed SuiteCRM by the “Installatron Applications Installer” on my webhotel provider.
The latest version i can install is 7.2.2.

  1. So i upgrade 7.2.2 to 7.3.2 with upgrade wizard
  2. then i go from 7.3.2 to 7.4.4 with upgrade wizard
  3. then i Try to go from 7.4.4 to 7.6.7 with upgrade wizard (I log of and in again between all upgrades) but get error
    Query Failed: SELECT id FROM upgrade_history where md5sum = ‘9f1f642c4c87063dce4ed1c8d94b75f3’: MySQL error 2006: MySQL server has gone away
  4. I googled a little and found out that it can be because max_allowed_packet needs to be a higher size, so i did so and put it to =104857600
  5. Still same issue so i went back to the upgrade guide and was thinking about this values in php.ini
    but i dont have a php.ini files?
    I made a search in all folders but there is none. Do i need to do something to get it?

BR
Emilkl

4

Can you also please do a quick repair and rebuild after every upgrade? helps to limit errors

What web service do you use?

My one is located in my apache2 folder

5

Thank you Cameron.
I have DirectAdmin as tool with my webhotel.

I found the values in the PHP area in Directadmin.

Im confused by one of them thou :slight_smile:
Set max_input_time to a large number
It was -1 so do that mean i should put it to like -2?

BR
Emil

6

i personally have mine set as 60 and it seems to have always worked ok for me. maybe try something around that and test :slight_smile:

7

Hello Cameron.

I tried that as well but still no go. :frowning:
Still get the same issue, noticed one thing thou.
Now i get the error while SuiteCRM is uploading the upgrade file. It takes maybe 1-2 minutes.
If i click on admin then upgrade wizard i can see its uploaded thou. So i try to install it but
again same issue. The difference as i can see in the file itself is that this upgrade is like 5mb larger then the previous one, if that has something to do with it?

I have been trying a lot of different values in the PHP but without luck. see untitled.png for my latest values.
I have also added the error log, thre are some different from my test today.
Below some from “fatal” log. In the txt file there is also some with “DEBUG” enabled.

Its a new installation so i have basically not added anything yet.

Fri Oct 7 16:35:13 2016 [311760][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Fri Oct 7 16:35:13 2016 [311901][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Fri Oct 7 16:35:13 2016 [311955][-none-][FATAL] Retrieving record by id users:1 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Fri Oct 7 16:39:13 2016 [314685][1][FATAL] Query Failed: SELECT id FROM upgrade_history where md5sum = ‘9f1f648c4c87063cce4ed1c8d94b75f3’: MySQL error 2006: MySQL server has gone away
Fri Oct 7 16:43:30 2016 [315715][1][FATAL] Query Failed: SELECT id FROM upgrade_history where md5sum = ‘9f1f648c4c87063cce4ed1c8d94b75f3’: MySQL error 2006: MySQL server has gone away
Fri Oct 7 16:47:15 2016 [316730][1][FATAL] Query Failed: SELECT id FROM upgrade_history where md5sum = ‘9f1f648c4c87063cce4ed1c8d94b75f3’: MySQL error 2006: MySQL server has gone away
Fri Oct 7 16:51:59 2016 [316730][1][FATAL] Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away

again to install 7.2.2 and upgrade that to 7.4.7 its no problem but from 7.4 to 7.6 i get this issues.
Is there anything more i can check?

BR
Emil