Skip to main content
  • X Twitter
  • youtube
Home
Drupal 4U
Built for AI. Powered by Drupal.
  • Home
  • Showcases
  • Services
  • Blog
  • About
  • Contact

Breadcrumb

  1. Home
  2. HowTos
  3. File entity module: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table

File entity module: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table

HowTos
March 06, 2016
Profile picture for user drupal
By drupal
  • facebook-f
  • twitter
  • envelope
  • print
128

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'DATABASENAME.image_dimensions' doesn't exist: SELECT * FROM {image_dimensions} id WHERE id.fid IN (:fids_0); Array ( [:fids_0] => 444 ) in file_entity_file_load() (Zeile 225 von /DRUPALROOT/sites/all/modules/media/file_entity/file_entity.module).

Same for me, after the update to Media 7.1.4, that I did following PSA-2014-001.

Seems that something is broken in this update.
The file_entity_module has changed, and is the update.php did not triggered the update_7101. Therefore, the image_dimensions table is not created

In the system table, schema_version column for file_entity is set to 7215.

One solution is to set it to 7100, and re-run the update.php :
update system set schema_version = '7100' where name = 'file_entity';

Seems there is a collision with Media 2, which uses File_entity 7.2.x

Edit: after analysis, the root cause was that I first installed file_entity, but then I installed Media 7.1, which brings its own File Entity stuff. I had to disable / desinstall File entity, and then re-enable Media.

Source: https://www.drupal.org/node/1882292#comment-8364995

File entity module
Troubleshooting

Read more articles

Newer
How to create a Drupal view with future events / dates of nodes
Older
Drupal Tokens: How to remove the line-breaking paragraph tag from tokens used within nodes
  • Log in to post comments
Profile picture for user drupal
drupal
128
1
min read
A- A+
  • facebook-f
  • twitter
  • envelope
  • print

Contact Us

Get in touch for questions and our Drupal development, design and optimization services.

Contact Us

We aim to reply the latest within 48h.

Drupal 4U: Built for AI. Powered by Drupal.

We are a group of Drupal designers, developers and webmasters. We are Drupal experts! We provide comprehensive services that go beyond traditional web development, focusing on how AI understands, interprets, and cites your content. With our deep expertise in Drupal's architecture, we build the intelligent core of your digital presence, ensuring your brand remains authoritative and visible in a world where AI is the primary gatekeeper of information. Partner with us and let's future-proof your digital strategy together.

  • X Twitter
  • youtube

Drupal Services

  • Drupal Web Design
  • Drupal Development
  • Drupal SEO
  • Drupal GEO
  • Drupal Migration

Drupal 4U

  • Services
  • Showcases
  • Blog
  • About

Drupal Links

  • Official Drupal Website
  • Drupal Answers
  • Gaivas Themes Drupal 11
  • More Than Themes
  • Theme Forest
  • DXPR: Drupal for Marketers
2012 - 2025, Drupal 4U

Footer menu

  • Contact
Home
Drupal 4U
Built for AI. Powered by Drupal.
  • Home
  • Showcases
  • Services
  • Blog
  • About
  • Contact
Clear keys input element