CMS pages not showing in Back Office

[Nils-H]

I have a problem where only categories, but no cms pages, are listed in the back office. I have traced down the error to one line in AdminCmsController.php (https://github.com/PrestaShop/PrestaShop/blob/development/controllers/admin/AdminCmsController.php#L63), where the controller references a non existing column in the result set. However, this line of code appears to have been around for ages, so the actual error has to have been triggered by something else… Have anyone else experienced this? I have registered an issue for this bug, but if anyone can shed light on what else triggered the actual error, I'd be grateful.

 

The bug report is here: http://forge.prestashop.com/browse/PSCFV-11035

 

The error that occurs is:

 

Unknown column 'a.position' in 'field list'

 

SELECT SQL_CALC_FOUND_ROWS

        b.*, a.*
        , a.position
        FROM `lns_cms` a
        LEFT JOIN `lns_cms_lang` b ON (b.`id_cms` = a.`id_cms` AND b.`id_lang` = 6)
        
        LEFT JOIN `lns_cms_category` c ON (c.`id_cms_category` = a.`id_cms_category`)
        
        WHERE 1 AND c.id_cms_category = 1
        
        
        ORDER BY position ASC LIMIT 0,50

[Alex Simonchik BelVG]

Hi,

 

You can run this SQL query in your DB: 

ALTER TABLE  `lns_cms` ADD  `position` INT( 10 ) UNSIGNED NOT NULL DEFAULT  '0'

maybe it help you

 

Regards

[Nils-H]

To "fix" it, I can just comment out the line that adds the position field to the sql, but it still doesn't explain or solve the actual error.

Edited November 18, 2013 by Nils-H (see edit history)