Hello gentlemen,

I'm getting a webform_emails error trying to go from 2.6 to 3.1:
"
Drupal database update
user warning: Duplicate column name 'excluded_components' query: ALTER TABLE drup_webform_emails ADD `excluded_components` TEXT DEFAULT NULL in xxxx/includes/database.mysql-common.inc on line 298.
"
The following queries were executed
webform module
"
Update #6308
Failed: ALTER TABLE {webform_emails} ADD `excluded_components` TEXT DEFAULT NULL
UPDATE {webform_emails} SET excluded_components = '%s' ()
ALTER TABLE {webform_emails} CHANGE `excluded_components` `excluded_components` TEXT NOT NULL
ALTER TABLE {webform_component} DROP email
"

Not only does it fail but it brings the whole site down!

Really appreciate any insight or suggestions, I've checked the table and it doesnt appear to be corrupted (even tried to repair it for good measure) ... come to think of it, it wasnt sending messages to the first e-mail address listed at one point, dont know if its related.

This was on a first attempt to update after enabling the version 3.1 module. I've tried several times on fresh backups made before installing the new module version.

Thanks in advance, you help is appreciated!
-Pjo

Comments

quicksketch’s picture

Category: bug » support

The only reason you'd be receiving this error would be if your site (running Webform 2.x) already had an "excluded_components" column in the "webform_emails" table. However as you can see from the latest code in Git (http://drupalcode.org/project/webform.git/blob/refs/heads/6.x-2.x:/webfo...), there is no "excluded_components" column anywhere in the webform.install file (or anywhere else for that matter).

This indicates that you may have tried to upgrade to Webform 3.x at some point in the past, then decided to downgrade again to 2.x. This is not supported and likely the cause of how the site got into its current predicament.

Since Webform module now has no idea how to upgrade your site (since it's not really 2.x or 3.x in the database structure), you'll need to reconcile all the differences manually. You could do this by installing the Schema module while you're site is running Webform 2.x, then make manual database changes to make it so that your site matches the expected database structure of Webform 2.x. Then the upgrade to 3.x should be able to complete without any errors.

artscientific’s picture

Status: Active » Closed (won't fix)

You are correct, I went in and removed excluded_components manually and all went well.

Thank you for your prompt and detailed help.
-ArtScientific