Any help will be helpful. I tried to upgrade from Version 7.11.2 to 7.11.3 from admin panel Upgrade Wizard. When I press Upgrade Wizard display gets freeze (for approximately 5 min) with error - âCould not connect to the database. Please refer to suitecrm.log for details (0).
Fatal error: Uncaught Exception: Could not connect to the database. Please refer to suitecrm.log for details (0). in /home2/htwoopur/public_html/SuiteCRM/include/utils.php:1775 Stack trace: #0 /home2/htwoopur/public_html/SuiteCRM/include/database/MysqliManager.php(322): sugar_die(âCould not conneâŚâ) #1 /home2/htwoopur/public_html/SuiteCRM/include/database/DBManagerFactory.php(150): MysqliManager->connect(Array, true) #2 /home2/htwoopur/public_html/SuiteCRM/include/entryPoint.php(182): DBManagerFactory::getInstance() #3 /home2/htwoopur/public_html/SuiteCRM/index.php(47): require_once(â/home2/htwoopurâŚâ) #4 {main} thrown in /home2/htwoopur/public_html/SuiteCRM/include/utils.php on line 1775â
After approximately 5 min website is coming back to work by itself.
Is it possible to upgrade manually to the new version? Or how could I fix this issue with Upgrade Wizard from admin panel?
Is your database running on the same server as SuiteCRM app?
You might need to increase some values in your php.ini:
memory_limit (make it 256MB or more)
max_execution_time
max_upload_size
max_post_size
But this looks like a server problem, or a database problem, not a SuiteCRM problemâŚ
Is your database running on the same server as SuiteCRM app? Yes, it is the same server.
I changed:
memory_limit 256Mb
max_execution_time 120
max_upload_size 128
max_post_size 128
any other ideas?
just to confirm that the app runs with no problems
the issue appears only in Update Wizard
By my understanding, I receive:
[FATAL] Could not connect to DB server localhost as varr_sugar. port : User varr_sugar already has more than âmax_user_connectionsâ active connections
I contacted the support to increase max_user_connections (at this moment 15)
support told me that is not possible for me to increase max_user_connections - instead I have to optimize the DB
Any clues on how to fix this issue?
Try renaming your âupload/upgradesâ directory to something else, so that you start the upgrade from a fresh state. You can delete that directory later if everything goes well.
âupload/upgradesâ renamed - did not help
when I press Upgrade Wizard new folder âupgradesâ appears. I still have the same problem with âmax_user_connectionsâ.
There is any way to change or to limit same time max queries for a user in SuiteCRM?
One more thing: I noticed that the error related to âmax_user_connectionsâ appears only at account administrator which run Upgrade Wizard.
I have 2 administrator accounts - if I run Upgrade wizard from one account this got freeze for 5-7 min. in the same time another administrator account is working with no problems.
CORRECTION: I renamed both âupload/upgradesâ from the cache too. at this moment âUpgrade Wizardâ starts with no issues but when I press the âNextâ button I have 405 error.
Ok, youâve made progress. Now letâs work on that 405 error, what exactly does it say?
I fixed 405 error - I changed permissions for folders and files in (cache upgrade) and (upgrade) to 775.
at this moment a can upload the upgrading file. I am stuck at upgrade file - zip file is uploaded but I still have the message âUpload a package before continuing.â pressing the âNEXTâ button gives no response. also in the same window, I have the message âThe following upgrade packages have been installed: ( SuiteCRM patch 7.11.3 04/25/2019 10:47 None)â this can be deleted.
You need to do the full ownership/permissions fix, not just change a couple of directories.
Do you know which user your web server is running under? Thatâs what you need to use for the chown command.
You can see the user name in Admin / Schedulers, at the bottom of the table, inside the recommended crontab command.
I checked the ownership/and group is correct
this is print screen
Fixed!
The problem was in 7.11.3 update
I downloaded 7.11.4 update - installed with no problems.
Thank you!
Not sure if this is exactly the same but I had various errors in my suitecrm.log and apache log and it seems that the virtual machine I was running just needed a little extra memory. I had been working successfully for quite some time with 3GB RAM (total machine) but then started hanging on login and upgrade wizard - interestingly only from some clients while others were fine. Increasing the memory available to the VM to 4GB immediately seemed to fix the problem.
I had this exact problem with upgrading 7.11.2. I kept getting stuck on the system check and timing out. I tried permissions and deleting upgrade folders, etc.
Nothing worked, then I did a quick repair and rebuild. Turns out the database was not syncâd with vardefs, not sure if this was left over from the last upgrade. Anyway, completed the quick repair and rebuild and the upgrade proceeded normally. Just in case anyone else has this problem you can try this too.