Support

Admin Tools

#35323 News for ticket #35308 – Unable to use auto update

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 on Thursday, 01 July 2021 20:17 CDT

toonetcreation

Hi,

Just a quick feedback regarding ticket #35308 – Unable to use auto update

Works fine now, after following your procedure : removing and adding again update ID number.

So as I have many websites to manage, do I need to do the same manually on each website or can I do it programmatically for all websites?

Thanks

L.

nicholas
Akeeba Staff
Manager

Well, you can do that programmatically. That's what the interface does — it's just code, not magic :)

You need to modify the #__update_sites table and set the extra_query column to dlid=YOUR_DOWNLOAD_ID  for the records that have to do with our software that has Professional editions (Admin Tools, Akeeba Backup or Akeeba Ticket System).

You can use the SQL query below, as long as you replace two things:

  • CHANGEME_ is the table name prefix of your site. Look in configuration.php, it's state in the $prefix line. Do not forget the trailing underscore.
  • YOUR_DOWNLOAD_ID is your Download ID. If you are using an Add-on Download ID replace : with %3A. For example, the add-on download ID 123:abcdef01234567890abcdef01234567890 becomes 123%3Aabcdef01234567890abcdef01234567890
UPDATE `CHANGEME_update_sites`
SET `extra_query` = "dlid=YOUR_DOWNLOAD_ID"
WHERE `update_site_id` IN (
    SELECT `update_site_id`
    FROM `CHANGEME_update_sites_extensions`
    WHERE `extension_id` IN (
        SELECT `extension_id` FROM `CHANGEME_extensions`
        WHERE `type` = 'package' AND `element` IN (
           'pkg_akeeba', 'pkg_admintools', 'pkg_ats'
          )
    )
)

I am not convinced that for real world use this is any faster than going through the interface.

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!

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.

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!