[Vtigercrm-developers] webforms Leads Fields not saved

Arnold den Boer arnold at ardebo.nl
Tue Feb 25 09:14:50 GMT 2014


Hi there, 

If your Leads fields are not saved the database probably doesn't contain the
vtiger_webforms_field table.
To create this run the following sql query :

CREATE TABLE `vtiger_webforms_field` (
`id` int(19) NOT NULL AUTO_INCREMENT,
`webformid` int(19) NOT NULL,
`fieldname` varchar(50) NOT NULL,
`neutralizedfield` varchar(50) NOT NULL,
`defaultvalue` varchar(200) DEFAULT NULL,
`required` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `webforms_webforms_field_idx` (`id`),
KEY `fk_1_vtiger_webforms_field` (`webformid`),
KEY `fk_2_vtiger_webforms_field` (`fieldname`),
CONSTRAINT `fk_1_vtiger_webforms_field` FOREIGN KEY (`webformid`) REFERENCES
`vtiger_webforms` (`id`) ON DELETE CASCADE,
CONSTRAINT `fk_3_vtiger_webforms_field` FOREIGN KEY (`fieldname`) REFERENCES
`vtiger_field` (`fieldname`) ON DELETE CASCADE
)



More information about the vtigercrm-developers mailing list