Upgrade from 3.5.1.e to 4.0 failed horribly

**midwestdedicated** · 2005-12-20, 01:31 PM

Well, I tried the upgrade last night and it went down in a ball of flames. In the 4.0 installation manual it states to upgrade using the wizard by uploading the 4.0 upgrade ZIP file. Is that the same as the 4.0 patch? If so, then it is missing something! The upgrade did not move any of the new ACL folders, did not upgrade the database, got to the timezone setting and then got stuck. At that point, the system was dead and any attempt to log-in left me at the timezone feature. I could not go into admin, or any other part of the CRM. Was I using the wrong ZIP file to upgrade? It appeared the Patch has the upgrade SQL in the SCRIPTS folder, but it doesn't seem to be executing correctly.

Regards,

Oliver

**mgamboa** · 2005-12-21, 04:38 PM

to me say somthing about the database can't upgrade

**et2brute** · 2005-12-21, 06:36 PM

My upgrade to 4.0.0 stopped several times with directory permission problems. Everytime I corrected the permissions and re-ran the upgrade and it correctly resumed from the last file. That was until it got to a point where it threw in the towel completely and now I have "Sugar CRM 4.0.0 Files May Only Be Used With A Sugar CRM 4.0.0 Database". I assume it missed the database upgrade step ~ any ideas how I can resume from there?

**Shuchi** · 2005-12-22, 12:15 PM

I currently upgraded to Suagrcrm 4.0beta .I had 3.5.1d(open source version) installed prevoiusly.After the installation, i logged out and now i can't log in. The following error is shown:

Sugar CRM 4.0.0beta Files May Only Be Used With A Sugar CRM 4.0.0beta Database.

**et2brute** · 2005-12-22, 01:45 PM

Update:

Using phpMyAdmin 2.7 and ran the two upgrade scripts which come with the 4.0.0 patch (scripts folder). After much fiddling with the database (the scripts weren't happy with certain folders), the database is now working with 4.0.0. Howeve...:

I can now log in to SugarCRM but am presented with:

"Please choose your timezone. You will receive this prompt only once.
You may change it at any time in "My Account" settings"

Well when I click on "save" it does not go away and I cannot proceed any further from this screen.

**midwestdedicated** · 2005-12-29, 02:54 PM

I am still getting that same problem too. I have had to roll back the installation twice now.

**et2brute** · 2006-01-01, 04:30 PM

I have re-installed 3.5.1 and now I am told that I cannot access the database:

"Sugar CRM 3.5.1a Files May Only Be Used With A Sugar CRM 3.5.1 Database"

Help!

**AlexXF** · 2006-01-04, 07:34 AM

How to upgrade to 4.0.0

BACKUP DATABASE!!!

Step 1.

Code:

 
UPDATE config SET value= '4.0.0' WHERE category='info' AND name='sugar_version'
ALTER TABLE `users` ADD `is_group` TINYINT(1)  DEFAULT "0"

Step 2.
table 'roles_modules' - delete all NON SUGAR modules rows

Step 3.
Backup your previouse (3.5.1) folder

Step 4.
Copy 4.0.0 files

Step 5.
Copy \config.php and .htaccess file from backup 3.5.1 to root 4.0.0

Step 6.
Login to SugarCRM using your admin account

Step 7.
Copy \cache\upload\ folder from 3.5.1 to 4.0.0

Step 8.
Repair: databases, relationship, extensions, DTF

Enjoy!