Cannot edit/create page anymore after upgrading confluence

error:
content_procedure_for_denormalised_permissions does not exist

You can create the 5 missing procedures by executing this:

Note1: It has to be executed by a privileged user (root)

Note2: Replace my_user with your confluence database user

 

DELIMITER ;;
CREATE DEFINER=`my_user`@`%` PROCEDURE `content_permission_procedure_for_denormalised_permissions`(OUT isServiceDisabled BOOL)
BEGIN
SET isServiceDisabled = TRUE;
END ;;

CREATE DEFINER=`my_user`@`%` PROCEDURE `content_perm_set_procedure_for_denormalised_permissions`(OUT isServiceDisabled BOOL)
BEGIN
SET isServiceDisabled = TRUE;
END ;;

CREATE DEFINER=`my_user`@`%` PROCEDURE `content_procedure_for_denormalised_permissions`(OUT isServiceDisabled BOOL)
BEGIN
SET isServiceDisabled = TRUE;
END ;;

CREATE DEFINER=`my_user`@`%` PROCEDURE `space_permission_procedure_for_denormalised_permissions`(OUT isServiceDisabled BOOL)
BEGIN
SET isServiceDisabled = TRUE;
END ;;

CREATE DEFINER=`my_user`@`%` PROCEDURE `space_procedure_for_denormalised_permissions`(OUT isServiceDisabled BOOL)
BEGIN
SET isServiceDisabled = TRUE;
END ;;