[Vtigercrm-developers] Bug in Webforms?

[Olivier Hallot]

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