by eVolpe Consulting Group

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!

Free 30 day trial
Try it Now

#1961 - Problem with Lead Creation

Closed Bug? created by leon 5 years ago

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.

  1. eVolpe member avatar

    eVolpe Consulting Group Provider

    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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "Install and first test worked like a charm (well documented). Except for one little thing: In my environment there was an issue with database table cr..." - Endymion

    Read More Reviews