Prbolem with CMS : "category cannot be loaded "

[Adrien Belhomme]

Hello everybody,

 

I have an issue with my CMS pages, they do not dipslay in the front office (404 error) and when I try to access the cms in the back office, I have the following message : category cannot be loaded 

 

Could anyone help me ?

 

Thanks guys !

 

By the way, this is the message I get with full explanation :

[PrestaShopDatabaseException]

Unknown column 'b.id_shop' in 'where clause'
 

SELECT *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1
LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1
WHERE (a.id_cms = 7) AND (b.id_shop = 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 52 - controllers/front/CmsController.php] - [3 Arguments]
• CmsControllerCore->init - [line 163 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

[jgamio]

Check your Database looking for table 

 

ps_cms_lang

 

do you have id_shop field  ?

[Adrien Belhomme]

Hey  jgamio,

 

thanks for answering me.

 

 

There is no  id_shop field in the ps_cms_lang table.

Only id_cms and id_lang

[jgamio]

You are right is not that field on the table but the error is because is looking for that

 

Are you custom you cms module ?

 

 

Version are you using ?

[Adrien Belhomme]

I'm using a theme I've downloaded for prestashop.

 

And I've created pages via CMS but no custom module.

 

I'm using the 1.6 version

[jgamio]

You can see the list ?

[Adrien Belhomme]

I'm able to see the cms pages I've created in phpmyadmin yes.

 

But not in the back office 

[ruben_ortega]

Hi!

 

I have the same problem. I got "not found page" at the front-end and this error at the back-end when I enter at the CMS.

[PrestaShopDatabaseException]

Table 'db561183755.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]

[climaticmoments]

Hi,

 

I am not a tech by any means, but I guess I am following this topic and saw your dilemma and think I can help you a little bit.

 

I read through and if I read it correctly you are able to see the CMS pages you created, but they are empty and or missing when you try to load them.

 

My solution was fixed by doing the following..

 

If you are able to access PhpMyAdmin..

• Check to make sure your ps_cms_lang  has the field id_shop
• Check to make sure your ps_cms_category_language  has the field id_shop

If one or both don't have those fields you will need to add them.

 

As far as if you need help adding those fields, it wouldn't be a good idea for me to help. I just barely make it by when it comes to queries and those sort of things.

 

I hope I was able to help you.

 

Tina

www.climaticmoments.com

[lovemyseo]

Hi can you send me the screen shoot of your database ?

Hi,

 

I am not a tech by any means, but I guess I am following this topic and saw your dilemma and think I can help you a little bit.

 

I read through and if I read it correctly you are able to see the CMS pages you created, but they are empty and or missing when you try to load them.

 

My solution was fixed by doing the following..

 

If you are able to access PhpMyAdmin..

• Check to make sure your ps_cms_lang  has the field id_shop
• Check to make sure your ps_cms_category_language  has the field id_shop

If one or both don't have those fields you will need to add them.

 

As far as if you need help adding those fields, it wouldn't be a good idea for me to help. I just barely make it by when it comes to queries and those sort of things.

 

I hope I was able to help you.

 

Tina

www.climaticmoments.com