Access denied for user 'gurudav'@'62.109.140.%' to database 'prestashop18'CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY
SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category_product cp
INNER JOIN ps_category c ON (c.id_category = cp.id_category AND
c.nleft >= 33
AND c.nright <= 34
AND c.active = 1)
INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product
AND product_shop.id_shop = 1)
INNER JOIN ps_product p ON (p.id_product=cp.id_product)
WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")
at line 765 in file classes/db/Db.php
760. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
761. }
762. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
763. {
764. if ($sql)
765. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
766.
767. throw new PrestaShopDatabaseException($this->getMsgError());
768. }
769. }
770.
413. if ($this->connect())
414. $this->result = $this->_query($sql);
415. }
416.
417. if (_PS_DEBUG_SQL_)
418. $this->displayError($sql);
419.
420. return $this->result;
421. }
422.
423. /**
Argument [0] CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 33 AND c.nright
573. public function execute($sql, $use_cache = true)
574. {
575. if ($sql instanceof DbQuery)
576. $sql = $sql->build();
577.
578. $this->result = $this->query($sql);
579. if ($use_cache && $this->is_cache_enabled)
580. Cache::getInstance()->deleteQuery($sql);
581.
582. return (bool)$this->result;
583. }
Argument [0] CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 33 AND c.nright
2123. AND c.nright <= '.(int)$parent->nright : 'c.id_category = '.(int)$id_parent).'
2124. AND c.active = 1)
2125. INNER JOIN '._DB_PREFIX_.'product_shop product_shop ON (product_shop.id_product = cp.id_product
2126. AND product_shop.id_shop = '.(int)$context->shop->id.')
2127. INNER JOIN '._DB_PREFIX_.'product p ON (p.id_product=cp.id_product)
2128. WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")', false);
2129.
2130.
2131. Db::getInstance()->execute('ALTER TABLE '._DB_PREFIX_.'cat_restriction ADD PRIMARY KEY (id_product),
2132. ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE,
2133. ADD KEY `condition` (`condition`,`id_product`) USING BTREE,
Argument [0] CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 33 AND c.nright Argument [1]
682. return false;
683.
684. global $smarty, $cookie;
685.
686. // No filters => module disable
687. if ($filter_block = $this->getFilterBlock($this->getSelectedFilters()))
688. if ($filter_block['nbr_filterBlocks'] == 0)
689. return false;
690.
691. if (Tools::getValue('id_category', Tools::getValue('id_category_layered', Configuration::get('PS_HOME_CATEGORY'))) == Configuration::get('PS_HOME_CATEGORY'))
692. return;
Argument [0] Array ( [category] => Array ( ) )
564. Module::$_log_modules_perfs_session = mt_rand();
565. }
566.
567. // Immediately return the result if we do not log performances
568. if (!Module::$_log_modules_perfs)
569. return $module->{$method}($params);
570.
571. // Store time and memory before and after hook call and save the result in the database
572. $time_start = microtime(true);
573. $memory_start = memory_get_usage(true);
574.
Argument [0]
521.
522. // Call hook method
523. if ($hook_callable)
524. $display = Hook::coreCallHook($moduleInstance, 'hook'.$hook_name, $hook_args);
525. elseif ($hook_retro_callable)
526. $display = Hook::coreCallHook($moduleInstance, 'hook'.$retro_hook_name, $hook_args);
527.
528. // Live edit
529. if (!$array_return && $array['live_edit'] && Tools::isSubmit('live_edit') && Tools::getValue('ad')
530. && Tools::getValue('liveToken') == Tools::getAdminToken('AdminModulesPositions'
531. .(int)Tab::getIdFromClassName('AdminModulesPositions').(int)Tools::getValue('id_employee')))
Argument [0] Argument [1] hookHeader Argument [2]
574. if (!$this->useMobileTheme())
575. {
576. // These hooks aren't used for the mobile theme.
577. // Needed hooks are called in the tpl files.
578. $this->context->smarty->assign(array(
579. 'HOOK_HEADER' => Hook::exec('displayHeader'),
580. 'HOOK_TOP' => Hook::exec('displayTop'),
581. 'HOOK_LEFT_COLUMN' => ($this->display_column_left ? Hook::exec('displayLeftColumn') : ''),
582. 'HOOK_RIGHT_COLUMN' => ($this->display_column_right ? Hook::exec('displayRightColumn', array('cart' => $this->context->cart)) : ''),
583. ));
584. }
Argument [0] displayHeader
126. /**
127. * Initializes page content variables
128. */
129. public function initContent()
130. {
131. parent::initContent();
132.
133. $this->setTemplate(_PS_THEME_DIR_.'category.tpl');
134.
135. if (!$this->customer_access)
136. return;
175.
176. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
177. $this->initHeader();
178.
179. if ($this->viewAccess())
180. $this->initContent();
181. else
182. $this->errors[] = Tools::displayError('Access denied.');
183.
184. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className)))
185. $this->initFooter();
368. // Execute hook dispatcher
369. if (isset($params_hook_action_dispatcher))
370. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
371.
372. // Running controller
373. $controller->run();
374. }
375. catch (PrestaShopException $e)
376. {
377. $e->displayMessage();
378. }
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();