Schema inconsistent
| Project: | Webform |
| Version: | 6.x-2.1.2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | duplicate |
Jump to:
here is a copy of the schema report; is this a bug, or if it is usser error, how do i fix?
webform
column submit_text:
declared: array('type' => 'varchar', 'length' => 255, 'default' => )
actual: array('type' => 'varchar', 'length' => '255', 'not null' => FALSE)
column email:
declared: array('type' => 'varchar', 'length' => 255, 'default' => )
actual: array('type' => 'varchar', 'length' => '255', 'not null' => FALSE)
column email_from_name:
declared: array('type' => 'varchar', 'length' => 255, 'default' => )
actual: array('type' => 'varchar', 'length' => '255', 'not null' => FALSE)
column email_from_address:
declared: array('type' => 'varchar', 'length' => 255, 'default' => )
actual: array('type' => 'varchar', 'length' => '255', 'not null' => FALSE)
column email_subject:
declared: array('type' => 'varchar', 'length' => 255, 'default' => )
actual: array('type' => 'varchar', 'length' => '255', 'not null' => FALSE)
column submit_text: key 'not null' not set, ignoring inspected default value
column email: key 'not null' not set, ignoring inspected default value
column email_from_name: key 'not null' not set, ignoring inspected default value
column email_from_address: key 'not null' not set, ignoring inspected default value
column email_subject: key 'not null' not set, ignoring inspected default value
webform_component
column form_key:
declared: array('type' => 'varchar', 'length' => 128, 'default' => )
actual: array('type' => 'varchar', 'length' => '128', 'not null' => FALSE)
column name:
declared: array('type' => 'varchar', 'length' => 255, 'default' => )
actual: array('type' => 'varchar', 'length' => '255', 'not null' => FALSE)
column type:
declared: array('type' => 'varchar', 'length' => 16, 'default' => )
actual: array('type' => 'varchar', 'length' => '16', 'not null' => FALSE)
column form_key: key 'not null' not set, ignoring inspected default value
column name: key 'not null' not set, ignoring inspected default value
column type: key 'not null' not set, ignoring inspected default value
webform_submitted_data
column sid:
declared: array('type' => 'int', 'unsigned' => TRUE, 'default' => 0)
actual: array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, 'disp-width' => '10')
#1
Did you upgrade from a Drupal 5 site? The actual and defined schemas should be the same yes, but I don't think any of these inconsistencies will cause any problems currently. I'd like to get them cleaned up though for consistency.
#2
new install of v.6, let me know if there is any more info i can provide.
#3
Marked #292722: db schema errors reported by schema module as duplicate.
#4
This has finally been corrected in #357476: Schema module reports table mismatch errors in webform and will be in the 2.5 release.