Witam.
W Menu>Stock>Stock Movement pojawił mi się błąd.
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ś wie jak rozwiążać ten problem?
Pozdrawiam
Czarek.
