# Missing database column?

**URL:** https://forum.mautic.org/t/missing-database-column/7977
**Category:** Product Support
**Created:** [March 20, 2017, 11:21pm UTC](https://forum.mautic.org/t/missing-database-column/7977 "2017-03-20T23:21:36Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)
#### Post date: [March 20, 2017, 11:21pm UTC](https://forum.mautic.org/t/missing-database-column/7977/1 "2017-03-20T23:21:36Z")

</div>

When trying to migrate to the latest database I keep getting the error ‘Can’t DROP ‘mauyu\_campaign\_event\_type\_search’; check that column/key exists’.  
  
The key exists but there is no column.  
  
Could someone please check their database and let me know if there should be a column and if so post the sql code to create it with the correct properties?  
  
  
  
Thanks

---

<div class="post-metadata">

### Author: ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)
#### Post date: [March 20, 2017, 11:21pm UTC](https://forum.mautic.org/t/missing-database-column/7977/2 "2017-03-20T23:21:36Z")

</div>

When trying to migrate to the latest database I keep getting the error ‘Can’t DROP ‘mauyu\_campaign\_event\_type\_search’; check that column/key exists’.  
The key exists but there is no column.  
Could someone please check their database and let me know if there should be a column and if so post the sql code to create it with the correct properties?

Thanks

---

<div class="post-metadata">

### Author: ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)
#### Post date: [March 21, 2017, 1:28am UTC](https://forum.mautic.org/t/missing-database-column/7977/3 "2017-03-21T01:28:34Z")

</div>

Thanks MxyzptlkFishStix,  
I somehow missed that - hopefully this will solve my problem.

---

<div class="post-metadata">

### Author: ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)
#### Post date: [March 21, 2017, 3:07am UTC](https://forum.mautic.org/t/missing-database-column/7977/4 "2017-03-21T03:07:31Z")

</div>

I have finally been able to upgrade to 2.7.1 Thanks to the code provided i was able to update the missing channels manually.  
Thanks MxyzptlkFishStix.

The failing code in the migration process was:

`ALTER TABLE mauyu_campaign_events
 ADD channel varchar(255) DEFAULT NULL,
 ADD channel_id INTEGER DEFAULT NULL;`

Changing this using code provided by MxyzptlkFishStix to :

`ALTER TABLE mauyu_campaign_events
 ADD channel varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 ADD channel_id int(11) DEFAULT NULL;`

allowed the upgrade to 2.7.1 to be implemented.