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
