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!

Cancel at any time!
Free Trial

#1961 - Problem with Lead Creation

Closed Bug? created by leon 10 months 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

    10 months 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...