CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (alumni2/al_aktifitas_alumni, CONSTRAINT fk_aktifitas_alumni_1 FOREIGN KEY (idaktifitas) REFERENCES al_aktifitas (idaktifitas) ON DELETE NO ACTION ON UPDATE CASCADE)[/color]
function relation di model biodata.php
public function relations()
{
// NOTE: you may need to adjust the relation name and the related
// class name for the relations automatically generated below.
return array(
'aktifitasAlumnis' => array(self::HAS_MANY, 'AktifitasAlumni', 'idalumni'),
'aktifitas' => array(self::MANY_MANY, 'Aktifitas', 'idaktifitas'),
'idprogram_studi'=>array(self::BELONGS_TO,'program_studi','idprogram'),
);
}
Keliatannya sih gagal delete record di tabel yang terelasi ama dia, gan. Soalnya untuk reference option delete-nya diset ‘NO ACTION’. Klo ga salah di MySQL ‘NO ACTION’ artinya jadi ‘RESTRICT’
Solusinya mungkin di option buat ON DELETE-nya dibikin jadi ‘CASCADE’ juga ato ‘SET NULL’. Tapi itu tergantung keinginan agan juga sih hasilnya mo kaya gimana …