After upgrading your Joomla install you get the one of following or similiar error:

• Error displaying the error page: Unknown column 'a.client_id' in 'where clause': Unknown column 'a.client_id' in 'where clause'

• 1054 Unknown column 'client_id' in 'field list'

Cause

This is cause by the finalising scripts being run for some reason. I think the joomla team know about this and is probably fixed by now.

Solution

I ran the Joomla upgrade and then the error 1054 occurs

• I kept the windows open and did not click on anything
  http://www.example.com/administrator/index.php?option=com_joomlaupdate&view=update&layout=finaliseconfirm
• I opened a new window in which i loaded the page
  http://www.example.com/administrator/index.php?option=com_installer&task=database.fix
• This found issues and fixed them - it said the 'fields_groups' table was missing, perhaps add this in before running the upgrade.
• I went back to the other window and refreshed the page and it loaded to the 'login and cleanup page'
  http://www.example.com/administrator/index.php?option=com_joomlaupdate&view=update&layout=finaliseconfirm
  i logged in

Menu Items are missing

• after research i came across thess threads which said this script had not run script for some reason. it is for 3.7.0 but i used it for 3.8.0 as the code looks what is needed.
  • https://github.com/joomla/joomla-cms/pull/16577
  • https://github.com/joomla/joomla-cms/issues/15719
  • The Script: https://github.com/joomla/joomla-cms/blob/staging/administrator/components/com_admin/sql/updates/mysql/3.7.0-2017-01-17.sql
• Re-Run 'fix database' just in-case

Done

Links

• Unknown column 'client_id' in 'field list ERROR - Joomla! Forum - community, help and support