title: Error: SQLSTATE[42S02]: Base table or view not found
body: <p>I am using CakePHP Version 2.2.3. Having imported my database into PHPMyAdmin, I went on to create my MVC sing CakePHP's bake console. This all went well, I declared my relationships etc...</p>
  
  <p>The problem occurs on creating the last 'view' (All the models/controllers were created without error). </p>
  
  <p>The full error is: Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'website.connections' doesn't exist</p>
  
  <p>Where as I can confirm it does exist, both table,controller,model and view!</p>
  
  <p>I'm exceptionally confused, any help would be greatly appreciated.</p>
  
  <p>Many thanks in advance.</p>
  
  <p><strong>Update</strong></p>
  
  <p>On the 'Members' model, on commenting out the 'Has Many' code relating to Connections, the error then appears for the next relationship below it. The relationship code is:</p>
  
  <pre><code>public $hasMany = array(
      'Connections' =&gt; array(
          'className' =&gt; 'Connections',
          'foreignKey' =&gt; 'Member_ID',
          'dependent' =&gt; false,
          'conditions' =&gt; '',
          'fields' =&gt; '',
          'order' =&gt; '',
          'limit' =&gt; '',
          'offset' =&gt; '',
          'exclusive' =&gt; '',
          'finderQuery' =&gt; '',
          'counterQuery' =&gt; ''
      ),
      'Recommendations' =&gt; array(
          'className' =&gt; 'Recommendations',
          'foreignKey' =&gt; 'Member_Being_Recommended_ID',
          'dependent' =&gt; false,
          'conditions' =&gt; '',
          'fields' =&gt; '',
          'order' =&gt; '',
          'limit' =&gt; '',
          'offset' =&gt; '',
          'exclusive' =&gt; '',
          'finderQuery' =&gt; '',
          'counterQuery' =&gt; ''
      ),
      'Groups' =&gt; array(
          'className' =&gt; 'Groups',
          'foreignKey' =&gt; 'Member_ID',
          'dependent' =&gt; false,
          'conditions' =&gt; '',
          'fields' =&gt; '',
          'order' =&gt; '',
          'limit' =&gt; '',
          'offset' =&gt; '',
          'exclusive' =&gt; '',
          'finderQuery' =&gt; '',
          'counterQuery' =&gt; ''
      )
  );
  </code></pre>
  
  <p>So once the 'connections' relationship is commented out, the error then moves onto Recommendations, the one below it.</p>