Hello,
for the past few days I have been trying to upgrade my version to 7.14, I always get the same error which I report below.
Max_execution_time is 6000.
Is there a problem with js?
Check errors in both your logs
and also in your browser’s developer tools, console tab.
Pay attention to timestamps so you can focus on what was happening at the moment when that screen broke.
Tue Feb 27 18:12:40 2024 [9248][-none-][FATAL] Mysqli_query failed.
Tue Feb 27 18:12:40 2024 [9248][-none-][FATAL] Retrieving record by id users:c593759d-e627-186c-1abd-607071f15f86 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘c593759d-e627-186c-1abd-607071f15f86’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Feb 27 18:12:40 2024 [9794][-none-][FATAL] Mysqli_query failed.
Tue Feb 27 18:12:40 2024 [9794][-none-][FATAL] Retrieving record by id users:c593759d-e627-186c-1abd-607071f15f86 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘c593759d-e627-186c-1abd-607071f15f86’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Feb 27 18:12:40 2024 [11373][-none-][FATAL] Mysqli_query failed.
Tue Feb 27 18:12:40 2024 [11373][-none-][FATAL] Retrieving record by id users:c593759d-e627-186c-1abd-607071f15f86 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘c593759d-e627-186c-1abd-607071f15f86’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Feb 27 18:12:40 2024 [10837][-none-][FATAL] Mysqli_query failed.
Tue Feb 27 18:12:40 2024 [10837][-none-][FATAL] Retrieving record by id users:c593759d-e627-186c-1abd-607071f15f86 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘c593759d-e627-186c-1abd-607071f15f86’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Tue Feb 27 18:12:40 2024 [9795][-none-][FATAL] Mysqli_query failed.
Tue Feb 27 18:12:40 2024 [9795][-none-][FATAL] Retrieving record by id users:c593759d-e627-186c-1abd-607071f15f86 found Query Failed: SELECT users.* FROM users WHERE users.id = ‘c593759d-e627-186c-1abd-607071f15f86’ AND users.deleted=0 LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Looks like permission, configuration or user access issue.
No, definitely not permissions.
You have a serious MySQL problem causing it to crash (not just error out). There are many possible causes to it, try diagnosing it with the help of this article:
mysql server is gone away. Is there a limit to max queries or you are on a shared hosting where the service is killed immediately with multiple frequent inserts?
The possible way around this could be to upgrade the system locally and then move files and DB to server.
Yes, the hosting is shared
Aggiornamento.
Non demordo e visto che sono in locale ho provato ad usare la funzionalità di aggiornamento da riga di comando.
Si blocca allo stesso punto, e lo script mi descrive in questo modo l’errore:
ERROR: str_ireplace(): Passing null to parameter #2 ($replace) of type array|string is deprecated
in /var/www/html/include/utils/db_utils.php:135
What is your PHP version?
Are you inside the Matrix, Neo?
Any way, I think these are the fixes you need
and they are in 7.14.3
Compatibily Matrix.
FOR SuiteCRM 7.13:
apache 2.4.52
mysql 8.0.36
php 8.1.2
I don’t quite understand the proposed changes; should I edit the files that are in verisone 7.13.2 and should I be in verisone 7.14.3? Or after the modifications should I try again with the upgrade?
It’s much easier if you simply upgrade to the latest 7.14.x
I solved it, in a less than elegant way.
- I built a LAMP server with the same features as the hosting one;
- I downloaded the database to the hosting server;
- I installed suitcrm 7.13.2 from scratch locally with the same mysql users and passwords as the hosting server;
- I replaced the local database with the hosting database. In this way I rebuilt a suitecrm 7.13.2 intact and with my data;
- I successfully upgraded from 7.13.2 to 7.14.3
This way I did not identify the problem, but at least it works. I will not be of much help to the community, but at least I have given a little insight.
That’s good. Happy for you! 
If you want a demo of 7.14.3
Username: will
Password: will