"Database failure" error when updating Opportunity status

When I set an opportunity to “Closed Won” (I haven’t tried others :wink: I get the following response:

Database failure. Please refer to sugarcrm.log for details.

The log file says this:

Wed Apr 16 00:11:11 2014 [25464][1][FATAL] Error updating table: opportunities: Query Failed: UPDATE opportunities
SET name=‘My Opportunity Name’,date_modified=‘2014-04-15 23:11:09’,modified_user_id=‘1’,created_by=‘1’,description=NULL,assigned_user_id=‘1’,opportunity_type=‘Existing Business’,campaign_id=’’,lead_source=‘Existing Customer’,amount=520,amount_usdollar=520,currency_id=’-99’,date_closed=‘2014-04-11’,next_step=NULL,sales_stage=‘Closed Won’,probability=100,=NULL
WHERE opportunities.id = ‘7a8cfcaf-f580-5549-cb5f-53467786041f’ AND deleted=0: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘=NULL
WHERE opportunities.id = ‘7a8cfcaf-f580-5549-cb5f-53467786041f’ AND’ at line 2

if ytou haven’t installed 7.1.1 I would install that, but other that the following should help you:-

https://suitecrm.com/index.php?option=com_kunena&view=topic&Itemid=1136&catid=10&id=885&limitstart=0#3686

This is wrong link!!!

See solution: https://www.suitecrm.co.uk/index.php?option=com_kunena&view=topic&Itemid=1136&catid=10&id=1791#7421

1 Like

Thanks for highlighting this, I’ve updated the link!