prestashop 1.6.1.8 Table 'prestashop.ps_cms_block' doesn't exist

[yayou]

please help , the accueil work fine but whene i click on categorie or product , this error show on,

[PrestaShopDatabaseException]

Table '........_prestashop.ps_cms_block' doesn't existSELECT bc.`id_cms_block`, bc.`id_cms_category`, bc.`display_store`, ccl.`link_rewrite`, ccl.`name` category_name, bcl.`name` block_name            FROM `ps_cms_block` bc            LEFT JOIN `ps_cms_block_shop` bcs            ON (bcs.id_cms_block = bc.id_cms_block)            INNER JOIN `ps_cms_category_lang` ccl            ON (bc.`id_cms_category` = ccl.`id_cms_category`)            INNER JOIN `ps_cms_block_lang` bcl            ON (bc.`id_cms_block` = bcl.`id_cms_block`)            WHERE bc.`location` = 0            AND ccl.`id_lang` = 1            AND bcl.`id_lang` = 1            AND bcs.id_shop = 1 AND ccl.`id_shop` = 1            ORDER BY `position`at line 791 in file classes/db/Db.php  if ($sql) {791.                 throw new     PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');792.             }DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]DbCore->executeS - [line 360 - modules/blockcms/BlockCMSModel.php] - [1 Arguments]BlockCMSModel::getCMSCategoriesByLocation - [line 581 - modules/blockcms/BlockCMSModel.php] - [2 Arguments]BlockCMSModel::getCMSTitles - [line 802 - modules/blockcms/blockcms.php] - [1 Arguments]BlockCms->displayBlockCMS - [line 841 - modules/blockcms/blockcms.php] - [1 Arguments]BlockCms->hookLeftColumn - [line 587 - classes/Hook.php] - [1 Arguments]HookCore::coreCallHook - [line 544 - classes/Hook.php] - [3 Arguments]HookCore::exec - [line 581 - classes/controller/FrontController.php] - [1 Arguments]FrontControllerCore->initContent - [line 129 - controllers/front/CategoryController.php]CategoryControllerCore->initContent - [line 189 - classes/controller/Controller.php]ControllerCore->run - [line 367 - classes/Dispatcher.php]DispatcherCore->dispatch - [line 28 - index.php]

[JayLab]

Does this table exist in your database ? If not create it, install a fresh one to see the structure.

[yayou]

hello , i did create this table , a another error show ,

Table 'cecidxeu_prestashop.ps_cms_block_shop' doesn't exist

but this table exist ,

 

the web site work well in the local , when i imigrate to web , the error shows up ,

thank you for help

[JayLab]

What is the full message ?

[yayou]

hello , thank you Enthusiast , i solve the probléme by desinstall the CMS block module , it work fine now , thank you again

[JayLab]

As i am reading your answer, i remember that it happens to me too, i reinstalled the modules concerned after and table were created and modules were working fine.