Support

Admin Tools

#24930 atpro.xml - why 2 ?!?

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 joomleb on Friday, 15 April 2016 13:50 CDT

joomleb
Hi guys,
looking in my joomla Extensions - Update Sites
I have listed two, apparently same, "Admin Tools Professional" atpro.xml files...

Is it right to have listed two times the "file" instead of one ?!?

nicholas
Akeeba Staff
Manager
No. It's due to a bug in Joomla!. I have seen that in older versions (around 3.3 or early 3.4). Sometimes Joomla! would create a new #__extensions table record for the updated version of a component (ANY component, not just ours!) it was installing, therefore creating a duplicate update record as well. Further to that, for reasons unknown Joomla! would sometimes create a new update site record when updating an extension if the URL was different.

Since we're aware of the duplicate update sites bugs in Joomla! we have code in our post-installation script which looks for duplicate update sites and remove them. However, to keep things safe, we only look for update sites assigned to the #__extensions table ID currently assigned by Joomla! to our extension. If Joomla! had created a duplicate update site under a different extension ID we cannot do anything about it.

Joomla! has similar bugs regarding administrator menu items (the entries under #__components). We are also aware of those and have code that works around them in our post-installation script.

The biggest irony of it all is that our master post-installation script is part of Joomla! since over a year ago as Joomla! includes our FOF framework. The same, of course, goes for our update sites management helper which is used by our installation scripts to refresh the update sites records despite Joomla! bugs.

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!

joomleb
Hi Nicholas,

many thanks for your reply.
Following your words I tried to take a look, but unfortunately I'm not a programmer.

Please, Can you help me ?
Do you need a Super Admin access to my live site and/or to phpMyAdmin ?
Can be anything related to when I ugraded from Admin Tools Core to Professional ?

Do have I to delete the oldest one ?

...and Many Thanks for support to help me on understanding

nicholas
Akeeba Staff
Manager
Unfortunately there is no user interface to remove double entries from Joomla!. When I contributed the Update Sites page of the Extensions Manager they asked me specifically to not include a Delete button. Indeed, that could be just as dangerous as it is useful in cases like yours.

The only way to fix that is through the database. You need to first get a backup of your site just in case :) Then open the #__update_sites table with phpMyAdmin (available through your hosting control panel) and delete the two rows which have a location of "http://cdn.akeebabackup.com/updates/atpro.xml".

Now download Admin Tools from our site and install it without uninstalling the existing version before. The update site should be reinstalled without a duplicate entry.

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!

joomleb
Hi Nicholas,
many thanks for the instructions, if I'm right the tables where to erase the rows are two:
#__update_sites
#__update_sites_extensions

Please, Can you confirm me ?

nicholas
Akeeba Staff
Manager
Confirmed.

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!

joomleb
Hi Nicholas,
done, all seem to be Okay now... many thanks for support

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!