Details
-
Type:
Bug
-
Status: Open
-
Priority:
Minor
-
Resolution: Unresolved
-
Affects Version/s: CDH3u0
-
Fix Version/s: None
-
Component/s: Docs
-
Labels:None
Description
On https://ccp.cloudera.com/display/CDH3U0DOCS/Hue+Installation in the last step for mysql + hue
– Current
mysql -uhue -psecretpassword -e "DELETE FROM hue.django_content_type;"
– ERROR IS:
ERROR 1451 (23000) at line 1: Cannot delete or update a parent row: a foreign key constraint fails (`hue/auth_permission`, CONSTRAINT `content_type_id_refs_id_728de91f` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`))
– Should Be
mysql -uhue -psecretpassword -e "SET foreign_key_checks = 0;DELETE FROM hue.django_content_type; SET foreign_key_checks = 1;"