Joomla error: 1054 unknown column 'client_id' in 'where clause'

After upgrading your Joomla site, you may get the error message 'joomla error 1054 unknown column 'client_id' in 'where clause'' in the backend of your site. The error usually means that although you can log into the backend of your site e.g. www.your-site.co.uk/administrator - you do not see the usual control panel and instead it's an almost or completely blank screen.

To resolve this issue you need to run an SQL query. Log into your hosting control panel and in PHPMyAdmin run the following ensuring that you replace 'wapjc' with the prefix of your database tables:

ALTER TABLE `wapjc_menu_types` ADD COLUMN `client_id` int(11) NOT NULL DEFAULT 0;

UPDATE `wapjc_menu` SET `published` = 1 WHERE `menutype` = 'main' OR `menutype` = 'menu';

Once done, your should now be able to log into the backend of your Joomla site again.

If you are having issues, please get in touch and our team will be happy to help.