Spent quite a bit of time trying to figure this one out. It turns out, InnoDB wants an index created on a referenced field. It turns out, the error was as a result of a non-indexed referenced field–title_etd in this case.
Affected tables are below