Support

Akeeba Backup for Joomla!

#40943 DB error when installing a backup

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
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

Joomla! version
4.4.2
PHP version
7.4
Akeeba Backup version
9.9.4

Latest post by webfeuerflo on Monday, 22 July 2024 03:35 CDT

webfeuerflo

EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 10MiB, please upload it on your server and post a link to it.

 

I created a a backup and when I try to install it locally on MAMP, I get this error. How can I fix this?

 

 

Database error processing line 532

Database server error reply:

ErrNo #1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PAGE_CHECKSUM=1' at line 14
 SQL=CREATE TABLE `bp_ftcontact_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `form_type` tinyint(1) NOT NULL,
  `content` longtext NOT NULL,
  `extras` longtext NOT NULL,
  `config` longtext NOT NULL,
  `wizardcode` longtext NOT NULL,
  `events_actions_map` longtext NOT NULL,
  `params` longtext NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 1,
  `app` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1

Raw query text:

CREATE TABLE `bp_ftcontact_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `form_type` tinyint(1) NOT NULL,
  `content` longtext NOT NULL,
  `extras` longtext NOT NULL,
  `config` longtext NOT NULL,
  `wizardcode` longtext NOT NULL,
  `events_actions_map` longtext NOT NULL,
  `params` longtext NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 1,
  `app` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1

tampe125
Akeeba Staff

Hello,

this happens because you're trying to restore from a MariaDB database to a MySQL. They have a close structure and logic (if I remember correctly it's the same guy that invented both), but it's not exactly the same. 

We can create a workaround for that, but it will need some time. In the meantime, you can change all the files inside the folder installation/sql and remove the string PAGE_CHECKSUM=1

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!

tampe125
Akeeba Staff

Hello,

we just created a dev release that should work around this issue. Please install the latest dev release (https://www.akeeba.com/download/akeebabackuppro-dev.html ), take a new backup and try to restore it. That should fix your issue

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!

webfeuerflo

great, 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!