Hi!
After many fixes, he could have Prestashop 1.7.6.0 working with the Warehouse theme. However I still have one to fix and I don't know how to do it.
When I enter the admin panel and try to access "CMS-Pages" I get the exception:
An exception occurred while executing 'SELECT cc.`id_cms_category`, cc.`id_parent`, cc.`active`, cc.`position`, ccl.`name`, ccl.`description` FROM ps_cms_category cc LEFT JOIN ps_cms_category_lang ccl ON ccl.`id_cms_category` = cc.`id_cms_category` INNER JOIN ps_cms_category_shop ccs ON ccs.`id_cms_category` = cc.`id_cms_category` WHERE (ccl.`id_lang` = ?) AND (ccl.`id_shop` IN (?)) AND (ccs.`id_shop` IN (?)) AND (cc.`id_parent` = ?) GROUP BY cc.`id_cms_category` ORDER BY id_webservice_account asc LIMIT 50 OFFSET 0' with params [1, 1, 1, 1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id_webservice_account' in 'order clause'
The SQL statement is wrong since it should be
SELECT cc.`id_cms_category`, cc.`id_parent`, cc.`active`, cc.`position`, ccl.`name`, ccl.`description` FROM ps_webservice_account wa, ps_cms_category cc LEFT JOIN ps_cms_category_lang ccl ON ccl.`id_cms_category` = cc.`id_cms_category` INNER JOIN ps_cms_category_shop ccs ON ccs.`id_cms_category` = cc.`id_cms_category` WHERE (ccl.`id_lang` = ?) AND (ccl.`id_shop` IN (?)) AND (ccs.`id_shop` IN (?)) AND (cc.`id_parent` = ?) GROUP BY cc.`id_cms_category` ORDER BY wa.id_webservice_account asc LIMIT 50 OFFSET 0
But I don't know where I can change it. Can you help me?
Prestashop 1.7.6.0 updated from Prestashop 1.6.0.14
PHP version 7.2 (I have also done tests with 7.1)
Thanks!
