Jump to content

Problem when i turned on delete function in adminorderscontroller.php


Recommended Posts

Hello guys,

 

Today when i truned on the delete function in adminorderscontroller.php ( so i can delete orders from my db ) i got this?

 

 
[b]	[PrestaShopDatabaseException][/b]

[b]Unknown column 'a.deleted' in 'where clause'[/b]

[b]		SELECT SQL_CALC_FOUND_ROWS
	a.`id_order`,`reference`,`total_paid_tax_incl`,`payment`,a.date_add as date_add
	, 
	a.id_currency,
	a.id_order AS id_pdf,
	CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `customer`,
	osl.`name` AS `osname`,
	os.`color`,
	IF((SELECT COUNT(so.id_order) FROM `ps_orders` so WHERE so.id_customer = a.id_customer) > 1, 0, 1) as new, shop.name as shop_name 
	FROM `ps_orders` a


	LEFT JOIN `ps_customer` c ON (c.`id_customer` = a.`id_customer`)
	LEFT JOIN `ps_order_state` os ON (os.`id_order_state` = a.`current_state`)
	LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1) 
	 LEFT JOIN ps_shop shop
						ON a.id_shop = shop.id_shop
	WHERE 1 AND a.`deleted` = 0  AND a.id_shop IN (1) 


	ORDER BY a.id_order DESC LIMIT 0,50[/b]
[i]at line [/i][b]607[/b][i] in file [/i][b]classes/db/Db.php[/b] 


601. 			WebserviceRequest::getInstance()->setError(500, '[sql Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
602. 		}
603. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
604. 		{
605. 			if ($sql)
[b][color="#f20000"]606. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
[/color][/b]607. 			throw new PrestaShopDatabaseException($this->getMsgError());
608. 		}
609. 	}
610. 
611. 	/**
[list]
[*][b]DbCore->displayError[/b] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][line 307 - classes/db/Db.php][/url] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][size="2"][1 Arguments][/size][/url] 

301. 		if ($sql instanceof DbQuery)
302. 			$sql = $sql->build();
303. 
304. 		$this->result = $this->_query($sql);
305. 		if (_PS_DEBUG_SQL_)
[b][color="#f20000"]306. 			$this->displayError($sql);
[/color][/b]307. 		return $this->result;
308. 	}
309. 
310. 	/**
311. 	 * Execute an INSERT query


[b]Argument [0][/b]

	SELECT SQL_CALC_FOUND_ROWS
	a.`id_order`,`reference`,`total_paid_tax_incl`,`payment`,a.date_add as date_add
	, 
	a.id_currency,
	a.id_order AS id_pdf,
	CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `customer`,
	osl.`name` AS `osname`,
	os.`color`,
	IF((SELECT COUNT(so.id_order) FROM `ps_orders` so WHERE so.id_customer = a.id_customer) > 1, 0, 1) as new, shop.name as shop_name 
	FROM `ps_orders` a


	LEFT JOIN `ps_customer` c ON (c.`id_customer` = a.`id_customer`)
	LEFT JOIN `ps_order_state` os ON (os.`id_order_state` = a.`current_state`)
	LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1) 
	 LEFT JOIN ps_shop shop
						ON a.id_shop = shop.id_shop
	WHERE 1 AND a.`deleted` = 0  AND a.id_shop IN (1) 


	ORDER BY a.id_order DESC LIMIT 0,50
[*][b]DbCore->query[/b] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][line 482 - classes/db/Db.php][/url] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][size="2"][1 Arguments][/size][/url] 

476. 		{
477. 			$this->last_cached = true;
478. 			return $result;
479. 		}
480. 
[b][color="#f20000"]481. 		$this->result = $this->query($sql);
[/color][/b]482. 		if (!$this->result)
483. 			return false;
484. 
485. 		$this->last_cached = false;
486. 		if (!$array)


[b]Argument [0][/b]

	SELECT SQL_CALC_FOUND_ROWS
	a.`id_order`,`reference`,`total_paid_tax_incl`,`payment`,a.date_add as date_add
	, 
	a.id_currency,
	a.id_order AS id_pdf,
	CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `customer`,
	osl.`name` AS `osname`,
	os.`color`,
	IF((SELECT COUNT(so.id_order) FROM `ps_orders` so WHERE so.id_customer = a.id_customer) > 1, 0, 1) as new, shop.name as shop_name 
	FROM `ps_orders` a


	LEFT JOIN `ps_customer` c ON (c.`id_customer` = a.`id_customer`)
	LEFT JOIN `ps_order_state` os ON (os.`id_order_state` = a.`current_state`)
	LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1) 
	 LEFT JOIN ps_shop shop
						ON a.id_shop = shop.id_shop
	WHERE 1 AND a.`deleted` = 0  AND a.id_shop IN (1) 


	ORDER BY a.id_order DESC LIMIT 0,50
[*][b]DbCore->executeS[/b] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][line 2200 - classes/controller/AdminController.php][/url] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][size="2"][1 Arguments][/size][/url] 

2194. 		'.$having_clause.'
2195. 		ORDER BY '.(($order_by == $this->identifier) ? 'a.' : '').pSQL($order_by).' '.pSQL($order_way).
2196. 		($this->_tmpTableFilter ? ') tmpTable WHERE 1'.$this->_tmpTableFilter : '').
2197. 		(($use_limit === true) ? ' LIMIT '.(int)$start.','.(int)$limit : '');
2198. 
[b][color="#f20000"]2199. 		if (!($this->_list = Db::getInstance()->executeS($this->_listsql)))
[/color][/b]2200. 			$this->_list_error = Db::getInstance()->getMsgError();
2201. 		else
2202. 			$this->_listTotal = Db::getInstance()->getValue('SELECT FOUND_ROWS() AS `'._DB_PREFIX_.$this->table.'`');
2203. 	}
2204. 	


[b]Argument [0][/b]

	SELECT SQL_CALC_FOUND_ROWS
	a.`id_order`,`reference`,`total_paid_tax_incl`,`payment`,a.date_add as date_add
	, 
	a.id_currency,
	a.id_order AS id_pdf,
	CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `customer`,
	osl.`name` AS `osname`,
	os.`color`,
	IF((SELECT COUNT(so.id_order) FROM `ps_orders` so WHERE so.id_customer = a.id_customer) > 1, 0, 1) as new, shop.name as shop_name 
	FROM `ps_orders` a


	LEFT JOIN `ps_customer` c ON (c.`id_customer` = a.`id_customer`)
	LEFT JOIN `ps_order_state` os ON (os.`id_order_state` = a.`current_state`)
	LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1) 
	 LEFT JOIN ps_shop shop
						ON a.id_shop = shop.id_shop
	WHERE 1 AND a.`deleted` = 0  AND a.id_shop IN (1) 


	ORDER BY a.id_order DESC LIMIT 0,50
[*][b]AdminControllerCore->getList[/b] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][line 1533 - classes/controller/AdminController.php][/url] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][size="2"][1 Arguments][/size][/url] 

1527. 	 */
1528. 	public function renderList()
1529. 	{
1530. 		if (!($this->fields_list && is_array($this->fields_list)))
1531. 			return false;
[b][color="#f20000"]1532. 		$this->getList($this->context->language->id);
[/color][/b]1533. 
1534. 		$helper = new HelperList();
1535. 		
1536. 		// Empty list is ok
1537. 		if (!is_array($this->_list))


[b]Argument [0][/b]
1
[*][b]AdminControllerCore->renderList[/b] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][line 1442 - classes/controller/AdminController.php][/url] - [size=3][0 Argument] [/size] 

[size=3]1436. 			$this->content .= $this->renderView();
1437. 		}
1438. 		elseif (!$this->ajax)
1439. 		{
1440. 			$this->content .= $this->renderModulesList();
[b][color="#f20000"]1441. 			$this->content .= $this->renderList();
[/color][/b]1442. 			$this->content .= $this->renderOptions();
1443. 
1444. 			// if we have to display the required fields form
1445. 			if ($this->required_database)
1446. 				$this->content .= $this->displayRequiredFields();
[/size]
[*][b]AdminControllerCore->initContent[/b] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][line 167 - classes/controller/Controller.php][/url] - [size=3][0 Argument] [/size] 

[size=3]161. 
162. 			if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
163. 				$this->initHeader();
164. 
165. 			if ($this->viewAccess())
[b][color="#f20000"]166. 				$this->initContent();
[/color][/b]167. 			else
168. 				$this->errors[] = Tools::displayError('Access denied.');
169. 
170. 			if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className)))
171. 				$this->initFooter();
[/size]
[*][b]ControllerCore->run[/b] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][line 349 - classes/Dispatcher.php][/url] - [size=3][0 Argument] [/size] 

[size=3]343. 			// Execute hook dispatcher
344. 			if (isset($params_hook_action_dispatcher))
345. 				Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
346. 
347. 			// Running controller
[b][color="#f20000"]348. 			$controller->run();
[/color][/b]349. 		}
350. 		catch (PrestaShopException $e)
351. 		{
352. 			$e->displayMessage();
353. 		}
[/size]
[*][b]DispatcherCore->dispatch[/b] - [url="http://zerocard.co/psadmin/index.php?controller=AdminOrders&token=402c25ed42893dabefefc679e1c75a3e#"][line 50 - psadmin/index.php][/url] - [size=3][0 Argument] [/size] 

[size=3]44. 	$_POST['controller'] = strtolower($_POST['tab']);
45. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab']))
46. 	$_REQUEST['controller'] = strtolower($_REQUEST['tab']);
47. 
48. // Prepare and trigger admin dispatcher
[b][color="#f20000"]49. Dispatcher::getInstance()->dispatch();[/color][/b][/size]
[/list]

Link to comment
Share on other sites

×
×
  • Create New...