Upgrade to 4.5 issue. Please help

[atippett]

I'm trying to upgrade from 4.2.1d.

I upload the 4.2.1-to-4.5.0 patch, click install and then click commit. The install wizard then says:

"The new Upgrade Wizard will now resume the upgrade process. Please continue your upgrade."

But nothing ever happens.

I looked at the php log file and it contained the following:
[07-Sep-2006 15:03:36] PHP Warning: main(cache/upload/upgrades/patch/SugarSuite-Patch-4.2.0c-manifest.php): failed to open stream: No such file or directory in /opt/usr/sugarcrm/modules/UpgradeWizard/index.php on line 181
[07-Sep-2006 15:03:36] PHP Fatal error: main(): Failed opening required 'cache/upload/upgrades/patch/SugarSuite-Patch-4.2.0c-manifest.php' (include_path='.:/usr/share/php:/opt/usr/share/php:/opt/usr/share/php/MimeMail') in /opt/usr/sugarcrm/modules/UpgradeWizard/index.php on line 181

not sure if it's relavant.

Please help if anyone has any ideas on what to do.

[tdp]

I'm trying to upgrade from 4.2.1d.

I upload the 4.2.1-to-4.5.0 patch, click install and then click commit. The install wizard then says:

"The new Upgrade Wizard will now resume the upgrade process. Please continue your upgrade."

But nothing ever happens.

I looked at the php log file and it contained the following:
[07-Sep-2006 15:03:36] PHP Warning: main(cache/upload/upgrades/patch/SugarSuite-Patch-4.2.0c-manifest.php): failed to open stream: No such file or directory in /opt/usr/sugarcrm/modules/UpgradeWizard/index.php on line 181
[07-Sep-2006 15:03:36] PHP Fatal error: main(): Failed opening required 'cache/upload/upgrades/patch/SugarSuite-Patch-4.2.0c-manifest.php' (include_path='.:/usr/share/php:/opt/usr/share/php:/opt/usr/share/php/MimeMail') in /opt/usr/sugarcrm/modules/UpgradeWizard/index.php on line 181

not sure if it's relavant.

Please help if anyone has any ideas on what to do.

I had a very similar Fatal error when I attempted to upgrade. When I looked at the info in that directory (cache/upload/upgrades/patch) there was a mismatch with what was listed in the upgrade_history table in the Sugar database. Once I removed everything from the upgrade_history table that wasn't in that directory, the upgrade proceeded smoothly.

[psdavec]

I'm having the same issue. My log is slightly different but still refers to a failed upgrade:
[Thu Sep 07 15:19:47 2006] [error] [client 5.14.14.65] PHP Warning: require_once(cache/upload/upgrades/patch/SugarSuite-Upgrade-4[1].0.1_to_4.2.0beta-manifest.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in C:\\Program Files\\Apache Group\\Apache2\\htdocs\\SugarCRM\\modules\\Upgrade Wizard\\index.php on line 181, referer: http://server:8080/sugarcrm/index.ph...Wizard_prepare
[Thu Sep 07 15:19:47 2006] [error] [client 5.14.14.65] PHP Fatal error: require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'cache/upload/upgrades/patch/SugarSuite-Upgrade-4[1].0.1_to_4.2.0beta-manifest.php' (include_path='.;C:\\php5\\pear') in C:\\Program Files\\Apache Group\\Apache2\\htdocs\\SugarCRM\\modules\\Upgrade Wizard\\index.php on line 181, referer: http://server:8080/sugarcrm/index.ph...Wizard_prepare

[psdavec]

Cleared the Update History table of all mismatches and upgrade went through. Thanks tdp

[atippett]

Yes.. i had to delete like 8 rows of updates that were not longer on the file system. Worked afterwards.

[marshalle]

Just one little question, how do you edit the history table, where is it?

Thanks!

[atippett]

Just one little question, how do you edit the history table, where is it?

Thanks!

It's in your database. Table upgrade_history.

[marshalle]

OK, I'm an infrastructure guy not an apps guy so database tables are out of my league. How do you edit a database table? Actually just checked google, it seems MYSQL administrator may be the go. But upon closer inspection I can't find the data so I guess back to Google any hints?

Thanks

Q

[tdp]

OK, I'm an infrastructure guy not an apps guy so database tables are out of my league. How do you edit a database table? Actually just checked google, it seems MYSQL administrator may be the go. But upon closer inspection I can't find the data so I guess back to Google any hints?

Thanks

Q

Rather than MySQLAdministrator, I would highly reccomend phpMyAdmin . It is a PHP/Web based program that is MUCH easier to use than MySQLAdministrator and lets you edit tables rows very easily. As far as I can tell (and I'm far from an expert) MySQLAdministrator doesn't let you delete individual rows, which is exactly what you need to do to solve this error.

[fredrikwestin]

I had a very similar Fatal error when I attempted to upgrade. When I looked at the info in that directory (cache/upload/upgrades/patch) there was a mismatch with what was listed in the upgrade_history table in the Sugar database. Once I removed everything from the upgrade_history table that wasn't in that directory, the upgrade proceeded smoothly.

Thanks, Made my day!