# Field 'is\_primary' doesn't have a default value

**URL:** https://forum.mautic.org/t/field-is-primary-doesnt-have-a-default-value/10607
**Category:** Development
**Created:** [June 26, 2018, 11:18am UTC](https://forum.mautic.org/t/field-is-primary-doesnt-have-a-default-value/10607 "2018-06-26T11:18:13Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![ravibabu](https://avatars.discourse-cdn.com/v4/letter/r/848f3c/32.png) [@ravibabu](https://forum.mautic.org/u/ravibabu)
#### Post date: [June 26, 2018, 11:18am UTC](https://forum.mautic.org/t/field-is-primary-doesnt-have-a-default-value/10607/1 "2018-06-26T11:18:13Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![ravibabu](https://avatars.discourse-cdn.com/v4/letter/r/848f3c/32.png) [@ravibabu](https://forum.mautic.org/u/ravibabu)
#### Post date: [June 26, 2018, 12:00pm UTC](https://forum.mautic.org/t/field-is-primary-doesnt-have-a-default-value/10607/2 "2018-06-26T12:00:02Z")

</div>

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