(Suite) The problem is that jetspeed tries to remove a user in the TURBINE_USER table, without removing first the foreign key dependencies in the TUBINE_USER_GROUP_ROLE table.
Does Jetspeed rely on a "cascade delete" done by MySQL ? (i don't know if it's possible and how to configure that) Help would be really appreciated ;o) Thanks Mike Hi all ! (English is not my native language, so please forgive my grammar errors...) I just configured Jetspeed to talk MySQL for user authentication, using the scripts found in the distribution (1.4b1). I am able to create users via the administrative portlets, i can see them in the MySQL tables, but i can't delete them... In Jetspeed, i got "Database Delete Failure. Please report this error to your Database Administrator.". In the logs, i see : java.sql.SQLException: General error: Cannot delete a parent row: a foreign key constraint fails at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source) at org.gjt.mm.mysql.Connection.execSQL(Unknown Source) at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Unknown Source) at org.gjt.mm.mysql.PreparedStatement.executeUpdate(Unknown Source) at com.workingdogs.village.Record.saveWithDelete(Unknown Source) at com.workingdogs.village.Record.save(Unknown Source) at com.workingdogs.village.Record.save(Unknown Source) at org.apache.torque.util.BasePeer.doDelete(BasePeer.java:700) at org.apache.torque.util.BasePeer.doDelete(BasePeer.java:563). Is it a MySQL configuration problem ? Anyone can help ? Thanks in advance Mike -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
