An error occurred while performing update updates. please advise public function save (){
If (IS_POST ){
$ Post = I ('post .');
If (! Isset ($ post ['pkid']) | empty ($ post ['pkid']) {
$ Result = $ this-> CourseModel-> addInfo ($ post );
} Else {
$ Result = $ this-> CourseModel-> updateInfo ($ post );
}
If ($ result! = False ){
$ This-> redirect ("Course/index", '', 1, 'saved successfully ');
} Else {
$ This-> redirect ("Course/index", '', 1, 'failed to save ');
}
}
}
Public function updateInfo ($ data = array ()){
If (empty ($ data )){
Return false;
}
$ Data ['modify _ time'] = dateTime ();
Return $ this-> data ($ data)-> save ();
}
ERR: SQLSTATE [23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails ('elearning '. 'course', CONSTRAINT 'course _ ibfk_1 'foreign key ('Category _ id') REFERENCES 'Category' ('pkid') on delete cascade on update cascade)
Reply to discussion (solution)
The modified table has a foreign key constraint. you have modified a record that does not exist.
The modified table has a foreign key constraint. you have modified a record that does not exist.
How can this problem be solved?
You can either cancel the foreign key or confirm that the key exists before modification.