You should try to go to Extensions/Manage/Database and click on "Fix" button.

Pascal

I have the same problem. After updating to Joomla 3.7.0 I get the error: Unknown column 'client_id' in 'where clause'

Clicking the FIX button on Extension/Manage/Database does not fix the problem. Please help if you can. My menu does not appear.

@aneelaranha What type of database do you use?

@th3r1dd1ck #15629 (comment) fixed issue for you?

@wojsmol looks like comment-link isn't working.

MySQL

If you visit www.hsiweb.org you'll see my menu bar has gone. Thanks for the help.

@franz-wohlkoenig fixed
@aneelaranha Show only structure of #__menu_type table.
Related #15671

The solution is to use phpMyadmin and run these queries

ALTER TABLE `#__menu_types` ADD COLUMN `client_id` int(11) NOT NULL DEFAULT 0;

UPDATE `#__menu` SET `published` = 1 WHERE `menutype` = 'main' OR `menutype` = 'menu';

Replace #_ by your db prefix

@infograf768

UPDATE `#__menu` SET `published` = 1 WHERE `menutype` = 'main' OR `menutype` = 'menu';

Is couse of the problem not a solution.
See #15671

Original issue here is for client_id, therefore the first query may solve the issue

We haqve 2 issue in one, 2 by @aneelaranha

@aneelaranha can you please open an own Issue so we not have longer 2 different in one Issue, thanks.

In our forum (RocketTheme) some members had run into the same issue.
Besides having to click the 'Fix' button for the database in the Joomla admin, they also had a lot of entries showing under > Extensions > Discover. After selecting all of them and installing, the error was fixed. Seems like the Joomla update has just failed in those cases.

@franz-wohlkoenig my apologies. I thought the issue was the same so didn't open a different post.
@kat05 thank you so much! I did what you suggested and THEN ran a FIX database and it worked.

This is my first time ever posting in a forum and I am grateful to all of you for your suggestions. Blessings.

Just Upgraded to Joomla 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?

@advancn See #15629 (comment)
@infograf768 I'm sorry for #15629 (comment),I was wrong.

closed as having PR #15690

Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/15629

||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

After reading so many forums and websites only this one got it fixed for me -

https://ltheme.com/question/error-1054-unknown-column-a-client_id-in-where-clause-in-backend-after-joomla-3-8-update/

This is not problem with page builder, you just go to admin > extension > database, click to button ‘Fix’ and recheck.

Yes, but BACKEND did´nt work anymore.
got some other Forum and tried this Solution.
COPY PATH BELOW AND PASTE ON YOUR WEBSITE
Just make a database Repair: YOURWEBSITE.COM/administrator/index.php?option=com_installer&task=database.fix
Now, Backend works and shows properly with Joomla 3.8.1

||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Thax shajhan, my problem resolved, it's fixed

THANK YOU shajhan!!!! you saved my life!!!!!!!!!!!!!

THANK YOU shajhan!! a very quick fix!

THANK YOU.I met this problem, too.

Made My Day

This work out good if the back end was also Broken down #15629 (comment)

The solution is to use phpMyadmin and run these queries

ALTER TABLE `#__menu_types` ADD COLUMN `client_id` int(11) NOT NULL DEFAULT 0;

UPDATE `#__menu` SET `published` = 1 WHERE `menutype` = 'main' OR `menutype` = 'menu';

Replace #_ by your db prefix

You saved me! Thank you so much

The solution is to use phpMyadmin and run these queries

ALTER TABLE `#__menu_types` ADD COLUMN `client_id` int(11) NOT NULL DEFAULT 0;

UPDATE `#__menu` SET `published` = 1 WHERE `menutype` = 'main' OR `menutype` = 'menu';

Replace #_ by your db prefix

Had to do this after upgrade to Joomla 3.91 which broke website and admin website, many thanks kudos to you.

I don't have any menu options when I try to log in...Unfortunately, I am a pretty novice Joomla user; I inherited this client site from a previous coworker and everything seemed to go smoothly until now. Any other advice to get the site working again?

@AFCURESite Please ask on Forum as this is for Coding.

The solution is to use phpMyadmin and run these queries

ALTER TABLE `#__menu_types` ADD COLUMN `client_id` int(11) NOT NULL DEFAULT 0;

UPDATE `#__menu` SET `published` = 1 WHERE `menutype` = 'main' OR `menutype` = 'menu';

Replace #_ by your db prefix

This solved the issue. Thanks

I don't have any menu options when I try to log in...Unfortunately, I am a pretty novice Joomla user; I inherited this client site from a previous coworker and everything seemed to go smoothly until now. Any other advice to get the site working again?

you can execute it on terminal (SSH) mysql -u root -p
or via phpmyadmin

remember to change #__ to your prefix

I was using an old 3.3.6

GoDaddy updated the PHP and my site crashed. They got me back up by rolling the PHP back but a lot of stuff didn't work. They said I had to update joomla. I was doing fine slowly updating up till 3.6.5 and then it said update to 3.9. After that update I can't get into the backend. My site works but I cant make any changes. I tried the:

ALTER TABLE #__menu_types ADD COLUMN client_id int(11) NOT NULL DEFAULT 0;

UPDATE #__menu SET published = 1 WHERE menutype = 'main' OR menutype = 'menu';

But it did nothing. I got a green confirmation that it did something but it didn't fix anything.

I tried:

YOURWEBSITE.COM/administrator/index.php?option=com_installer&task=database.fix

But it also did nothing. Can someone help me out to get back into the backend of my site?

@pi3yeargrad please use the forum for support https://forum.joomla.org