Support

Hi,

When i try the migration of site and restoration in a new server i get the following error during database restoration. Can't further more. I tryed new backups and several restorations.

Can you help?

Database restoration
An error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.
Database error processing line 55
Database server error reply:

ErrNo #1061
Duplicate key name 'cgn01_admintools_log_logdate_reason'
SQL=CREATE TABLE `cgn01_admintools_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`logdate` datetime NOT NULL,
`ip` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url` varchar(10240) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`reason` enum('other','adminpw','ipwl','ipbl','sqlishield','antispam','wafblacklist','tpone','tmpl','template','muashield','csrfshield','badbehaviour','geoblocking','rfishield','dfishield','uploadshield','xssshield','httpbl','loginfailure','securitycode','external','awayschedule','admindir','sessionshield','nonewadmins','nonewfrontendadmins','configmonitor','phpshield','404shield') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`extradata` longtext COLLATE utf8mb4_unicode_ci,
UNIQUE KEY `id` (`id`),
KEY `cgn01_admintools_log_logdate_reason` (`logdate`,`reason`),
KEY `cgn01_admintools_log_logdate_reason` (`logdate`,`reason`)
) ENGINE=MyISAM AUTO_INCREMENT=20236 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Raw query text:

CREATE TABLE `cgn01_admintools_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`logdate` datetime NOT NULL,
`ip` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`url` varchar(10240) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`reason` enum('other','adminpw','ipwl','ipbl','sqlishield','antispam','wafblacklist','tpone','tmpl','template','muashield','csrfshield','badbehaviour','geoblocking','rfishield','dfishield','uploadshield','xssshield','httpbl','loginfailure','securitycode','external','awayschedule','admindir','sessionshield','nonewadmins','nonewfrontendadmins','configmonitor','phpshield','404shield') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`extradata` longtext COLLATE utf8mb4_unicode_ci,
UNIQUE KEY `id` (`id`),
KEY `cgn01_admintools_log_logdate_reason` (`logdate`,`reason`),
KEY `cgn01_admintools_log_logdate_reason` (`logdate`,`reason`)
) ENGINE=MyISAM AUTO_INCREMENT=20236 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Hello,

you can tell ANGIE to ignore SQL errors by removing both checks from the options Stop on ... errors .

At the end you will have a SQL file containing all the failed query, so you can manually edit them and rerun them.

 

In your case the line KEY `cgn01_admintools_log_logdate_reason` (`logdate`,`reason`), is repeated: simply delete it and then run the SQL query in your database administration tool (such as phpMyAdmin). That will do the trick.

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.