Expression #1 of ORDER BY clause is not in SELECT list, references column 'goorgani_live.cs.position' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT c.*, cl.*
FROM `ps_category` c
LEFT JOIN `ps_category_shop` cs ON (c.`id_category`=cs.`id_category` AND cs.`id_shop`=1)
LEFT JOIN `ps_category_lang` cl ON (cs.`id_category`=cl.`id_category` AND cl.`id_shop`=cs.`id_shop` AND `id_lang` = 1)
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE c.`active` = 1 AND cl.`id_shop` IS NOT NULL AND `level_depth` <= 8
AND cg.`id_group` = 1
ORDER BY cs.`position` ASC ,`level_depth` ASC
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. /**
319. if ($sql instanceof DbQuery)
320. $sql = $sql->build();
321.
322. $this->result = $this->_query($sql);
323. if (_PS_DEBUG_SQL_)
324. $this->displayError($sql);
325. return $this->result;
326. }
327.
328. /**
329. * Execute an INSERT query
Argument [0] SELECT DISTINCT c.*, cl.* FROM `ps_category` c LEFT JOIN `ps_category_shop` cs ON (c.`id_category`=cs.`id_category` AND cs.`id_shop`=1) LEFT JOIN `ps_category_lang` cl ON (cs.`id_category`=cl.`id_category` AND cl.`id_shop`=cs.`id_shop` AND `id_lang` = 1) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE c.`active` = 1 AND cl.`id_shop` IS NOT NULL AND `level_depth`
495. {
496. $this->last_cached = true;
497. return $result;
498. }
499.
500. $this->result = $this->query($sql);
501.
502. if (!$this->result)
503. $result = false;
504. else
505. {
Argument [0] SELECT DISTINCT c.*, cl.* FROM `ps_category` c LEFT JOIN `ps_category_shop` cs ON (c.`id_category`=cs.`id_category` AND cs.`id_shop`=1) LEFT JOIN `ps_category_lang` cl ON (cs.`id_category`=cl.`id_category` AND cl.`id_shop`=cs.`id_shop` AND `id_lang` = 1) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE c.`active` = 1 AND cl.`id_shop` IS NOT NULL AND `level_depth`
1335. LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON (cg.`id_category` = c.`id_category`)
1336. WHERE c.`active` = 1 AND cl.`id_shop` IS NOT NULL' .(intval($maxdepth) != 0 ? ' AND `level_depth` <= '.intval($maxdepth) : '').'
1337. AND cg.`id_group` '.(!$id_customer ? '= 1' : 'IN (SELECT id_group FROM '._DB_PREFIX_.'customer_group WHERE id_customer = '.intval($id_customer).')').'
1338. ORDER BY cs.`position` ASC ,`level_depth` ASC';
1339.
1340. if (!$result = Db::getInstance()->ExecuteS($sql))
1341. return;
1342. $resultParents = array();
1343. $resultIds = array();
1344.
1345. foreach ($result as $row)
Argument [0] SELECT DISTINCT c.*, cl.* FROM `ps_category` c LEFT JOIN `ps_category_shop` cs ON (c.`id_category`=cs.`id_category` AND cs.`id_shop`=1) LEFT JOIN `ps_category_lang` cl ON (cs.`id_category`=cl.`id_category` AND cl.`id_shop`=cs.`id_shop` AND `id_lang` = 1) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE c.`active` = 1 AND cl.`id_shop` IS NOT NULL AND `level_depth`
1440. {
1441. if($option['content_option']->opt_show_parent_cat == 1 || $option['content_option']->opt_show_image_cat == 1)
1442. {
1443. $option['category_parent']= new Category($option['content_option']->opt_id_parent_cat,(int)Context::getContext()->language->id);
1444. }
1445. $option['sub_category'] = $this->getAllSubCategory($option['content_option']->opt_id_parent_cat);
1446. }
1447. if($option['type_option'] == 1) /*option 1 : type product*/
1448. {
1449. if(isset($option['content_option']->input_hidden_id) && $option['content_option']->input_hidden_id!="")
1450. {
Argument [0] 32
1602. {
1603. if (!$this->isCached('csmegamenu.tpl', $this->getCacheId('csmegamenu')))
1604. {
1605. $this->user_groups = ($this->context->customer->getGroups());
1606. $option_megamenu = simplexml_load_file(dirname(__FILE__).'/'.'option.xml');
1607. $menus = $this->getMenuDisplay();
1608. $this->_respMenu="";
1609. $responsive_menu = $this->_buildResponsiveMenu();
1610. $this->context->smarty->assign(array(
1611. 'menus' => $menus,
1612. 'ps_manu_img_dir' => _PS_MANU_IMG_DIR_,
501. if ($use_push && isset($moduleInstance->push_filename) && file_exists($moduleInstance->push_filename))
502. Tools::waitUntilFileIsModified($moduleInstance->push_filename, $moduleInstance->push_time_limit);
503.
504. // Call hook method
505. if ($hook_callable)
506. $display = $moduleInstance->{'hook'.$hook_name}($hook_args);
507. elseif ($hook_retro_callable)
508. $display = $moduleInstance->{'hook'.$retro_hook_name}($hook_args);
509. // Live edit
510. if (!$array_return && $array['live_edit'] && Tools::isSubmit('live_edit') && Tools::getValue('ad') && Tools::getValue('liveToken') == Tools::getAdminToken('AdminModulesPositions'.(int)Tab::getIdFromClassName('AdminModulesPositions').(int)Tools::getValue('id_employee')))
511. {
Argument [0]
182. if ($module && $module->id)
183. $id_module = $module->id;
184. unset($hook_params['mod']);
185. }
186. unset($hook_params['h']);
187. return Hook::exec($params['h'], $hook_params, $id_module);
188. }
189. }
190.
191. function toolsConvertPrice($params, &$smarty)
192. {
Argument [0] displayNav Argument [1] Argument [2]
235. if($a == 0)
236. $args[] = $arguments[0];
237. else
238. $args[] = &$arguments[$a];
239.
240. return call_user_func_array($item, $args);
241. }
242. }
243.
244. public static function getInstance()
245. {
Argument [0] Array ( [h] => displayNav ) Argument [1]
287.
288. <div class="mode_megamenu clearfix">
289.
290. <div class="container_24">
291.
292. <?php echo $_smarty_tpl->smarty->registered_plugins[Smarty::PLUGIN_FUNCTION]['hook'][0][0]->smartyHook(array('h'=>"displayNav"),$_smarty_tpl);?>
293.
294.
295. </div>
296.
297. </div>
Argument [0] smartyHook Argument [1]
182. }
183. array_unshift($_template->_capture_stack, array());
184. //
185. // render compiled template
186. //
187. $_template->properties['unifunc']($_template);
188. // any unclosed {capture} tags ?
189. if (isset($_template->_capture_stack[0][0])) {
190. $_template->capture_error();
191. }
192. array_shift($_template->_capture_stack);
Argument [0]
297. foreach ($data as $_key => $_val) {
298. $tpl->tpl_vars[$_key] = new Smarty_variable($_val);
299. }
300. }
301.
302. return $tpl->fetch(null, null, null, null, false, false, true);
303. }
304.
305. /**
306. * Template code runtime function to set up an inline subtemplate
307. *
Argument [0] Argument [1] Argument [2] Argument [3] Argument [4] Argument [5] Argument [6] 1
40. <?php $_smarty_tpl->tpl_vars['right_column_size'] = new Smarty_variable(0, null, 0);?>
41. <?php } else { ?>
42. <?php $_smarty_tpl->tpl_vars['right_column_size'] = new Smarty_variable(6, null, 0);?>
43. <?php }?>
44. <?php }?>
45. <?php if (!empty($_smarty_tpl->tpl_vars['display_header']->value)) {?><?php echo $_smarty_tpl->getSubTemplate (((string)$_smarty_tpl->tpl_vars['tpl_dir']->value)."./header.tpl", $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, 0, null, array('HOOK_HEADER'=>$_smarty_tpl->tpl_vars['HOOK_HEADER']->value), 0);?>
46. <?php }?>
47. <?php if (!empty($_smarty_tpl->tpl_vars['template']->value)) {?><?php echo $_smarty_tpl->tpl_vars['template']->value;?>
48. <?php }?>
49. <?php if (!empty($_smarty_tpl->tpl_vars['display_footer']->value)) {?><?php echo $_smarty_tpl->getSubTemplate (((string)$_smarty_tpl->tpl_vars['tpl_dir']->value)."./footer.tpl", $_smarty_tpl->cache_id, $_smarty_tpl->compile_id, 0, null, array(), 0);?>
50. <?php }?>
Argument [0] /home/goorgani/public_html/themes/pt_fashionixx/./header.tpl Argument [1] Argument [2] Argument [3] 0 Argument [4] Argument [5] Array ( [HOOK_HEADER] => // (function (i, s, o, g, r, a, m) { i['GoogleAnalyticsObject'] = r; i[r] = i[r] || function () { (i[r].q = i[r].q || []).push(arguments) }, i[r].l = 1 * new Date(); a = s.createElement(o), m = s.getElementsByTagName(o)[0]; a.async = 1; a.src = g; m.parentNode.insertBefore(a, m) })(window, document, 'script', '//www.google-analytics.com/analytics.js', 'ga'); ga('create', 'UA-62867891-1'); ga('send', 'pageview'); /* * 2007-2018 PrestaShop * * NOTICE OF LICENSE * * This source file is subject to the Academic Free License (AFL 3.0) * that is bundled with this package in the file LICENSE.txt. * It is also available through the world-wide-web at this URL: * http://opensource.org/licenses/afl-3.0.php * If you did not receive a copy of the license and are unable to * obtain it through the world-wide-web, please send an email * to license@prestashop.com so we can send you a copy immediately. * * DISCLAIMER * * Do not edit or add to this file if you wish to upgrade PrestaShop to newer * versions in the future. If you wish to customize PrestaShop for your * needs please refer to http://www.prestashop.com for more information. * * @author 2007-2019 PayPal * @author 2007-2013 PrestaShop SA * @author 2014-2019 202 ecommerce * @copyright PayPal * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) * */ function updateFormDatas() { var nb = $('#quantity_wanted').val(); var id = $('#idCombination').val(); $('.paypal_payment_form input[name=quantity]').val(nb); $('.paypal_payment_form input[name=id_p_attr]').val(id); } $(document).ready( function() { var baseDirPP = baseDir; if($('#in_context_checkout_enabled').val() != 1) { $(document).on('click','#payment_paypal_express_checkout', function() { $('#paypal_payment_form_cart').submit(); return false; }); } var jquery_version = $.fn.jquery.split('.'); if(jquery_version[0]>=1 && jquery_version[1] >= 7) { $('body').on('submit',".paypal_payment_form", function () { updateFormDatas(); }); } else { $('.paypal_payment_form').live('submit', function () { updateFormDatas(); }); } function displayExpressCheckoutShortcut() { var id_product = $('input[name="id_product"]').val(); var id_product_attribute = $('input[name="id_product_attribute"]').val(); $.ajax({ type: "GET", url: baseDirPP+'/modules/paypal/express_checkout/ajax.php', data: { get_qty: "1", id_product: id_product, id_product_attribute: id_product_attribute }, cache: false, success: function(result) { if (result == '1') { $('#container_express_checkout').slideDown(); } else { $('#container_express_checkout').slideUp(); } return true; } }); } $('select[name^="group_"]').change(function () { setTimeout(function(){displayExpressCheckoutShortcut()}, 500); }); $('.color_pick').click(function () { setTimeout(function(){displayExpressCheckoutShortcut()}, 500); }); if($('body#product').length > 0) { setTimeout(function(){displayExpressCheckoutShortcut()}, 500); } var modulePath = 'modules/paypal'; var subFolder = '/integral_evolution'; var fullPath = baseDirPP + modulePath + subFolder; var confirmTimer = false; if ($('form[target="hss_iframe"]').length == 0) { if ($('select[name^="group_"]').length > 0) displayExpressCheckoutShortcut(); return false; } else { checkOrder(); } function checkOrder() { if(confirmTimer == false) confirmTimer = setInterval(getOrdersCount, 1000); } }); ) Argument [6] 0
182. }
183. array_unshift($_template->_capture_stack, array());
184. //
185. // render compiled template
186. //
187. $_template->properties['unifunc']($_template);
188. // any unclosed {capture} tags ?
189. if (isset($_template->_capture_stack[0][0])) {
190. $_template->capture_error();
191. }
192. array_shift($_template->_capture_stack);
Argument [0]
400.
401. if (is_array($content))
402. foreach ($content as $tpl)
403. $html = $this->context->smarty->fetch($tpl);
404. else
405. $html = $this->context->smarty->fetch($content);
406.
407. $html = trim($html);
408.
409. if ($this->controller_type == 'front' && !empty($html) && $this->getLayout())
410. {
Argument [0] /home/goorgani/public_html/themes/pt_fashionixx/layout.tpl
557. $template = ob_get_contents();
558. ob_clean();
559.
560. }
561. $template = $this->context->smarty->assign('template', $template);
562. $this->smartyOutputContent($layout);
563. }
564. else
565. {
566. Tools::displayAsDeprecated('layout.tpl is missing in your theme directory');
567. if ($this->display_header)
Argument [0] /home/goorgani/public_html/themes/pt_fashionixx/layout.tpl
192. $this->{'displayAjax'.$action}();
193. elseif (method_exists($this, 'displayAjax'))
194. $this->displayAjax();
195. }
196. else
197. $this->display();
198. }
199. else
200. {
201. $this->initCursedPage();
202. $this->smartyOutputContent($this->layout);
367. // Execute hook dispatcher
368. if (isset($params_hook_action_dispatcher))
369. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
370.
371. // Running controller
372. $controller->run();
373. }
374. catch (PrestaShopException $e)
375. {
376. $e->displayMessage();
377. }
23. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
24. * International Registered Trademark & Property of PrestaShop SA
25. */
26.
27. require(dirname(__FILE__).'/config/config.inc.php');
28. Dispatcher::getInstance()->dispatch();