I’m about to install the yii-user extension as a part of my website, but run into problems. If I import the module, the application gives me the following error message:
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.
Have you experiences the same problem yourself, and/or do you know what I can do to solve it?
Im not really sure where to find duplicated value.
The problem has probably something to do with me, because I’m new to Yii and php programming as a whole.
Based on the yii blog demo, I have expanded that with yii-user. If I follow along the installation manual,
doing the import, add module array, as well as components user array, and then login with the newly created yii-user module, thereby tries to create a post, it gives me the error:
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