I add components and try to save webform with 4 email fields (to address, from name, from address, subject) in various combinations. I get error:

* user warning: Unknown column 'email_from_name' in 'field list' query: INSERT INTO webform (nid, confirmation, redirect_post, submit_limit, submit_interval, email, email_from_name, email_from_address, email_subject, additional_validate, additional_submit) VALUES (75, 'node/74', 0, -1, 157784630, '', 'none', 'none', 'none', '', '') in C:\wamp\www\myDrupal\includes\database.mysql.inc on line 172.
* user warning: Unknown column 'form_key' in 'field list' query: INSERT INTO webform_component (nid, cid, pid, form_key, name, type, value, extra, mandatory, weight) VALUES (75, 1186504134, 0, '1186504134', 'Full Name', 'textfield', '', 'a:3:{s:11:\"description\";s:0:\"\";s:9:\"maxlength\";s:2:\"30\";s:5:\"width\";s:0:\"\";}', 1, -10) in C:\wamp\www\myDrupal\includes\database.mysql.inc on line 172.

Nothing is saved. Any insight will be appreciated.

Comments

rickvug’s picture

rickvug commented

I also get the same error from time to time, although often the webform results will send through. In general the form is slow to process even when there is no error. Here is the full error message:

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: SELECT dst FROM url_alias WHERE src = &amp;#039;node/29/done&amp;#039;</em> in <em>/home/hughmcki/public_html/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.hughmckinnon.com/contact-us', 'http://www.hughmckinnon.com/contact-us', '154.5.87.73', 1190316422) in /home/hughmcki/public_html/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>Cannot modify header information - headers already sent by (output started at /home/hughmcki/public_html/includes/database.mysql.inc:172)</em> in <em>/home/hughmcki/public_html/includes/common.inc</em> on line <em>311</em>.', 2, '', 'http://www.hughmckinnon.com/contact-us', 'http://www.hughmckinnon.com/contact-us', '154.5.87.73', 1190316422) in /home/hughmcki/public_html/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: SELECT sid FROM sessions WHERE sid = &amp;#039;6acef839c9934c42744ab0ffd7c5a4f8&amp;#039;</em> in <em>/home/hughmcki/public_html/includes/database.mysql.inc</em> on line <em>172</em>.', 2, '', 'http://www.hughmckinnon.com/contact-us', 'http://www.hughmckinnon.com/contact-us', '154.5.87.73', 1190316422) in /home/hughmcki/public_html/includes/database.mysql.inc on line 172

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '<em>MySQL server has gone away\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES (&amp;#039;6acef839c9934c42744ab0ffd7c5a4f8&amp;#039;, 1, 0, &amp;#039;154.5.87.73&amp;#039;, &amp;#039;watchdog_overview_filter|s:3:\\&amp;quot;all\\&amp;quot;;form|a:1:{s:32:\\&amp;quot;92485c4e1367af357fbd0d3f20832348\\&amp;quot;;a:2:{s:9:\\&amp;quot;timestamp\\&amp;quot;;i:1190315663;s:4:\\&amp;quot;args\\&amp;quot;;a:1:{i:0;s:14:\\&amp;quot;system_modules\\&amp;quot;;}}}update_remaining|a:0:{}update_total|i:4;messages|a:1:{s:5:\\&amp;quot;error\\&amp;quot;;a:2:{i:0;s:181:\\&amp;quot;user warning: MySQL server has gone away\\nquery: SELECT dst FROM url_alias WHERE src = &amp;amp;#039;node/29/done&amp;amp;#039; in /home/hughmcki/public_html/inclu in /home/hughmcki/public_html/includes/database.mysql.inc on line 172
quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Closed (fixed)

It looks like the original post was caused by a lack of running update.php (in 1.4 those columns were added to the database). I'm going to go ahead and close because this issue is nearly 6 months old.