Copied! Copy Stacktrace Search Stackoverflow Search Google Exception

Integrity constraint violationyii\db\IntegrityException

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'city_id' in where clause is ambiguous
The SQL being executed was: SELECT COUNT(*) FROM `object` LEFT JOIN `builder` ON `object`.`builder_id` = `builder`.`id` WHERE (`city_id`='32') AND (`approved`=1)

Error Info: Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'city_id' in where clause is ambiguous
)
$_GET = [
    'ObjectSearch' => [
        'city_id' => '32',
    ],
];