I have a new Joomla installation with this error:

1054 Unknown column 'extra_query' in 'field list' SQL=SELECT DISTINCT update_site_id, type, location, last_check_timestamp, extra_query FROM no3a2_update_sites WHERE enabled = 1

The error is displayed when I want to open my template settings. The template is from RocketTheme.

What can I do?


You give very little information to give a good answer, but there are a couple of things you can try:

  • Make sure both Joomla and your template is up to date
  • Re-upload your template if possible
  • Fix your database by going to Extension manager -> Database, and click the Fix button in the upper left corner

Fix Database

  • can anyone tell me from which joomla version "extra_query" column added to the core table update_sites ? – dev-m Mar 10 '17 at 12:40

The error is saying that your no3a2_update_sites table don't contain any column named extra_query which might be used some where in your template.You can either create that column in your database to temporarily avoid it or try reinstalling the template.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.