Upgrade From 6.1.6 to 6.2.3 Failes with SQL Error

[Simmons]

Good Day,

I've been upgrading my SugarCRM CE from 5.5.0 to 6.2.3. The upgrade through 6.1.6 has gone without incident but now the upgrade fails with this message.

SQL Error : Conversion failed when converting the varchar value '56a796d6-35d9-d723-8d34-48418499eff1' to data type int.

If I go in and through the admin menu and run quick repair and rebuild I get this message;

Rebuilding Extensions...
Rebuilding Modules...
Rebuilding Language...en_us
Rebuilding Vardefs...
Rebuilding Layoutdefs...
Rebuilding Menus...
Rebuilding DC Actions...
Rebuilding User Page Section...
Rebuilding administration Section...
Rebuilding RelationshipsSQL Error : Conversion failed when converting the varchar value '56a796d6-35d9-d723-8d34-48418499eff1' to data type int.

We do have some custom fields that are updated by a MSSQL view into Sugar, but historically, these have not caused a problem.

We are running SugarCRM with MS SQL 2008 Release 2.

Can someone throw me a bone here as to where to start looking for the cause of this error?

Thanks..

-Mark-

[Simmons]

Well this was fun. Seems the ADMIN account was inactive. Re-activating the ADMIN account allowed the upgrade to complete.

Another problem has surfaced which is the global search function fails with the following error message.

Query Failed: SELECT TOP 11 contacts.id , LTRIM(RTRIM(ISNULL(contacts.first_name,'') + ' ' + ISNULL(contacts.last_name,''))) as name, contacts.first_name , contacts.last_name , contacts.salutation , contacts.title , contacts.phone_work , contacts.date_entered , contacts.assigned_user_id FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c where (((contacts.first_name like 'Simmons%' ) OR ( contacts.last_name like 'Simmons%' ) OR ( ( contacts.phone_mobile like 'Simmons%' OR contacts.phone_work like 'Simmons%' OR contacts.phone_other like 'Simmons%' OR contacts.phone_fax like 'Simmons%' OR contacts.assistant_phone like 'Simmons%' ) ) OR ( contacts.assistant like 'Simmons%' ) OR ( contacts.id IN (SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE 'Simmons%') ) OR ( accounts.name like 'Simmons%'))) AND contacts.deleted=0 ORDER BY contacts.date_entered

DESC: SQL Server error: The multi-part identifier "accounts.name" could not be bound.

Not sure where to start with this one....

Thanks...

-Mark-

[Simmons]

Thought I'd update everyone on this issue.

Seems the ADMIN account was "Inactive" Once the account was made active, the upgrade completed without any further errors.

-Mark-