MODX Community

MIGXdb not creating db table

Hi,
Just having issues using MIGXdb. It doesn’t appear to be creating the db tables.
Modx 2.7.2 | Migx 2.12.0
My schema is:

< model package="therapists" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
< object class="Therapist" table="therapists" extends="xPDOSimpleObject">
< field key="name" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
< field key="website" dbtype="varchar" precision="255" phptype="string" null="false" default=""/>
< field key="email" dbtype="varchar" precision="100" phptype="string" null="false" default=""/>
< field key="phone" dbtype="varchar" precision="100" phptype="string" null="false" default=""/>
< field key="details" dbtype="varchar" precision="800" phptype="string" null="false" default=""/>
< field key="deleted" dbtype="int" precision="1" attributes="unsigned" phptype="integer" null="false" default="0"/>
< field key="published" dbtype="int" precision="1" attributes="unsigned" phptype="integer" null="false" default="0"/>
< /object>
< /model>

Please note that the spaces after the < in the above are not like this in the actual schema code.

Errors:

[2020-01-31 08:26:51] (ERROR in modProcessor::run @ /www/core/model/modx/modprocessor.class.php : 177) Flat file processor support, used for action mgr/migxdb/getList with path /www/core/components/migx/processors/mgr/migxdb/getlist.php, is deprecated since version 2.7.0.
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 503) Path specified for package therapists is not a valid or accessible directory: /www/core/components/therapists/model/
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Therapist from mysql.therapist.
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 1617) Could not load class Therapist
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Therapist from mysql.therapist.
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Therapist from mysql.therapist.
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 762) Therapist::getSelectColumns() is not a valid static method.
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Therapist from mysql.therapist.
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Therapist from mysql.therapist.
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 1617) Could not load class Therapist
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Therapist from mysql.therapist.
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 762) Therapist::loadCollection() is not a valid static method.
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.
[2020-01-31 08:26:51] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.
[2020-01-31 08:26:52] (ERROR @ /www/core/xpdo/xpdo.class.php : 503) Path specified for package therapists is not a valid or accessible directory: /www/core/components/therapists/model/
[2020-01-31 08:26:52] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Therapist from mysql.therapist.
[2020-01-31 08:27:18] (ERROR in modProcessor::run @ /www/core/model/modx/modprocessor.class.php : 177) Flat file processor support, used for action mgr/migxdb/update with path /www/core/components/migx/processors/mgr/migxdb/update.php, is deprecated since version 2.7.0.
[2020-01-31 08:27:18] (ERROR @ /www/core/xpdo/xpdo.class.php : 503) Path specified for package therapists is not a valid or accessible directory: /www/core/components/therapists/model/
[2020-01-31 08:27:18] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Therapist from mysql.therapist.
[2020-01-31 08:27:27] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.
[2020-01-31 08:27:27] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.
[2020-01-31 08:27:27] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.
[2020-01-31 08:29:20] (ERROR in modProcessor::run @ /www/core/model/modx/modprocessor.class.php : 177) Flat file processor support, used for action mgr/migxdb/getList with path /www/core/components/migx/processors/mgr/migxdb/getlist.php, is deprecated since version 2.7.0.
[2020-01-31 08:29:21] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.
[2020-01-31 08:29:21] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.
[2020-01-31 08:29:21] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.
[2020-01-31 08:29:37] (ERROR in xPDO::getService @ /www/core/xpdo/xpdo.class.php : 1234) modRestClient::__construct is deprecated since version 2.3.0. Use the modRest classes instead.
[2020-01-31 08:29:37] (ERROR in modRestCurlClient::__construct @ /www/core/model/modx/rest/modrestcurlclient.class.php : 26) modRestClient::__construct is deprecated since version 2.3.0. Use the modRest classes instead.
[2020-01-31 08:29:37] (ERROR in xPDO::getService @ /www/core/xpdo/xpdo.class.php : 1234) modRestClient::__construct is deprecated since version 2.3.0. Use the modRest classes instead.
[2020-01-31 08:29:37] (ERROR in modRestCurlClient::__construct @ /www/core/model/modx/rest/modrestcurlclient.class.php : 26) modRestClient::__construct is deprecated since version 2.3.0. Use the modRest classes instead.
[2020-01-31 08:29:37] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.
[2020-01-31 08:29:37] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.
[2020-01-31 08:29:37] (ERROR @ /www/core/xpdo/xpdo.class.php : 644) Could not load class: Location from mysql.location.

Everything looks good in the Manager except adding a new item in the CMP table does not save. Clicking the save button does nothing at all.
Thanks for any help

Did you create the package first? does the dorectory exist? I think yes beacause else you could not have saved the schema…
because of this error, that states that the folder is not there or not accessible.

Yep the folders appear to have been created.
I’m thinking I might start afresh and see what happens.