You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE id_parent=3 ORDER BY `position`' at line 5<br /><br /><pre> SELECT m.*, md.*
FROM ps_anblogcat m
LEFT JOIN ps_anblogcat_lang md
ON m.id_anblogcat = md.id_anblogcat AND md.id_lang = 2 JOIN ps_anblogcat_shop bs
ON m.id_anblogcat = bs.id_anblogcat AND bs.id_shop = 1 WHERE m.`active`=1 WHERE id_parent=3 ORDER BY `position` </pre>
at line 769 in file classes/db/Db.php
764. if ($webservice_call && $errno) {
765. $dbg = debug_backtrace();
766. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
768. if ($sql) {
769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
770. }
771.
772. throw new PrestaShopDatabaseException($this->getMsgError());
773. }
774. }
380. $this->result = $this->_query($sql);
381. }
382. }
383.
384. if (_PS_DEBUG_SQL_) {
385. $this->displayError($sql);
386. }
387.
388. return $this->result;
389. }
390.
Argument [0] SELECT m.*, md.* FROM ps_anblogcat m LEFT JOIN ps_anblogcat_lang md ON m.id_anblogcat = md.id_anblogcat AND md.id_lang = 2 JOIN ps_anblogcat_shop bs ON m.id_anblogcat = bs.id_anblogcat AND bs.id_shop = 1 WHERE m.`active`=1 WHERE id_parent=3 ORDER BY `position`
608. }
609.
610. return $this->execute($sql, $use_cache);
611. }
612.
613. $this->result = $this->query($sql);
614.
615. if (!$this->result) {
616. $result = false;
617. } else {
618. if (!$array) {
Argument [0] SELECT m.*, md.* FROM ps_anblogcat m LEFT JOIN ps_anblogcat_lang md ON m.id_anblogcat = md.id_anblogcat AND md.id_lang = 2 JOIN ps_anblogcat_shop bs ON m.id_anblogcat = bs.id_anblogcat AND bs.id_shop = 1 WHERE m.`active`=1 WHERE id_parent=3 ORDER BY `position`
418. if ($id_anblogcat != null) {
419. // validate module
420. $sql .= ' WHERE id_parent='.(int)$id_anblogcat;
421. }
422. $sql .= ' ORDER BY `position` ';
423. return Db::getInstance()->executeS($sql);
424. }
425.
426. public function getAllChild($id_anblogcat = null, $id_lang = null, $id_shop = null, $active = true)
427. {
428. if (!$id_lang) {
Argument [0] SELECT m.*, md.* FROM ps_anblogcat m LEFT JOIN ps_anblogcat_lang md ON m.id_anblogcat = md.id_anblogcat AND md.id_lang = 2 JOIN ps_anblogcat_shop bs ON m.id_anblogcat = bs.id_anblogcat AND bs.id_shop = 1 WHERE m.`active`=1 WHERE id_parent=3 ORDER BY `position`
169. 'navigationPipe' => Configuration::get('PS_NAVIGATION_PIPE'),
170. 'isNew' => $this->module->new174,
171. )
172. );
173. /* sub categories */
174. $categories = $category->getChild($category->id_anblogcat, $this->context->language->id);
175.
176. $childrens = array();
177.
178. if ($categories) {
179. foreach ($categories as $child) {
Argument [0] 3 Argument [1] 2
289. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
290. $this->initHeader();
291. }
292.
293. if ($this->viewAccess()) {
294. $this->initContent();
295. } else {
296. $this->errors[] = $this->trans('Access denied.', array(), 'Admin.Notifications.Error');
297. }
298.
299. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {
513. if (isset($params_hook_action_dispatcher)) {
514. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
515. }
516.
517. // Running controller
518. $controller->run();
519.
520. // Execute hook dispatcher after
521. if (isset($params_hook_action_dispatcher)) {
522. Hook::exec('actionDispatcherAfter', $params_hook_action_dispatcher);
523. }
23. * @copyright Since 2007 PrestaShop SA and Contributors
24. * @license https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
25. */
26.
27. require dirname(__FILE__).'/config/config.inc.php';
28. Dispatcher::getInstance()->dispatch();