Page 1 of 1

Joomla Admin Error: Unknown column 'a.client_id' in 'where clause': Unknown column 'a.client_id' in 'where clause'

Posted: Mon Feb 04, 2019 11:18 am
by stuartb42
Hello
I wonder if anyone can help. I am running a Joomla intranet site on a synology box. I have recently upgraded joomla to version 3.8.8-0166. The front end is all working fine but when I login to the admin page I just get a blue header with the following words:
Error: Unknown column 'a.client_id' in 'where clause': Unknown column 'a.client_id' in 'where clause'

Any ideas on how to fix this? as I am a little stuck on what to do next.

Many thanks

Stuart

Re: Joomla Admin Error: Unknown column 'a.client_id' in 'where clause': Unknown column 'a.client_id' in 'where clause'

Posted: Tue Feb 05, 2019 5:18 am
by imanickam
Can you please check whether the database schema is up to date? This could be done in the screen "Extensions: Database".

Make sure to take a backup of your site (both files and database content) before attempting the fix, if need be.

Re: Joomla Admin Error: Unknown column 'a.client_id' in 'where clause': Unknown column 'a.client_id' in 'where clause'

Posted: Tue Feb 05, 2019 11:18 am
by stuartb42
Hello thanks, I have just managed to find a fix this morning. I put the following in:
MYWEBSITE/administrator/index.php?option=com_installer&view=database
It found 2 Database Problems. I was then able to update and fix the database