We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

MIGXdb CMP - creating many to many relationships

    • 48532
    • 23 Posts
    just_nico Reply #21, 12 years ago
    I got to catch up on that topic again after giving it a rest for a while … I tried several adjustments but still end up with the same issue of an empty grid that shows no attributes and some errors in the log.

    Is there a known problem with the import of the configuration settings or is just my installation corrupt? As when I try to set up a test with the above provided information (of Bruno and rebornmedia) and want to import the configurations it ends up not changing anything but creating an Error.
    (ERROR @ /…/core/components/migx/model/migx/migx.class.php : 1911) PHP warning: Invalid argument supplied for foreach()


    If somebody has a little clue I would really appreciate it smiley
      • 38539
      • 18 Posts
      mojorisin Reply #22, 11 years ago
      Excellent thread on the many-to-many relationship MIGXdb setup. Thanks for all the contributors. However I am running into the same issue as described by @just_nico

      (ERROR @ /assets/components/migx/connector.php) No foreign key definition for parentClass: Products using relation alias: "classname":"ProductsAttributes","local":"products","foreign":"attributes"


      Any ideas or workaround?

      Thanks in advance
        • 48532
        • 23 Posts
        just_nico Reply #23, 11 years ago
        @mojorisin, depends on your schema and configs.
        I am not sure if my configs have been correct back then.

        Have you checked this thread? https://forums.modx.com/thread/96409/help-with-simple-many-to-many-nested-migxdb-cmp

        In previous versions of MIGX you had to use custom processors to synchronise the data in the connection-table. Now you can use a hook snippet (aftersave), like @Bruno17 described in the thread linked above.