Restore of backup 7.0.1 fails on 7.0.1 and 7.0.3

[svenson]

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 1062uplicate 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?

 

[AbsolutelyFreeW]

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