Backoffice Errors 500 - CMS pages

[koyocik]

Hi, after update from 1.7.2 to 1.7.6.4 I got an error in backoffice, when I try to get to Design->Pages.

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 date_add DESC LIMIT 50 OFFSET 0' with params [1, 1, 1, 1]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'date_add' in 'order clause'

I compared ps_cms table to fresh installed prestashop 1.7.6.4 and has the same columns, no "date_add".

 

Any help? 

[koyocik]

I added column "date add" and it works, but still seems strange, as it does not have this column in fresh install.