Mailchimp Extension allows you to sync the mailchimp details with SuiteCRM and SuiteCRM details to mailchimp
#3720 - Lot of MySQL errors and cant able to save the leads
Hi Team,
I'm facing the below error while saving the lead after installing the module. Please fix ASAP.
Wed Jul 7 12:20:06 2021 [32207][1][FATAL] Error updating table: leads: Query Failed: UPDATE leads SET date_modified='2021-07-07 12:20:03',modified_user_id='1',created_by='1',description='left vm',assigned_user_id='',salutation=NULL,first_name='Test',last_name=NULL,title=NULL,photo=NULL,department=NULL,do_not_call=0,phone_home=NULL,phone_mobile=NULL,phone_work='7149552341',phone_other=NULL,phone_fax=NULL,lawful_basis=NULL,date_reviewed=NULL,lawful_basis_source=NULL,primary_address_street=NULL,primary_address_city=NULL,primary_address_state=NULL,primary_address_postalcode=NULL,primary_address_country=NULL,alt_address_street=NULL,alt_address_city=NULL,alt_address_state=NULL,alt_address_postalcode=NULL,alt_address_country=NULL,assistant=NULL,assistant_phone=NULL,converted=0,refered_by=NULL,lead_source='Web Site',lead_source_description=NULL,status='Won',status_description=NULL,reports_to_id='',account_name='Test',account_description=NULL,contact_id='',account_id='',opportunity_id='',opportunity_name=NULL,opportunity_amount=NULL,campaign_id='',birthdate=NULL,portal_name=NULL,portal_app=NULL,website='http://',mailchimp_subscriber_list_id='' WHERE leads.id = '1a4001e4-ce03-01f9-6a56-60c2792348f8' AND deleted=0: MySQL error 1054: Unknown column 'mailchimp_subscriber_list_id' in 'field list' Wed Jul 7 12:20:06 2021 [32207][1][FATAL] Job c3fd59fa-76fa-7fd3-b58e-60e59bf317d2 (Process Workflow Tasks) failed in CRON run
3 years ago
Please create a mailchimp subscriber list and then update it. I belive you are syncing the mailchimp with leads module.
3 years ago
Please follow the installation steps - https://store.suitecrm.com/addons/mailchimp-extension
3 years ago
Thank you, It works.