After switching from MySQL to PostgreSQL I have a lot of table with the same mismatch. For example for the Comment module :

column status - difference on: size
declared: array('description' => 'TODO: please describe this field!', 'type' => 'int', 'unsigned' => TRUE, 'size' => 'small', 'not null' => TRUE, 'default' => 1)
actual: array('description' => 'TODO: please describe this field!', 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 1)

I have the same difference on size on something like 100+ columns in a lot of different tables. Any idea about how I can fix it ?

Thank you in advance

Comments

bzrudi71’s picture

bzrudi71 commented

Guess we need a bit more background information here. How did you switch/migrate from MySQL exactly? Which tools in use?

Version: 7.38 » 7.x-dev

Core issues are now filed against the dev versions where changes will be made. Document the specific release you are using in your issue comment. More information about choosing a version.

roderik’s picture

roderik
Primary language Dutch
Location Amsterdam,NL / Budapest,HU
commented
Project: Drupal core » Schema
Version: 7.x-dev » 7.x-1.x-dev
Component: database system » Miscellaneous

This seems like a Schema thing.

At first sight, this looks like the database is not wrong - but the report is wrong for flagging those differences. I'm not sure though; people in the Schema queue can comment on this.

(I suspect "switching from MySQL to PostgreSQL" in the original bug report just means "reinstalling a fresh Drupal on PostgreSQL".)