There’s a very common bug circulating around for a while in VTiger 7 Webforms. The bug doesn’t allow to save configuration of Webforms after setting them up. Using HTML option doesn’t work either.

I was asked for a solution to this problem too many times that I preferred to put the solution into writing.

Issue:

Webforms do not seem to be working in 7.0. When trying to set up a new webform, it does not save the preference of fields. Moreover, using the form HTML, nothing is displayed.

Solution:

If you run into that problem, you need to update following tables in your database. In case the tables are not there, create them:

• Table: vtiger_webforms

CREATE TABLE IF NOT EXISTS `vtiger_webforms` (<br />
`id` int(19) NOT NULL AUTO_INCREMENT,<br />
`name` varchar(100) NOT NULL,<br />
`publicid` varchar(100) NOT NULL,<br />
`enabled` int(1) NOT NULL DEFAULT '1',<br />
`targetmodule` varchar(50) NOT NULL,<br />
`description` text,<br />
`ownerid` int(19) NOT NULL,<br />
`returnurl` varchar(250) DEFAULT NULL,<br />
`captcha` int(1) NOT NULL DEFAULT '0',<br />
`roundrobin` int(1) NOT NULL DEFAULT '0',<br />
`roundrobin_userid` varchar(256) DEFAULT NULL,<br />
`roundrobin_logic` int(11) NOT NULL DEFAULT '0'<br />
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

• Table: vtiger_webforms_field

CREATE TABLE IF NOT EXISTS `vtiger_webforms_field` (<br />
`id` int(19) NOT NULL,<br />
`webformid` int(19) NOT NULL AUTO_INCREMENT,<br />
`fieldname` varchar(50) COLLATE latin1_german1_ci NOT NULL,<br />
`neutralizedfield` varchar(50) COLLATE latin1_german1_ci NOT NULL,<br />
`defaultvalue` text COLLATE latin1_german1_ci,<br />
`required` int(10) NOT NULL DEFAULT '0',<br />
`sequence` int(11) NOT NULL DEFAULT '0',<br />
`hidden` varchar(100) COLLATE latin1_german1_ci DEFAULT NULL<br />
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;

For further help, please send an email to help@vtexperts.com. We’ll be glad to be of service.