[PrestaShopDatabaseException]

Unknown column 'cl.additional_description' in 'field list'<br /><br /><pre> SELECT c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description` FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 2 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC</pre>
at line 773 in file classes/db/Db.php

768.         if ($webservice_call && $errno) {
769.             $dbg = debug_backtrace();
770.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
771.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
772.             if ($sql) {
773.                 throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
774.             }
775. 
776.             throw new PrestaShopDatabaseException($this->getMsgError());
777.         }
778.     }

• DbCore->displayError - [line 385 - classes/db/Db.php]

  380.             $this->connect();
  381.             $this->result = $this->_query($sql);
  382.         }
  383. 
  384.         if (_PS_DEBUG_SQL_) {
  385.             $this->displayError($sql);
  386.         }
  387. 
  388.         return $this->result;
  389.     }
  390. 
  

• DbCore->query - [line 614 - classes/db/Db.php]

  609.             || stripos($sql, 'dumpfile') !== false
  610.         ) {
  611.             throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');
  612.         }
  613. 
  614.         $this->result = $this->query($sql);
  615. 
  616.         if (!$this->result) {
  617.             $result = false;
  618.         } else {
  619.             if (!$array) {
  

• DbCore->executeS - [line 924 - classes/Category.php]

  919. 		' . Shop::addSqlAssociation('category', 'c') . '
  920. 		LEFT JOIN `' . _DB_PREFIX_ . 'category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = ' . (int) $idLang . ' ' . Shop::addSqlRestrictionOnLang('cl') . ')
  921. 		' . $sqlGroupsJoin . '
  922. 		WHERE `id_parent` = ' . (int) $this->id . '
  923. 		' . ($active ? 'AND `active` = 1' : '') . '
  924. 		' . $sqlGroupsWhere . '
  925. 		GROUP BY c.`id_category`
  926. 		ORDER BY `level_depth` ASC, category_shop.`position` ASC');
  927. 
  928.         foreach ($result as &$row) {
  929.             $row['id_image'] = Tools::file_exists_cache($this->image_dir . $row['id_category'] . '.jpg') ? (int) $row['id_category'] : Language::getIsoById($idLang) . '-default';
  

• CategoryCore->getSubCategories - [line 892 - controllers/front/ProductController.php]

  887.             $this->category = new Category((int) $this->product->id_category_default, (int) $this->context->language->id);
  888.         }
  889. 
  890.         $sub_categories = [];
  891.         if (Validate::isLoadedObject($this->category)) {
  892.             $sub_categories = $this->category->getSubCategories($this->context->language->id, true);
  893. 
  894.             // various assignements before Hook::exec
  895.             $this->context->smarty->assign([
  896.                 'category' => $this->category,
  897.                 'subCategories' => $sub_categories,
  

• ProductControllerCore->assignCategory - [line 368 - controllers/front/ProductController.php]

  363.                 }
  364.                 unset($customization_field);
  365.             }
  366. 
  367.             // Assign template vars related to the category + execute hooks related to the category
  368.             $this->assignCategory();
  369.             // Assign template vars related to the price and tax
  370.             $this->assignPriceAndTax();
  371. 
  372.             // Assign attributes combinations to the template
  373.             $this->assignAttributesCombinations();
  

• ProductControllerCore->initContent - [line 17 - override/controllers/front/ProductController.php]

  12. 		$this->context->smarty->assign(array(
  13. 			'prev_product'=> $adjacent_products['previous'],
  14. 			'next_product'=> $adjacent_products['next']
  15. 		));
  16. 
  17. 		parent::initContent();
  18. 	}	
  19. }

• ProductController->initContent - [line 319 - classes/controller/Controller.php]

  314.             if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
  315.                 $this->initHeader();
  316.             }
  317. 
  318.             if ($this->viewAccess()) {
  319.                 $this->initContent();
  320.             } else {
  321.                 $this->errors[] = $this->trans('Access denied.', [], 'Admin.Notifications.Error');
  322.             }
  323. 
  324.             if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {
  

• ControllerCore->run - [line 510 - classes/Dispatcher.php]

  505. 
  506.             // Execute hook dispatcher
  507.             Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
  508. 
  509.             // Running controller
  510.             $controller->run();
  511. 
  512.             // Execute hook dispatcher after
  513.             Hook::exec('actionDispatcherAfter', $params_hook_action_dispatcher);
  514.         } catch (PrestaShopException $e) {
  515.             $e->displayMessage();
  

• DispatcherCore->dispatch - [line 28 - index.php]

  23.  * @copyright Since 2007 PrestaShop SA and Contributors
  24.  * @license   https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
  25.  */
  26. 
  27. require dirname(__FILE__).'/config/config.inc.php';
  28. Dispatcher::getInstance()->dispatch();