[Vtigercrm-developers] webforms not working

[Hamono, Chris (DPC)]

Thanks Mel and Alan

I found the vtiger_webforms_field table was missing.

I also could not create that table as the constraints failed due to the vtiger_fields table having the wrong collation, for some reason it was set to latin1 instead of utf8

mysql kept throwing  errno 150 until I changed the default collation and several columns which were not set to the default collation

Very strange. I think that an early "version" of vtiger 6.0 was the cause. 

We started this project on 6.0 not 5.4.

Chris
________________________________________
From: vtigercrm-developers-bounces at lists.vtigercrm.com [vtigercrm-developers-bounces at lists.vtigercrm.com] On Behalf Of Melanie [m.brummell at btinternet.com]
Sent: Thursday, February 05, 2015 11:26 PM
To: vtigercrm-developers at lists.vtigercrm.com
Subject: Re: [Vtigercrm-developers] webforms not working

Hi,

I had this problem to and it was as Al said. I am using latest release 6.2.
To repair it:

1. Go to PHPMyAdmin ---> Drop these 2 tables if they exist
"vtiger_webforms.sql" and "vtiger_webforms_field.sql" (in vtiger 6.2 they
were missing).
2. Import the attached `vtiger_webforms_field.sql`
3. Import the attached `vtiger_webforms.sql`
4. Replace the file `FieldsEditView.tpl`in
layouts/vlayout/modules/Settings/Webforms/FieldsEditView.tpl
with this one (maybe just copy and paste the content in to new one)

Mel

Message: 1
Date: Thu, 05 Feb 2015 07:43:51 +0000
From: Alan Lord <alanslists at gmail.com>
To: vtigercrm-developers at lists.vtigercrm.com
Subject: Re: [Vtigercrm-developers] webforms not working
Message-ID: <mav6vn$vil$3 at ger.gmane.org>
Content-Type: text/plain; charset=windows-1252; format=flowed

On 05/02/15 03:47, Hamono, Chris (DPC) wrote:
> I have upgraded 6.1 to 6.2 hoping it would resolve a problem In 6.1 we
> cannot create webforms. It doesn?t work in 6.2 either

If this is a migrated system from 5.4.0 check your database structure
against a clean 6.1(or2).0 system.

I have seen this part fail frequently during the migration so your
vtiger_webform* tables do not end up with all the necessary columns.

HTH

Al