Sorting pages with "Open in PrettyBlock" drives to a persistant error

[grismajeur]

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.

[hwctblanc]

prettyblocks.php private function _generateButtonPrettyBLocks add 'sortable' => false to setOptions method.