I have about 10 schema mismatches of the following kind that I cannot figure out how to fix:

The mismatch is the Default Value, and the schema specifies a blank, but shows quotes; whereas the actual just shows blank. For example:

uc_usps_products

column container - difference on: default
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'varchar', 'length' => '255', 'not null' => TRUE, 'default' => '')
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'varchar', 'length' => '255', 'not null' => TRUE)

So notice, in the actual database, the default is blank, and not even shown as specified as blank. But in the schema it shows as what looks like blank with single quotation marks around the blank. I have been unable to figure out how to specify this in the mysql structure. If I actually put two single quotes in the default field, Schema gives me the error that actual is...

...'default' => '''')
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'varchar', 'length' => '255', 'not null' => TRUE)

...in other words, it puts single quotes around the single quotes.

How do I fix this? -- it's occurring across so many different modules, and I am trying to get my db errors under control to keep the system problem free.

I use the Chive Manager SQL GUI, and have also tried SQLBuddy GUI in the past.

Comments

alex.cunha’s picture

Is there an automatic fix?
update.php doest care this.

greggles’s picture

Status: Active » Closed (outdated)

The 6.x branch of this module is no longer supported so I am changing the status.

If this issue is still present in the 7.x version can you please reopen it and adjust the version?