-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi!
Thanks for your interest in using VCL. Thanks for pointing this out. A foreign key constraint was added after that page was written, but we never updated the page. I've updated it now so that the value for basedoffrevisionid is now NULL instead of 0. Josh On Wednesday, May 20, 2020 8:00:57 AM EDT M. Sebastián Tobar wrote: > Hello, > > I've just finished installing VCL but I'm unable to configure the provision > of Lab computers. I'm following this How To: > https://cwiki.apache.org/confluence/display/VCL/How+to+Provision+Linux+and+U > nix+Lab+Computers > > On step 6 "Insert an image into the image table for this lab machine" im > getting this error: > ERROR 1452 (23000): Cannot add or update a child row: a foreign key > constraint fails (`vcl`.`image`, CONSTRAINT `image_ibfk_6` FOREIGN KEY > (`basedoffrevisionid`) REFERENCES `imagerevision` (`id`) ON UPDATE CASCADE) > > If I continue with the next table, I get a similar error: > ERROR 1452 (23000): Cannot add or update a child row: a foreign key > constraint fails (`vcl`.`imagerevision`, CONSTRAINT `imagerevision_ibfk_1` > FOREIGN KEY (`imageid`) REFERENCES `image` (`id`)) > > There seems to be a Mysql cross-database foreign key issue. > > Can you help me? > > Best regards > -- > M. Sebastián Tobar - -- - ------------------------------- Josh Thompson VCL Developer North Carolina State University my GPG/PGP key can be found on pool.sks-keyservers.net All electronic mail messages in connection with State business which are sent to or received by this account are subject to the NC Public Records Law and may be disclosed to third parties. -----BEGIN PGP SIGNATURE----- iF0EARECAB0WIQRMIdRtWXideTZDK31X8tBw1209AwUCXsUkQwAKCRBX8tBw1209 A5RvAJ9wwuy7xQu9N3x6v/GTfE/hvL0T0QCdHpioN262IpOtatFzysLxOhB/BO0= =CUgS -----END PGP SIGNATURE-----
