Database update from 3.3.10 to 3.4.0 fails

[steinm]

I found a solution. The procedure for droping the foreign key in the update-3.4.0/update.sql script didn't work.

It must be replaced by

Code:

DROP PROCEDURE IF EXISTS DROPFK;
DELIMITER $$
CREATE PROCEDURE DROPFK (
IN parm_table_name VARCHAR(100),
IN parm_key_name VARCHAR(100)
)
BEGIN
  SET @table_name = parm_table_name;
  SET @key_name = parm_key_name;
  SET @sql_text = concat('ALTER TABLE ',@table_name,' DROP FOREIGN KEY ',@key_name);
  IF EXISTS (SELECT NULL FROM information_schema.TABLE_CONSTRAINTS
    WHERE CONSTRAINT_SCHEMA = DATABASE() AND CONSTRAINT_NAME = parm_key_name) THEN
    PREPARE stmt FROM @sql_text;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
  END IF;
END $$
DELIMITER ;

Uwe