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

How to Fix 1054 Unknown Column

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

If you go to MenusMain Menu, you may see this error:

1054 Unknown column 'client_id' in 'field list'

This is a problem with Joomla's database update, but it is easily fixed. In this tutorial, you will learn how to quickly fix it.

  •  This is what the error page looks like:

unknown column in Joomla

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

manage Joomla menus

  • 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 MenusMain 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.

Note: this tutorial was originally published in November 2018.


What's Next?

Save $1000's when you sign up to the Everything Club today! You' ll get access to all our extensions, templates, and Joomla training.