Hello, having an issue saving an opportunity (or rather, updating one) after it has been converted from a quote in the AOS Quotes module.
Steps to reproduce:
1.) Create Quote, add a few product or service line items.
2.) click the dropdown and select create opportunity
3.) click Save on the new opportunity
You receive the error: “Database failure. Please refer to sugarcrm.log for details.”
Sugarcrm log shows:
SET name='Quote',date_modified='2015-02-25 23:33:13',modified_user_id='c27c071e-e16e-1aa1-5867-4dbee98cc548',created_by='c27c071e-e16e-1aa1-5867-4dbee98cc548',description=NULL,assigned_user_id='c27c071e-e16e-1aa1-5867-4dbee98cc548',opportunity_type=NULL,campaign_id='',lead_source='Self Generated',amount=280,amount_usdollar=280,currency_id='-99',date_closed='2015-03-25',next_step=NULL,sales_stage='Proposal/Price Quote',probability=65,=NULL
WHERE opportunities.id = '54dcbbdf-8289-5948-0527-54ee58fe77fd' 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 = '54dcbbdf-8289-5948-0527-54ee58fe77fd' AND' at line 2Looks like its trying to update a column but it’s not including it in the SQL query. Notice at the end of the query the “,=NULL” it is not including the column name. Have no idea what column it’s trying to update.