webform module - pending updates

* 7307 - Update the confirmation_format column for default text format changes.
* 7308 - Update the confirmation_format column to allow it to store strings.
* 7309 - Add the ability to auto-save as draft between pages.
* 7310 - Remove orphaned and unnecessary rows in the webform table.
* 7311 - Add an index for sid_nid_uid to webform_submissions.

After updating webform in drupal-7.0, MySQL 5.1.30-community this error is logged.

* Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 2: UPDATE {webform} SET confirmation_format=:db_update_placeholder_0 WHERE
(confirmation_format IS NOT NULL ) AND (confirmation_format NOT IN ()) ; Array ( [:db_update_placeholder_0] => 1 ) in webform_update_7307() (line 520 of C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\drupal-7.0\sites\all\modules\webform\webform.install).

...

and this is the code (line 520) referred to in error ..

webform.install

db_update('webform')
->fields(array('confirmation_format' => $default_format))
->isNotNull('confirmation_format')
->condition('confirmation_format', $numeric_formats, 'NOT IN')
->execute();

Comments

campeon38’s picture

I got the same error, cannot update webform:

The following updates returned messages

webform module

Update #7307
Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 2: UPDATE {webform} SET confirmation_format=:db_update_placeholder_0 WHERE (confirmation_format IS NOT NULL ) AND (confirmation_format NOT IN ()) ; Array ( [:db_update_placeholder_0] => 1 ) in webform_update_7307() (line 520 of /var/www/clients/client1/web4/web/sites/all/modules/webform/webform.install).

Drupal 7, MySQL 5.5.9, php 5.3.5

quicksketch’s picture