AnsweredAssumed Answered

Can't upgrade from 6.5.4 to 6.5.17 by using the wizard

Question asked by Jaume Albaigès on Jul 15, 2014
Latest reply on Jun 4, 2015 by evan@legalvision.com.au
Hello everybody,

I am trying to upgrade a SugarCRM CE 6.5.4 to 6.5.17. My instance runs on a dedicated server hosted in 1and1.

I properly load the Upgrade wizard page. When I click on Next button for the first time, Sugar displays a popup with a progress bar while checking the system. After a couple of minutes a database error is rendered by Sugar asking me to check sugarcrm.log.

In the upgradeWizard.log I can see:
Tue, 15 Jul 2014 16:31:22 +0200 [UpgradeWizard] - setting session variables...
Tue, 15 Jul 2014 16:31:22 +0200 [UpgradeWizard] - -----------------------------------------------------------------------------
Tue, 15 Jul 2014 16:31:22 +0200 [UpgradeWizard] - Upgrade started. At start.php
Tue, 15 Jul 2014 16:31:22 +0200 [UpgradeWizard] - at unlinkUWTempFiles()
Tue, 15 Jul 2014 16:31:22 +0200 [UpgradeWizard] - finished!
Tue, 15 Jul 2014 16:31:22 +0200 [UpgradeWizard] - resetting $_SESSION
Tue, 15 Jul 2014 16:31:55 +0200 [UpgradeWizard] - setting session variables...
Tue, 15 Jul 2014 16:31:55 +0200 [UpgradeWizard] - [At systemCheck.php]
Tue, 15 Jul 2014 16:31:55 +0200 [UpgradeWizard] - Starting file permission check...
Tue, 15 Jul 2014 16:33:20 +0200 [UpgradeWizard] - Finished file permission check.
Tue, 15 Jul 2014 16:33:20 +0200 [UpgradeWizard] - Starting database permissions check...
Tue, 15 Jul 2014 16:33:20 +0200 [UpgradeWizard] - Checking CREATE TABLE permissions...
Tue, 15 Jul 2014 16:33:20 +0200 [UpgradeWizard] - cannot CREATE TABLE!
[Deleted some lines because they are redundant]

Tue, 15 Jul 2014 16:33:20 +0200 [UpgradeWizard] - Finished database permissions check.

So, it seems there is something wrong with the database. Then I go to the sugarcrm.log:
Tue Jul 15 16:33:20 2014 [23419][1][FATAL] Query Failed: CREATE TABLE temp (id varchar(36)): MySQL error 2006: MySQL server has gone away
Tue Jul 15 16:33:20 2014 [23419][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
So, it seems the problem with the database is about connecting to the server.
 
In 1and1 dedicated servers the connection with MySQL is made through a special socket, so when I installed the CRM I had to add these two lines in my php.ini, otherwise I could not connect to MySQL server:
mysql.default_socket =/tmp/mysql5.sock
mysqli.default_socket =/tmp/mysql5.sock
I suspect the wizard is not using these lines so it can't connect to MySQL (although SugarCRM is running ok and I can normally read and write content to the database through the UI). Does the wizard connect to the database in a special way? Any ideas about it?

Thank you very much!

Jaume

Outcomes