Support

Akeeba Backup for Joomla!

#21536 1054 Unknown column 'update_site_id' in 'field list' SQL=SELECT update_site_id FROM ig2np_update_sites WHERE location = 'http://cdn.akeebabackup.com/updates/abpro.xml'

Posted in ‘Akeeba Backup 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
Akeeba Backup version
n/a

Latest post by tampe125 on Tuesday, 25 November 2014 09:49 CST

Tuesday, 25 November 2014 08:26 CST

user85619
Description of my issue:
Unable to re-install the com_akeeba-revBF1A2B8-pro
as nothing works and not able to connect to my Akkeba control panel.

Whant can I do with this error:
1054 Unknown column 'update_site_id' in 'field list' SQL=SELECT update_site_id FROM ig2np_update_sites WHERE location = 'http://cdn.akeebabackup.com/updates/abpro.xml'

Thakns for your good product

Pierre

Tuesday, 25 November 2014 08:56 CST

tampe125
Hello Pierre,

most likely a core Joomla table is missing a column.
You can repair your database visiting the page Extension Manager -> Database -> Fix database

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!

Tuesday, 25 November 2014 09:11 CST

user85619
Thank you for your fast reply.
I did what you recommended. Unfortunately, it doesn't work : the database appears as corect and no repair is available.
I agree : it lookks like a Joomla's problem...

BEst regards
Pierre

Tuesday, 25 November 2014 09:13 CST

tampe125
Do you have cache enabled on your site?
Can you please try to clear Joomla cache and check again?

Which version of PHP and Joomla are you currently using?

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!

Edited by tampe125 on 2014-11-25 09:16 CST

Tuesday, 25 November 2014 09:22 CST

user85619
Cache was disabled.
Nothing to clear.

Thnaks for your help, but as the site wasn't completed, I did another installation and Content sql import.
Not very glorious, but a safe Joomla and Akkeba component working... (:

Best regards

Tuesday, 25 November 2014 09:49 CST

tampe125
I'm glad you solved your issue... in a way or another ;)

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!

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!