Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.webform_update_7419() introduced an index on the webform_submission table's data column in order to speed up unique validation. The data column is of type 'text'. MS SQL both can't create a length-limited index and can't index a text column.
The solution is simply to not create this index for MS SQL Server. This patch both bypasses adding the index int he update function and defers creation of the index from hook_schema to hook_install (where the database driver can be checked).
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | webform-index_ms_sql-2457045-1.patch | 1.4 KB | danchadwick |
Comments
Comment #2
danchadwick commentedCommitted to 7.x-4.x.
Needs porting to 8.x
Comment #3
danchadwick commentedComment #4
danchadwick commentedBTW -- the only part that needs porting is deferring the creation of the index until installation time, after the schema has been built. The portion in the hook_update_7419 does not apply to D8, of course.
Comment #5
fenstratCommitted and pushed to 8.x-4.x. Thanks!