ZeroCard Posted June 12, 2013 Share Posted June 12, 2013 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 More sharing options...
El Patron Posted June 12, 2013 Share Posted June 12, 2013 you should not be changing native ps when at all possible try this instead, by a top notch developer, and its free http://www.prestashop.com/forums/topic/191037-free-delete-orders-module/ Link to comment Share on other sites More sharing options...
Recommended Posts