3.22 Update: Unknown column 'extra_query'

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
Redundant
Joomla! Intern
Joomla! Intern
Posts: 69
Joined: Fri Feb 02, 2007 5:37 am

3.22 Update: Unknown column 'extra_query'

Post by Redundant » Thu Feb 06, 2014 5:47 pm

When auto updating to 3.2.2, the result reported this error:

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

System seems OK. Any recommendation ?

 
baterfly
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sun Jul 23, 2006 7:39 am

Re: 3.22 Update: Unknown column 'extra_query'

Post by baterfly » Fri Feb 07, 2014 3:33 am

Having the same issue.

Also, before that, when update to 3.2.2 completed, the following error message came up:

1062 - Duplicate entry '437' for key 'PRIMARY' SQL=INSERT INTO `u9wkx_extensions` (`extension_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `system_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES (437, 'plg_quickicon_joomlaupdate', 'plugin', 'joomlaupdate', 'quickicon', 0, 1, 1, 1, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0), (438, 'plg_quickicon_extensionupdate', 'plugin', 'extensionupdate', 'quickicon', 0, 1, 1, 1, '', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0);

baterfly
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sun Jul 23, 2006 7:39 am

Re: 3.22 Update: Unknown column 'extra_query'

Post by baterfly » Fri Feb 07, 2014 3:38 am

Also, and more alarmingly, this is what I get now when I try to add a new article (attached). Yikes. Help?
You do not have the required permissions to view the files attached to this post.

iextensions
I've been banned!
Posts: 1498
Joined: Fri Jul 12, 2013 5:37 pm
Contact:

Re: 3.22 Update: Unknown column 'extra_query'

Post by iextensions » Fri Feb 07, 2014 5:11 am

you can do this:
- disable the extension of that table
- login back-end/ extensions/ tab database/ click Fix button
I think it can help.

Todecay
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Nov 03, 2010 12:40 pm

Re: 3.22 Update: Unknown column 'extra_query'

Post by Todecay » Fri Feb 07, 2014 5:12 am

Same issue here, right after update (uploading package via ftp):

Code: Select all

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

baterfly
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sun Jul 23, 2006 7:39 am

Re: 3.22 Update: Unknown column 'extra_query'

Post by baterfly » Fri Feb 07, 2014 5:50 am

Thank you iextensions - database fix seems to have worked, and now site can check for updates again.

However, still having the issue as per posted screenshot when I go to add a new article. Don't know what to do.

jtarin
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu May 10, 2007 10:58 pm

Re: 3.22 Update: Unknown column 'extra_query'

Post by jtarin » Fri Feb 07, 2014 6:00 am

Thank you iextensions.......for pointing that out. One more lesson learned. Isn't Joomla wonderful....sometimes. :p

baterfly
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Sun Jul 23, 2006 7:39 am

Re: 3.22 Update: Unknown column 'extra_query'

Post by baterfly » Fri Feb 07, 2014 6:37 am

I'll take my problem to a new topic, as the original topic here appears to be solved. Thanks.

Redundant
Joomla! Intern
Joomla! Intern
Posts: 69
Joined: Fri Feb 02, 2007 5:37 am

Re: 3.22 Update: Unknown column 'extra_query'

Post by Redundant » Fri Feb 07, 2014 1:45 pm

iextensions wrote:you can do this:
- disable the extension of that table
- login back-end/ extensions/ tab database/ click Fix button
I think it can help.
Thank you

NickC4555
Joomla! Explorer
Joomla! Explorer
Posts: 457
Joined: Sun Jan 30, 2011 10:09 am
Location: Leicester, UK

Re: 3.22 Update: Unknown column 'extra_query'

Post by NickC4555 » Fri Feb 07, 2014 5:35 pm

I had the same error after the upgrade froze. Fixing the database solved it.

User avatar
vickyro
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Sat Oct 30, 2010 4:52 pm
Location: Alba Iulia
Contact:

Re: 3.22 Update: Unknown column 'extra_query'

Post by vickyro » Sat Feb 22, 2014 4:40 pm

Thank you for help. After updating the database, everything seems to be ok. No errors. Joomla is updated.

User avatar
razor7
Joomla! Explorer
Joomla! Explorer
Posts: 340
Joined: Wed Aug 24, 2005 2:06 pm
Location: Argentina
Contact:

Re: 3.22 Update: Unknown column 'extra_query'

Post by razor7 » Thu Mar 13, 2014 12:41 pm

iextensions wrote:you can do this:
- disable the extension of that table
- login back-end/ extensions/ tab database/ click Fix button
I think it can help.
Fixed it!
Visit http://www.mgscreativa.com

Take a look at our downloads section for VirtueMart payment plugins and mouch more! http://www.mgscreativa.com/contenidos/i ... Itemid=214

CroVV
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Thu Feb 04, 2010 6:47 pm

Re: 3.22 Update: Unknown column 'extra_query'

Post by CroVV » Sun Mar 23, 2014 4:33 pm

iextensions wrote:you can do this:
- disable the extension of that table
- login back-end/ extensions/ tab database/ click Fix button
I think it can help.
THANKS...

kpanagoulis
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Fri Jul 08, 2011 7:13 am

Re: 3.22 Update: Unknown column 'extra_query'

Post by kpanagoulis » Thu Apr 03, 2014 7:14 pm

iextensions

How can I disable the extension of that table

couchsurfer
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sat May 17, 2014 8:31 am

Re: 3.22 Update: Unknown column 'extra_query'

Post by couchsurfer » Sat May 17, 2014 8:33 am

THANX, it rocks!


iextensions wrote:you can do this:
- disable the extension of that table
- login back-end/ extensions/ tab database/ click Fix button
I think it can help.

cmscoding
I've been banned!
Posts: 46
Joined: Wed Feb 26, 2014 8:58 am
Contact:

Re: 3.22 Update: Unknown column 'extra_query'

Post by cmscoding » Sat May 17, 2014 8:43 am

kpanagoulis wrote:iextensions

How can I disable the extension of that table
you can login phpmyadmin, select table "extension" in your database.
Search your extension and change field "enable" from 1 to 0

marie_t
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon May 26, 2014 4:45 pm

Re: 3.22 Update: Unknown column 'extra_query'

Post by marie_t » Mon May 26, 2014 4:58 pm

you can login phpmyadmin, select table "extension" in your database.
Search your extension and change field "enable" from 1 to 0
sorry but couldn't get which table and field I need exactly. I have exactly the same issue as the topicstarter, so could you please explain it a little bit more in detail
UPD. I don't have any fix button here, just the liest of errors.. should I correct all of them by myself?

sovainfo
Joomla! Exemplar
Joomla! Exemplar
Posts: 8808
Joined: Sat Oct 01, 2011 7:06 pm

Re: 3.22 Update: Unknown column 'extra_query'

Post by sovainfo » Mon May 26, 2014 5:48 pm

The tables in your database start with a prefix determined at installation. You can go to Global configuration and find the prefix in use at the database section on the server tab. The table you need is prefix_entensions replacing prefix for the prefix you found in Global configuration. The column is `enabled`, the 7th column in the table. Set its value from 1 to 0. 1 meaning enabled, 0 meaning disabled.
Issue with migrating? Include logs/joomla_update.php in your report!
Blank screen? Verify pagesource for HTML code (javascript error)
Installation failing on populating database? Install with set_time_limit(0)
Document your customizations!

User avatar
denuwan
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Feb 02, 2011 5:59 am
Location: Colombo
Contact:

Re: 3.22 Update: Unknown column 'extra_query'

Post by denuwan » Tue Oct 14, 2014 9:37 am

Thanks! This works
iextensions wrote:you can do this:
- disable the extension of that table
- login back-end/ extensions/ tab database/ click Fix button
I think it can help.

HUN
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed May 06, 2015 8:32 am

Re: 3.22 Update: Unknown column 'extra_query'

Post by HUN » Wed May 06, 2015 8:58 am

Ok.
 It is located in the 'extra_query' names in the column names joom_update_sites table.
Therefore, the Joomla does not recognize the upgrade.

Solution that works for me:

I entered my phpMyAdmin hosting service.
The database located the xxx_update_sites (joom_update_sites) plate and inserting the end => extra_query column. It was missing before.
Joomla is now recognized by the update and it works.

jlservices
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Oct 05, 2006 4:31 pm

Re: 3.22 Update: Unknown column 'extra_query'

Post by jlservices » Sat May 30, 2015 7:26 am

cmscoding wrote:
kpanagoulis wrote:iextensions

How can I disable the extension of that table
you can login phpmyadmin, select table "extension" in your database.
Search your extension and change field "enable" from 1 to 0

Thank You!!!
I solved the update issue... but i didn't understand if I have to re-enable the "extensions" table...
Shall I?

Luca

 

Locked

Return to “Migrating and Upgrading to Joomla! 3.x”