Mautic Community Forums

Field 'is_primary' doesn't have a default value

Hi,

Yesterday, I upgraded the Mautic v2.8.1 to v2.13.1,

I am getting some errors in the step of database migration.

[Doctrine\DBAL\Exception\DriverException]
An exception occurred while executing ‘insert into maujj_companies_leads (company_id, lead_id, date_added, manually_added, manually_removed) SELECT c.id, l.id, ‘2018-06-26 15:02:15’, 0, 0 from
maujj_leads l join maujj_companies c on c.companyname = l.company ON DUPLICATE KEY UPDATE company_id = c.id;’:

Field ‘is_primary’ doesn’t have a default value

[Doctrine\DBAL\Driver\Mysqli\MysqliException]
Field ‘is_primary’ doesn’t have a default value

This is the errors iam getting.

Please help with this error.

ALTER TABLE maujj_companies_leads CHANGE is_primary is_primary TINYINT(1) NULL DEFAULT NULL;