[SOLVED] Stock Movement Error, PrestashopDatabaseExeption

[Czarekplpl]

Hello.

I've got an error in Stock>Stock Movement.

Looks like shop working well just in Stock Movement goes to this error:

[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]

Does anyone can help me solve this problem???

[NemoPS]

There is no zone column in my 1.6.0.9, are you using a third party module related to that? Exact ps version?

[Czarekplpl]

Yes, it was old third party module Advanced Stock Managemagement PRO which is not compatibile to 1.6

And this module made a big mass. So I override the override folder from fresh Presta and everything came back to normal. :-))

Problem solved.

[benjamin utterback]

Yes, it was old third party module Advanced Stock Managemagement PRO which is not compatibile to 1.6

And this module made a big mass. So I override the override folder from fresh Presta and everything came back to normal. :-))

Problem solved.

 

Thanks, I'll go ahead and mark this is as Solved!