We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
  • Greetings,

    Creating a map and got the following on an enum field.. I suspect this is a bug, but I’m not even sure how this should have come out.
    <field key="marital_status" dbtype="enum" precision="'" attributes="married','married','divorced','widowed','common-law')" phptype="string" null="true" default="never married" />
    


    * precision simply contains an apostrophe
    * attributes should start with ’never married’
    * attributes ends with a closing parenthesis

    I can fix this up manually, but I’m not sure what the precision attribute is really supposed to be, or if the attributes should have parentheses around them.

      Mike Schell
      Lead Developer, MODX Cloud
      Email: [email protected]
      GitHub: https://github.com/netProphET/
      Twitter: @mkschell
    • Hello netProphET:

      Can you generate a create table statement for the actual table this was generated from and post it? Or just a SHOW COLUMNS FROM...

      Precision should not appear at all, and no, attributes should not be surrounded by parenthesis...
      Actually, I was wrong, the attributes should not appear at all and precision should contain all of the enum options, just to clarify.
      • Hi OpenGeek,

        After looking a little closer, it seems to only happen when one of the enum values has a space in it.
        Here’s the table:

        CREATE TABLE `resume_form` (
          `id` mediumint(8) unsigned NOT NULL auto_increment,
          `file_number` varchar(64) NOT NULL default '',
          `last_name` varchar(64) NOT NULL default '',
          `middle_name` varchar(64) NOT NULL default '',
          `first_name` varchar(64) NOT NULL default '',
          `date_of_birth` date NOT NULL default '0000-00-00',
          `place_of_birth` varchar(64) NOT NULL default '',
          `citizenship` varchar(64) NOT NULL default '',
          `street` varchar(128) NOT NULL default '',
          `city` varchar(64) NOT NULL default '',
          `province` varchar(64) NOT NULL default '',
          `postal_code` varchar(32) NOT NULL default '',
          `country_of_residence` varchar(64) NOT NULL default '',
          `status_in_country` varchar(64) NOT NULL default '',
          `email` varchar(128) NOT NULL default '',
          `phone` varchar(64) NOT NULL default '',
          `mobile` varchar(64) NOT NULL default '',
          `marital_status` enum('never married','married','divorced','widowed','common-law') NOT NULL default 'never married',
          `children` enum('yes','no') NOT NULL default 'yes',
          `num_children` varchar(32) NOT NULL default '',
          `relatives_in_canada` enum('yes','no') NOT NULL default 'yes',
          `occupation` varchar(64) NOT NULL default '',
          `education` varchar(255) NOT NULL default '',
          `other_education` varchar(128) NOT NULL default '',
          `describe_program` text NOT NULL,
          `years_experience` enum('none','1 year','2 years','3 years','4 years','5 years and more') NOT NULL default 'none',
          `current_employer_name` varchar(64) NOT NULL default '',
          `current_employer_city` varchar(64) NOT NULL default '',
          `current_employer_country` varchar(64) NOT NULL default '',
          `current_employer_from` varchar(32) NOT NULL default '',
          `current_employer_to` varchar(32) NOT NULL default '',
          `current_employer_position` varchar(64) NOT NULL default '',
          `current_employer_job_description` text NOT NULL,
          `previous_employer1_name` varchar(64) NOT NULL default '',
          `previous_employer1_city` varchar(64) NOT NULL default '',
          `previous_employer1_country` varchar(64) NOT NULL default '',
          `previous_employer1_from` varchar(32) NOT NULL default '',
          `previous_employer1_to` varchar(32) NOT NULL default '',
          `previous_employer1_poition` varchar(64) NOT NULL default '',
          `previous_employer1_job_description` text NOT NULL,
          `previous_employer2_name` varchar(64) NOT NULL default '',
          `previous_employer2_city` varchar(64) NOT NULL default '',
          `previous_employer2_country` varchar(64) NOT NULL default '',
          `previous_employer2_from` varchar(32) NOT NULL default '',
          `previous_employer2_to` varchar(32) NOT NULL default '',
          `previous_employer2_position` varchar(64) NOT NULL default '',
          `previous_employer2_job_description` text NOT NULL,
          `previous_employer3_name` varchar(64) NOT NULL default '',
          `previous_employer3_city` varchar(64) NOT NULL default '',
          `previous_employer3_country` varchar(64) NOT NULL default '',
          `previous_employer3_from` varchar(32) NOT NULL default '',
          `previous_employer3_to` varchar(32) NOT NULL default '',
          `previous_employer3_position` varchar(64) NOT NULL default '',
          `previous_employer3_job_description` text NOT NULL,
          `english` enum('none','little','intermediate','good','fluent') NOT NULL default 'none',
          `french` enum('none','little','intermediate','good','fluent') NOT NULL default 'none',
          `resume` varchar(128) NOT NULL default '',
          `picture` varchar(128) NOT NULL default '',
          `approved_public` tinyint(1) unsigned NOT NULL default '0',
          PRIMARY KEY  (`id`)
        ) TYPE=MyISAM;
        

          Mike Schell
          Lead Developer, MODX Cloud
          Email: [email protected]
          GitHub: https://github.com/netProphET/
          Twitter: @mkschell
        • Great; thanks for the information. I see the problem in the code which parses the column data.