Topic: Missing Database Table Error

[cluelessnoob]

I get this error when I try to load the scaffold view.
I have tables called artists and comics in the comic database and models
call artist.php and comic.php. i have no idea what I'm doing wrong.

Missing Database Table

Error: Database table artists_comics for model ArtistsComic was not found.

[thorpe]

Going to need allot more information than that I'm afraid. You might at least tell us what framework your talking about.

[cluelessnoob]

Sorry I've been at this for too long. I'm using Cakephp. I have a database called comicdb and a tables called comics and artist. I have a model and controller for called comic and comics_controller respectively. As well as similarly named models and controllers for my six tables. the comics table has a foreign key for each table here is the code for the model:

Code: [Select]

<?
 class Comic extends AppModel {
 var $name = 'Comic';
 var $belongsTo = array('User');
var $hasOne = array(
        'Artist',
        'Author',
        'Rating',
        'Publisher'
);
 }
 ?>
and the controller:

Code: [Select]

<?
 class ComicsController extends AppController {
 var $name = 'Comics';
 var $scaffold;
 }
?>

I'm not sure what other information might be necessary.

[jcombs_31]

artists_comics would be a join table for... you guessed it, artists and comics.  The join table would be for a hasAndBelongsToMany relationship, which is a many to many relationship. 

Without more information about your database and model creations it is hard to see where you went wrong.  What does your artist model look like?

Do you have a join table?  Is it a many to many relationship?