Код: Выделить всё
$modelSites = Sites::findOne(1);
...
if ($modelMovies->save()) {
$modelMoviesReleases = new MoviesReleases();
$modelMoviesReleases->link('movies', $modelMovies);
$modelMoviesReleases->link('sites', $modelSites);
// $modelMoviesReleases->movies_id = $modelMovies->id;
// $modelMoviesReleases->sites_id = $modelSites->id;
$modelMoviesReleases->save();
}
Код: Выделить всё
Exception 'yii\db\IntegrityException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`movies`.`movies_re
leases`, CONSTRAINT `fk-movies-releases-sites-id` FOREIGN KEY (`sites_id`) REFERENCES `sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
The SQL being executed was: INSERT INTO `movies_releases` (`release_date`, `movies_id`) VALUES ('Release Date: 20 January 2019', 1)'
in C:\webservers\home\movies.local\vendor\yiisoft\yii2\db\Schema.php:664
Error Info:
Array
(
[0] => 23000
[1] => 1452
[2] => Cannot add or update a child row: a foreign key constraint fails (`movies`.`movies_releases`, CONSTRAINT `fk-movies-releases-sites-id` FOREIGN KEY (`sites_id`) REFERENCES `sites` (
`id`) ON DELETE CASCADE ON UPDATE CASCADE)
)
Код: Выделить всё
$modelMoviesReleases->link('sites', $modelSites);
$modelMoviesReleases->link('movies', $modelMovies);