Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
The SQL being executed was: SELECT COUNT(*) FROM ((SELECT 0 as type, `d_realizers_id`, `dorama_year` AS `year`, `dorama_episodes` AS `episodes`, `lc_doramas_realizers`.`dorama_id` AS `id`, `status`, `count_added`, `realizer` FROM `lc_doramas_realizers` LEFT JOIN `lc_doramas` ON `lc_doramas_realizers`.`dorama_id` = `lc_doramas`.`dorama_id` WHERE (`realizer`=8) AND ((`status`=1) OR (TRIM(dorama_episodes)=(SELECT count_added FROM lc_doramas_realizers WHERE realizer=8 AND lc_doramas_realizers.dorama_id=lc_doramas.dorama_id)))) UNION ALL ( SELECT 1 as type, `d_realizers_id`, `movie_year` AS `year`, 1 as episodes, `lc_movies_realizers`.`movie_id` AS `id`, 1 as status, 1 as count_added, `realizer` FROM `lc_movies_realizers` LEFT JOIN `lc_movies` ON `lc_movies_realizers`.`movie_id` = `lc_movies`.`movie_id` WHERE `realizer`=8 )) `a`

Error Info: Array
(
    [0] => 21000
    [1] => 1242
    [2] => Subquery returns more than 1 row
)
$_GET = [
    'id' => 8,
];