Unknown column 'client_id' in 'field list ERROR

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.
User avatar
fadyagha
Joomla! Intern
Joomla! Intern
Posts: 81
Joined: Thu Apr 23, 2009 11:07 pm
Location: qatar,doha
Contact:

Unknown column 'client_id' in 'field list ERROR

Post by fadyagha » Mon Mar 06, 2017 8:54 am

Hello Dear
After upgrade joomla to 3.7.0 beta3 many issues at joomla sections
like menus section I have error :
Unknown column 'client_id' in 'field list
In all menu other error :
Unknown column 'client_id' in 'where clause' Unknown column 'client_id' in 'where clause' Unknown column 'client_id' in 'where clause'
In modules and templates section :
Unknown column 'client_id' in 'where clause'
So I want know how to solved this issues !!

Regards,

User avatar
fadyagha
Joomla! Intern
Joomla! Intern
Posts: 81
Joined: Thu Apr 23, 2009 11:07 pm
Location: qatar,doha
Contact:

Re: Unknown column 'client_id' in 'field list ERROR

Post by fadyagha » Thu Mar 09, 2017 7:49 am

Any answer!!

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 20400
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ Germany/ S'pore/Bogor/ North America
Contact:

Re: Unknown column 'client_id' in 'field list ERROR

Post by leolam » Thu Mar 09, 2017 8:32 am

You should roll back to your backup since the upgrade has failed. Also do not use any Beta version or RC version on a live site since development for J3.7 is still in full flow.

We have no related issue for Joomla 3.7 on the Issue Tracker and all my test installations or upgrade tests have gone well and I do not have this experience. From what version you upgraded? How did you upgrade?

Leo 8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Webmaster Services: gws-webmaster.services

imnlimited
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Mon Apr 13, 2015 3:07 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by imnlimited » Wed Apr 26, 2017 7:45 am

Hi, just upgraded Joomla 3.6.5 to Joomla 3.7.0 on our DEV site and we are also getting the exact same error where our Main Menu should be.

Any ideas?

srab
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Wed Nov 15, 2006 1:47 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by srab » Wed Apr 26, 2017 9:10 am

Same here, just upgraded Joomla 3.6.5 to Joomla 3.7.0.

And after installation of 3.7 update I get on the same page:
Table '#__extensions' is marked as crashed and should be repaired

After repair of the table in MySQL i GOT this on home admin screen:

Code: Select all

JInstaller: :Instalace: Chyba SQL Incorrect key file for table '.\hotelsport2017\#__extensions.MYI'; try to repair it
Aktualizace souborů: chyba SQL souboru DB funkce selhala, číslo chyby 126
Incorrect key file for table '.\hotelsport2017\#__extensions.MYI'; try to repair it
SQL =

INSERT INTO `#__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
(458, 'plg_quickicon_phpversioncheck', 'plugin', 'phpversioncheck', 'quickicon', 0, 1, 1, 1, '', '', '', '', 0, '0000-00-00 00:00:00', 0, 0);
In modules, templates:
Unknown column 'client_id' in 'where clause'
Unknown column 'client_id' in 'where clause'

And try to show Menu is not working at all, menu list of my menus is not shown:
1054 Unknown column 'client_id' in 'field list'

hypnoticstate
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Thu Apr 09, 2009 4:28 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by hypnoticstate » Wed Apr 26, 2017 1:43 pm

I'm also getting this exact error. Upgraded from 3.6.5 to 3.7. Menu is missing from my pages and shows "Unknown column 'a.client_id' in 'where clause'". Clicking any of the menu pages in the back-end also brings up the same error and on some pages it brings up display errors too.

StephenP3
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Apr 26, 2017 2:25 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by StephenP3 » Wed Apr 26, 2017 2:27 pm

I'm experiencing the same issue when upgrading from 3.6.5 to 3.7.

Error

Unknown column 'client_id' in 'where clause'

Is this a possible issue with K2 and 3.7?

mightyoz
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Feb 28, 2008 2:11 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by mightyoz » Wed Apr 26, 2017 7:21 pm

I had this same issue after updating and fixed it by installing php 7 instead of php 5.4.

hypnoticstate
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Thu Apr 09, 2009 4:28 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by hypnoticstate » Wed Apr 26, 2017 8:54 pm

mightyoz wrote:I had this same issue after updating and fixed it by installing php 7 instead of php 5.4.
I use PHP 7.0 and still have this issue.

SolarGordon
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Sun Apr 03, 2016 8:38 am

Re: Unknown column 'client_id' in 'field list ERROR

Post by SolarGordon » Wed Apr 26, 2017 9:06 pm

try: Extensions -> Manage -> Database and click the Fix button. It worked for me.

hypnoticstate
Joomla! Apprentice
Joomla! Apprentice
Posts: 15
Joined: Thu Apr 09, 2009 4:28 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by hypnoticstate » Wed Apr 26, 2017 10:23 pm

SolarGordon wrote:try: Extensions -> Manage -> Database and click the Fix button. It worked for me.
This worked for me. Thanks for the tip.

SolarGordon
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Sun Apr 03, 2016 8:38 am

Re: Unknown column 'client_id' in 'field list ERROR

Post by SolarGordon » Thu Apr 27, 2017 6:50 am

No prob. I thought it worked for me but I've just checked all of my pages and see that certain ones still have database errors. Annoying.

vast
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Fri Feb 24, 2012 6:51 am

Re: Unknown column 'client_id' in 'field list ERROR

Post by vast » Thu Apr 27, 2017 9:39 pm

I had the same problem throwing an error when accessing the menus after updating to 3.7

Problem fix... go to extensions/manage/database... here it listed more than 13 errors in the database showing a db version of 3.6.5.

Click on the upper left "fix" button and walla!! it updated the db and fixed the issues.

It now states a version of 3.7 and all is good.

Hope this helps others.

gdk
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Thu Apr 07, 2016 12:50 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by gdk » Fri Apr 28, 2017 10:09 am

I also get this error.
I have php 7.0 and tried to fix database. After that I get message: 1146 Table 'koivupor_gdk.gdk_session' doesn't exist. How can I fix this problem?

LeonardoM
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Fri Oct 02, 2009 8:25 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by LeonardoM » Sun Apr 30, 2017 10:28 pm

For
joomla error 1054 unknown column 'client_id'

Only try:
Extensions -> Manage -> Database
and click the Fix button.
It worked.
by Leonardo Miljko :)

User avatar
fadyagha
Joomla! Intern
Joomla! Intern
Posts: 81
Joined: Thu Apr 23, 2009 11:07 pm
Location: qatar,doha
Contact:

Re: Unknown column 'client_id' in 'field list ERROR

Post by fadyagha » Wed May 03, 2017 11:45 am

Thanks guys the solution is :
Extensions -> Manage -> Database and click the Fix button
:D

anphonic
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Tue Jul 19, 2011 3:02 am
Location: Oklahoma
Contact:

Re: Unknown column 'client_id' in 'field list ERROR

Post by anphonic » Thu May 11, 2017 5:03 am

Well, not quite...

I just updated and have 1 error

Code: Select all

The Joomla! Core database tables have not been converted yet to UTF-8 Multibyte (utf8mb4).
but when i click "Fix" it attempts to then throws this error and doesn't actually fix the DB

Code: Select all

Error

Unknown column 'type_alias' in '#__content_types'
Key column 'type_alias' doesn't exist in table

NewbieCruiser
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed May 17, 2017 12:27 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by NewbieCruiser » Wed May 24, 2017 2:07 pm

Help, when I click on "extensions" I don't have a "manage" option.

raineytran
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Feb 28, 2011 1:43 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by raineytran » Tue May 30, 2017 7:01 am

SolarGordon wrote:try: Extensions -> Manage -> Database and click the Fix button. It worked for me.
Yes, it worked for me too :D :D :D :D
Nha phan phoi va dai ly smc vietnam, SMC penumatics Vietnam http://tvptech.com

apsilva
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 162
Joined: Tue Jul 12, 2016 11:22 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by apsilva » Thu Jun 08, 2017 8:02 pm

when yoiu need to use "Extensions -> Manage -> Database and click the Fix button." it means your update didn't run properly.

I always advise, in those cases to restore the backup and update trough Joomla Update Component which is now the only valid way to update

Note: If your server does not have internet access use "Upload & Update" feature (added in 3.6.0) of the Joomla Update Component.

viksitsachdeva
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sun Jun 11, 2017 6:02 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by viksitsachdeva » Tue Jun 13, 2017 9:58 am

hi,
i did the above directed by clikcing on fix in extension->manage->database->fix but i still get the error..
this is in particular happening in the JSN IMAGESHOW while selecting the "THEME SLider" theme..

Anyone plz help

favdes
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 141
Joined: Wed Dec 18, 2013 10:47 am

Re: Unknown column 'client_id' in 'field list ERROR

Post by favdes » Fri Jun 30, 2017 12:46 pm

I've just had a similar error.

What I did was run 'extension->manage->database->fix'

Then go to 'Components' | 'Joomla Update' and 'resinstall core files'

I then ran the database fix again.

This worked for me.

Alberty
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sat Aug 26, 2017 8:19 am

Re: Unknown column 'client_id' in 'field list ERROR

Post by Alberty » Fri Sep 01, 2017 6:51 am

favdes wrote:I've just had a similar error.

What I did was run 'extension->manage->database->fix'

Then go to 'Components' | 'Joomla Update' and 'resinstall core files'

I then ran the database fix again.

This worked for me.
Hi Favdes I tried that but it didn't work. What version of PHP are you using?

favdes
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 141
Joined: Wed Dec 18, 2013 10:47 am

Re: Unknown column 'client_id' in 'field list ERROR

Post by favdes » Fri Sep 01, 2017 6:58 am

Hi Alberty,

I'll be honest, we look after a lot of sites and I cannot remember which one we had this issue with. I would suggest trying it and if it doesn't work, change the version of PHP that you site uses and then try again.

Let us know how you get on.

Kind regards


James

Consac
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Tue Sep 19, 2017 8:33 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by Consac » Tue Sep 19, 2017 8:46 pm

I have something similar happening to me.
After I did an update to Joomla, the Site itself is still up but when I try to either go to the administrator page, or if the login shows up, as soon as I try to log in, I get a blank page.
At the top of the page it says: "Error displaying the error page"

And on the tab it says Error:1054 Unknown column 'a.client_id' in 'where clause'

So the site is up but I can't access the administrator page to apply the fix.

What should I do???

breto33
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Tue Mar 31, 2009 4:28 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by breto33 » Tue Sep 19, 2017 8:49 pm

Trying to figure out how to solve this when I dont have a menu to use to navigate anywhere to fix the database?
error.jpg
You do not have the required permissions to view the files attached to this post.

Consac
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Tue Sep 19, 2017 8:33 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by Consac » Tue Sep 19, 2017 9:00 pm

LeonardoM wrote:For
joomla error 1054 unknown column 'client_id'

Only try:
Extensions -> Manage -> Database
and click the Fix button.
It worked.
by Leonardo Miljko :)

But I can't even access my administrator page to go to Extensions - Manage - Database

Any suggestions?

When I try to go to my administrator page I get the error Error 1054 Unknown column 'a.client_id' in 'where clause'

User avatar
fadyagha
Joomla! Intern
Joomla! Intern
Posts: 81
Joined: Thu Apr 23, 2009 11:07 pm
Location: qatar,doha
Contact:

Re: Unknown column 'client_id' in 'field list ERROR

Post by fadyagha » Wed Sep 20, 2017 6:42 am

Try to clear cash from your browser
if issue is still I think you need to remove your database content and re import your database backup

art4d
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Sep 20, 2017 6:23 pm

Re: Unknown column 'client_id' in 'field list ERROR

Post by art4d » Wed Sep 20, 2017 6:26 pm

you can try to fix database by
administrator/index.php?option=com_installer&task=database.fix

shoulders
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 209
Joined: Fri Oct 10, 2008 9:03 pm
Contact:

Re: Unknown column 'client_id' in 'field list ERROR

Post by shoulders » Thu Sep 21, 2017 1:22 pm

@art4d thanks

what i did to update my joomla 3.5.1 site

- removed all the junk that was not needed (including weblinks)
- ran the update

Then the error 1054 occurs

- i kept the windows open and did not click on anything
http://www.example.com/administrator/in ... iseconfirm

- i opened a new window in which i loaded the page

http://www.example.com/administrator/in ... tabase.fix

- this found issues and fixed them - it said the 'fields_groups' table was missing, perhaps add this in before running the upgraded
- i went back to the other windows and refreshed the page and it loaded to the 'login and cleanup page'
http://www.example.com/administrator/in ... iseconfirm
- i logged in

Menu Items are now missing

- after research i came across thess threads which said this script had not run script for some reason. it is for 3.7.0 but i used it for 3.8.0 as the code looks what is needed.
https://github.com/joomla/joomla-cms/pull/16577
https://github.com/joomla/joomla-cms/issues/15719

script: https://github.com/joomla/joomla-cms/bl ... -01-17.sql

- run fix database just in-case

- done

hope this helps


Locked

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