Hello
Just after having added a new MIGX config, MODX MCP stops to get datas from table.
The grid is OK, but empty.
In phpMyAdmin all datas are in place.
I have changed the MODX db settings a few weeks ago but it was working until now.
Any idea ?
If you open the “Network” tab of the developer tools in your browser and then open your CMP. There should be an xhr-request to assets/components/migx/connector.php with the request parameter action = "mgr/migxdb/getList". What is the response of this request?
Also, have you checked the MODx error log for any errors?
I have regenerated the classes now there are 32 row only with IDs (no data)
It seems to target a wrong table…
I didn’t change the XML schama.
In the console, when I load my custom CMP page I have:
Request URL:
https://*****/assets/components/migx/connector.php
action: mgr/migxdb/getList
https://****/?a=index&namespace=migx&configs=blog-plateformes
Response is a JSON
{“success”:true,“total”:32,“results”:[{“id”:“1”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“2”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“3”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“4”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“5”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“6”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“7”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“8”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“9”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“10”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“11”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“12”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“13”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“14”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“15”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“17”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“18”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“19”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“20”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“21”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“22”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“23”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“24”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“25”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“26”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“27”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“28”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“29”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“30”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“31”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“32”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"},{“id”:“33”,“title”:"",“shop_id”:"",“description”:"",“shop_url”:"",“domain”:"",“email_cform”:"",“email_default”:"",“catalogue_tel”:"",“canal”:"",“createdon”:null,“enabled”:“1”,“blog_enabled”:“1”,“catalogue_enabled”:“1”,“bgoverlay”:"",“fournisseurs”:"",“blog_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:"",“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}",“catalogue_enabled_ro”:"{“MIGX_id”:“1”,“name”:“Activ\u00e9”,“use_as_fallback”:"",“value”:“1”,“clickaction”:“switchOption”,“handler”:"",“image”:“assets\/components\/migx\/style\/images\/tick.png”,“idx”:0,"_renderer":“this.renderSwitchStatusOptions”,“selectorconfig”:""}"}]}
Also I have upgrded to latest MODX and MIGX versions
Here is the schema:
<?xml version="1.0" encoding="UTF-8"?>
<model package="ctm_plateformes" baseClass="xPDOObject" platform="mysql" defaultEngine="InnoDB" version="1.1">
<object class="CtmPlateformes" table="ctm_plateformes" extends="xPDOSimpleObject">
<field key="title" dbtype="varchar" precision="100" phptype="string" null="false" default="" />
<field key="shop_id" dbtype="tinytext" phptype="string" null="false" />
<field key="description" dbtype="text" phptype="string" null="false" default="" />
<field key="shop_url" dbtype="varchar" precision="100" phptype="string" null="false" default="" />
<field key="domain" dbtype="tinytext" phptype="string" null="false" />
<field key="email_cform" dbtype="tinytext" phptype="string" null="false" />
<field key="email_default" dbtype="tinytext" phptype="string" null="false" />
<field key="catalogue_tel" dbtype="tinytext" phptype="string" null="false" />
<field key="canal" dbtype="text" phptype="string" null="false" />
<field key="createdon" dbtype="datetime" phptype="datetime" null="true" />
<field key="enabled" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="1" />
<field key="blog_enabled" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="1" />
<field key="catalogue_enabled" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="1" />
<field key="bgoverlay" dbtype="varchar" precision="7" phptype="string" null="false" default="" />
<field key="fournisseurs" dbtype="text" phptype="string" null="false" />
</object>
</model>So what are the settings in your MIGX-config blog-plateformes in the tab “MIGXdb-Settings”?
Package: ctm_plateformes
Classname: CtmPlateformes
Prefix:default
Where are these 32 rows in the grid coming from? Are there 32 rows in your database table modx_ctm_plateformes?
Yes There are 32 rows
I guess MIGX use the MODX database settings isnt’it ?
The database has been migrated a few weeks ago to another server
The DB engine for this table is MyISAM
In the XML it’s InnoDB
but I also tried with MyISAM in the XML without success
The weird thing is that the program can read the rows from the database and the values for the column id are filled but all the other values are empty.
If the data in the database is correct, then there is probably a problem with the file that does the mapping core/components/ctm_plateformes/model/ctm_plateformes/mysql/ctmplateformes.map.inc.php.
I see some fields in your schema with null=“false” but without a default value