Are you facing difficulties trying to coordinate efforts between marketing and sales? The SuiteCRM & Mautic Integrator by eVolpe is the best solution that will help you solve this issue. TRY IT NOW FOR FREE!
#1961 - Problem with Lead Creation
Hi, when I try to create a lead, I get follow error:
INSERT INTO leads (mautic_points,mautic_synced,mautic_opt_out,id,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,salutation,first_name,last_name,title,department,do_not_call,phone_mobile,phone_work,phone_fax,primary_address_street,primary_address_city,primary_address_state,primary_address_postalcode,primary_address_country,alt_address_street,alt_address_city,alt_address_state,alt_address_postalcode,alt_address_country,converted,refered_by,lead_source,lead_source_description,status,status_description,account_name,contact_id,account_id,opportunity_id,opportunity_amount,campaign_id,website) VALUES (0,0,0,'b0ec248f-41d2-4250-c827-5cdda5479e7a','2019-05-16 18:02:40','2019-05-16 18:02:40','1','1','',0,'1','','','1212','','',0,'','','','','','','','','','','','','',0,'','','','New','','','','','','','','http://'): MySQL error 1054: Unknown column 'mautic_points' in 'field list' Thu May 16 18:02:40 2019 [27425][1][FATAL] Exception handling in /var/www/html/include/MVC/Controller/SugarController.php:400 Thu May 16 18:02:40 2019 [27425][1][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details. Thu May 16 18:02:40 2019 [27425][1][FATAL] backtrace:
0 /var/www/html/include/database/DBManager.php(353): sugar_die('Database failur...')
1 /var/www/html/include/database/DBManager.php(328): DBManager->registerError('Error inserting...', 'Error inserting...', true)
2 /var/www/html/include/database/MysqliManager.php(179): DBManager->checkError('Error inserting...', true)
3 /var/www/html/include/database/DBManager.php(519): MysqliManager->query('INSERT INTO lea...', true, 'Error inserting...')
4 /var/www/html/data/SugarBean.php(2426): DBManager->insert(Object(Lead))
5 /var/www/html/include/SugarObjects/templates/person/Person.php(200): SugarBean->save(false)
6 /var/www/html/modules/Leads/Lead.php(587): Person->save(false)
7 /var/www/html/modules/Leads/LeadFormBase.php(378): Lead->save(false)
8 /var/www/html/modules/Leads/Save.php(53): LeadFormBase->handleSave('', true, false)
9 /var/www/html/include/MVC/View/SugarView.php(834): include_once('/var/www/html/m...')
10 /var/www/html/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile('modules/Leads/S...')
11 /var/www/html/include/MVC/View/SugarView.php(226): ViewClassic->display()
12 /var/www/html/include/MVC/Controller/SugarController.php(435): SugarView->process()
13 /var/www/html/include/MVC/Controller/SugarController.php(375): SugarController->processView()
14 /var/www/html/include/MVC/SugarApplication.php(113): SugarController->execute()
15 /var/www/html/index.php(52): SugarApplication->execute()
Can You Help Me?
Thanks.
5 years ago
Hello,
For formissing columns in database, please go to Administration -> Repair -> Quick Repair and Rebuild and afterwards execute printed SQL queries.
Best regards, Maciej Jankiewicz eVolpe Support Team