CMS backend "Category cannot be loaded" error

[skullym]

I am unable to access the CMS pages in my back office. I get the following error :

 

"Category can not be loaded". 

 

This was all working fine till yesterday.

 

When I turn on debugging mode I get the following database exception below.

 

Can anyone tell me where the error is and what I should do to correct it ?

 

Thanks for your help

 

M. Schulster

 

[PrestaShopDatabaseException]

Table 'ophos25032_ps1.ps_cms_category_shop' doesn't exist
 

SELECT *
FROM `ps_cms_category` a
LEFT JOIN `ps_cms_category_shop` `c` ON a.id_cms_category = c.id_cms_category AND c.id_shop = 1
WHERE (a.id_cms_category = 1) LIMIT 1
at line 646 in file classes/db/Db.php

 

641.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642.         }
643.         elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644.         {
645.             if ($sql)
646.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647.             throw new PrestaShopDatabaseException($this->getMsgError());
648.         }
649.     }
650.
651.     /**

• DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 558 - classes/db/Db.php] - [1 Arguments]
• DbCore->getRow - [line 233 - classes/ObjectModel.php] - [1 Arguments]
• ObjectModelCore->__construct - [line 43 - controllers/admin/AdminCmsContentController.php] - [1 Arguments]
• AdminCmsContentControllerCore->__construct - [line 135 - classes/controller/Controller.php] - [2 Arguments]
• ControllerCore::getController - [line 366 - classes/Dispatcher.php] - [1 Arguments]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

[skullym]

ok I think I have found a solution (posted elsewhere on the forum) by replacing the classes/shop/Shop.php file from a fresh download.

 

I now have acces via the back office to the CMS module but I seem to have lost all of my previous cms pages.

 

Are they recoverable somewhere ?

 

 

[zelduxs]

I have the same problem

[zelduxs]

my version of the prestashop has been 1.6.0.11 and a new version has been installed 1.6.0.14

Mysql prestashop 1.6.0.14 It has several new tables

Installation of the base I took table and import in my db

ps_cms_category_shop

delete old ps_cms_category_lang and import new ps_cms_category_lang (because that no column id_shop and can't creat new)

 

export ps_cms_lang to csv, insert new column 1,1,1,1,1... and 

delete old ps_cms_lang and import new ps_cms_lang (because that no column id_shop and can't creat new)