Hi Folks,
i’m pretty new to yii and I have this annoying issue that theres this exception on the server when I try to assign a user.
$auth=Yii::app()->authManager;
$auth->assign($user->role, $this->_id);
the thing is, on my local system all works well, but when I transfer it to the server this exception happens:
CDbException
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 (db416793489
.AuthAssignment
, CONSTRAINT authassignment_ibfk_1
FOREIGN KEY (itemname
) REFERENCES authitem
(name
) ON DELETE CASCADE ON UPDATE CASCADE). The SQL statement executed was: INSERT INTO AuthAssignment
(itemname
, userid
, bizrule
, data
) VALUES (:itemname, :userid, :bizrule, :data)
sql:
# Export von Tabelle AuthAssignment
# ------------------------------------------------------------
CREATE TABLE `AuthAssignment` (
`itemname` varchar(64) NOT NULL DEFAULT '',
`userid` varchar(64) NOT NULL DEFAULT '',
`bizrule` text,
`data` text,
PRIMARY KEY (`itemname`,`userid`),
CONSTRAINT `authassignment_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Export von Tabelle AuthItem
# ------------------------------------------------------------
CREATE TABLE `AuthItem` (
`name` varchar(64) NOT NULL DEFAULT '',
`type` int(11) NOT NULL,
`description` text,
`bizrule` text,
`data` text,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Export von Tabelle AuthItemChild
# ------------------------------------------------------------
CREATE TABLE `AuthItemChild` (
`parent` varchar(64) NOT NULL DEFAULT '',
`child` varchar(64) NOT NULL DEFAULT '',
PRIMARY KEY (`parent`,`child`),
KEY `child` (`child`),
CONSTRAINT `authitemchild_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `authitemchild_ibfk_2` FOREIGN KEY (`child`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
any ideas? i’m really stuck. thanks in advance