Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

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.
Post Reply
Iamwe888
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Sat Aug 01, 2015 4:45 am

Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by Iamwe888 » Sat Apr 29, 2017 11:11 pm

Just upgrade from the last version to 3.7

After adding a new menu item, then attempting to view it, I received the following error:
Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

When viewing modules I receive this error:
Unknown column 'client_id' in 'where clause'

Q - How can I fix this?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 25756
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by Per Yngve Berg » Sun Apr 30, 2017 7:01 am

The upgrade have to run to the end. Changes in the database tables have not been done.

Run Extensions->Extension Manager->Database->Fix

You should increase the max_execution-time on the server, so upgrades are allowed to finish.

pjcons
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Thu Dec 31, 2015 12:37 am

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by pjcons » Mon May 01, 2017 8:22 am

Mate that worked!! Thanks for the reply. BTW, in latest version it's "Extensions | Manage | Database | Fix.

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

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by NewbieCruiser » Wed May 24, 2017 1:09 pm

I have the same issue. When I click on "extensions" I don't have an "Extension Manager"
Please help

Clive Middleton
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Fri Mar 14, 2014 9:06 pm

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by Clive Middleton » Sun Jun 25, 2017 1:29 pm

The actual names of the menu options are

Extensions->Manage->Database

The Fix button is in the top left corner, below the main Joomla menu

I had 31 errors.

N.B. it took over a minute to fix the errors, so be patient and let it continue.

Afterwards I could access the menus

JeremyMalies
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Jul 07, 2017 10:00 pm

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by JeremyMalies » Fri Jul 07, 2017 10:10 pm

The pjcons solution worked for me as well. Thank you for taking the trouble to post your solution and help other people. Jeremy

Carlo LeRocal
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Wed Apr 06, 2016 9:07 am

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by Carlo LeRocal » Wed Aug 02, 2017 2:50 pm

Per Yngve Berg wrote:The upgrade have to run to the end. Changes in the database tables have not been done.

Run Extensions->Extension Manager->Database->Fix

You should increase the max_execution-time on the server, so upgrades are allowed to finish.

THANKS VERY MUCH!!!!!

Lost in France
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sat Apr 07, 2018 1:23 pm

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by Lost in France » Sat Apr 07, 2018 1:29 pm

I have the same error in the administrator panel but when I click on the 'Return to Control Panel' button it just takes me back to the same message.

Also when I logged back in as administrator (after the time-out) it again took me back to the same message.

Please HELP
AAJoom.JPG
You do not have the required permissions to view the files attached to this post.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 25756
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by Per Yngve Berg » Sat Apr 07, 2018 1:49 pm

Run

/administrator/index.php?option=com_installer&view=database

Lost in France
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Sat Apr 07, 2018 1:23 pm

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by Lost in France » Sat Apr 07, 2018 3:07 pm

Thanks but I can't do anything to get past that screen, running /administrator/index.php?option=com_installer&view=database just gets me back to that error.

I do have ftp and phpmyadmin access to the site if that helps.

rbm
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Thu Apr 06, 2017 6:28 am

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by rbm » Mon Nov 12, 2018 7:54 am

I Have the same problem
But after the login page, I just see White page without any menus !!
So I don't have access to fix database!
what should I do?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 25756
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by Per Yngve Berg » Mon Nov 12, 2018 12:54 pm

Use the URL

rbm
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Thu Apr 06, 2017 6:28 am

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by rbm » Tue Nov 13, 2018 12:38 pm

Per Yngve Berg wrote:
Mon Nov 12, 2018 12:54 pm
Use the URL
I used url but nothing happened and still white screen with no menu

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 25756
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Unknown column 'a.client_id' in 'field list' Unknown column 'a.client_id' in 'where clause'

Post by Per Yngve Berg » Tue Nov 13, 2018 7:35 pm

It ended with a php error. Raise the php error level and enable debug, so you can see the error.


Post Reply

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