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

| Joomla
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.

Subscribe to OSTraining Video Club and right away start learning how to build superb Joomla websites. Follow our step by step bite-sized video tutorials from only $6 per month!

About the author

Born from Ukrainian mother and Russian father, Alex migrated to the United Kingdom in 1999. He is a self-taught Microsoft Certified Professional. He enjoys learning content management systems and helping web site developers make the most of them.