Jump to content

Backoffice Errors 500 - CMS pages


koyocik
 Share

Recommended Posts

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? 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More