Can't configure FORM EMAIL FIELD after update to 2.0.0

[Ben]

Hey Peter! How's it going? I didn't know you were mrGarvin. The forums lend themselves to anonymity.

Regarding your problem, it actually sounds relatively serious... My hunch is that something went wrong with the upgrade: you shouldn't have had to re-write those admin files, so if something went wrong that required updating the files, we may have to do a little manual surgery on the database as well.

Since you have phpMyAdmin access, could you confirm the structure of the following tables? These were the ones that were updated in the most recent release.

(ft_)email_template_recipients
(ft_)email_templates
(ft_)form_email_fields
(ft_)forms

Here's what they're supposed to have, column-wise. (ignore the PHP - I just copied this from /install/files/sql.php):

PHP Code:

$g_sql[] = "CREATE TABLE %PREFIX%email_template_recipients (
  recipient_id mediumint(8) unsigned NOT NULL auto_increment,
  email_template_id mediumint(8) unsigned NOT NULL,
  recipient_user_type enum('admin','client','form_email_field','custom') NOT NULL,
  recipient_type enum('main','cc','bcc') NOT NULL default 'main',
  account_id mediumint(9) default NULL,
  form_email_id MEDIUMINT UNSIGNED NULL,
  custom_recipient_name varchar(200) default NULL,
  custom_recipient_email varchar(200) default NULL,
  PRIMARY KEY  (recipient_id)
) TYPE=InnoDB DEFAULT CHARSET=utf8";

$g_sql[] = "CREATE TABLE %PREFIX%email_templates (
  email_id mediumint(8) unsigned NOT NULL auto_increment,
  form_id mediumint(8) unsigned NOT NULL,
  email_template_name varchar(100) default NULL,
  email_status enum('enabled','disabled') NOT NULL default 'enabled',
  view_mapping_type enum('all','specific') NOT NULL default 'all',
  view_mapping_view_id mediumint(9) default NULL,
  limit_email_content_to_fields_in_view mediumint(9) default NULL,
  email_event_trigger set('on_submission','on_edit','on_delete') default NULL,
  include_on_edit_submission_page enum('no','all_views','specific_views') NOT NULL default 'no',
  subject varchar(255) default NULL,
  email_from enum('admin','client','form_email_field','custom','none') default NULL,
  email_from_account_id mediumint(8) unsigned default NULL,
  email_from_form_email_id MEDIUMINT UNSIGNED NULL,
  custom_from_name varchar(100) default NULL,
  custom_from_email varchar(100) default NULL,
  email_reply_to enum('admin','client','form_email_field','custom','none') default NULL,
  email_reply_to_account_id mediumint(8) unsigned default NULL,
  email_reply_to_form_email_id MEDIUMINT UNSIGNED NULL,
  custom_reply_to_name varchar(100) default NULL,
  custom_reply_to_email varchar(100) default NULL,
  html_template mediumtext,
  text_template mediumtext,
  PRIMARY KEY (email_id)
) TYPE=InnoDB DEFAULT CHARSET=utf8";

$g_sql[] = "CREATE TABLE %PREFIX%form_email_fields (
  form_email_id MEDIUMINT unsigned NOT NULL auto_increment,
  form_id MEDIUMINT UNSIGNED NOT NULL,
  email_field VARCHAR( 255 ) NOT NULL,
  first_name_field VARCHAR( 255 ) NULL,
  last_name_field VARCHAR( 255 ) NULL,
  PRIMARY KEY (form_email_id)
) TYPE=InnoDB DEFAULT CHARSET=utf8";

$g_sql[] = "CREATE TABLE %PREFIX%form_fields (
  field_id mediumint(8) unsigned NOT NULL auto_increment,
  form_id mediumint(8) unsigned NOT NULL default '0',
  field_name varchar(255) NOT NULL default '',
  field_test_value mediumtext,
  field_size enum('tiny','small','medium','large','very_large') default 'medium',
  field_type enum('select','multi-select','radio-buttons','checkboxes','file','textbox','textarea','system','wysiwyg','date','image','password') NOT NULL default 'textbox',
  data_type enum('string','number','date') NOT NULL default 'string',
  field_title varchar(100) default NULL,
  col_name varchar(100) default NULL,
  list_order smallint(5) unsigned default NULL,
  include_on_redirect enum('yes','no') NOT NULL default 'no',
  `field_group_id` mediumint(9) default NULL,
  PRIMARY KEY  (field_id)
) TYPE=InnoDB DEFAULT CHARSET=utf8"; 


- Ben