Hello,

I tried to install the module and it simply emptied the users table, had to restore the DB :(

Best,
Pascal

Comments

psiegel created an issue. See original summary.

znak’s picture

znak commented

Hello. I couldn't reproduce this error, my users table isn't empty, but I can't to uninstall this module.
Drupal version - 8.2.4

psiegel’s picture

psiegel commented

Hello,

I tried again from a clean installation and this time the user table was fine, all users where still there an a quick test of revision seems to work, I get the user revision when modifying it.
I had a number of other user related modules installed when I first tried it and will try to find out (later) if there is some conflict with one of them.

I also can not uninstall the module because there is data in the vid and other fields/ tables.

Best,
Pascal

darkstartom’s picture

darkstartom commented

I think I am having the same problem. Just downloaded and enabled user_revision 8.x-1.x-dev on Drupal 8.2.5 and got the following:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'beddev.users' doesn't exist: SELECT revision.vid AS vid, revision.langcode AS langcode, revision.revision_timestamp AS revision_timestamp, revision.revision_uid AS revision_uid, revision.revision_log AS revision_log, base.uid AS uid, base.uuid AS uuid, CASE base.vid WHEN revision.vid THEN 1 ELSE 0 END AS isDefaultRevision FROM {users} base INNER JOIN {users_revision} revision ON revision.vid = base.vid WHERE (base.uid IN (:db_condition_placeholder_0)); Array ( [:db_condition_placeholder_0] => 5 ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->getFromStorage() (line 428 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

I urgently need revisioning of users profiles (using the profile module) so any fix would be very much appreciated, thanks!

geek-merlin’s picture

geek-merlin
Primary language German
Location Freiburg, Germany
commented
Status: Active » Closed (duplicate)
Related issues: +#3049787: Leverage EntityUpdate API (without this installing via web can lead to timeout and data loss)