I have a fresh unaltered install which starting with Sugar 6.5.20 then I uploaded the upgrade module 6.5.X to Suite 7.1.5. through the upgrade wizard and the install is running on…
Linux
Apache: 2.2.22
MySQL: 5.1.66-cll
Php: 5.3.16
I noticed that after creating a new opportunity either from converting a lead or directly from the opportunity module, if I try to edit that opportunity and save it again or just click the edit button and save it without changing anything, I get the following… “Database failure. Please refer to sugarcrm.log for details.”
Here is the error log…
Wed Feb 11 00:32:36 2015 [24580][1][FATAL] Query Failed: UPDATE aos_pdf_templates SET type = ‘AOS_Quotes’ WHERE type = ‘Quotes’: MySQL error 1146: Table ‘veritas9_grow15.aos_pdf_templates’ doesn’t exist
Wed Feb 11 00:32:36 2015 [24580][1][FATAL] Query Failed: UPDATE aos_pdf_templates SET type = ‘AOS_Invoices’ WHERE type = ‘Invoices’: MySQL error 1146: Table ‘veritas9_grow15.aos_pdf_templates’ doesn’t exist
Wed Feb 11 00:32:37 2015 [24580][1][FATAL] Query Failed: ALTER TABLE aor_fields DISABLE KEYS: MySQL error 1146: Table ‘veritas9_grow15.aor_fields’ doesn’t exist
Wed Feb 11 00:32:37 2015 [24580][1][FATAL] Query Failed: ALTER TABLE aor_fields CHANGE function field_function VARCHAR( 100 ): MySQL error 1146: Table ‘veritas9_grow15.aor_fields’ doesn’t exist
Wed Feb 11 00:32:37 2015 [24580][1][FATAL] Query Failed: ALTER TABLE aor_fields ENABLE KEYS: MySQL error 1146: Table ‘veritas9_grow15.aor_fields’ doesn’t exist
Wed Feb 11 00:32:37 2015 [24580][1][FATAL] MySQL error 1146: Table ‘veritas9_grow15.aor_fields’ doesn’t exist
Wed Feb 11 00:36:28 2015 [25160][1][FATAL] Error updating table: opportunities: Query Failed: UPDATE opportunities
SET name=‘tom, tom - credit program’,date_modified=‘2015-02-11 06:36:27’,modified_user_id=‘1’,created_by=‘1’,description=NULL,assigned_user_id=‘1’,opportunity_type=NULL,campaign_id=’’,lead_source=NULL,amount=247,amount_usdollar=247,currency_id=’-99’,date_closed=‘2015-02-13’,next_step=NULL,sales_stage=‘Closed Won’,probability=100,=NULL
WHERE opportunities.id = ‘9c51b892-1604-cf5c-0df8-54daf65f3afb’ 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 = ‘9c51b892-1604-cf5c-0df8-54daf65f3afb’ AND’ at line 2
Wed Feb 11 00:41:55 2015 [26210][1][FATAL] Error updating table: opportunities: Query Failed: UPDATE opportunities
SET name=‘tom, tom - credit program’,date_modified=‘2015-02-11 06:41:54’,modified_user_id=‘1’,created_by=‘1’,description=NULL,assigned_user_id=‘1’,opportunity_type=NULL,campaign_id=’’,lead_source=NULL,amount=247,amount_usdollar=247,currency_id=’-99’,date_closed=‘2015-02-13’,next_step=NULL,sales_stage=‘Needs Analysis’,probability=25,=NULL
WHERE opportunities.id = ‘9c51b892-1604-cf5c-0df8-54daf65f3afb’ 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 = ‘9c51b892-1604-cf5c-0df8-54daf65f3afb’ AND’ at line 2
Wed Feb 11 00:42:12 2015 [26316][1][FATAL] Error updating table: opportunities: Query Failed: UPDATE opportunities
SET name=‘tom, tom - credit program’,date_modified=‘2015-02-11 06:42:12’,modified_user_id=‘1’,created_by=‘1’,description=NULL,assigned_user_id=‘1’,opportunity_type=‘Existing Business’,campaign_id=’’,lead_source=‘Employee’,amount=247,amount_usdollar=247,currency_id=’-99’,date_closed=‘2015-02-13’,next_step=NULL,sales_stage=‘Perception Analysis’,probability=50,=NULL
WHERE opportunities.id = ‘9c51b892-1604-cf5c-0df8-54daf65f3afb’ 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 = ‘9c51b892-1604-cf5c-0df8-54daf65f3afb’ AND’ at line 2
Wed Feb 11 00:43:59 2015 [26448][1][FATAL] Error updating table: opportunities: Query Failed: UPDATE opportunities
SET name=‘tom, tom - credit program’,date_modified=‘2015-02-11 06:43:59’,modified_user_id=‘1’,created_by=‘1’,description=NULL,assigned_user_id=‘1’,opportunity_type=NULL,campaign_id=’’,lead_source=NULL,amount=247,amount_usdollar=247,currency_id=’-99’,date_closed=‘2015-02-13’,next_step=NULL,sales_stage=‘Perception Analysis’,probability=50,=NULL
WHERE opportunities.id = ‘9c51b892-1604-cf5c-0df8-54daf65f3afb’ 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 = ‘9c51b892-1604-cf5c-0df8-54daf65f3afb’ AND’ at line 2