Akeeba Backup for Joomla!

Friday, 24 May 2019 17:20 CDT

dwreski

Hi,

I started to notice the size of the daily backups was increasing by five or six megs each day. I also today received an email stating the backup didn't succeed, although it was successfully uploaded to S3 and there was no indication in the akeeba.cli log (backup run from cron).

After attempting to restore the backup, it failed with dozens of "duplicate entry" messages. I've attached a screenshot.

We're using jinbound to manage the landing pages with call-to-action submission forms. Is this a problem with their plugin?

I've uploaded a copy of our daily backup log, with company name changed to "example.com"

Saturday, 25 May 2019 12:52 CDT

nicholas

Before answering that question I need to know what was your choice during restoration about existing tables: did you use Drop or Backup? If it's Drop then yes, that would be a problem with their plugin creating duplicate records which is a bit weird considering that MySQL should have cried bloody murder when that happened.

If it's Backup (or you have another site's or an older site's tables in the same database) then the problem is with the plugin using a primary key name which does not use the prefix of the database, meaning that now we have two tables sharing the same primary key. A solution to that problem is dropping the tables of the other site or using a different database.

Moreover, another solution is trying to use the "Use REPLACE instead of INSERT" option during restoration. This will try to restore the data in a way that is not affected by duplicate keys.

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!

Saturday, 25 May 2019 13:14 CDT

dwreski

Thanks so much for your help. Using REPLACE instead of INSERT appears to have fixed it.

I've also opened a ticket with jinbound to determine why there are so many entries in that table and why there are duplicates.

Monday, 27 May 2019 00:45 CDT

nicholas

You're welcome!

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!

Monday, 22 July 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-07-22 17:17 CDT

Support