User login

Nothing happens when saving webform e-mail settings

Trying to change the e-mails that are sent out when a web form is submitted, the form submits, a message is given saying that everything saved or updated fine... and not a single change is saved.

Had to look at Watchdog to see what was happening.

May 1 13:20:16 sojourner drupal: http://agaric.com|1304270416|php|166.186.169.102|http://agaric.com/node/20/webform/emails/2|http://agaric.com/node/20/webform/emails/2|1||Unknown column 'html' in 'field list'#012query: UPDATE webform_emails SET nid = 20, eid = 2, email = '3', subject = '[Ask Agaric] %value[subject]', from_name = 'default', from_address = 'default', template = 'default', excluded_components = '5', html = 0, attachments = 0 WHERE nid = 20 AND eid = 2 in /var/local/drupal/agaric/web/includes/common.inc on line 3538.

Very odd. Somehow the update:

<?php
/**
 * Add columns for e-mail HTML and attachment settings.
 */
function webform_update_6319() {
  $ret = array();
  if (!db_column_exists('webform_emails', 'html')) {
    db_add_field($ret, 'webform_emails', 'html', array('type' => 'int', 'size' => 'tiny', 'unsigned' => TRUE, 'default' => 0, 'not null' => TRUE));
    db_add_field($ret, 'webform_emails', 'attachments', array('type' => 'int', 'size' => 'tiny', 'unsigned' => TRUE, 'default' => 0, 'not null' => TRUE));
  }
  return $ret;
}
?>

was never run.

And it had just run from 6323 through 6326.

In Drupal 6 you can manually set from where you think things should be run, so i told it to run from 6315 since from then on looked harmless, and an update a couple before that i confirmed had run.

A few duplicate column errors, of course, but the needed updates ran.

And saving e-mail settings for the ask webform worked beautifully after that.

Searched words: 
web form configuration saving fail

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <small> <h2> <h3> <h4> <h5> <h6> <sub> <sup> <p> <br> <strike> <table> <tr> <td> <thead> <th> <tbody> <tt> <output>
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.