Help -- 4.5

[elvispresley99]

I just upgraded my 4.2.1a system to 4.5. All systems go. I really like the interface. However, in the announcement, there is a reference that both backup and restore funtionality is available, and I am unable to find it here. Going through the admin guide for 4.5 I don't see any reference to it either.

Am I missing something, or did my install get hosed? I want to pull over data / configuration from my production environment. I can seem to find any good threats on this.

Thanks in advance for your help with this issue.

My diagnostics file is included.

Thanks,

Elvis

[elvispresley99]

Anyone find anything on this?

It seems that the files that were backed up may not be completely compatible with 4.5?

I get an error, when simply performing the upgrade that would not let me even enter the site, implying that there was a vardef called 'NAMES' that was not valid?

What gives? Is it a vardef that has been changed?

I followed the directions, but I don't find this in the installation or admin guide, and I followed the upgrade verbatim.

Thanks

[kpit]

I recommend reverting the install it sound like the install didnt quite go according to plan. put back your original files and restore the database to pre install state and try again.

[elvispresley99]

Thanks for your response, but this is my first attempt at "reverting" a system. Can you instruct me or point me to a lnk that can assist me in this effort. I can't find any instruction on "restore."

Thanks!

Elvis

[Markku]

Unfortunately the only way to revert a system is to use backup copies of your database and files, like umeco said.

If you don't have backup copies available, you can try to copy Sugar 4.2.1a files over your installation and delete possible references to 4.5 from database tables upgrade_history and config. Now wait, if you've run run the upgrade script, then your database has been updated to 4.5 structure, so copying files from older version will not work. You could try to copy 4.5 files over your current installation.

edited ** Forgot one thing, the upgrade wizard will create cache/upload/upgrades/patch/SugarSuite-Upgrade-4.2.1-to-4.5.0-restore.zip which includes your 4.2.1 files.

edited part 2 *** I created two sql scripts which you can use to downgrade Sugar 4.5.0 database to version 4.2.1.

Steps to downgrade (use at your own risk, worked on my test environment though)

1. Run downgrade_sugar450_to_421.sql
This will delete tables created by 4.5.0 upgrade and revert db structure back to 4.2.1

2. Run downgrade_sugar_table_charset_450_to_421.sql
This will simply change the character set of all tables to Latin1, if you use another charecter set, simply change the script

3. Copy files from cache/upload/upgrades/patch/SugarSuite-Upgrade-4.2.1-to-4.5.0-restore.zip to root folder (overwrite Sugar 4.5.0 files)

As said, I tried this on my test system with success, your milage might vary.

[stevec]

Looking at another post in the forums - that 'NAMES' error could be generated by an incompatable version of mysql. You may need to upgrade that too.

[elvispresley99]

Thanks for the info guys. I will try the scripts you provided and let you know!

I really appreciate the help!

[Markku]

Hi elvispresley99,

Just curious, how did it go? Did you solve your problem?

[elvispresley99]

I did get everything back to pre-state. I am in the process of getting back to 4.5. Thanks for the scripts guys.

[sugarsugarinc]

I am trying to revert back to v4.2.1 from a 4.5 install that is not working with my host (MySQL not the right version) so I ran the 2 .sql scripts. But there is no SugarSuite-Upgrade-4.2.1-to-4.5.0-restore.zip file. It looks like it wasn't created. What do you recommend as the next step? Should I try to copy Sugar 4.2.1a files over my installation of 4.5 now that I have the database corrected?

Thanks for your help.

If you don't have backup copies available, you can try to copy Sugar 4.2.1a files over your installation and delete possible references to 4.5 from database tables upgrade_history and config. Now wait, if you've run run the upgrade script, then your database has been updated to 4.5 structure, so copying files from older version will not work. You could try to copy 4.5 files over your current installation.

edited ** Forgot one thing, the upgrade wizard will create cache/upload/upgrades/patch/SugarSuite-Upgrade-4.2.1-to-4.5.0-restore.zip which includes your 4.2.1 files.

edited part 2 *** I created two sql scripts which you can use to downgrade Sugar 4.5.0 database to version 4.2.1.

Steps to downgrade (use at your own risk, worked on my test environment though)

1. Run downgrade_sugar450_to_421.sql
This will delete tables created by 4.5.0 upgrade and revert db structure back to 4.2.1

2. Run downgrade_sugar_table_charset_450_to_421.sql
This will simply change the character set of all tables to Latin1, if you use another charecter set, simply change the script

3. Copy files from cache/upload/upgrades/patch/SugarSuite-Upgrade-4.2.1-to-4.5.0-restore.zip to root folder (overwrite Sugar 4.5.0 files)