#1 Database schema creation fails (foreign key constraint)

[Éric Gillet]

With a clean database and all privileges given to the vcmdb user, the database.sql import fails with error :

"ERROR 1452 (23000) at line 259: Cannot add or update a child row: a foreign key constraint fails (vcmdb.vcmdb-permissions, CONSTRAINT vcmdb-permissions_ibfk_1 FOREIGN KEY (id_vcmdb-action) REFERENCES vcmdb-action (id))"

[Vincent PAGES]

Problem has been solved!

--- database.sql (révision 27)
+++ database.sql (copie de travail)
@@ -256,4 +256,4 @@
INSERT INTO vcmdb-menu-url (name,id_vcmdb-menu,url) VALUES ('Personnaliser la base de données','1','./object.php');
INSERT INTO vcmdb-menu-url (name,id_vcmdb-menu,url) VALUES ('Langues','1','./list.php?object=vcmdb-language');
INSERT INTO vcmdb-menu-url (name,id_vcmdb-menu,url) VALUES ('Documentation','1','http://www.vcmdb.fr');
-INSERT INTO vcmdb-permissions (name,id_vcmdb-action,login,objet) VALUES ('admin','4','admin','');
+INSERT INTO vcmdb-permissions (name,id_vcmdb-action,login,objet) VALUES ('admin','25','admin','');

[Éric Gillet]

Thanks, I'm going to test after holidays. Bonnes fêtes !