Admin Tools

#28532 IP white list: Record ID=0 when making a new entry

Posted in ‘Admin Tools 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

n/a

PHP version

n/a

Admin Tools version

n/a

Latest post by kuk on Thursday, 28 September 2017 06:06 CDT

Thursday, 28 September 2017 02:57 CDT

kuk

Making a new entry in the Admin IP White list creates an record with ID = 0 in database. This causes an MySQL error (= duplicate entry 0 with id) when trying to make a new one.

I have this the first time. I am not sure if this has something to do with J 3.8 which causes a lot of other issues.

I could fix it by changing the record ID in database directly but this is not a practical solution. Any ideas what's going wrong?

Thursday, 28 September 2017 03:39 CDT

tampe125

Hello,

this is not caused by Admin Tools, this is an issue with your database, which allows the value 0 for primary keys.
You should get in touch with your host and ask him to take a look at the option NO_AUTO_VALUE_ON_ZERO of their MySQL installation.

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 September 2017 06:06 CDT

kuk

Sorry, I do not believe this. Reason: I have exactly the same website for testing. Same conditions in PHP in MySQL. With one exception: it runs with Joomla 3.7.5 instead of 3.8

Here I do not have this issue.

Anyway I tried it - set this SQL mode and restarted MySQL. The issue keeps the same. :(

Solution: I checked the table structure for adminiplist. The flag for AUTO_INCREMENT wasn't set. Why? No idea. The Joomla 3.7.5 website still has it.

Edited by kuk on 2017-09-28 06:46 CDT

Support