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

Answered Use custom folder and table in MIGXdb

    • 40092
    • 265 Posts
    thapriest86 Reply #11, 13 years, 7 months ago
    Quote from: Bruno17 at Mar 12, 2013, 04:09 AM
    did you run 'parse Schema' again, after doing your changes in the xpdo-schema?

    also, may be I did changes on the update.php and getlist.php - processors, since the latest official release.

    https://github.com/Bruno17/MIGX/tree/master/core/components/migx/processors/mgr/default


    I did, but i notice that when i try to load the schema for the new package, it returns empty, whatever i do.

    Should i replace those two files?
      • 40092
      • 265 Posts
      thapriest86 Reply #12, 13 years, 7 months ago
      Can't seem to find out where this is going wrong. I tried doing the same on a local copy of this site and ended up exactly the same error:

       [2013-03-12 13:50:31] (ERROR @ /abcrevo/assets/components/migx/connector.php) No foreign key definition for parentClass: Images using relation alias: Accomodations
[2013-03-12 13:50:31] (ERROR @ /abcrevo/assets/components/migx/connector.php) Error 42S22 executing statement: 
Array
(
    [0] => 42S22
    [1] => 1054
    [2] => Unknown column 'Images.resource_id' in 'where clause'
)


      As far as i am aware the schema is good, how come it nags about the foreign key?
        • 4172
        • 5,888 Posts
        Bruno17 Reply #13, 13 years, 7 months ago
        did you update the update.php and getlist.php -files? and still this error in the log?

        check for Accomodations / Accomodation

        <aggregate alias="Accomodation" class="Accomodations" local="idAccomodation" foreign="id" cardinality="one" owner="foreign" />


        Join Alias: Accomodation
          -------------------------------

          you can buy me a beer, if you like MIGX

          http://webcmsolutions.de/migx.html

          Thanks!
          • 40092
          • 265 Posts
          thapriest86 Reply #14, 13 years, 7 months ago
          Quote from: Bruno17 at Mar 12, 2013, 07:58 AM
          did you update the update.php and getlist.php -files? and still this error in the log?

          check for Accomodations / Accomodation

          <aggregate alias="Accomodation" class="Accomodations" local="idAccomodation" foreign="id" cardinality="one" owner="foreign">


          Join Alias: Accomodation</aggregate>

          Hmm, updated both the files, but now the CMP's are not working at all. (no data to display)
          Also no errors in the log.

          Join Alias was something i tried with renaming both the schema and backend. (to test the update)
            • 4172
            • 5,888 Posts
            Bruno17 Reply #15, 13 years, 7 months ago
            is it online accessible?
              -------------------------------

              you can buy me a beer, if you like MIGX

              http://webcmsolutions.de/migx.html

              Thanks!
              • 40092
              • 265 Posts
              thapriest86 Reply #16, 13 years, 7 months ago
              I will PM you account details in a minute.

              It is in a lab account.
                • 40092
                • 265 Posts
                thapriest86 Reply #17, 13 years, 7 months ago
                PM sent, let me know if you need more details.
                  • 40092
                  • 265 Posts
                  thapriest86 Reply #18, 13 years, 7 months ago
                  All solved thanks to the amazing help of Bruno. Problem was my package being in the wrong place and a badly copied package.

                  I even got the PDF's working already, Bruno;-)

                  I was wondering, though, the pictures now load as a filename but i would rather have them displayed as the picture itself.
                  I can do that on my thumbnail page when i give it an input TV, but on the photo tab it already has migxd as type and the configuration already has a call to the migx configuration instead of the image renderer.

                  What would be the best approah here, if even possible?
                    • 4172
                    • 5,888 Posts
                    Bruno17 Reply #19, 13 years, 7 months ago
                    you will need to use the renderImage - renderer for this column to render them as images in the grid.
                      -------------------------------

                      you can buy me a beer, if you like MIGX

                      http://webcmsolutions.de/migx.html

                      Thanks!
                      • 40092
                      • 265 Posts
                      thapriest86 Reply #20, 13 years, 7 months ago
                      I tried, but then the column remains empty, and there are no errors in the error log.

                      filename column has Renderer this.renderImage