[ https://issues.apache.org/jira/browse/OFBIZ-243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12661261#action_12661261 ]
Adrian Crum commented on OFBIZ-243: ----------------------------------- Jacopo, This appears to be fixed in the latest SVN trunk (DatabaseUtil.java, line 2515). Could you confirm please? > SQL Exception when dropping FK's on MySQL > ----------------------------------------- > > Key: OFBIZ-243 > URL: https://issues.apache.org/jira/browse/OFBIZ-243 > Project: OFBiz > Issue Type: Bug > Components: framework > Reporter: Jacopo Cappellato > Priority: Minor > > Migrated from an issue in the old server from Matt Penner: > On r4762 (probably since the beginning of this class) removing Foreign Keys > using the WebTools app causes SQL Exceptions using MySQL 4.1.11 on Windows. > This is because the SQL call is using DROP CONSTRAINT whereas MySQL requires > DROP FOREIGN KEY. > I noticed that the DatabaseUtil class takes into account fkStyle when > creating a Foreign Key but it doesn't check this when deleting one. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.