1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Restore of backup 7.0.1 fails on 7.0.1 and 7.0.3

Discussion in 'Plesk for Windows - 8.x and Older' started by svenson, Mar 6, 2005.

  1. svenson

    svenson Guest

    The restore of a backup of a 7.0.1 system fails with the following error message:

    Run-Time error: can't execute INSERT INTO siteappresources('type','app_id','res_id') values ('database','77','0'): MySql error 1062:Duplicate entry 'database-0' for key 1

    We tried to restore on both clean installs of Windows 2003 with Plesk 7.0.1 and 7.0.3

    I removed the Unique attribute on the siteappresource table to make the restore work, but I guess it's not the best way to solve this problem :)

    Any ideas?
  2. AbsolutelyFreeW

    AbsolutelyFreeW Guest

    just open the backup and edit the database script causing the problem