When trying to create a web form i receive a permission denied error

Comments

• creativemango

  October 2014 Vote Up0Vote Down

  @devitechnosolutions -- thanks for the columns list.
  
  i tried to add it manually in table but error is still same.
• chetan

  October 2014 Vote Up0Vote Down

  hi all,
  
  could you please tell us whether you are using a fresh installation of vtiger 6.1.0 or migrated from the older instances? this would give us a good insight to look at the issue.
• cor9003

  October 2014 Vote Up0Vote Down

  i have the same problem. it is not possible to create any web form in 6.1
  
  any help, please ?
• Makonz

  October 2014 Vote Up0Vote Down

  same problem here, adding the tables did not help. cannot believe things like missing table structure is missing out of a vtiger release.
• chetan

  October 2014 Vote Up0Vote Down

  hi all,
  
  we have noted down the issue over here:
  
  http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8316. please refer this for further details.
• rabbisteve

  November 2014 Vote Up0Vote Down

  i have the same problem, i tried to add the columns, but still get the same "permission denied"
• vjstyla

  November 2014 Vote Up0Vote Down

  hello all,
  
  here is what i have done to fix this error (i am not so techie so writing the exact way i did it).....
  
  
  
  step 1
  
  run this query 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 change this file
  
  /layouts/vlayout/modules/settings/webforms/ fieldseditview.tpl
  
  
  and done.....
  
  now you will see the web-form is working fine...if you still getting error...let me know and i will upload the files and vtiger-weform table so you can import it........
• brianroberts

  November 2014 Vote Up0Vote Down

  could you please post the sql and file?
• brianroberts

  November 2014 Vote Up0Vote Down

  you said
  "step 3
  
  now change this file
  
  /layouts/vlayout/modules/settings/webforms/ fieldseditview.tpl
  "
  
  but you didn't tell us what to change.
• vjstyla

  November 2014 Vote Up0Vote Down

  @brianroberts
  
  here is the file
  
  please download the file from my website http://www.aambeesoft.co.uk/blog/vtiger-6-1-webfrom-fix
  
  let me know if you still get problem making webform working
  
  vjstyla