Sometimes the WordPress database user is unable to correctly create the Broadcast “broadcastdata” (linking) database table, leaving the table with an ID column.
Without the ID column, links between are unable to be created.
The source of the error is usually SQL user permissions.
Using the snippet below, you can use the SQL CLI or phpMyadmin in order to create the table completely.
CREATE TABLE IF NOT EXISTS `wp__3wp_broadcast_broadcastdata` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID of row',
`blog_id` int(11) NOT NULL COMMENT 'Blog ID',
`post_id` int(11) NOT NULL COMMENT 'Post ID',
`data` longtext DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `blog_id` (`blog_id`,`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;