cl.id_shop' in 'where clause

[1qwerty1]

Witam

 

Prosiłbym o pomoc albo nakierowanie co mam zrobić z takim o to błędem: 

 

[PrestaShopDatabaseException]

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

SELECT cl.`meta_title`, cl.`link_rewrite`
            FROM `ps_cms_lang` cl
            INNER JOIN `ps_cms` c
            ON (cl.`id_cms` = c.`id_cms`)
            WHERE cl.`id_cms` = 1
            AND (c.`active` = 1 OR c.`id_cms` = 1)
            AND cl.`id_shop` = 1
            AND cl.`id_lang` = 1 LIMIT 1
at line 635 in file classes/db/Db.php

 

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

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
630.         }
631.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
632.         {
633.             if ($sql)
634.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
635.             throw new PrestaShopDatabaseException($this->getMsgError());
636.         }
637.     }
638.
639.     /**

• DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 547 - classes/db/Db.php] - [1 Arguments]
• DbCore->getRow - [line 325 - modules/blockcms/BlockCMSModel.php] - [1 Arguments]
• BlockCMSModel::getCMSMetaTitle - [line 279 - modules/blockcms/BlockCMSModel.php] - [1 Arguments]
• BlockCMSModel::getCMSTitlesFooter - [line 861 - modules/blockcms/blockcms.php]
• BlockCms->hookFooter - [line 509 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 811 - classes/controller/FrontController.php] - [1 Arguments]
• FrontControllerCore->initFooter - [line 185 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

 

Miałem do aktualizacji kilka modułów i po prostu wszystkie naraz zaktualizowałem. 

Z góry dziękuję za pomoc

[endriu107]

Zobacz w tej tabeli ps_cms_lang czy masz kolumne id_shop.

[1qwerty1]

Zobacz w tej tabeli ps_cms_lang czy masz kolumne id_shop.

nie ma, sa tylko: 

 

id_cms id_lang meta_title meta_description meta_keywords content link_rewrite

[endriu107]

To musisz ją tam dodać z wartością domyślną 1.

[1qwerty1]

To musisz ją tam dodać z wartością domyślną 1.

Ok wszystko działa. 

Dzięki za pomoc.

[pimastickerslab]

I have today idem problem!!!! please send me a solution, i'm not expert!

[endriu107]

You need to add column id_shop with default value 1 in table pc_cms_lang.

[pimastickerslab]

please i'm italian, can i edit the table pc_cms_lang? please...

Edited July 20, 2015 by pimastickerslab (see edit history)

[endriu107]

Sorry it should be table ps_cms_lang if you didn't change table prefix and this is in your sql datebase.

[pimastickerslab]

id_shop not present in my ps_cms_lang

i need to insert this? 

This is correct?

 

what is the procedure?

 

yhis is present

 

id_cms id_lang meta_title meta_description meta_keywords content link_rewrite

Edited July 20, 2015 by pimastickerslab (see edit history)

[pimastickerslab]

it's correct? 

 

 

http://i1284.photobucket.com/albums/a562/PimaStickerslab/corretto_zpsrwz8ot8p.jpg~original

 

yes it work's!!!!! very very very best!!!!!

Edited July 20, 2015 by pimastickerslab (see edit history)

[endriu107]

You better use this query:

 

ALTER TABLE `ps_cms_lang` ADD `id_shop` int NOT NULL DEFAULT 1 AFTER `id_lang`

[ariels3]

You better use this query:

 

ALTER TABLE `ps_cms_lang` ADD `id_shop` int NOT NULL DEFAULT 1 AFTER `id_lang`

 

its correct! thanks endriu107!!!

[endriu107]

What's happened, why everybody has the same problem? Did you updates some modules?

[Valkyrija]

Díky...

Yes i come back after 2 weeks in hospital and wait for me some module updates... but i use "update all" and from this moment start this problem...
Now is everything OK... thx for this query