Wrong field name in webform.install [#277195]

The schema "webform_component" contains 2 times the "mandatory field". The second field should be email because when you try to add a new component to the form, Drupal throws an error "Unknown column 'email' in 'field list' query: INSERT INTO webform_component (nid, cid, pid, form_key, name, type, value, extra, mandatory, weight, email)"

Change line 153 of webform.install from "mandatory" to "email" and everything works fine

Comments

Comment #1

quicksketch

he/him

CreditAttribution: quicksketch commented 1 July 2008 at 15:36

Status:

Active

» Fixed

This was already fixed in #276729: Install schema typo for field email. But this is a really serious problem. I'm making a new release today.

Comment #2

quicksketch

he/him

CreditAttribution: quicksketch commented 1 July 2008 at 17:07

The 2.1.1 version is now out. Sorry for the trouble!

Comment #3

Agilealan CreditAttribution: Agilealan commented 1 July 2008 at 18:58

This is a great capability to add to Drupal (many thanks)but I can't seem to get started with it... I believe I'm still having this same problem with 6x 2.1.1 (and update.php) done...
2 errors follow:

Warning: Table 'watchdog' was not locked with LOCK TABLES query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:451:\"Unknown column &#039;email&#039; in &#039;field list&#039;\nquery: INSERT INTO webform_component (nid, cid, pid, form_key, name, type, value, extra, mandatory, weight, email) VALUES (48, 1, 0, &#039;name&#039;, &#039;Name&#039;, &#039;textfield&#039;, &#039;&amp;username&#039;, &#039;a:2:{s:11:\\&quot;description\\&quot;;s:31:\\&quot;&lt;p&gt;Do you know who you are?&lt;/p&gt;\\&quot;;s:9:\\&quot;maxlength\\&quot;;s:2:\\&quot;45\\&quot;;}&#039;, 1, -10, 1)\";s:5:\"%file\";s:89:\"/home/imultipl/public_html/thexxxxx/si in /home/imultipl/public_html/xxxxxx/includes/database.mysql.inc on line 128
_____________________________
New component Name added.
user warning: Unknown column 'email' in 'field list' query: INSERT INTO webform_component (nid, cid, pid, form_key, name, type, value, extra, mandatory, weight, email) VALUES (48, 1, 0, 'name', 'Name', 'textfield', '&username', 'a:2:{s:11:\"description\";s:31:\"<p>Do you know who you are?</p>\";s:9:\"maxlength\";s:2:\"45\";}', 1, -10, 1) in /home/imultipl/public_html/txxxxx/sites/all/modules/webform/webform_components.inc on line 478.

Comment #4

quicksketch

he/him

CreditAttribution: quicksketch commented 1 July 2008 at 19:13

Because the 2.1 version already modified your database (I didn't make 2.1.1 undo the change then redo it properly), you'll need to uninstall the module and try it all over again.

You can do this by:
- Going to admin/build/modules
- Turn off Webform module
- Go to admin/build/modules/uninstall
- Uninstall Webform module
- Turn Webform module back on again, from which it'll start a clean install

Sorry for the trouble :(

Comment #5

Agilealan CreditAttribution: Agilealan commented 1 July 2008 at 22:07

Works perfectly now- thanks for quick response!!

Comment #6

greg911 CreditAttribution: greg911 commented 2 July 2008 at 11:54

Sorry, I haven't "looked" for an already reported bug... I just corrected the code in the module and made it work... .But I thought that someone without any Drupal knowledge might find it useful ;)

Thanks for the quick response