Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Need help with the Administration of your Joomla! 3.x site? This is the spot for you.

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.
Post Reply
sylwekb
Joomla! Explorer
Joomla! Explorer
Posts: 327
Joined: Mon Mar 14, 2011 5:08 pm

Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by sylwekb » Tue Mar 29, 2022 6:07 pm

Hallo
After update Joomla 3.10.6 to 3.10.7

1054 Unknown column 'authProvider' in 'field list'

an error appears in the administration panel. The front page works. What is the cause and how can I fix it? I can't do anything in the admin panel.

Thanks

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41507
Joined: Sat Apr 05, 2008 9:58 pm

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by Webdongle » Tue Mar 29, 2022 7:12 pm

Replace the broken site with the backup you made before updating.
Also please https://forumpostassistant.github.io/docs/
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

sylwekb
Joomla! Explorer
Joomla! Explorer
Posts: 327
Joined: Mon Mar 14, 2011 5:08 pm

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by sylwekb » Tue Mar 29, 2022 7:19 pm

Restoring from backup is not a problem but I would like to know why this error appeared in the admin panel after updating to the latest Joomla version? So far I have updated and there has never been a problem.

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41507
Joined: Sat Apr 05, 2008 9:58 pm

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by Webdongle » Tue Mar 29, 2022 7:37 pm

When you restore from backup and post the results of the fpa then we can look to see what might have caused the problem.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 12009
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by sozzled » Tue Mar 29, 2022 8:05 pm

I haven't seen any mention of any "Unknown column 'authProvider' in 'field list'" in J! 3.10; I probably won't encounter this situation any time soon but, then again, I haven't updated any of my J! 3.10.6 websites to J! 3.10.7 yet.

sylwekb wrote:
Tue Mar 29, 2022 6:07 pm
After update Joomla 3.10.6 to 3.10.7 ... an error appears in the administration panel.
This begs the question, did this error occur with J! 3.10.6? I agree with @Webdongle that it would be best to "roll back" the update—delete the J! 3.10.7 file system and restore the website from the backup that you took before you updated—and see if this "unknown column" error occurs in J! 3.10.6. If the error does not occur in J! 3.10.6 then you may have found a bug in J! 3.10.7.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

bardamenas
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Sat Oct 03, 2009 5:32 pm

Unknown column 'authProvider' in 'field list' after update to 3.10.7

Post by bardamenas » Tue Mar 29, 2022 8:27 pm

I just upgraded to version 3.10.7 from 3.10.6 and got the same problem ... :'( How fix...
You do not have the required permissions to view the files attached to this post.
Last edited by toivo on Tue Mar 29, 2022 8:53 pm, edited 1 time in total.
Reason: mod note: split from someone else's topic - please create your own topics in the future!

csolisblandon
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu Feb 12, 2009 6:01 pm

Error after update

Post by csolisblandon » Tue Mar 29, 2022 8:31 pm

Hello Community,

Need your support after update a couple of websites, I received this error:

An error has occurred.
1054 Unknown column 'authProvider' in 'field list'


This happened on version 4.1.10 to 4.1.1 and 3.10.6 to 3.10.7

My admin is not accesible

Need your help with issue

Thanks
Last edited by toivo on Wed Mar 30, 2022 3:39 am, edited 1 time in total.
Reason: mod note: merged with the current topic

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41507
Joined: Sat Apr 05, 2008 9:58 pm

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by Webdongle » Tue Mar 29, 2022 8:37 pm

Best guess, until sylwekb posts the fpa repport, login issue 3rd party extension or ftp layer activated?
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

fr56
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Thu Mar 13, 2014 9:59 am

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by fr56 » Tue Mar 29, 2022 8:38 pm

I see the same error message, but on Joomla 4, when updating from 4.1.0 to Joomla 4.1.1. Could this be something common for both of today's releases? The bug only occurs when trying to login on frontend, the backend is ok. I have not seen this when updating from 3.10.6 to 3.10.7, and I have never seen this bug before on 3.10.6 or 4.1.0.

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 12009
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by sozzled » Tue Mar 29, 2022 8:48 pm

Just saw this tweet from @mbabker:
mb_j411-tweet.jpg
:-\

Relevance: J! authentication plugin(s) used with logging in.
You do not have the required permissions to view the files attached to this post.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

User avatar
Rondeb
Joomla! Explorer
Joomla! Explorer
Posts: 362
Joined: Mon Dec 02, 2013 12:14 pm
Location: Meschede - Germany
Contact:

Re: Error after update

Post by Rondeb » Tue Mar 29, 2022 8:50 pm

Hi,

read this.
https://www.akeeba.com/news/1750-do-not ... dates.html

Maybe is that the problem :(

Regards Ron

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41507
Joined: Sat Apr 05, 2008 9:58 pm

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by Webdongle » Tue Mar 29, 2022 9:21 pm

Updated 4 sites no problem. So why are some sites breaking? 3rd party extensions with logins that are clashing with Joomla authorisation?
Last edited by Webdongle on Tue Mar 29, 2022 9:40 pm, edited 1 time in total.
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

bardamenas
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Sat Oct 03, 2009 5:32 pm

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by bardamenas » Tue Mar 29, 2022 9:31 pm

Webdongle wrote:
Tue Mar 29, 2022 9:21 pm
Updated 3 sites no problem. So why are some sites breaking? 3rd party extensions with logins that are clashing with Joomla authorisation?
2 site update - ok, but 1 - no...
All update 3.10.6 to 3.10.7...

cocacolacowboys
Joomla! Apprentice
Joomla! Apprentice
Posts: 43
Joined: Sun Jun 13, 2010 8:54 pm

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by cocacolacowboys » Tue Mar 29, 2022 9:39 pm

So strange cause I can not update at all. I got the message You have already the latest version... and this is 3.10.6. Maybe I should be happy cause I can still use backend without problem...

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 12009
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by sozzled » Tue Mar 29, 2022 9:42 pm

See discussion(s): viewtopic.php?f=9&t=992880 and viewtopic.php?f=9&t=992878. The updates contain errors that break J! websites. Fortunately for me, I haven't updated any of my J! 3.10.6 websites and I've only updated one disposable test J! 4.1.0 website.

The fix—for the present—is to DROP your existing database tables, delete the existing J! files and restore both of them from the backup you made before you updated.
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

csolisblandon
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu Feb 12, 2009 6:01 pm

Re: Error after update

Post by csolisblandon » Tue Mar 29, 2022 11:36 pm

Thank you,

Let me try

User avatar
sozzled
Joomla! Master
Joomla! Master
Posts: 12009
Joined: Sun Jul 05, 2009 3:30 am
Location: Canberra, Australia

An error has occurred. 1054 Unknown column 'authProvider' in 'field list'

Post by sozzled » Wed Mar 30, 2022 12:37 am

csolisblandon wrote:
Tue Mar 29, 2022 8:31 pm
An error has occurred.
1054 Unknown column 'authProvider' in 'field list'


This happened on version 4.1.10 to 4.1.1 and 3.10.6 to 3.10.7
J! 4.1.1 and J! 3.10.7 are buggy. Do not use these releases. This issue has been discussed
  1. viewtopic.php?f=708&p=3656641
  2. viewtopic.php?f=9&t=992878
  3. viewtopic.php?f=9&t=992880#p3656630
“If you think I’m wrong then say, ‘I think you’re wrong.’ If you say ‘You’re wrong!’, how do you know?” :)

pilotgta
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Mar 30, 2022 1:05 am

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by pilotgta » Wed Mar 30, 2022 1:23 am

Hello from Moscow! I got this problem after updating today. From the backup, I replaced only two folders on the server.
1. The src folder in the libraries directory
2. plugins folder
Login to the admin panel has been restored, the version shows Joomla! 3.10.6
I didn't delete the database table
Good mood friends!

sylwekb
Joomla! Explorer
Joomla! Explorer
Posts: 327
Joined: Mon Mar 14, 2011 5:08 pm

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by sylwekb » Wed Mar 30, 2022 8:27 am

For me, everything works after restoring all subfolders in libraries/src from a copy

fpa bottom
Forum Post Assistant (v1.6.5) : 30-Mar-2022 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.10.6-Stable (Daraja) 12-February-2022
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.10.6: Yes | Database Supports J! 3.10.6: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.10.0-962.3.2.lve1.5.64.el7.x86_64 | Technology: x86_64 | Web Server: LiteSpeed | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 370.00 GiB |

PHP Configuration :: Version: 5.6.40 | PHP API: litespeed | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 0 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 128M | Max. POST Size: 128M | Max. Input Time: -1 | Max. Execution Time: 180 | Memory Limit: 128M

Database Configuration :: Version: 10.4.24-MariaDB-cll-lve (Client:10.4.24) | Database Size: 89.81 MiB | #of Tables with config prefix: 139 | #of other Tables: 223 | User Privileges : GRANT SELECTUser Privileges : INSERTUser Privileges : UPDATEUser Privileges : DELETEUser Privileges : CREATEUser Privileges : DROPUser Privileges : REFERENCESUser Privileges : INDEXUser Privileges : ALTERUser Privileges : CREATE TEMPORARY TABLESUser Privileges : LOCK TABLESUser Privileges : EXECUTEUser Privileges : CREATE VIEWUser Privileges : SHOW VIEWUser Privileges : CREATE ROUTINEUser Privileges : ALTER ROUTINEUser Privileges : EVENTUser Privileges : TRIGGER
Detailed Environment :: wrote:PHP Extensions :: Core (5.6.40) | date (5.6.40) | ereg () | libxml () | openssl () | pcre () | sqlite3 (0.7-dev) | zlib (2.0) | bz2 () | calendar () | ctype () | curl () | hash (1.0) | filter (0.11.0) | ftp () | gettext () | gmp () | SPL (0.2) | iconv () | pcntl () | readline (5.6.40) | Reflection ($Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $) | session () | standard (5.6.40) | shmop () | SimpleXML (0.1) | mbstring () | tokenizer (0.1) | xml () | litespeed () | bcmath () | bz2_filter (0.1) | dom (20031129) | enchant (1.1.0) | fileinfo (1.0.5) | gd () | geoip (1.0.8) | imagick (3.5.1) | imap () | intl (1.1.0) | json (1.2.1) | ldap () | sockets () | libevent (0.1.0) | exif (1.4 $Id: cad29b729548e4206f0697710cc9e177f26fdff3 $) | mcrypt () | mssql () | mysql (1.0) | mysqli (0.1) | mysqlnd (mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $) | ncurses (1.0.2) | oci8 (2.0.12) | odbc (1.0) | PDO (1.0.4dev) | pdo_dblib (1.0.1) | pdo_mysql (1.0.2) | PDO_ODBC (1.0.1) | pdo_pgsql (1.0.2) | pdo_sqlite (1.0.1) | Phar (2.0.2) | pspell () | snmp (0.1) | soap () | tidy (2.0) | xmlreader (0.1) | xmlrpc (0.51) | xmlwriter (0.1) | xsl (0.1) | zip (1.12.5) | mhash () | ionCube Loader (11.0.0) | Zend OPcache (7.0.4-devFE) | Zend Guard Loader () | Zend Engine (2.6.0) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: No
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (---) |

Elevated Permissions (First 10) :: cache/0/ (775) | wacko__/_cache/config/ (777) | wacko__/_cache/feeds/ (777) | wacko__/_cache/pages/ (777) | wacko__/_cache/queries/ (777) | wacko__/_cache/templates/ (777) | wacko__/files/backup/ (777) | wacko__/files/global/ (777) | wacko__/files/perpage/ (777) | wacko__/xml/ (777) |
Database Information :: wrote:Database statistics :: Uptime: 13204 | Threads: 71 | Questions: 40207286 | Slow queries: 0 | Opens: 18236 | Flush tables: 1 | Open tables: 10000 | Queries per second avg: 3045.083 |
Extensions Discovered :: wrote:Components :: Site ::
Core :: com_wrapper (3.0.0) 1 | com_mailto (3.0.0) 1 |
3rd Party:: mybb (2.1.2) ? | joomla_int (2.1.2) ? | WF_SEARCHREPLACE_TITLE (2.6.24) ? | WF_FULLSCREEN_TITLE (2.6.24) ? | WF_BROWSER_TITLE (2.6.24) ? | WF_SOURCE_TITLE (2.6.24) ? | WF_AUTOSAVE_TITLE (2.6.24) ? | WF_KITCHENSINK_TITLE (2.6.24) ? | WF_STYLE_TITLE (2.6.24) ? | WF_ANCHOR_TITLE (2.6.24) ? | WF_LINK_TITLE (2.6.24) ? | WF_CHARMAP_TITLE (2.6.24) ? | WF_TABLE_TITLE (2.6.24) ? | WF_FONTSELECT_TITLE (2.6.24) ? | WF_CONTEXTMENU_TITLE (2.6.24) ? | WF_IMGMANAGER_TITLE (2.6.24) ? | WF_HR_TITLE (2.6.24) ? | WF_DIRECTIONALITY_TITLE (2.6.24) ? | WF_SPELLCHECKER_TITLE (2.6.24) ? | WF_ARTICLE_TITLE (2.6.24) ? | WF_NONBREAKING_TITLE (2.6.24) ? | WF_LISTS_TITLE (2.6.24) ? | WF_TEXTCASE_TITLE (2.6.24) ? | WF_INLINEPOPUPS_TITLE (2.6.24) ? | WF_FONTSIZESELECT_TITLE (2.6.24) ? | WF_MEDIA_TITLE (2.6.24) ? | WF_LAYER_TITLE (2.6.24) ? | WF_VISUALCHARS_TITLE (2.6.24) ? | WF_FONTCOLOR_TITLE (2.6.24) ? | WF_PREVIEW_TITLE (2.6.24) ? | WF_CLEANUP_TITLE (2.6.24) ? | WF_STYLESELECT_TITLE (2.6.24) ? | WF_PRINT_TITLE (2.6.24) ? | WF_FORMATSELECT_TITLE (2.6.24) ? | WF_VISUALBLOCKS_TITLE (2.6.24) ? | WF_XHTMLXTRAS_TITLE (2.6.24) ? | WF_EMOTIONS_TITLE (2.6.24) ? | WF_CLIPBOARD_TITLE (2.6.24) ? | WF_AGGREGATOR_VIMEO_TITLE (2.6.24) ? | WF_AGGREGATOR_VINE_TITLE (2.6.24) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.6.24) ? | WF_AGGREGATOR_[youtube]_TITLE (2.6.24) ? | WF_LINKS_JOOMLALINKS_TITLE (2.6.24) ? | WF_POPUPS_WINDOW_TITLE (2.6.24) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.6.24) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.6.24) ? | WF_LINK_SEARCH_TITLE (2.6.24) ? |

Components :: Admin ::
Core :: com_installer (3.0.0) 1 | com_categories (3.0.0) 1 | com_tags (3.1.0) 1 | com_redirect (3.0.0) 1 | com_media (3.0.0) 1 | com_languages (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_checkin (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_messages (3.0.0) 1 | com_search (3.0.0) 1 | com_privacy (3.9.0) 1 | com_ajax (3.2.0) 1 | com_cpanel (3.0.0) 1 | com_login (3.0.0) 1 | com_config (3.0.0) 1 | com_newsfeeds (3.0.0) 1 | com_plugins (3.0.0) 1 | com_content (3.0.0) 1 | com_templates (3.0.0) 1 | com_joomlaupdate (3.10.1) 1 | com_weblinks (3.9.0) 1 | com_cache (3.0.0) 1 | com_associations (3.7.0) 1 | com_finder (3.0.0) 1 | com_fields (3.7.0) 1 | com_banners (3.0.0) 1 | com_contenthistory (3.2.0) 1 | com_users (3.0.0) 1 | com_admin (3.0.0) 1 | com_modules (3.0.0) 1 | com_menus (3.0.0) 1 |
3rd Party:: COM_JEVENTS (3.6.30) 1 | jNews (8.3.1) 1 | jNews Content Bot (2.6) ? | jNews Forward to Friend (2.1) 1 | jNews Tag: Subscriber (2.1) 1 | jNews K2 Bot (2.1) ? | jNews Share Bot (2.1) ? | jNews Tag: Date and Time (2.1) 1 | jNews Module (2.0) 1 | jNews CB Plugin (1.1) ? | jNews Tag: Subscriptions (2.1) 1 | VirtueMart Products (2.1) ? | jNews User Synchronization (2.1) 1 | jNews-Virtuemart Newsletter Subscri (2.6) ? | jNews Tag: Site Links (2.1) 1 | com_jfusion (2.1.2) 1 | JoomGallery (3.3.4) 1 | JoomGallery pl-PL (3.1) ? | COM_JCE (2.6.24) 1 |

Modules :: Site ::
Core :: mod_articles_categories (3.0.0) 1 | mod_menu (3.0.0) 1 | Newsflash (1.5.0) ? | mod_custom (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_languages (3.5.0) 1 | Latest News (1.5.0) ? | mod_tags_similar (3.1.0) 1 | mod_login (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_weblinks (3.9.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_users_latest (3.0.0) 1 | Menu (1.5.0) ? | mod_articles_news (3.0.0) 1 | Archived Content (1.5.0) ? | mod_footer (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_search (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_stats (3.0.0) 1 | Most Read Content (1.5.0) ? | Poll (1.5.0) ? | mod_banners (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_random_image (3.0.0) 1 | Sections (1.5.0) ? |
3rd Party:: mod_joomsearch (3.0 BETA) 1 | JJ Shoutbox (8.1.10) 1 | JFusion Activity Module (2.1.2) 1 | mod_joomcat (3.0 BETA2) 1 | MOD_JEV_LATEST_EVENTS_TITLE (3.6.30) 1 | Communicator Subscribe Module (2.0.3) ? | MOD_JEV_FILTER_MODULE_TITLE (3.6.30) 1 | mod_jgtreeview (3.1 BETA) 1 | jNews Module (2.0) 1 | SmaHRSlide (1.3) 1 | MOD_FUOFB_XML_TITLE (1.5.0) 1 | MOD_JEV_SWITCH_VIEW_TITLE (3.6.30) 1 | Smaproof (1.1) 1 | mod_joomstats (3.0 BETA) 1 | MOD_JEV_CALENDAR_TITLE (3.6.30) 1 | Nurte Facebook Like Box Module (1.0.0.0) ? | JFusion User Activity Module (2.1.2) 1 | MOD_JEV_CUSTOM_MODULE_TITLE (3.6.30) 1 | JFusion Login Module (2.1.2) 1 | mod_joomimg (3.3.0) 1 | Newsletter Subscriber (1.4.21) 1 | JFusion Whos Online Module (2.1.2) 1 | MOD_JEV_LEGEND_TITLE (3.6.30) 1 |

Modules :: Admin ::
Core :: mod_popular (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_login (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_submenu (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_status (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_quickicon (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_title (3.0.0) 1 | mod_version (3.0.0) 1 |
3rd Party:: MOD_JEV_DASHBOARD_MODULE_TITLE (3.6.30) 1 |

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_system_sessiongc (3.8.6) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_weblinks (3.9.0) 0 | plg_system_cache (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_privacyconsent (3.9.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_p3p (3.0.0) 1 | plg_system_highlight (3.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_redirect (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_captcha_recaptcha (3.4.0) 1 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_extension_joomla (3.0.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_eos310 (3.10.0) ? | plg_fields_user (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_twofactorauth_totp (3.2.0) 0 | plg_finder_weblinks (3.9.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_ldap (3.0.0) 0 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_weblink (3.9.0) 0 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_search_weblinks (3.9.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_tags (3.0.0) 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_joomla (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_geshi (2.5.0) 0 | plg_content_fields (3.7.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_pagenavigation (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_vote (3.0.0) 1 |
3rd Party:: PLG_JOOMAUTOCAT (3.0) 0 | User - JFusion (2.1.2) 1 | jNews User Synchronization (2.1) 1 | jNews Content Bot (2.6) ? | jNews Forward to Friend (2.1) 1 | jNews Tag: Subscriber (2.1) 1 | jNews Share Bot (2.1) ? | jNews Tag: Date and Time (2.1) 1 | jNews Tag: Subscriptions (2.1) 1 | jNews Tag: Site Links (2.1) 1 | PLG_JOOMGALLERY_JOOMHIGHSLIDE (3.0) 0 | PLG_JOOMGALLERY_JOOMRECAPTCHA (2.0) 0 | PLG_JOOMGALLERY_JOOMLIGHTBOX2 (1.0) 0 | plg_joomgallery_joomphotoswipe (3.0 BETA) 0 | plg_joomgallery_joomlytebox (3.0) 0 | PLG_JOOMGALLERY_JOOMADDITIONALIMAGE (1.1) ? | PLG_JOOMGALLERY_JOOMPRETTYPHOTO (1.0) 0 | PLG_JOOMGALLERY_JOOMSHADOWBOX (3.0) 0 | plg_joomgallery_joomcolorbox (3.0) 0 | PLG_JOOMGALLERY_JOOMFANCYBOX (1.1) 0 | PLG_JOOMGALLERY_JOOMADDITIONALCATEG (1.1) ? | JoomGallery - Integrate RokBox (3.0) 0 | Xmap - JoomGallery Plugin (2.0) 0 | System - Cloudflare Universal SSL (1.1.0) 1 | plg_system_jce (2.6.24) 1 | PLG_SYSTEM_CIACHO (2.5.1) 1 | PLG_SYSTEM_GWEJSON (3.6.30) 1 | System - JFusion (2.1.2) 1 | PLG_SYSTEM_JQUERYEASY (2.2.0) 0 | PLG_SYSTEM_IMAGESIZER32FREE (3.2.4) 1 | plg_installer_jce (2.6.24) 1 | plg_installer_jeventsinstaller (3.6.30) 1 | plg_captcha_customrecaptcha (2.0.1) 0 | plg_extension_jce (2.6.24) 1 | JEvents - Action Log (3.6.30) 0 | plg_quickicon_jce (2.6.0-pro-bet) 1 | plg_quickicon_joomgallery (3.0) 1 | PLG_FINDER_JEVENTS (3.6.30) 0 | Authentication - JFusion (2.1.2) 1 | PLG_JOOMBU (3.2) 0 | plg_editors_jce (2.6.24) 1 | plg_editors_codemirror (5.60.0) 1 | plg_editors_tinymce (4.5.12) 1 | plg_search_joomgallery (3.1) 0 | PLG_JEV_SEARCH_TITLE (3.6.30) 0 | Search - JFusion (2.1.2) 1 | plg_content_jce (2.6.24) 1 | AllVideos (by JoomlaWorks) (6.1.0) 1 | AllVideos (by JoomlaWorks) (6.1.0) 1 | Content - Newsletter Subscriber (1.4.21) 0 | PLG_JEV_CORE_CONTENT_PLUGIN_TITLE (3.6.30) 1 | Content - JFusion Discussion Bot (2.1.2) 1 | PLG_JOOMPLU (3.1) 0 |
Templates Discovered :: wrote:Templates :: Site :: riders_v (1.1v) 1 | beez_20 (2.5.0) 1 | beez5 (2.5.0) 1 | riders (1.0) 1 | JA_Purity (1.2.0) ? | atomic (2.5.0) 1 | rhuk_milkyway (1.0.2) 1 | dd_motogarage_56 (1.0) 1 | beez3 (3.1.0) 1 | protostar (1.0) 1 |
Templates :: Admin :: bluestork (2.5.0) 1 | hathor (3.0.0) 1 | isis (1.0) 1 |
Last edited by toivo on Wed Mar 30, 2022 11:48 am, edited 1 time in total.
Reason: mod note: removed CODE tags, disabled smilies

prz24
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Mar 30, 2022 8:51 am

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by prz24 » Wed Mar 30, 2022 8:56 am

Go to your database with phpadmin.
Add a column to the table px_users, name authProvider, type Text
Then you'll acces your admin panel. Goto Extension - Database and fix the errors in the database structure.

sylwekb
Joomla! Explorer
Joomla! Explorer
Posts: 327
Joined: Mon Mar 14, 2011 5:08 pm

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by sylwekb » Wed Mar 30, 2022 9:02 am

I already have everything in order with the latest version of Joomla 3.10.7. The scheme of the base must be as shown in the screenshot.
You do not have the required permissions to view the files attached to this post.

jneub60
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Sun Nov 20, 2016 4:06 am

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by jneub60 » Wed Mar 30, 2022 6:48 pm

prz24 wrote:
Wed Mar 30, 2022 8:56 am
Go to your database with phpadmin.
Add a column to the table px_users, name authProvider, type Text
Then you'll acces your admin panel. Goto Extension - Database and fix the errors in the database structure.
Thanks prz24, this worked great for my one site that broke.

groovemaster
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Mar 31, 2016 6:39 pm

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by groovemaster » Wed Mar 30, 2022 8:00 pm

prz24 wrote:
Wed Mar 30, 2022 8:56 am
Go to your database with phpadmin.
Add a column to the table px_users, name authProvider, type Text
Then you'll acces your admin panel. Goto Extension - Database and fix the errors in the database structure.
This has been working, thank you.

User avatar
trogladyte
Joomla! Explorer
Joomla! Explorer
Posts: 485
Joined: Sat May 03, 2008 9:27 pm
Location: Phoenix, AZ
Contact:

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by trogladyte » Wed Mar 30, 2022 10:27 pm

Wow, what a disaster....

I tried following prz24's fix, but I'm not even a MySQL beginner. I tried:

ALTER TABLE <table_name>
ADD COLUMN authProvider TEXT;

but got the error #1067 - Invalid default value for 'registerDate'. I'd really appreciate some help. Only about 80 sites to fix......
Ian Shere - Phoenix Website Design & Hosting
http://www.citruskiwi.com
Certified Flight Instructor http://www.flygoodyear.com


suchymdt
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Mar 31, 2022 6:03 am

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by suchymdt » Thu Mar 31, 2022 6:07 am

just install Joomla! 3.10.7 to 3.10.8 Patch Package or Joomla! 3.10.x to 3.10.8 Patch Package and fix the problem ;)

User avatar
Webdongle
Joomla! Master
Joomla! Master
Posts: 41507
Joined: Sat Apr 05, 2008 9:58 pm

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by Webdongle » Thu Mar 31, 2022 11:43 am

suchymdt wrote:
Thu Mar 31, 2022 6:07 am
just install Joomla! 3.10.7 to 3.10.8 Patch Package or Joomla! 3.10.x to 3.10.8 Patch Package and fix the problem ;)
Not if the 3.10.7 update prevented the user logging into admin :pop
http://www.weblinksonline.co.uk/
https://www.weblinksonline.co.uk/updating-joomla.html
"When I'm right no one remembers but when I'm wrong no one forgets".

User avatar
trogladyte
Joomla! Explorer
Joomla! Explorer
Posts: 485
Joined: Sat May 03, 2008 9:27 pm
Location: Phoenix, AZ
Contact:

Re: Error after update Joomla 3.10.6 to 3.10.7 - 1054 Unknown column 'authProvider' in 'field list'

Post by trogladyte » Thu Mar 31, 2022 12:42 pm

Thanks @Webdongle - missed that fix - worked like a charm, though I still would like to find out how to write the MySQL statement. :-)
Ian Shere - Phoenix Website Design & Hosting
http://www.citruskiwi.com
Certified Flight Instructor http://www.flygoodyear.com



Post Reply

Return to “Administration Joomla! 3.x”