Joomla: Unknown column client_id in where clause

Problem:

after update from 3.6.5 to 3.7.0, the modules menu shows the following error:
Unknown column ‘client_id’ in ‘where clause

 

The solution is to use phpMyadmin and run these queries

ALTER TABLE `#__menu_types` ADD COLUMN `client_id` int(11) NOT NULL DEFAULT 0;
UPDATE `#__menu` SET `published` = 1 WHERE `menutype` = 'main' OR `menutype` = 'menu';

Replace `#_` by your db prefix