Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Database Exceptionyii\db\Exception

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') sm_teams_seasons_scenariodata ON team_seasons_id = sm_teams_seasons.id WHERE (' at line 2
The SQL being executed was: SELECT COUNT(*) FROM `sm_teams` INNER JOIN `sm_teams_seasons` ON `sm_teams`.`id` = `sm_teams_seasons`.`team_id` LEFT JOIN ( SELECT * FROM `sm_teams_seasons_scenariodata`
WHERE sm_teams_seasons_scenariodata.scenario_id=) sm_teams_seasons_scenariodata ON team_seasons_id = sm_teams_seasons.id WHERE (season_id = 22391) AND (is_placeholder IS NULL)

Error Info: Array
(
    [0] => 42000
    [1] => 1064
    [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') sm_teams_seasons_scenariodata ON team_seasons_id = sm_teams_seasons.id WHERE (' at line 2
)
$_GET = [
    'country_uri' => 'Italy',
    'league_uri' => 'Serie-C:-Girone-A',
    'hiddenfield' => 1,
    'country_id' => '251',
    'league_id' => [
        '1203',
    ],
    'season_id' => 22391,
];

$_SESSION = [
    '__flash' => [],
    'frontendTranslation_EnableTranslate' => 1,
    'sporttype_id' => 1,
    'sporttype' => unserialize('O:21:"app\\models\\Sporttypes":10:{s:36:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_attributes";a:18:{s:2:"id";i:1;s:4:"name";s:8:"Football";s:11:"tableprefix";s:2:"sm";s:4:"icon";s:6:"futbol";s:6:"active";i:1;s:7:"hitname";s:4:"goal";s:8:"has_draw";i:1;s:15:"stats_available";i:1;s:15:"squad_available";i:1;s:15:"sm_ai_available";i:1;s:15:"game_length_min";i:90;s:7:"periods";i:2;s:15:"overtimes_count";i:0;s:19:"overtime_length_min";i:0;s:9:"penalties";i:0;s:10:"win_points";i:3;s:11:"draw_points";i:1;s:11:"loss_points";i:0;}s:39:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_oldAttributes";a:18:{s:2:"id";i:1;s:4:"name";s:8:"Football";s:11:"tableprefix";s:2:"sm";s:4:"icon";s:6:"futbol";s:6:"active";i:1;s:7:"hitname";s:4:"goal";s:8:"has_draw";i:1;s:15:"stats_available";i:1;s:15:"squad_available";i:1;s:15:"sm_ai_available";i:1;s:15:"game_length_min";i:90;s:7:"periods";i:2;s:15:"overtimes_count";i:0;s:19:"overtime_length_min";i:0;s:9:"penalties";i:0;s:10:"win_points";i:3;s:11:"draw_points";i:1;s:11:"loss_points";i:0;}s:33:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_related";a:0:{}s:47:"' . "\0" . 'yii\\db\\BaseActiveRecord' . "\0" . '_relationsDependencies";a:0:{}s:23:"' . "\0" . 'yii\\base\\Model' . "\0" . '_errors";N;s:27:"' . "\0" . 'yii\\base\\Model' . "\0" . '_validators";N;s:25:"' . "\0" . 'yii\\base\\Model' . "\0" . '_scenario";s:7:"default";s:27:"' . "\0" . 'yii\\base\\Component' . "\0" . '_events";a:0:{}s:35:"' . "\0" . 'yii\\base\\Component' . "\0" . '_eventWildcards";a:0:{}s:30:"' . "\0" . 'yii\\base\\Component' . "\0" . '_behaviors";a:0:{}}'),
];