I am using Chrono Forms V3.2.0. I have created a form to register new members. I am using another Joomla component to handle memberships so the database exists. It is created as follows:
CREATE TABLE IF NOT EXISTS `kc_nokcm_persons` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`salutation` varchar(25) DEFAULT NULL,
`firstname` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
`middlename` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
`birthday` date DEFAULT NULL,
`address` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`city` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`zip` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`country` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`state` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`telephone` varchar(25) DEFAULT NULL,
`mobile` varchar(25) DEFAULT NULL,
`url` varchar(250) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`description` text,
`image` varchar(250) DEFAULT NULL,
`createdby` varchar(50) DEFAULT NULL,
`createddate` datetime DEFAULT NULL,
`modifiedby` varchar(50) DEFAULT NULL,
`modifieddate` datetime DEFAULT NULL,
`custom1` varchar(255) DEFAULT NULL,
`custom2` varchar(255) DEFAULT NULL,
`custom3` varchar(255) DEFAULT NULL,
`custom4` varchar(255) DEFAULT NULL,
`custom5` varchar(255) DEFAULT NULL,
`birthname` varchar(50) DEFAULT NULL,
`deceased` date DEFAULT NULL,
`hh_person_id` int(11) unsigned DEFAULT NULL,
`hh_salutation_override` varchar(50) DEFAULT NULL,
`hh_name_override` varchar(255) DEFAULT NULL,
`_import_id` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
I have attached a backup of the form. The debug is showing no errors but the data doesn't get loaded.
CREATE TABLE IF NOT EXISTS `kc_nokcm_persons` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`salutation` varchar(25) DEFAULT NULL,
`firstname` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
`middlename` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`nickname` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
`birthday` date DEFAULT NULL,
`address` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`city` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`zip` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`country` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`state` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`telephone` varchar(25) DEFAULT NULL,
`mobile` varchar(25) DEFAULT NULL,
`url` varchar(250) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`description` text,
`image` varchar(250) DEFAULT NULL,
`createdby` varchar(50) DEFAULT NULL,
`createddate` datetime DEFAULT NULL,
`modifiedby` varchar(50) DEFAULT NULL,
`modifieddate` datetime DEFAULT NULL,
`custom1` varchar(255) DEFAULT NULL,
`custom2` varchar(255) DEFAULT NULL,
`custom3` varchar(255) DEFAULT NULL,
`custom4` varchar(255) DEFAULT NULL,
`custom5` varchar(255) DEFAULT NULL,
`birthname` varchar(50) DEFAULT NULL,
`deceased` date DEFAULT NULL,
`hh_person_id` int(11) unsigned DEFAULT NULL,
`hh_salutation_override` varchar(50) DEFAULT NULL,
`hh_name_override` varchar(255) DEFAULT NULL,
`_import_id` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
I have attached a backup of the form. The debug is showing no errors but the data doesn't get loaded.