I updated to the latest dev (7.x-2.0-unstable7+88-dev) from "7.x-2.0-unstable7+76-dev" and get this error after running update.php:

file_entity module

Update #7211
Failed: DatabaseSchemaObjectExistsException: Table <em class="placeholder">file_metadata</em> already exists. in DatabaseSchema->createTable() (line 657 of /Applications/MAMP/htdocs/100_Projects/thezooproject2013/includes/database/schema.inc).

Comments

drupa11y’s picture

drupa11y commented

I use MAMP Pro 2.x on OS X 10.6.8 with mySQL 5.5.29 and PHP 5.3.20 with APC

graytoby’s picture

graytoby commented

Same thing here. I had no problems on my VPS account, however on shared host I got this and my admin theme lost all its styling!

drupa11y’s picture

drupa11y commented

Error still occurs when I try to update to "7.x-2.0-unstable7+96-dev"

I get these messages before trying to upgrade:

file_entity module
    7211 - Create the {image_dimensions} table.
    7212 - Migrate the image_dimensions table to the new file_metadata table.
drupa11y’s picture

drupa11y commented

Can I fix this somehow by deleting tables directly in the mySql-DB ?

drupa11y’s picture

drupa11y commented

Update.php works after deleting the "file_metadata"-table.

Can anyone say if this solution is o.k. or not recommended?

drupa11y’s picture

drupa11y commented
Category: bug » support
devin carlson’s picture

devin carlson commented
Status: Active » Fixed

As long as the {file_metadata} was recreated by the update function you should be fine. Otherwise, I'd suggest reinstalling File entity.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

r2coder’s picture

r2coder commented
Issue summary: View changes

I know this issue is closed.. but I wanted to confirm that deleting the file_metadata => running update.php resolves the issue even today (Mar 2015).

Drupal 7.34

jhheli’s picture

jhheli commented

@r2coder Thanks for the update, I experienced this error also, dropped file_metadata and updated with no issue.

Drupal 7.34

andreynacarrasco’s picture

andreynacarrasco commented

Run update.php after delete file_metadata table... it works.

Drupal 7.35, File entity 7.x-2.0-beta1

eyn’s picture

eyn commented

drupal 7.43
drop table file
update.php
Works

frederico’s picture

frederico commented

New Drupal 7.50 install with file_entity 7.x-2.0-beta3
drop file_metadata table
update.php
Works

rosswass’s picture

rosswass commented

running drupal 7.42, dropping this table leads to this error in update.php

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'avenueco_drup919.dr8x_media_filter_usage' doesn't exist: DELETE FROM {media_filter_usage} WHERE (timestamp < :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 1473130035 ) in media_flush_caches() (line 1129 of /home/xxxx/public_html/sites/all/modules/media/media.module).