3.22 Update: Unknown column 'extra_query'

[Redundant]

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]

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]

Also, and more alarmingly, this is what I get now when I try to add a new article (attached). Yikes. Help?

[iextensions]

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]

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]

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]

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

[baterfly]

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

[Redundant]

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]

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

[vickyro]

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

[razor7]

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!

[CroVV]

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]

iextensions

How can I disable the extension of that table

[couchsurfer]

THANX, it rocks!

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]

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]

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]

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.

[denuwan]

Thanks! This works

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]

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]

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