Attempting to perform a sync using the user interface. Sync fails with error (screen shot attached). In the logs, I find the following message:

LOCATION	http://xxx/admin/config/system/configuration/sync
REFERRER	http://xxx/admin/config/system/configuration/sync
MESSAGE	DatabaseSchemaObjectExistsException: Table <em class="placeholder">field_data_field_xxx_account_number</em> already exists. in DatabaseSchema->createTable() (line 657 of /var/www/vhosts/xxx/drupal-git/includes/database/schema.inc).
SEVERITY	error

Comments

ohthehugemanatee’s picture

Issue summary: View changes
Status: Active » Closed (works as designed)

This error is exactly what it says: the table already exists in your database, when configuration is trying to create the field. You'd get the same error with Features or with module_enable in the same circumstances, so this is not a bug.

I usually run into this issue when I create a field, then import a DB dump to "start over". Importing a DB dump doesn't remove tables, it just overwrites the ones mentioned in the dump. You end up with the tables from the old field, even though that field doesn't exist anymore. The solution is to actually wipe your database before you import from a dump.