4.2.1b upgrade - "Files May Only Be Used With A Sugar CRM 4.2.1 Database"

[iamluke]

Hi

I'm experiencing catastrophic problems upgrading from 4.2.0d to 4.2.1a/4.2.1b. When I run the Upgrade wizard with either installation file (SugarSuite-Upgrade-4[1].2.0-to-4.2.1a.zip or SugarSuite-Upgrade-4[1].2.0-to-4.2.1b.zip) it gives me the following output:

-----------
Including: C:\Program Files\SugarCRM\oss\httpd\htdocs\SugarCRM/cache/upload//upgrades/temp\23.tmp/scripts/pre_install.php
Scanning Files...Including: C:\Program Files\SugarCRM\oss\httpd\htdocs\SugarCRM/cache/upload//upgrades/temp\23.tmp/scripts/post_install.php
Upgrading the database to version 4.2.1...
Running SQL file 420_to_421_mysql.sql...
Finished.
Sugar CRM 4.2.1b Files May Only Be Used With A Sugar CRM 4.2.1 Database.
-----------

then when I attempt to navigate to any of the other modules I get a blank screen with the following message:

"Sugar CRM 4.2.1b Files May Only Be Used With A Sugar CRM 4.2.1 Database."


any suggestions much appreciated.

thanks!
Luke


PHP 5.0.4
Apache 2.0.54
MySQL 4.1.13
Windows XP professional 5.1.2600 SP2

[sacramentojoe]

I had this problem before. The last step of the upgrade is to modify the sugar version. 99% of the time I get an error at the bottom stating that it can't update the sugar version.
There is a check within the code that makes sure your database version is the same as the file versions.

I would check,
1. config.php and look at the sugar_version variable.
2. look at sugar_version.php in the docroot as well.
3. look at your config table for your crm database. There is a field called sugar_version.


Let me know if this works or if you have any other questions.

Joe

[iamluke]

Thanks for the pointers Joe

1. after the 4.2.1a upgrade, config.php seems to be ok:

  'sugar_version' => '4.2.1a' 
  

2.Sugar_version.php seems to be ok:

 // $Id: sugar_version.php,v 1.60.2.4.2.6 2006/07/10 21:53:36 awu Exp $
 
$sugar_version      = '4.2.1a';
$sugar_db_version   = '4.2.1';
$sugar_flavor       = 'OS'; 
  

3. sugar_version in the config table is 'null' which must be causing the problems, but I'm having trouble changing it... could you help with the syntax for the query to update it?

thanks again

Luke

[iamluke]

I've tried running this with no success (sugar_version remains stuck as 'Null'):

INSERT INTO config (category, name, value) VALUES ('info', 'sugar_version', '4.2.1');

any suggestions much appreciated.

thanks
Luke

[Proware]

Change the data type of the version field to Mediumtext.

[iamluke]

It worked!!

and I have absolutely no idea why...

thanks!

Luke

[seek]

what do you mean with "mediumext" ?

[translux]

I believe this is in reference to a sql statement.
Luke can you post what the syntax is that solved you problem?