Upgrading 7.0.2 to 7.1 Opportunity Update Adds spurious 'column' to query

📦 Install & Upgrade Help
1

Update completed, Ran quick repair and synched database schema - all report good. On update of opportunity, getting an odd bit added to the end of the query:

UPDATE opportunities
SET name=‘Opportunity’,date_modified=‘2014-04-01 15:28:45’,modified_user_id=‘ab95d954-dd2c-9aaa-222d-5238e6306f4d’,created_by=‘944364a7-4b5d-104f-1f64-5238da6d08d1’,description=‘Notes’,assigned_user_id=‘31304e58-3b79-21ac-d3ad-52573657ba92’,opportunity_type=‘School_District’,campaign_id=’’,lead_source=‘Conference’,amount=600000,amount_usdollar=600000,currency_id=’-99’,date_closed=‘2014-05-31’,next_step=NULL,sales_stage=‘Presentation_Demo’,probability=20,=NULL

Note at the very end the ,=NULL.

This is obviously throwing a syntax error. Error updating table: opportunities: Query Failed:

2

Hi Andrew,

You need to remove this file:

custom/Extension/modules/Opportunities/Ext/Vardefs/sugarfield_textarea_c.php

Then run a Quick Repair & Rebuild.

Thanks,

Will.

3

Note: Opportunity Create is working as expected.

4

All better. Thank you, Will.

Any other bits like this I need to address post upgrade?

Thanks!

5

Hi Andrew,

We were not aware of this file/field being added. If you spot any other bugs, please post them and any solutions you have.

Thanks,

Will.

1 Like
6

Hi Will,

I am having this same issue but in my Contacts module. However, I cannot find the file under:

custom/Extension/modules/Contacts/Ext/Vardefs/sugarfield_textarea_c.php

May you kindly let me know which file I need to remove?

Regards,

Saagar

7

I noticed that I had this file:

custom/Extension/modules/Contacts/Ext/Vardefs/sugarfield_facebook_username_c

But no corresponding field in Studio.

Deleted the file and ran a Quick Repair & Rebuild.

All’s well now.

Thanks

8

Hi saagark,

You also need to remove the following file:

custom/Extension/modules/Opportunities/Ext/Vardefs/sugarfield_textarea_c.php

Thanks,

Will.

9

Done that.

Thanks a bunch Will.