How to Fix 1054 Unknown Column 'client_id' in 'field list'

When you run an update from older versions of Joomla to version 3.7, you may see an error.

If you go to Menus >> Main Menu, you may see this error:

1054 Unknown column 'client_id' in 'field list'

In this tutorial, you will learn how to quickly fix it.

  •  This is what the error page looks like:

 nknown column in Joomla

  • In your Joomla admin area, go to Extensions >> Manage >> Manage:

02 manage manage

  • You will see the Extensions: Manage admin page. On the left-hand sidebar click on Database:

03 database

  • You will see the Extensions: Database admin page. Click on the Fix button:

04 fix button

  • After a few quick seconds, you will see the "Database table structure is up to date" message:

05 db structure fixed

  • That's it, you are all good. Now, go once again to Menus >> Main Menu. You will now see that the error 1054 has gone:

06 menu ok

Congratulations! You just learned how to fix the 1054 Unknown Column 'client_id' in 'field list' error.