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 Creating tables with MIGXDB fails...

    • 4172
    • 5,888 Posts
    Bruno17 Reply #11, 12 years, 8 months ago
    what is your db-schema?
      -------------------------------

      you can buy me a beer, if you like MIGX

      http://webcmsolutions.de/migx.html

      Thanks!
      • 38705
      • 101 Posts
      mintnl Reply #12, 12 years, 8 months ago
      DB XML -schema

      <?xml version="1.0" encoding="UTF-8"?>
<model package="jevenementen" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
	<object class="JEvenementen" table="jevenementen" extends="xPDOObject">
		<field key="ev_id" dbtype="smallint" precision="3" phptype="integer" null="false" index="pk"  generated="native" />
		<field key="ev_jaar" dbtype="smallint" precision="4" phptype="integer" null="false" default="0" />
		<field key="ev_start" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="ev_eind" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="ev_sluiting" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="ev_uur" dbtype="tinyint" precision="2" attributes="unsigned" phptype="integer" null="false" default="00" />
		<field key="ev_min" dbtype="tinyint" precision="2" attributes="unsigned" phptype="integer" null="false" default="00" />
		<field key="ev_land" dbtype="char" precision="3" phptype="string" null="false" default="" />
		<field key="ev_naam" dbtype="varchar" precision="50" phptype="string" null="false" default="" />
		<field key="ev_soort" dbtype="varchar" precision="5" phptype="string" null="false" default="0" />
		<field key="ev_jaarbeker" dbtype="enum" precision="'Ja','Nee'" phptype="string" null="false" default="Ja" />
		<field key="ev_info" dbtype="varchar" precision="150" phptype="string" null="false" />
		<field key="ev_meld" dbtype="enum" precision="'Ja','Nee'" phptype="string" null="false" default="Ja" />
		<field key="ev_nameld" dbtype="enum" precision="'Ja','Nee'" phptype="string" null="false" default="Ja" />
		<field key="ev_locatie_x" dbtype="varchar" precision="15" phptype="string" null="false" default="0" />
		<field key="ev_locatie_y" dbtype="varchar" precision="15" phptype="string" null="false" default="0" />
		<field key="ev_windfinder" dbtype="varchar" precision="8" phptype="string" null="false" default="" />
		<field key="ev_route" dbtype="varchar" precision="200" phptype="string" null="false" />
		<field key="ev_website" dbtype="varchar" precision="150" phptype="string" null="false" />
		<field key="ev_kosten" dbtype="double" precision="5,2" phptype="float" null="false" default="0.00" />
		<field key="ev_kosten_nameld" dbtype="double" precision="5,2" phptype="float" null="false" default="0.00" />
		<field key="ev_uitslagen" dbtype="varchar" precision="50" phptype="string" null="false" default="" />
		<field key="ev_races" dbtype="smallint" precision="2" phptype="integer" null="false" default="0" />
		<field key="ev_crossout" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
		<field key="ev_type_ev" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
		<field key="ev_omschr" dbtype="varchar" precision="150" phptype="string" null="false" default="" />
		<field key="ev_adres" dbtype="varchar" precision="50" phptype="string" null="false" default="" />
		<field key="ev_postcode" dbtype="varchar" precision="15" phptype="string" null="false" />
		<field key="ev_plaats" dbtype="varchar" precision="50" phptype="string" null="false" default="" />
		<field key="ev_telnr" dbtype="int" precision="15" phptype="integer" null="false" default="0" />
</object>
</model>
        Addict since 2012....
        • 4172
        • 5,888 Posts
        Bruno17 Reply #13, 12 years, 8 months ago
        I also got a error-message in the error-log with this schema

        This did work:

        <?xml version="1.0" encoding="UTF-8"?>
<model package="jevenementen" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
    <object class="JEvenementen" table="jevenementen" extends="xPDOSimpleObject">
        <field key="ev_id" dbtype="smallint" precision="3" phptype="integer" null="false" index="index" />
        <field key="ev_jaar" dbtype="smallint" precision="4" phptype="integer" null="false" default="0" />
        <field key="ev_start" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
        <field key="ev_eind" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
        <field key="ev_sluiting" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
        <field key="ev_uur" dbtype="tinyint" precision="2" attributes="unsigned" phptype="integer" null="false" default="00" />
        <field key="ev_min" dbtype="tinyint" precision="2" attributes="unsigned" phptype="integer" null="false" default="00" />
        <field key="ev_land" dbtype="char" precision="3" phptype="string" null="false" default="" />
        <field key="ev_naam" dbtype="varchar" precision="50" phptype="string" null="false" default="" />
        <field key="ev_soort" dbtype="varchar" precision="5" phptype="string" null="false" default="0" />
        <field key="ev_jaarbeker" dbtype="enum" precision="'Ja','Nee'" phptype="string" null="false" default="Ja" />
        <field key="ev_info" dbtype="varchar" precision="150" phptype="string" null="false" />
        <field key="ev_meld" dbtype="enum" precision="'Ja','Nee'" phptype="string" null="false" default="Ja" />
        <field key="ev_nameld" dbtype="enum" precision="'Ja','Nee'" phptype="string" null="false" default="Ja" />
        <field key="ev_locatie_x" dbtype="varchar" precision="15" phptype="string" null="false" default="0" />
        <field key="ev_locatie_y" dbtype="varchar" precision="15" phptype="string" null="false" default="0" />
        <field key="ev_windfinder" dbtype="varchar" precision="8" phptype="string" null="false" default="" />
        <field key="ev_route" dbtype="varchar" precision="200" phptype="string" null="false" />
        <field key="ev_website" dbtype="varchar" precision="150" phptype="string" null="false" />
        <field key="ev_kosten" dbtype="double" precision="5,2" phptype="float" null="false" default="0.00" />
        <field key="ev_kosten_nameld" dbtype="double" precision="5,2" phptype="float" null="false" default="0.00" />
        <field key="ev_uitslagen" dbtype="varchar" precision="50" phptype="string" null="false" default="" />
        <field key="ev_races" dbtype="smallint" precision="2" phptype="integer" null="false" default="0" />
        <field key="ev_crossout" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
        <field key="ev_type_ev" dbtype="tinyint" precision="1" phptype="integer" null="false" default="0" />
        <field key="ev_omschr" dbtype="varchar" precision="150" phptype="string" null="false" default="" />
        <field key="ev_adres" dbtype="varchar" precision="50" phptype="string" null="false" default="" />
        <field key="ev_postcode" dbtype="varchar" precision="15" phptype="string" null="false" />
        <field key="ev_plaats" dbtype="varchar" precision="50" phptype="string" null="false" default="" />
        <field key="ev_telnr" dbtype="int" precision="15" phptype="integer" null="false" default="0" />
</object>
</model>
          -------------------------------

          you can buy me a beer, if you like MIGX

          http://webcmsolutions.de/migx.html

          Thanks!
          • 38705
          • 101 Posts
          mintnl Reply #14, 12 years, 8 months ago
          After editing the column ev_id to id everything went smooth....
          (and put id as hidden in columns-tab, else you get "quip.thread_ns_err" on delete and no data on duplicate) 

          <field key="ev_id" dbtype="smallint" precision="3" phptype="integer" null="false" index="index" />


          change to

          <field key="id" dbtype="smallint" precision="3" phptype="integer" null="false" index="index" />
            Addict since 2012....
            • 4172
            • 5,888 Posts
            Bruno17 Reply #15, 12 years, 8 months ago
            you don't need to define an id-field in the schema, when you use xPDOSimpleObject
            xPDOSimpleObject does it all automatically for you.
              -------------------------------

              you can buy me a beer, if you like MIGX

              http://webcmsolutions.de/migx.html

              Thanks!