[Vtigercrm-developers] Bug in Webforms?

[Christophe Humbert]

Thansk a lot Olivier

You save the day it was indeed this table missing



Christophe Humbert



On Mon, Apr 20, 2015 at 11:08 AM, Olivier Hallot <
olivier.hallot at libreoffice.org> wrote:

> Hello Christophe
>
> Check if the table vtiger_webforms_field exist in your brand new 6.2
> install. It did not existed in mine which is a bug in 6.2 install
> package. If it is missing, create it as:
>
> ----8<------
>
>  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',
>     sequence int(10) DEFAULT NULL,
>     hidden int(10) DEFAULT NULL,
>     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
>
> )
> ----8<------
>
> Webforms should work after that
>
> Olivier
>
> On 20/04/2015 04:53, Christophe Humbert wrote:
> > Hello
> >
> > I am not able to reproduce in demo systems.
> >
> > This is a brand new 6.2 Install
> >
> > I will turn on the debug and will see
> >
> > Thanks
> >
> > Christophe Humbert
> >
> >
> >
> > On Mon, Apr 20, 2015 at 9:00 AM, Alan Lord <alanslists at gmail.com
> > <mailto:alanslists at gmail.com>> wrote:
> >
> >     On 19/04/15 14:06, Christophe Humbert wrote:
> >
> >         Hello
> >
> >         I am selecting my fields etc...and when I save my fields they
> >         disappear
> >         from the list of fields in the webform so my webform is empty...
> >
> >
> >     Was this a migrated system? I have seen this when the migration had
> >     failed silently and there were some missing columns in the tables.
> >
> >     Check the debug log when saving a Webform.
> >
> >     HTH
> >
> >     Al
> >
> >
> >     _______________________________________________
> >     http://www.vtiger.com/
> >
> >
> >
> >
> > _______________________________________________
> > http://www.vtiger.com/
> >
>
> --
> Olivier Hallot
> Comunidade LibreOffice
> http://ask.libreoffice.org/pt-br
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150420/a975df57/attachment.html>