Skip to content

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

@grismajeur

Description

@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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions