Support

Site Restoration

#42156 ERROR AT BEGINNING OF RESTORE

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
8.3
CMS Type
Joomla!
CMS Version
5.2.3
Backup Tool Version
10.0.0.5
Kickstart version
8.0.6

Latest post by nicholas on Wednesday, 30 July 2025 02:43 CDT

qivic
Restoration Halted and Will Resume Automatically

The database restoration has been halted because an error was detected. However, the restoration script will attempt to resume the process. If you do not want to resume the restoration please click the Cancel button below.

Restoration will resume in 2 seconds

For your information, the last error message was:

The error received was:

Database error processing line 31

Database server error reply:

ErrNo #1273
Unknown collation: 'utf8mb3_uca1400_ai_ci'

Raw query text:

CREATE TABLE `rjjda_djimageslider` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `catid` int(10) unsigned NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL DEFAULT '',
  `image` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `checked_out` int(10) unsigned NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT 0,
  `params` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`,`published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci
Debug information

nicholas
Akeeba Staff
Manager

Try the following configuration changes in the right hand side of the database restoration page (SCREEN4 in your screenshot):

  • Force UTF-8 collation on database: Yes
  • Force UTF-8 collation on tables: Yes
  • Normalise character set: Yes

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!