Wyszukaj

Witam. Pojawił mi się błąd, w Menu>Stock>Stock Movement. Naprawa bazy w Mysqlu nie dała rezultatu. Błąd wygłąda tak: [PrestaShopDatabaseException] Unknown column 'wpl.zone' in 'field list' SELECT SQL_CALC_FOUND_ROWS a.* , CONCAT(pl.name, ' ', GROUP_CONCAT(IFNULL(al.name, ''), '')) product_name, CONCAT(a.employee_lastname, ' ', a.employee_firstname) as employee, mrl.name as reason, stock.reference as product_reference, stock.ean13 as product_ean13, stock.upc as product_upc, w.id_currency as id_currency, w.name as warehouse_name, so.reference as supply_order_reference, a.id_supply_order as product_id_supply_order, CONCAT(wpl.zone, ";", wpl.sous_zone, ";", wpl.location) as location, stock.id_product, stock.id_product_attribute, sign FROM `ps_stock_mvt` a INNER JOIN ps_stock stock ON a.id_stock = stock.id_stock LEFT JOIN `ps_product_lang` pl ON ( stock.id_product = pl.id_product AND pl.id_lang = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_stock_mvt_reason_lang` mrl ON ( a.id_stock_mvt_reason = mrl.id_stock_mvt_reason AND mrl.id_lang = 1 ) LEFT JOIN `ps_warehouse` w ON (w.id_warehouse = stock.id_warehouse) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.id_product_attribute = stock.id_product_attribute) LEFT JOIN `ps_attribute_lang` al ON ( al.id_attribute = pac.id_attribute AND al.id_lang = 1 ) LEFT JOIN `ps_supply_order` so ON (a.id_supply_order = so.id_supply_order) LEFT JOIN `ps_warehouse_product_location` wpl ON (wpl.id_product = stock.id_product AND wpl.id_product_attribute = stock.id_product_attribute) WHERE 1 GROUP BY a.id_stock_mvt ORDER BY a.`id_stock_mvt` ASC LIMIT 0,50 at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$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 501 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 2791 - classes/controller/AdminController.php] - [3 Arguments] AdminControllerCore->getList - [line 233 - controllers/admin/AdminStockMvtController.php] - [6 Arguments] AdminStockMvtControllerCore->getList - [line 193 - override/controllers/admin/AdminStockMvtController.php] - [6 Arguments] AdminStockMvtController->getList - [line 1992 - classes/controller/AdminController.php] - [1 Arguments] AdminControllerCore->renderList - [line 186 - override/controllers/admin/AdminStockMvtController.php] AdminStockMvtController->renderList - [line 1768 - classes/controller/AdminController.php] AdminControllerCore->initContent - [line 312 - controllers/admin/AdminStockMvtController.php] AdminStockMvtControllerCore->initContent - [line 180 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 54 - admin/index.php] Czy ktoś mi pomoże rozwiłać ten problem??