Support

Site Restoration

#31004 Error while trying to install database

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 Delemo on Thursday, 28 February 2019 05:36 CST

Wednesday, 27 February 2019 11:10 CST

Delemo
Hello,

While trying to restore a backup, from a local MAMP to a hosted remote server, I'm getting an error when it comes to install the database tables.

The error is the following:

SQL query:

ALTER TABLE `e75ud_akeeba_common`
ADD PRIMARY KEY (`key`)

MySQL said:
#1071 - Specified key was too long; max key length is 767 bytes

I'm getting this error when doing a restoration with Kickstart.
I've tried to manually install the database (with phpMyAdmin) and got the same error.

What is wrong with my remote server?

Thank you

Thursday, 28 February 2019 03:03 CST

tampe125
Hello,

we are aware of this bug, we already fixed it and it will be included in the next version.
For the immediate: latest versions of ANGIE have an option to ignore database errors. While restoring the database, please double check that the options Stop on CREATE errors and Stop on other errors aren't selected.
Then restore as usual. At the end of the restoration a summary of all the errors occurred will be displayed. If the only affected table is the #__akeeba_common, you can safely ignore everything and complete the restoration.

When your site is ready, simply install Akeeba Backup again (no need to uninstall it).
The #__akeeba_common table is used to track down library dependencies between Akeeba software, so it's not super critical for your site. Once the site is restored, re-installing Akeeba Backup will recreate the table.

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!

Thursday, 28 February 2019 04:26 CST

Delemo
Hello Davide,

Thank you for your support.

OK, I'm waiting for the new release of Akeeba Backup.

I have another related question.
What about UNITE.

In fact, my attempt with standard Kickstart restoration process, was a check to try to find why restoration with UNITE was failed.
Is there a way in UNITE to bypass errors as you explained?

Thank you

Thursday, 28 February 2019 05:23 CST

tampe125
I'm sorry but currently it's not possible to pass those options while performing a restoration with UNiTE.
We will try to implement them, but it will take some time.

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!

Thursday, 28 February 2019 05:36 CST

Delemo
Thank you gor your reply

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!