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

[Prasad]

InnoDB is preferable - this could be a reason for failure of some tables.

Can you retry creating the failed table and report the error message?

--
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 Fri, Jan 30, 2015 at 5:10 PM, Olivier Hallot <
olivier.hallot at libreoffice.org> wrote:

> 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
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150130/a9b1fdce/attachment-0001.html>