Following today's update to 1.2 I cannot run home page on my site. It crashes with the following error.
Please advise promptly.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'myserver.commerce_product_revision' doesn't exist: SELECT revision.revision_id AS revision_id, revision.sku AS sku, revision.title AS title, revision.revision_uid AS revision_uid, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.data AS data, base.product_id AS product_id, base.type AS type, base.language AS language, base.uid AS uid, base.created AS created, base.changed AS changed FROM {commerce_product} base INNER JOIN {commerce_product_revision} revision ON revision.revision_id = base.revision_id WHERE (base.product_id IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => 8 ) in DrupalDefaultEntityController->load() (line 196 of /includes/entity.inc).

Comments

moniuch’s picture

moniuch commented
Status: Active » Closed (fixed)

At some point I received a db update alert which helped. Case closed

sbaroulette’s picture

sbaroulette commented

HELP!! I have received this exact problem. I was attempted to update my site after receiving update notifications for the following modules:
Commerce PayPal 7.x-1.x-dev 7.x-1.x-dev (Release notes)
Commerce Shipping 7.x-2.x-dev 7.x-2.0-beta1 (Release notes)
Commerce UPS 7.x-1.x-dev 7.x-1.x-dev (Release notes)
Views 7.x-3.1 7.x-3.3 (Release notes)

Manual Updates:
Drupal core (Security update) 7.10 7.12 (Release notes)

I am a newbie and totally confused why I am getting this error on my store and when I login:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'myserver.commerce_product_revision' doesn't exist: SELECT revision.revision_id AS revision_id, revision.sku AS sku, revision.title AS title, revision.revision_uid AS revision_uid, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.data AS data, base.product_id AS product_id, base.type AS type, base.language AS language, base.uid AS uid, base.created AS created, base.changed AS changed FROM {commerce_product} base INNER JOIN {commerce_product_revision} revision ON revision.revision_id = base.revision_id WHERE (base.product_id IN (:db_condition_placeholder_0)) ; Array ( [:db_condition_placeholder_0] => 5 ) in DrupalDefaultEntityController->load() (line 196 of /home/content/z/e/n/myserver/html/drupal/includes/entity.inc).

Please advise on what steps to take to fix ASAP. Thanks!

sbaroulette’s picture

sbaroulette commented
Status: Closed (fixed) » Active
bojanz’s picture

bojanz commented
Status: Active » Closed (fixed)

You need to run update.php to install the relevant updates.