Mailing reports - no such table - fixed! :-)

[nsjski]

We just migrated our site.   CiviCRM looks ok, apart from the mailing reports.

civicrm/mailing/report?mid=108&reset=1

gives

Sorry but we are not able to provide this at the moment.  DB Error: no such table

In the log file I found this:  "Table 'civicrm_mailing_event_reply' doesn't exist"

I checked in phpmyadmin and it's true, there is no table called civicrm_mailing_event_reply there.  We have several other civicrm_mailing_event tables: bounce, confirm, delivered, forward, opened, queue, subscribe, trackable_url_open and unsubscribe.   I have no idea how that table vanished or if there are others missing.

Help!  How should I fix this?

- - - - - - -

I found this in an old backup:

Code: [Select]

DROP TABLE IF EXISTS `civicrm_mailing_event_reply`;
CREATE TABLE `civicrm_mailing_event_reply` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,   `event_queue_id` int(10) unsigned NOT NULL COMMENT 'FK to EventQueue',   `time_stamp` datetime NOT NULL COMMENT 'When this reply event occurred.',   PRIMARY KEY (`id`),   KEY `FK_civicrm_mailing_event_reply_event_queue_id` (`event_queue_id`),   CONSTRAINT `FK_civicrm_mailing_event_reply_event_queue_id` FOREIGN KEY (`event_queue_id`) REFERENCES `civicrm_mailing_event_queue` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
There are no other mentions of that table in the backup file.  If I copy the create table line into phpmyadmin's query box will that do the job?   I am not very familiar with mysql.

- - - - - - -

YES!  It worked!   

This was our 2nd migration in 2 months and both times I had the hosting service do the migration, the table got left behind somehow in the 1st migration.