vTiger 6.1 Webfrom Fix

on Friday, 07 November 2014. Posted in Web Expertise

STEP 1

Create this Table in MySQL:

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', `captcha` int(1) NOT NULL DEFAULT '0', `roundrobin` int(1) NOT NULL DEFAULT '0', `roundrobin_userid` varchar(256) DEFAULT NULL, `roundrobin_logic` int(11) 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 )

STEP 2

Then run this query

ALTER TABLE `vtiger_webforms_field` ADD `sequence` INT NULL DEFAULT NULL AFTER `required` , ADD `hidden` INT NULL DEFAULT NULL AFTER `sequence`

STEP 3

Now replace this file

/layouts/vlayout/modules/Settings/Webforms/ FieldsEditView.tpl (Download from below Link)

  

DONE!!!

Comments (4)

  • aruny

    aruny

    10 November 2014 at 11:08 |
    well, its an interesting blog....

    reply

  • Chris

    Chris

    19 November 2014 at 10:55 |
    the download lin kis broken, can you please provide it again?

    reply

  • harshaja

    harshaja

    23 December 2014 at 18:45 |
    Your link mentioned above is invalid.
    In "STEP 3

    Now Change this file

    /layouts/vlayout/modules/Settings/Webforms/ FieldsEditView.tpl
    "

    But you didn't tell us what to change.

    Please help!

    reply

  • Ronald

    Ronald

    31 March 2015 at 04:40 |
    This pontisg knocked my socks off

    reply

Leave a comment

You are commenting as guest.

  • PHP
  • MySQL
  • HTML 5
  • jQuery
  • Java
  • JS
  • Postgre SQL
  • Python
  • git
  • Node

Last 30 Days Activities

Development-pie-chart

  • 01 Web Applications
  • 02 SEO
  • 03 Mobile Apps
  • 04 Other
  • 05 Software Development

Subscribe To Us

Social Activity