Mautic Community Forums

Missing database column?

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

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

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

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.