user warning: Unknown column 'email' in 'field list' query: UPDATE webform_component ...
madjoe - July 9, 2008 - 11:19
| Project: | Webform |
| Version: | 5.x-2.1.1 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
After upgrading from v2.0 to 2.1.1 I have problems with modifying or submitting new fields to my existing form. I have a field type "email" (name: email) in the form and if I try to submit any other field, I receive this warning from Drupal:
user warning: Unknown column 'email' in 'field list' query: UPDATE webform_component SET pid = 27, form_key = 'FieldKey', name = 'FieldName', type = 'markup', value = 'FieldValue', extra = 'a:1:{s:6:\"format\";s:1:\"3\";}', mandatory = 0, weight = 10, email = 0 WHERE nid = 5 AND cid = 37 in /home/public_html/includes/database.mysql.inc on line 172.
#1
You need to run update.php to bring the webform schema up-to-date. The e-mail column should be added to the database for you.
#2
Even if I've run update.php two times, this time I did it by manually selecting Webform module upgrade "1" from the select box. And this time it worked. Thanks for the clue!
#3
If that worked for you, that's great. For anyone running across this thread, I'd discourage taking this same approach. It's very likely to break a bunch of things, running all the updates from 1. Generally, you should *never* change the the update function number, Drupal will select the number starting at the updates that have not yet been run. Update functions are not run-twice safe, as they'll try to run all the SQL queries again, even if it's not necessary.