[Vtigercrm-developers] New 6.2 release : CREATE TABLE vtiger_webforms_field

[Olivier Hallot]

Hi Prasad

The ISP I use does not let me choose the engine (I created an empty
database before installing 6.2).

Looking from phpMyAdmin, I see a mix of MySam and innodb.

Was I supposed to let the install script create the db?


Kind regards

Olivier

On 29/01/2015 03:10, Prasad wrote:
> What is the default engine type set at MySQL server?
> 
> --
> FB <http://www.facebook.com/vtiger> I Twit
> <http://twitter.com/vtigercrm> I LIn
> <https://www.linkedin.com/company/1270573?trk=tyah> I Blog
> <https://blogs.vtiger.com> I Website <https://www.vtiger.com/>
> 
> On Thu, Jan 29, 2015 at 9:50 AM, Vipul Zalavadiya
> <vipul.zalavadiya at commercepundit.com
> <mailto:vipul.zalavadiya at commercepundit.com>> wrote:
> 
>     Hi Uma,
> 
>     I am facing also the same issue.
> 
>     Fresh installation of Vtiger 6.2 but not found vtiger_webforms_field
>     table.
> 
>     Thanks & Regards,
> 
>     *Vipul Zalavadiya
>     *
> 
>     Software Engineer
> 
>     *Phone:*+91 79 26400638
> 
>     *Email: *vipul.zalavadiya at commercepundit.com
>     <mailto:vipul.zalavadiya at commercepundit.com>
> 
>     ________________________________________________
> 
>     *commerce**pundit***
> 
>     WEB DESIGN & DEVELOPMENT
> 
>     SEO l  MARKETPLACE MANAGEMENT
> 
>     *facebook* <http://www.facebook.com/commercepundit>*   **twitter*
>     <http://twitter.com/commercepundit>*   **linkedin*
>     <http://www.linkedin.com/company/commercepundit>*   **pinterest*
>     <http://www.pinterest.com/commercepundit/>
> 
>     On Wed, Jan 28, 2015 at 10:58 PM, Olivier Hallot
>     <olivier.hallot at libreoffice.org
>     <mailto:olivier.hallot at libreoffice.org>> wrote:
> 
>         Hi Uma
> 
>         I did a clean installation of VT 6.2.0: new database, new
>         folder. All
>         went OK as indicated by the last page (all green).
> 
>         Tarball downloaded from SourceForge: vtigercrm6.2.0.tar.gz
> 
>         The table is not created and webforms can't save fields data.
> 
>         Kind regards
>         Olivier
> 
>         On 28/01/2015 14:52, Uma S wrote:
>         > Hi,
>         >
>         > In the clean installation of vtiger 6.2.0 vtiger_webforms_field table is
>         > present. Can you please provide clarification regarding this issue. Are
>         > you facing this issue in migrated instance?
>         >
>         > On Wed, Jan 28, 2015 at 9:47 PM, Olivier Hallot
>         > <olivier.hallot at libreoffice.org
>         <mailto:olivier.hallot at libreoffice.org>
>         <mailto:olivier.hallot at libreoffice.org
>         <mailto:olivier.hallot at libreoffice.org>>>
>         > wrote:
>         >
>         >     HI
>         >
>         >     Thanks for the new 6.2.release. Kudos for the community.
>         >
>         >     One issue: on a brand new install of 6.2, the webform
>         module still needs
>         >     this table:
>         >
>         >     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 )
>         >
>         >
>         >     regards
>         >     --
>         >     Olivier Hallot
>         >     Comunidade LibreOffice
>         >     http://ask.libreoffice.org/pt-br
>         >     _______________________________________________
>         >     http://www.vtiger.com/
>         >
>         >
>         >
>         >
>         > --
>         > With
>         > Best Regards
>         > Uma.S
>         > Vtiger Team
>         >
>         >
>         > _______________________________________________
>         > http://www.vtiger.com/
>         >
> 
>         --
>         Olivier Hallot
>         Comunidade LibreOffice
>         http://ask.libreoffice.org/pt-br
>         _______________________________________________
>         http://www.vtiger.com/
> 
> 
> 
>     _______________________________________________
>     http://www.vtiger.com/
> 
> 
> 
> 
> _______________________________________________
> http://www.vtiger.com/
> 

-- 
Olivier Hallot
Comunidade LibreOffice
http://ask.libreoffice.org/pt-br