title: MySQL errno: 150 can't create table
body: <p>I know there are a lot of questions on SO regarding this error, but even applying what I've gleaned from those, I still get "can't create table (errno: 150)"</p>
  
  <pre><code>CREATE TABLE sch_results
  (
  id INT NOT NULL AUTO_INCREMENT,
  s_id INT UNSIGNED NOT NULL,
  r_eid VARCHAR(10) NOT NULL,
  cohorts INT,
  allstudents INT,
  comments TEXT,
  PRIMARY KEY (id),
  FOREIGN KEY (s_id) REFERENCES scholarships (id),
  FOREIGN KEY (r_eid) REFERENCES sch_recommenders (eid)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>I've checked that the foreign keys are both stored exactly under that name in their respective tables.<br>
  I've checked that their respective data types match this query. 
  I've checked that the two existing tables are using InnoDB and utf8.<br>
  I added the UNSIGNED NOT NULL to the foreign keys.<br>
  I indexed the two foreign keys in their tables. 
  Initially, I was using s_id and r_id, but heard this might cause some problems.  r_eid is also unique, so I switched to that.  It is not the primary key. </p>
  
  <p>What am I missing?</p>