-
-
Notifications
You must be signed in to change notification settings - Fork 43
Open
Description
Platform: Prestashop 8.2.3
Page on which error appeared: pages's page (/admin/index.php/improve/design/cms-pages/), the listing of the shop pages.
Issue constated: Sorting pages with "Open in PrettyBlock" drives to a persistant error which message is:
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing 'SELECT c.`id_cms`, cl.`link_rewrite`, c.`active`, c.`position`, cl.`meta_title`, cl.`head_seo_title`, c.`id_cms_category` FROM ps_cms c LEFT JOIN ps_cms_lang cl ON cl.`id_cms` = c.`id_cms` INNER JOIN ps_cms_shop cs ON cs.`id_cms` = c.`id_cms` WHERE (cl.`id_lang` = ?) AND (cl.`id_shop` IN (?)) AND (cs.`id_shop` IN (?)) AND (c.`id_cms_category` = ?) GROUP BY c.`id_cms` ORDER BY edit2 asc LIMIT 50' with params [1, 1, 1, 1]:
Not working workarounds: Emptying the cache or removing any cooky doesn't solve the problem. Each time you reach the listing page (/admin/index.php/improve/design/cms-pages/) the error is displayed and the page is no accessible any more.
Efficient workaround: use an SQL removal instruction:
DELETE FROM ps_admin_filter WHERE filter_id LIKE '%cms%' AND filter LIKE '%edit2%';
Correction to do: I don't know.
Metadata
Metadata
Assignees
Labels
No labels