Site Restoration

#31754 duplicate key in table

Posted in ‘Site restoration’

This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version

n/a

CMS Type

Other

CMS Version

n/a

Backup Tool Version

n/a

Kickstart version

n/a

Latest post by on Saturday, 12 October 2019 17:17 CDT

Thursday, 12 September 2019 02:19 CDT

vincentsimon

Hello,

I Have the following error message when I try to restore my Joomla database with akeeba backup :

Can't write; duplicate key in table 'jootest_acym_step'

SQL=CREATE TABLE `jootest_acym_step` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `triggers` longtext, `automation_id` int(11) NOT NULL, `last_execution` int(11) DEFAULT NULL, `next_execution` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `fkjoo3923_acym__step1` (`automation_id`), CONSTRAINT `fkjoo3923_acym__step1` FOREIGN KEY (`automation_id`) REFERENCES `jootest_acym_automation` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8

Could you please help me to fix this issue?

Regards
Vincent

Thursday, 12 September 2019 03:02 CDT

tampe125

Hello,

during the restoration phase, there are two options in the Database step: Ignore CREATE errors and Ignore other SQL errors.
Check them all, in this way ANGIE will not stop when it finds any database error (such yours) during restoration.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Saturday, 12 October 2019 17:17 CDT

System Task

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Edited by on 2019-10-12 17:17 CDT

Support