I updated the media module to 2.0 and I'm getting this SQL error. I updated the file system with the previous version, but I can't even clear caches. I'm going to reboot the SQL server, but I'm curious if anyone has this issue, and how to get over it?

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxx.media_type' doesn't exist: SELECT mt.* FROM {media_type} mt ORDER BY weight ASC; Array ( ) in media_type_get_types() (line 134 of /var/www/html/xxxxx/sites/all/modules/media/includes/media.types.inc).

Thanks.

Comments

MeghanNIH created an issue. See original summary.

joseph.olstad’s picture

joseph.olstad
Primary language French
CreditAttribution: joseph.olstad commented
Parent issue: » #1567356: Installation fails with SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database.media_type' doesn't exist

It is likely that you are using a 1.x dev release, or something older than release 1.2

This issue was fixed in release 1.2

First before upgrading to 2.0, make sure that you've already upgraded to the most recent 1.x release (1.6 was the final 1.x release)

see related issues.

joseph.olstad’s picture

joseph.olstad
Primary language French
CreditAttribution: joseph.olstad commented

please restore your database prior to the 2.0 upgrade, then upgrade to 1.6 , then after you've upgraded to 1.6, upgrade to 2.0

joseph.olstad’s picture

joseph.olstad
Primary language French
CreditAttribution: joseph.olstad commented
Status: Active » Closed (duplicate)