After installing User Revision I encountered this error:

Error message
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'web25518_drup1.user_revision' doesn't exist: update user_revision set vid=0 where uid=0;; Array ( ) in user_revision_install() (line 165 of /home/web25518/domains/fmedk.se/public_html/d/sites/all/modules/user_revision/user_revision.install).
The website encountered an unexpected error. Please try again later.

My log:
---------------------------
Details
Type php
Date Saturday, August 13, 2011 - 12:38
User admin
Location http://www.mydomain/d/?q=admin/modules/list/confirm
Referrer http://www.mydomain/d/?q=admin/modules
Message PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mydomaintable.user_revision' doesn't exist: update user_revision set vid=0 where uid=0;; Array ( ) in user_revision_install() (line 165 of /home/My account/domains/Mydomain/public_html/d/sites/all/modules/user_revision/user_revision.install).
Severity error
Hostname xxxxx
Operations
---------------------------
Thanks / Tomas

Comments

attiks’s picture

attiks commented
Status: Active » Fixed

There are {} missing in user_revision.install on line 164:
$sql = 'update {user_revision} set vid=0 where uid=0;';

Status: Fixed » Closed (fixed)

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