Akeeba Backup for WordPress

#29912 Creating New Profiles - ID error

Posted in ‘Akeeba Backup for WordPress’
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

WordPress version
PHP version
Akeeba Backup version

Latest post by syeduk on Saturday, 07 July 2018 16:32 CDT

So this ticket is more of a bug notification and info for others searching the tickets like me.

I encountered an issue when I first installed Akeeba Backup for WP on two sites yesterday. It seems that when you create a new profile, Akeeba assigns them the ID "0", always.

The problem of course is that:
a) After the profile is created, you can't actually customise it. When you try to switch profiles, it keeps redirecting back to profile 1 (i.e. the Default Profile). I assume that's because of some logic that says "1" should be the lowest ID

b) You can't create another profile. So after the first profile you create is assigned the ID "0", when you try to create another profile, which is also given the ID "0", the database kicks up a "Not allowed to have duplicate ID" error.

My fix was to manually edit the profile IDs in MySQL (table name is something like akeeba_profiles). Once updates, normal functionality returns.

Perhaps a hotfix is needed?

Akeeba Staff

this problem is caused by your database setup.
Your MySQL database is configured to allow the 0 value for a primary key: instead of generating a new auto increment ID; it will accept the 0 value.
This behavior is caused by the option NO_AUTO_VALUE_ON_ZERO. You should contact your host and ask him to disable such option, since it will break several plugins.

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!

Ah that makes sense...and solves the issue. Thanks!

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!