Migx PHP Compatibility

dopeless · May 2, 2024, 4:25pm

Hello, I’m working on a project with migx.
Modx 3.0.5
Migx 3.0.2-b1
PHP 8.1.23

I’m facing multiple problems, and as I’m not developing to oft with MODx lately, don’t know where to start.

For example, drag and drop does not work. I can drag items, connector is initiated and returns 200, but there are no changes in db. All logs (Modx, PHP, Mysql are empty).
Combobox filters does not work. I configure the simplest filter (and I’m pretty sure, that I’m doing everything right), and the dropbox has no recors.
There are other bugs too.
It seems, that Migx is somehow broken. I’ve reinstalled it, reinstalled my CMP - no result.

So my first question - which PHP version is the Migx 3.0.2 compatible the best? I want to eliminat server issues to move on.

My second question - what else could be wrong?

I post my schema too, maybe someone can spot the problem.
Thanxs


<?xml version="1.0" encoding="UTF-8"?>
<model package="MeCatalog\Model\" baseClass="xPDO\Om\xPDOObject" platform="mysql"  defaultEngine="InnoDB" phpdoc-package="" phpdoc-subpackage="" version="3.0">
    <object class="MeCatalogProduct" table="mecatalog_products" extends="xPDO\Om\xPDOSimpleObject" >
        <field key="title_de" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="title_en" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="alias_de" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="alias_en" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="description_de" dbtype="mediumtext" phptype="string"  />
        <field key="description_en" dbtype="mediumtext" phptype="string"  />
        <field key="snippet_text_de" dbtype="text" phptype="string"  />
        <field key="snippet_text_en" dbtype="text" phptype="string"  />
        <field key="intro_de" dbtype="mediumtext" phptype="string"  />
        <field key="intro_en" dbtype="mediumtext" phptype="string"  />
        <field key="specs_text_de" dbtype="mediumtext" phptype="string"  />
        <field key="specs_text_en" dbtype="mediumtext" phptype="string"  />
        <field key="downloads_text_de" dbtype="mediumtext" phptype="string"  />
        <field key="downloads_text_en" dbtype="mediumtext" phptype="string"  />
        <field key="content_de" dbtype="mediumtext" phptype="string"  />
        <field key="content_en" dbtype="mediumtext" phptype="string"  />
        <field key="options_de" dbtype="mediumtext" phptype="string"  />
        <field key="options_en" dbtype="mediumtext" phptype="string"  />
        <field key="snippet_image" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
        <field key="header_image" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
        
        <field key="category" dbtype="int" precision="255" phptype="integer" null="false" default="0" />
        <field key="published" dbtype="int" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />   
        <field key="pos" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" />

        <aggregate alias="Category" class="MeCatalog\Model\MeCatalogProductCategory" local="category" foreign="id" cardinality="one" owner="foreign" />
        <composite alias="Files" class="MeCatalog\Model\MeCatalogFile" local="id" foreign="resource_id" cardinality="many" owner="local" />

        <index alias="title_de" name="title_de" primary="false" unique="false" type="BTREE">
			<column key="title_de" length="" collation="A" null="false" />
		</index>
        <index alias="title_en" name="title_en" primary="false" unique="false" type="BTREE">
			<column key="title_en" length="" collation="A" null="false" />
		</index>
        <index alias="pos" name="pos" primary="false" unique="false" type="BTREE">
            <column key="pos" length="" collation="A" null="false" />
        </index>  
    </object>

    <object class="MeCatalogProductCategory" table="mecatalog_product_categories" extends="xPDO\Om\xPDOSimpleObject" >
        <field key="title_de" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="title_en" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="subtitle_de" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="subtitle_en" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="alias_de" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="alias_en" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="description_de" dbtype="mediumtext" phptype="string" null="false" default="" />
        <field key="description_en" dbtype="mediumtext" phptype="string" null="false" default="" />
        <field key="snippet_text_de" dbtype="text" phptype="string"  />
        <field key="snippet_text_en" dbtype="text" phptype="string"  />
        <field key="intro_de" dbtype="mediumtext" phptype="string" null="false" default="" />
        <field key="intro_en" dbtype="mediumtext" phptype="string" null="false" default="" />
        <field key="content_de" dbtype="mediumtext" phptype="string" null="false" default="" />
        <field key="content_en" dbtype="mediumtext" phptype="string" null="false" default="" />
        <field key="color" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="snippet_image" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>

        <field key="pos" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" />

        <composite alias="Products" class="MeCatalog\Model\MeCatalogProduct" local="id" foreign="category" cardinality="many" owner="local" />

        <index alias="title_de" name="title_de" primary="false" unique="false" type="BTREE">
			<column key="title_de" length="" collation="A" null="false" />
		</index>
        <index alias="title_en" name="title_en" primary="false" unique="false" type="BTREE">
			<column key="title_en" length="" collation="A" null="false" />
		</index>
        <index alias="pos" name="pos" primary="false" unique="false" type="BTREE">
            <column key="pos" length="" collation="A" null="false" />
        </index>  
    </object>

    <object class="MeCatalogFile" table="mecatalog_files" extends="xPDO\Om\xPDOSimpleObject" >
        <field key="title_de" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="title_en" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="alias_de" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="alias_en" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="mediasource_id" dbtype="int" precision="11" phptype="integer" null="false" default="0" />
        <field key="file_de" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
        <field key="file_en" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
        <field key="extended_de" dbtype="text" phptype="json" null="false" default="JSON_OBJECT()" />
        <field key="extended_en" dbtype="text" phptype="json" null="false" default="JSON_OBJECT()" />
        
        <field key="resource_id" dbtype="int" precision="11" phptype="integer" null="false" default="0" />
        <field key="file_category" dbtype="int" precision="255" phptype="integer" null="false" default="0" />
        <field key="published" dbtype="int" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />   
        <field key="pos" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" />

        <aggregate alias="Product" class="MeCatalog\Model\MeCatalogProduct" local="resource_id" foreign="id" cardinality="one" owner="foreign" />
        <aggregate alias="FileCategory" class="MeCatalog\Model\MeCatalogFileCategory" local="file_category" foreign="id" cardinality="one" owner="foreign" />


        <index alias="resource_id" name="resource_id" primary="false" unique="false" type="BTREE">
			<column key="resource_id" length="" collation="A" null="false" />
		</index>
        <index alias="title_de" name="title_de" primary="false" unique="false" type="BTREE">
			<column key="title_de" length="" collation="A" null="false" />
		</index>
        <index alias="title_en" name="title_en" primary="false" unique="false" type="BTREE">
			<column key="title_en" length="" collation="A" null="false" />
		</index>
        <index alias="pos" name="pos" primary="false" unique="false" type="BTREE">
            <column key="pos" length="" collation="A" null="false" />
        </index>  
    </object>

    <object class="MeCatalogFileCategory" table="mecatalog_file_categories" extends="xPDO\Om\xPDOSimpleObject" >
        <field key="title_de" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="title_en" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="alias_de" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="alias_en" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>

        <field key="pos" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" />

        <composite alias="Files" class="MeCatalog\Model\MeCatalogFile" local="id" foreign="file_category" cardinality="many" owner="local" />

        <index alias="title_de" name="title_de" primary="false" unique="false" type="BTREE">
			<column key="title_de" length="" collation="A" null="false" />
		</index>
        <index alias="title_en" name="title_en" primary="false" unique="false" type="BTREE">
			<column key="title_en" length="" collation="A" null="false" />
		</index>
        <index alias="pos" name="pos" primary="false" unique="false" type="BTREE">
            <column key="pos" length="" collation="A" null="false" />
        </index>  
    </object>


    <object class="MeCatalogImageGallery" table="mecatalog_image_gallery" extends="xPDO\Om\xPDOSimpleObject" >
        <field key="title_de" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="title_en" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="description_de" dbtype="text" phptype="string" index="fulltext" />
        <field key="description_en" dbtype="text" phptype="string" index="fulltext" />
        <field key="resource_id" dbtype="int" precision="11" phptype="integer" null="false" default="0" />
        <field key="mediasource_id" dbtype="int" precision="11" phptype="integer" null="false" default="0" />
        <field key="image" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
        <field key="extended" dbtype="text" phptype="json" null="false" default="JSON_OBJECT()" />

        <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        <field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        <field key="pos" dbtype="int" precision="10" phptype="integer" null="false" default="0" />

        <aggregate alias="Product" class="MeCatalog\Model\MeCatalogProduct" local="resource_id" foreign="id" cardinality="one" owner="foreign" />
     
        <index alias="pos" name="pos" primary="false" unique="false" type="BTREE">
            <column key="pos" length="" collation="A" null="false" />
        </index>  
    </object>

    <object class="MeCatalogDealer" table="mecatalog_dealers" extends="xPDO\Om\xPDOSimpleObject" >
        <field key="title" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="description_de" dbtype="text" phptype="string" index="fulltext" />
        <field key="description_en" dbtype="text" phptype="string" index="fulltext" />
        <field key="image" dbtype="varchar" precision="255" phptype="string" null="false" default="" />
        <field key="extended" dbtype="text" phptype="json" null="false" default="JSON_OBJECT()" />

        <field key="country_id" dbtype="int" precision="11" phptype="integer" null="false" default="0" />
        <field key="zip" dbtype="varchar" precision="10" phptype="string" null="false" default=""/>
        <field key="city_de" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="city_en" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="address_de" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="address_en" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="phone" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="email" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="website" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />

        <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
        <field key="pos" dbtype="int" precision="10" phptype="integer" null="false" default="0" />

        <aggregate alias="Country" class="MeCatalog\Model\MeCatalogCountry" local="country_id" foreign="id" cardinality="one" owner="foreign" />
     
        <index alias="pos" name="pos" primary="false" unique="false" type="BTREE">
            <column key="pos" length="" collation="A" null="false" />
        </index>  
    </object>

    <object class="MeCatalogCountry" table="mecatalog_countries" extends="xPDO\Om\xPDOSimpleObject" >
        <field key="title_de" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="title_en" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />

        <composite alias="Dealer" class="MeCatalog\Model\MeCatalogDealer" local="id" foreign="country_id" cardinality="many" owner="local" />
    </object>

    <object class="MeCatalogVeneer" table="mecatalog_veneers" extends="xPDO\Om\xPDOSimpleObject" >
        <field key="title_de" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="title_en" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="description_de" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="description_en" dbtype="varchar" precision="255" phptype="string" null="false" default="" index="index" />
        <field key="image" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
        <field key="pos" dbtype="int" precision="10" attributes="unsigned" phptype="integer" null="false" default="0" />
        <field key="published" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
    </object>
</model>

halftrainedharry · May 2, 2024, 4:47pm

It’s probably not a PHP issue.
MIGXdb on MODX 3 is still relatively untested.

Can you provide the MIGX config you use for the CMP? (Right-click → “Export/Import”)

dopeless · May 2, 2024, 5:46pm

This is a config where combobox filters do not work (the first one is with a join, and a second one is “internal” for testing - both do not work).

{
  "formtabs":[
    {
      "MIGX_id":19,
      "caption":"DE",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":73,
          "field":"title_de",
          "caption":"Title",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":74,
          "field":"alias_de",
          "caption":"Alias",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":2
        },
        {
          "MIGX_id":93,
          "field":"description_de",
          "caption":"Description",
          "description":"SEO",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":3
        },
        {
          "MIGX_id":123,
          "field":"snippet_text_de",
          "caption":"Snippet Text",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":4
        },
        {
          "MIGX_id":107,
          "field":"intro_de",
          "caption":"Intro",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"textarea",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":5
        },
        {
          "MIGX_id":94,
          "field":"content_de",
          "caption":"Content",
          "description":"",
          "description_is_code":"0",
          "inputTV":"mcSections",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":6
        },
        {
          "MIGX_id":95,
          "field":"options_de",
          "caption":"Technical Data",
          "description":"",
          "description_is_code":"0",
          "inputTV":"prodTechicalData",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":7
        },
        {
          "MIGX_id":149,
          "field":"specs_text_de",
          "caption":"Technical Data Text",
          "description":"If Empty - text from parent resource will be used",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"richtext",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":8
        },
        {
          "MIGX_id":150,
          "field":"downloads_text_de",
          "caption":"Downloads Text",
          "description":"If Empty - text from parent resource will be used",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"richtext",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":9
        }
      ],
      "pos":1
    },
    {
      "MIGX_id":29,
      "caption":"EN",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":97,
          "field":"title_en",
          "caption":"Title",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":98,
          "field":"alias_en",
          "caption":"Alias",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":2
        },
        {
          "MIGX_id":99,
          "field":"description_en",
          "caption":"Description",
          "description":"SEO",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":3
        },
        {
          "MIGX_id":124,
          "field":"snippet_text_en",
          "caption":"Snippet Text",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":4
        },
        {
          "MIGX_id":108,
          "field":"intro_en",
          "caption":"Intro",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"textarea",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":5
        },
        {
          "MIGX_id":100,
          "field":"content_en",
          "caption":"Content",
          "description":"",
          "description_is_code":"0",
          "inputTV":"mcSections",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":6
        },
        {
          "MIGX_id":101,
          "field":"options_en",
          "caption":"Technical Data",
          "description":"",
          "description_is_code":"0",
          "inputTV":"prodTechicalData",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":7
        },
        {
          "MIGX_id":151,
          "field":"specs_text_en",
          "caption":"Technical Data Text",
          "description":"If Empty - text from parent resource will be used",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"richtext",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":8
        },
        {
          "MIGX_id":152,
          "field":"downloads_text_en",
          "caption":"Downloads Text",
          "description":"If Empty - text from parent resource will be used",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"richtext",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":9
        }
      ],
      "pos":2
    },
    {
      "MIGX_id":20,
      "caption":"Options",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":76,
          "field":"category",
          "caption":"category",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"listbox",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"@CHUNK: migxFieldListCategories",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":96,
          "field":"published",
          "caption":"Published",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"checkbox",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"Yes==1",
          "default":"0",
          "useDefaultIfEmpty":"0",
          "pos":2
        }
      ],
      "pos":3
    },
    {
      "MIGX_id":23,
      "caption":"Downloads",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":81,
          "field":"files",
          "caption":"Downloads",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"migxdb",
          "validation":"",
          "configs":"files",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        }
      ],
      "pos":4
    },
    {
      "MIGX_id":31,
      "caption":"Media",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":104,
          "field":"gallery",
          "caption":"Gallery",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"migxdb",
          "validation":"",
          "configs":"megallery",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":106,
          "field":"snippet_image",
          "caption":"Snippet Image",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"image",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":[
            {
              "MIGX_id":1,
              "context":"mgr",
              "sourceid":3
            },
            {
              "MIGX_id":2,
              "context":"web",
              "sourceid":3
            },
            {
              "MIGX_id":3,
              "context":"en",
              "sourceid":3
            }
          ],
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":2
        },
        {
          "MIGX_id":109,
          "field":"header_image",
          "caption":"Header Image",
          "description":"Is displayed on the top of the product page",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"image",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":[
            {
              "MIGX_id":1,
              "context":"mgr",
              "sourceid":3
            },
            {
              "MIGX_id":2,
              "context":"web",
              "sourceid":3
            },
            {
              "MIGX_id":3,
              "context":"en",
              "sourceid":3
            }
          ],
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":3
        }
      ],
      "pos":5
    }
  ],
  "contextmenus":"update||duplicate||publish||unpublish||remove",
  "actionbuttons":"addItem",
  "columnbuttons":"update||duplicate||publish||unpublish||remove",
  "filters":[
    {
      "MIGX_id":1,
      "name":"search",
      "label":"Search",
      "emptytext":"Search...",
      "type":"textbox",
      "getlistwhere":{
        "title_de:LIKE":"%[[+search]]%",
        "OR:title_en:LIKE":"%[[+search]]%"
      },
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":"_empty"
    },
    {
      "MIGX_id":2,
      "name":"categoryfilter",
      "label":"Category",
      "emptytext":"-- All Categories --",
      "type":"combobox",
      "getlistwhere":{
        "category":"[[+categoryfilter]]"
      },
      "getcomboprocessor":"getcombo",
      "combotextfield":"Category.title_de",
      "comboidfield":"Category.id",
      "combowhere":{
        "category:!=":"0"
      },
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":[
        {
          "alias":"Category",
          "selectfields":"title_de"
        }
      ],
      "comboparent":"",
      "default":"all"
    },
    {
      "MIGX_id":4,
      "name":"reg_category",
      "label":"category",
      "emptytext":"--filter by category--",
      "type":"combobox",
      "getlistwhere":{
        "category":"[[+reg_category]]"
      },
      "getcomboprocessor":"getcombo",
      "combotextfield":"category",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":""
    },
    {
      "MIGX_id":3,
      "name":"resetProductFilters",
      "label":"Reset Filters",
      "emptytext":"",
      "type":"resetall",
      "getlistwhere":"",
      "getcomboprocessor":"",
      "combotextfield":"",
      "comboidfield":"",
      "combowhere":"",
      "comboclassname":"",
      "combopackagename":"",
      "combo_use_custom_prefix":"0",
      "comboprefix":"",
      "combojoins":"",
      "comboparent":"",
      "default":""
    }
  ],
  "extended":{
    "migx_add":"",
    "disable_add_item":"",
    "add_items_directly":"",
    "formcaption":"",
    "update_win_title":"",
    "win_id":"products",
    "maxRecords":"",
    "addNewItemAt":"bottom",
    "media_source_id":6,
    "multiple_formtabs":"",
    "multiple_formtabs_label":"",
    "multiple_formtabs_field":"",
    "multiple_formtabs_optionstext":"",
    "multiple_formtabs_optionsvalue":"",
    "actionbuttonsperrow":4,
    "winbuttonslist":"",
    "extrahandlers":"",
    "filtersperrow":4,
    "packageName":"",
    "classname":"MeCatalog\\Model\\MeCatalogProduct",
    "task":"",
    "getlistsort":"",
    "getlistsortdir":"",
    "sortconfig":"",
    "gridpagesize":"",
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"",
    "gridload_mode":1,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"",
    "has_jointable":"yes",
    "getlistwhere":"",
    "joins":[
      {
        "alias":"Category"
      }
    ],
    "hooksnippets":{
      "aftersave":"migxItemAftersave"
    },
    "cmpmaincaption":"Manage Products",
    "cmptabcaption":"Products",
    "cmptabdescription":"Edit Products",
    "cmptabcontroller":"",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "permissions":{
    "apiaccess":"",
    "view":"",
    "list":"",
    "save":"",
    "create":"",
    "remove":"",
    "delete":"",
    "publish":"",
    "unpublish":"",
    "viewdeleted":"",
    "viewunpublished":""
  },
  "fieldpermissions":"",
  "columns":[
    {
      "MIGX_id":2,
      "header":"id",
      "dataIndex":"id",
      "width":"",
      "sortable":true,
      "show_in_grid":"0",
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":6,
      "header":"pos",
      "dataIndex":"pos",
      "width":"",
      "sortable":true,
      "show_in_grid":"0",
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":9,
      "header":"Image",
      "dataIndex":"snippet_image",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderImage",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":3,
      "header":"Title",
      "dataIndex":"title_de",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":5,
      "header":"Category",
      "dataIndex":"Category_title_de",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":7,
      "header":"Ppublished",
      "dataIndex":"published",
      "width":"",
      "sortable":true,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderCrossTick",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    }
  ],
  "category":""
}

And this is the one, where drag and drop does not work.

Thank you.


{
  "formtabs":[
    {
      "MIGX_id":8,
      "caption":"DE",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":30,
          "field":"title_de",
          "caption":"Title",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":31,
          "field":"description_de",
          "caption":"Description",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":2
        }
      ],
      "pos":1
    },
    {
      "MIGX_id":30,
      "caption":"EN",
      "print_before_tabs":"0",
      "fields":[
        {
          "MIGX_id":102,
          "field":"title_en",
          "caption":"Title",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":1
        },
        {
          "MIGX_id":103,
          "field":"description_en",
          "caption":"Description",
          "description":"",
          "description_is_code":"0",
          "inputTV":"",
          "inputTVtype":"",
          "validation":"",
          "configs":"",
          "restrictive_condition":"",
          "display":"",
          "sourceFrom":"config",
          "sources":"",
          "inputOptionValues":"",
          "default":"",
          "useDefaultIfEmpty":"0",
          "pos":2
        }
      ],
      "pos":2
    }
  ],
  "contextmenus":"update||publish||unpublish||recall_remove_delete",
  "actionbuttons":"bulk||emptyTrash||uploadfiles_db",
  "columnbuttons":"",
  "filters":"",
  "extended":{
    "migx_add":"",
    "disable_add_item":"",
    "add_items_directly":"",
    "formcaption":"",
    "update_win_title":"",
    "win_id":"megallery",
    "maxRecords":"",
    "addNewItemAt":"top",
    "media_source_id":4,
    "multiple_formtabs":"",
    "multiple_formtabs_label":"",
    "multiple_formtabs_field":"",
    "multiple_formtabs_optionstext":"",
    "multiple_formtabs_optionsvalue":"",
    "actionbuttonsperrow":3,
    "winbuttonslist":"",
    "extrahandlers":"",
    "filtersperrow":1,
    "packageName":"",
    "classname":"MeCatalog\\Model\\MeCatalogImageGallery",
    "task":"",
    "getlistsort":"",
    "getlistsortdir":"",
    "sortconfig":[
      {
        "sortby":"`pos`",
        "sortdir":"ASC"
      },
      {
        "sortby":"`id`",
        "sortdir":"ASC"
      }
    ],
    "gridpagesize":"",
    "use_custom_prefix":"0",
    "prefix":"",
    "grid":"dragdrop",
    "gridload_mode":2,
    "check_resid":1,
    "check_resid_TV":"",
    "join_alias":"Product",
    "has_jointable":"no",
    "getlistwhere":"",
    "joins":"",
    "hooksnippets":"",
    "cmpmaincaption":"",
    "cmptabcaption":"",
    "cmptabdescription":"",
    "cmptabcontroller":"",
    "winbuttons":"",
    "onsubmitsuccess":"",
    "submitparams":""
  },
  "permissions":{
    "apiaccess":"",
    "view":"",
    "list":"",
    "save":"",
    "create":"",
    "remove":"",
    "delete":"",
    "publish":"",
    "unpublish":"",
    "viewdeleted":"",
    "viewunpublished":""
  },
  "fieldpermissions":"",
  "columns":[
    {
      "MIGX_id":1,
      "header":"ID",
      "dataIndex":"id",
      "width":"",
      "sortable":"false",
      "show_in_grid":"0",
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":3,
      "header":"Image",
      "dataIndex":"image",
      "width":30,
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderChunk",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"<img src=\"\/connectors\/system\/phpthumb.php?h=80&amp;src=[[!addmediasourcepath? &image=`[[+image]]` &mediasourceid=`[[+mediasource_id]]`]]\" alt=\"\">",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":2,
      "header":"Title",
      "dataIndex":"title_de",
      "width":40,
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":"this.textEditor"
    },
    {
      "MIGX_id":4,
      "header":"Published",
      "dataIndex":"published",
      "width":15,
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderClickCrossTick",
      "clickaction":"switchOption",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":6,
      "header":"Deleted",
      "dataIndex":"deleted",
      "width":15,
      "sortable":"false",
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"this.renderClickCrossTick",
      "clickaction":"switchOption",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    },
    {
      "MIGX_id":5,
      "header":"Position",
      "dataIndex":"pos",
      "width":"",
      "sortable":1,
      "show_in_grid":1,
      "customrenderer":"",
      "renderer":"",
      "clickaction":"",
      "selectorconfig":"",
      "renderchunktpl":"",
      "renderoptions":"",
      "editor":""
    }
  ],
  "category":""
}

dopeless · May 2, 2024, 6:47pm

I think, I’ve found the problem wtith drag and drop - it des not pass the resource_id, and the object_id is actually the entry id itself

This is a corresponding entry in DB

halftrainedharry · May 2, 2024, 8:00pm

To fix the drag&drop issue, change this line in the code

github.com

Bruno17/MIGX/blob/d799e082e62c99418665a04772be0ebccdfeab07/core/components/migx/model/migx/migx.class.php#L2758


      
                  $joinclass = $fkMeta['class'];
                  $joinfield = $fkMeta[$fkMeta['owner']];
              } else {
                  $joinalias = '';
              }
          }
          
          //$parent = $workingobject->get('parent');
          $c = $xpdo->newQuery($classname);
          //$c->where(array('deleted'=>0 , 'parent'=>$parent));
          $c->select($xpdo->getSelectColumns($classname, $classname));
          
          if (!empty($joinalias)) {
              /*
              if ($joinFkMeta = $modx->getFKDefinition($joinclass, 'Resource')){
              $localkey = $joinFkMeta['local'];
              }    
              */
              $c->leftjoin($joinclass, $joinalias);
              $c->select($xpdo->getSelectColumns($joinclass, $joinalias, 'Joined_'));
          }

to this:

$c->select($xpdo->getSelectColumns($classname, $c->getAlias()));

To fix the issue with the combobox filter, apply the changes from this pull request:

dopeless · May 2, 2024, 8:14pm

How dumb is that, that the second fix with filters is based on my own topic. And what even dumber, is that it’s the same project. I’ve totally forgotten, that I’ve asked the same question and you’ve helped me with a fix

But I’ve remembered, that filters worked
I’ve tried to fix drag and drop today, reinstalled migx, and overwritten the fix

The drag and drop fix works too. Thank you so much. You are beautiful.