Unable to restore snapshot: Table 'widget' - SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

Created:

2016-11-16 13:20:44 UTC

Modified:

2017-08-16 16:58:01 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to restore snapshot: Table 'widget' - SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry

Applicable to:

  • Web Presence Builder for Linux

Symptoms

When trying to restore a website from the snapshot created using bru.php utility the following error appears:

#/usr/bin/sw-engine /usr/local/sb/utils/bru.php --restore --target=site --uuid=38fb60ce-975c-d623-0484-111e9a3d299a --file=38fb60ce-975c-d623-0484-111e9a3d299a.zip

Restoring the site with UUID: 38fb60ce-975c-d623-0484-111e9a3d299a
Error: Site (38fb60ce-975c-d623-0484-111e9a3d299a) can't be restored. Table 'widget' - SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7c2398d5-06b5-09c5-5291-1d4e79a1d9cd' for key 2

Cause

In general, before restoration process, bru.php utility removes all records related to the site from Presence Builder database. But due to some reasons some orphan records may remain in Presence Builder database which prevents the site to be restored.

Resolution

It is required to perform manual changes in Presence Builder database, so please contact Parallels Technical Support.

Have more questions? Submit a request
Please sign in to leave a comment.