1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    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