Support

Mandatory information about my setup:

Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? Yes
Have I searched the tickets before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 1.5.25
PHP version: 5.2.17
MySQL version: 5.1.61-community-log
Host: (optional, but it helps us help you)
Akeeba Backup version which took the backup: 3.0
Kickstart version used to extract the backup: 3.1.1


Description of my issue:

I get the following error when attemtping a restore. It gets to about 7% and then gives the error. I have tried multiple backups and all give the same error. Would appreciate any advice on this as I am desperate to get the site back up.

Error at the line 679: INSERT INTO `j17_virtuemart_states` VALUES ('532', '1', '84', '0', 'ΛΑΡΙΣΑΣ', 'ΛΑΡ', 'ΛΡ', '0', '0', '1', '0000-00-00 00:00:00', '0', '0000-00-00 00:00:00', '0', '0000-00-00 00:00:00', '0' ... MySQL: MySQL query failed with error 1062 (Duplicate entry '84-???' for key 'idx_state_3_code'). The query was:INSERT INTO `j17_virtuemart_states` VALUES ('532', '1', '84', '0', 'ΛΑΡΙΣΑΣ', 'ΛΑΡ', 'ΛΡ', '0', '0', '1', '0000-00-00 00:00:00', '0', '0000-00-00 00:00:00', '0', '0000-00-00 00:00:00', '0')

Thank you for the reply. I have checked my database and it is set to utf8_general_ci - I have done backups and restores 100s of times over (I have many sites across a number of servers) and I've never come across this error before and in fact I've never actually really had any errors until this one. Usually everything works perfectly as expected.

I could not see where the Force UTF8 collation option was in the restoration page. I checked the documentation and it says it should be in the fine tuning section in the restoration area but I do not seem to have it?

Oh, I see. No unfortuntely I am not able to make another backup. I need to restore this particular backup or at least one of the earlier ones which are all giving me the same error...