title: I am getting an error trying to create table in phpmyadmin
body: <p>I am trying to run the following:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS table_name (
  user_id int(11) NOT NULL,
  other_id int(11) NOT NULL,
  FOREIGN KEY (user_id) REFERENCES users(id),
  FOREIGN KEY (other_id) REFERENCES other_table(id),
  PRIMARY KEY (user_id, other_id)
  );
  </code></pre>
  
  <p>and getting the following error:</p>
  
  <pre><code>#1005 - Can't create table 'database_name.table_name' (errno: 150)
  </code></pre>
  
  <p>am I doing something wrong? This works fine just running it in another environment rather than phpmyadmin sql environment.</p>