install fails and now cannot access admin page functionality - Unknown column 'a.client_id'

Need help installing Joomla! 3.x? For all Joomla! 3.x installation issues please use this forum. Note: Users creating new sites can use either version 2.5 or 3.x. Please consider the availability of third-party templates and extensions when deciding which Joomla version to use.

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.
tv21
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Wed Aug 09, 2006 5:31 pm

install fails and now cannot access admin page functionality - Unknown column 'a.client_id'

Postby tv21 » Thu Jan 25, 2018 7:54 pm

Hi

So I upgraded to 3.8.3 from I think 3.6.x

Upgrade seemed to go ok, until, of course I got some errors. All seemed well however as the front end is still working normally. However, when I login to the admin, I only see the black bar along the top and nothing else.

The last line of HTML in the output shows:

Error: Unknown column 'a.client_id' in 'where clause': Unknown column 'a.client_id' in 'where clause'

I have seen this before in the forums but any fix seems to require a working admin page. But as I said, mine is unusable.

I have been using Joomla for a long time (Mambo) so I'm used to surprises, but I'm stumped and after a week of fruitless attempts I am afraid I need to ask for help.

Any suggestions welcomed!





The forum post assistant gave me this info to share:

Problem Description :: Forum Post Assistant (v1.3.9) : 25th January 2018 wrote:Admin view is blank
Log/Error Message :: Forum Post Assistant (v1.3.9) : 25th January 2018 wrote:none on screen. code reveals "Error: Unknown column 'a.client_id' in 'where clause': Unknown column 'a.client_id' in 'where clause'"
Log/Error Message :: Forum Post Assistant (v1.3.9) : 25th January 2018 wrote:Error: Unknown column 'a.client_id' in 'where clause': Unknown column 'a.client_id' in 'where clause'
Actions Taken To Resolve by Forum Post Assistant (v1.3.9) 25th January 2018 wrote:Tried to add latest code but admin page blank other than black header.
Forum Post Assistant (v1.3.9) : 25th January 2018 wrote:
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.8.3-Stable (Amani) 12-December-2017
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (440) | Owner: --protected-- . (uid: 1/gid: 1) | Group: --protected-- (gid: 1) | Valid For: 3.8
Configuration Options :: Offline: 0 | SEF: 1 | SEF Suffix: 0 | SEF ReWrite: 0 | .htaccess/web.config: No | GZip: 1 | Cache: 2 | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: N/A | FTP Layer: 0 | Proxy: 0 | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: N/A | SSL: 0 | FrontEdit: 1 | Error Reporting: simple | Site Debug: 0 | Language Debug: 0 | Default Access: 1 | Unicode Slugs: 0 | dbConnection Type: mysqli | Database Credentials Present: Yes

Host Configuration :: OS: Linux | OS Version: 2.6.32-896.16.1.lve1.4.49.el6.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate | Doc Root: --protected-- | System TMP Writable: Yes | Free Disk Space : 87.86 GiB |

PHP Configuration :: Version: 5.5.38 | PHP API: cgi-fcgi | Session Path Writable: Yes | Display Errors: 1 | Error Reporting: 22519 | Log Errors To: /dev/null | Last Known Error: 11th January 2018 18:18:39. | Register Globals: | Magic Quotes: | Safe Mode: | Open Base: | Uploads: 1 | Max. Upload Size: 128M | Max. POST Size: 128M | Max. Input Time: 60 | Max. Execution Time: 30 | Memory Limit: 512M

MySQL Configuration :: Version: 5.5.5-10.2.12-MariaDB-log (Client:mysqlnd 5.0.11-dev - 20120503 - $Id: 15d5c781cfcad91193dceae1d2cdd127674ddb3e $) | Host: --protected-- (--protected--) | Collation: latin1_swedish_ci (Character Set: latin1) | Database Size: 52.90 MiB | #of Tables:  462
Detailed Environment :: wrote:PHP Extensions :: Core (5.5.38) | date (5.5.38) | ereg () | libxml () | openssl () | pcre () | zlib (2.0) | bcmath () | bz2 () | calendar () | ctype () | curl () | dom (20031129) | hash (1.0) | fileinfo (1.0.5) | filter (0.11.0) | ftp () | gd () | gettext () | SPL (0.2) | iconv () | session () | intl (1.1.0) | json (1.2.1) | mbstring () | mcrypt () | standard (5.5.38) | mysqlnd (mysqlnd 5.0.11-dev - 20120503 - $Id: 15d5c781cfcad91193dceae1d2cdd127674ddb3e $) | mysqli (0.1) | pcntl () | mysql (1.0) | PDO (1.0.4dev) | pdo_mysql (1.0.2) | pdo_pgsql (1.0.2) | pgsql () | Phar (2.0.2) | posix () | pspell () | Reflection ($Id: dc76d2fe0f3e9c327c1d4ca617d94e26c7fae98d $) | imap () | SimpleXML (0.1) | soap () | sockets () | exif (1.4 $Id: 74b652b3ebe78882b8006d49c17cac029fe8a5d0 $) | tidy (2.0) | tokenizer (0.1) | xml () | xmlreader (0.1) | xmlrpc (0.51) | xmlwriter (0.1) | xsl (0.1) | zip (1.11.0) | cgi-fcgi () | sqlite3 (0.7-dev) | pdo_sqlite (1.0.1) | mhash () | ionCube Loader () | Zend Engine (2.5.0) |
Potential Missing Extensions :: suhosin |

Switch User Environment (Experimental) :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Custom SU (LiteSpeed/Cloud/Grid): Yes
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) ::
Database Information :: wrote:Database statistics :: Uptime: 49310 | Threads: 233 | Questions: 49572252 | Slow queries: 4776 | Opens: 713488 | Flush tables: 1 | Open tables: 4096 | Queries per second avg: 1005.318 |
Extensions Discovered :: wrote:Components :: SITE :: CB Mambo Author Tab (1.2) 1 | Yanc Integration (1.2) 1 | CBreCaptcha (1.2.2) 1 | CB Mamblog Tab (1.2) 1 | com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
Components :: ADMIN :: com_search (3.0.0) 1 | com_users (3.0.0) 1 | com_plugins (3.0.0) 1 | com_redirect (3.0.0) 1 | com_banners (3.0.0) 1 | com_phocadownload (3.0.0) 1 | com_fields (3.7.0) 1 | com_templates (3.0.0) 1 | com_cache (3.0.0) 1 | com_checkin (3.0.0) 1 | mod_kunenamenu (3.0.6) 1 | plg_system_kunena (-) 1 | plg_kunena_gravatar (3.0.6) 0 | plg_kunena_community (3.0.6) 0 | plg_kunena_finder (3.0.6) 1 | plg_kunena_kunena (3.0.6) 1 | plg_kunena_alphauserpoints (3.0.6) 0 | plg_kunena_uddeim (3.0.6) 0 | plg_kunena_joomla (3.0.6) 1 | plg_kunena_comprofiler (3.0.6) 0 | plg_finder_kunena (3.0.6) 1 | com_kunena (3.0.6) 1 | com_redj (1.7.6) 1 | comprofiler (1.9.1) 1 | comprofiler (1.9.1) 1 | com_login (3.0.0) 1 | Admintools (3.8.3) 1 | com_categories (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_installer (3.0.0) 1 | Gantry (4.1.31) 1 | com_menus (3.0.0) 1 | com_config (3.0.0) 1 | com_admin (3.0.0) 1 | com_weblinks (3.0.0) 1 | com_languages (3.0.0) 1 | com_ajax (3.2.0) 1 | com_tags (3.1.0) 1 | com_newsfeeds (3.0.0) 1 | com_associations (3.7.0) 1 | com_joomlaupdate (3.6.2) 1 | jSecure Lite (1.0) 1 | com_contenthistory (3.2.0) 1 | com_jhackguard (2.0.2) 1 | com_modules (3.0.0) 1 | COM_COMMENT (5.0rc3) 1 | com_content (3.0.0) 1 | com_finder (3.0.0) 1 | com_media (3.0.0) 1 | com_bfstop (1.3.0) 1 | com_messages (3.0.0) 1 | com_cpanel (3.0.0) 1 |

Modules :: SITE :: mod_feed (3.0.0) 1 | mod_login (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_custom (3.0.0) 1 | RokNavMenu (2.0.8) 1 | MOD_VIPAMAZONASSOCIATES (1.6) 1 | mod_breadcrumbs (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_ads_elite (4.5) 1 | mod_weblinks (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_articles_categories (3.0.0) 1 | CB Online (1.9) 1 | mod_search (3.0.0) 1 | mod_articles_news (3.0.0) 1 | CB Login (1.9) 0 | mod_articles_archive (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_menu (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_users_latest (3.0.0) 1 | CB Workflows (1.9) 1 | mod_random_image (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_stats (3.0.0) 1 |
Modules :: ADMIN :: mod_feed (3.0.0) 1 | mod_login (3.0.0) 1 | mod_version (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_menu (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_title (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_status (3.0.0) 1 |

Plugins :: SITE :: plg_captcha_recaptcha (3.4.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_adselite (4.5) 0 | plg_content_geshi (2.5.0) 0 | plg_content_pagenavigation (3.0.0) 1 | Content - CComment (5.0rc3) 0 | plg_content_vote (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_finder (3.0.0) 0 | K2 Plugin - CComment (5.0rc3) 0 | plg_user_profile (3.0.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_twofactorauth_yubikey (3.2.0) 1 | plg_twofactorauth_totp (3.2.0) 1 | plg_kunena_gravatar (3.0.6) 0 | plg_kunena_uddeim (3.0.6) 0 | plg_kunena_comprofiler (3.0.6) 0 | plg_kunena_alphauserpoints (3.0.6) 0 | plg_kunena_joomla (3.0.6) 1 | plg_kunena_kunena (3.0.6) 1 | plg_kunena_community (3.0.6) 0 | plg_editors_tinymce (4.5.8) 1 | plg_editors_codemirror (5.30.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_kunena (3.0.6) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_system_bfstop (1.3.0) 1 | plg_system_log (3.0.0) 1 | plg_system_stats (3.5.0) 1 | System - Admin Tools (3.8.3) 1 | plg_system_redirect (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_debug (3.0.0) 1 | JHackGuard Plugin (2.0.2) 1 | plg_system_p3p (3.0.0) 1 | plg_system_kunena (3.0.6) 1 | plg_system_redj (1.7.6) 1 | plg_system_highlight (3.0.0) 1 | System - Gantry (4.1.31) 1 | plg_system_sef (3.0.0) 1 | System - RokExtender (2.0.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_adsstarterelite (4.5) 1 | System - jSecure Lite (1.0) 0 | plg_system_cache (3.0.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_languagefilter (3.0.0) 0 | plg_system_logout (3.0.0) 1 | System - Marco's SQL Injection (1.4) 1 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_extension_joomla (3.0.0) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_installer_webinstaller (1.0.5) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_weblinks (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_tags (3.0.0) 0 | plg_search_contacts (3.0.0) 1 | plg_search_weblinks (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_newsfeeds (3.0.0) 1 |
Templates Discovered :: wrote:Templates :: SITE :: atomic (2.5.0) 1 | beez3 (3.1.0) 1 | beez_20 (2.5.0) 1 | gantry (4.1.13) 1 | protostar (1.0) 1 | beez5 (2.5.0) 1 |
Templates :: ADMIN :: isis (1.0) 1 | bluestork (2.5.0) 1 | hathor (3.0.0) 1 |

mintmarketing
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Jan 25, 2018 8:14 pm

Re: install fails and now cannot access admin page functionality - Unknown column 'a.client_id'

Postby mintmarketing » Thu Jan 25, 2018 8:55 pm

I have the exact same problem. I know little coding and am a tad worried about how to fix this....

biggr620
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Jan 31, 2018 4:22 am

Re: install fails and now cannot access admin page functionality - Unknown column 'a.client_id'

Postby biggr620 » Wed Jan 31, 2018 4:27 am

I have also tried to upgrade from Joomla 3.6.5 to Joomla 3.8. Upgrade seems to go fine then a blank admin screen and cannot login. The front works fine but no access to admin area. The only way to get access is to manually restore backup via ftp.
How do you upgrade from 3.6.5 to 3.8 without crashing the site?

hacki65
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Feb 01, 2018 12:20 am

Re: install fails and now cannot access admin page functionality - Unknown column 'a.client_id'

Postby hacki65 » Thu Feb 01, 2018 12:37 am

@tv21 - Most of your extensions are to old and has conflicts with newest Joomla! Version (e.g. kunena 3.0.6, there is 5.0.13 out).

All Extensions must be updated before the Upgrade to J3.8.4!!!

My advise: Try to update to J3.7.0, then to J3.7.5. If all works - update the extensions. Then try to update to J3.8.4.
And make backups between all steps :)

biggr620
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Jan 31, 2018 4:22 am

Re: install fails and now cannot access admin page functionality - Unknown column 'a.client_id'

Postby biggr620 » Thu Feb 01, 2018 3:10 pm

hacki65 wrote:@tv21 - Most of your extensions are to old and has conflicts with newest Joomla! Version (e.g. kunena 3.0.6, there is 5.0.13 out).

All Extensions must be updated before the Upgrade to J3.8.4!!!

My advise: Try to update to J3.7.0, then to J3.7.5. If all works - update the extensions. Then try to update to J3.8.4.
And make backups between all steps :)


I have updated every extension prior to upgrading from 3.7.5 to 3.8.xx, this problem still remains. I can get access when I I rename administrator/modules/mod_menu to administrator/modules/mod_menuold, but I also lose my my back-end menu and some functionality. Any thoughts on this?

tv21
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Wed Aug 09, 2006 5:31 pm

Re: install fails and now cannot access admin page functionality - Unknown column 'a.client_id'

Postby tv21 » Fri Mar 02, 2018 10:34 pm

I wanted to provide an update. I did the initial post and yes, many of the extensions were (VERY) out of date.
So, I did as suggested.

backed up the database
Installed 3.6.x over everything.
updated and fixed any "minor issues" with extensions
upgraded to 3.70 and again updated extensions
upgraded to 3.7.5 I think this was fairly painless
Finally upgraded all extensions
then finally upgraded to 3.8.x and now all is well.

It can be done, so if you are in the state my site was in, this is a fixable thing. Do not give up!

Also, a huge thank you to everyone who provided help.


Return to “Installation Joomla! 3.x”

Who is online

Users browsing this forum: CookieOfficial5, donnan and 5 guests