[PrestaShopDatabaseException]

User 'prodigitdoliba' has exceeded the 'max_questions' resource (current value: 40000) SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 32) WHERE p.id_product = 5639 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 20 DAY ) ) > 0
at line 605 in file classes/db/Db.php

599. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
600. 		}
601. 		else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
602. 		{
603. 			if ($sql)
604. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
605. 			throw new PrestaShopDatabaseException($this->getMsgError());
606. 		}
607. 	}
608. 
609. 	/**

DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments]

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

Argument [0]

			SELECT p.id_product
			FROM `ps_product` p
			 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 32)
			WHERE p.id_product = 5639
			AND DATEDIFF(
				product_shop.`date_add`,
				DATE_SUB(
					NOW(),
					INTERVAL 20 DAY
				)
			) > 0

DbCore->query - [line 482 - classes/db/Db.php] - [1 Arguments]

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

Argument [0]

			SELECT p.id_product
			FROM `ps_product` p
			 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 32)
			WHERE p.id_product = 5639
			AND DATEDIFF(
				product_shop.`date_add`,
				DATE_SUB(
					NOW(),
					INTERVAL 20 DAY
				)
			) > 0

DbCore->executeS - [line 1052 - classes/Product.php] - [1 Arguments]

1046. 				DATE_SUB(
1047. 					NOW(),
1048. 					INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY
1049. 				)
1050. 			) > 0
1051. 		');
1052. 		return count($result) > 0;
1053. 	}
1054. 
1055. 	public function productAttributeExists($attributes_list, $current_product_attribute = false, Context $context = null, $all_shops = false, $return_id = false)
1056. 	{

Argument [0]

			SELECT p.id_product
			FROM `ps_product` p
			 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 32)
			WHERE p.id_product = 5639
			AND DATEDIFF(
				product_shop.`date_add`,
				DATE_SUB(
					NOW(),
					INTERVAL 20 DAY
				)
			) > 0

ProductCore->isNew - [line 464 - classes/Product.php] - [0 Argument]

458. 			if (is_object($context->cart) && $context->cart->{Configuration::get('PS_TAX_ADDRESS_TYPE')} != null)
459. 				$address = $context->cart->{Configuration::get('PS_TAX_ADDRESS_TYPE')};
460. 
461. 			$this->tax_rate = $this->getTaxesRate(new Address($address));
462. 
463. 			$this->new = $this->isNew();
464. 			$this->price = Product::getPriceStatic((int)$this->id, false, null, 6, null, false, true, 1, false, null, null, null, $this->specificPrice);
465. 			$this->unit_price = ($this->unit_price_ratio != 0  ? $this->price / $this->unit_price_ratio : 0);
466. 			if ($this->id)
467. 				$this->tags = Tag::getProductTags((int)$this->id);
468.

ProductCore->__construct - [line 693 - modules/blocktopmenu/blocktopmenu.php] - [3 Arguments]

687. 						$this->_menu .= '<ul>';
688. 					
689. 						foreach ($products as $child)
690. 						{
691. 							//$selected = ($this->page_name == 'product' && (Tools::getValue('id_product') == $child["id_product"])) ? ' class="sfHover"' : ''; 
692. 							$product = new Product((int)$child["id_product"], true, (int)$id_lang);
693. 							if (!is_null($product->id) && (int)Shop::getContextShopID() != 2)
694. 								$this->_menu .= '<li class="li_prd" '.$selected.'><a href="'.$product->getLink().'" class="a_li_prd" >'.$product->name.'</a></li>'.PHP_EOL;
695. 								
696. 						}
697. 						$this->_menu .= '</ul>';

Argument [0]
5639
Argument [1]
1
Argument [2]
5

Blocktopmenu->getCategory - [line 674 - modules/blocktopmenu/blocktopmenu.php] - [4 Arguments]

668. 				$this->_menu .= '<ul id="ssmenuss'.$pos.'" class="dropdown-menu" aria-labelledby="navbarDropdownMenuLink" data-bs-popper="none">';
669. 
670. 				foreach ($children as $child)
671. 				{
672. 					$pos ++;
673. 					$this->getCategory((int)$child['id_category'], (int)$id_lang, (int)$child['id_shop'], $pos +10);
674. 				}
675. 					
676. 				$this->_menu .= '</ul>';
677. 			}
678. 			else

Argument [0]
877
Argument [1]
5
Argument [2]
32
Argument [3]
15

Blocktopmenu->getCategory - [line 529 - modules/blocktopmenu/blocktopmenu.php] - [4 Arguments]

523. 
524. 			switch (substr($item, 0, strlen($value[1])))
525. 			{
526. 				case 'CAT':
527. 					$pos++;
528. 					$this->getCategory((int)$id,false,false,$pos);
529. 					break;
530. 
531. 				case 'PRD':
532. 					$selected = ($this->page_name == 'product' && (Tools::getValue('id_product') == $id)) ? ' class="sfHover"' : '';
533. 					$product = new Product((int)$id, true, (int)$id_lang);

Argument [0]
876
Argument [1]

Argument [2]

Argument [3]
4

Blocktopmenu->makeMenu - [line 775 - modules/blocktopmenu/blocktopmenu.php] - [0 Argument]

769. 		$smarty_cache_id = 'blocktopmenu-'.$this->page_name.'-'.(int)$this->context->shop->id.'-'.implode(', ',$this->user_groups).'-'.(int)$this->context->language->id.'-'.(int)Tools::getValue('id_category').'-'.(int)Tools::getValue('id_manufacturer').'-'.(int)Tools::getValue('id_supplier').'-'.(int)Tools::getValue('id_cms').'-'.(int)Tools::getValue('id_product');
770. 		$this->context->smarty->cache_lifetime = 31536000;
771. 		Tools::enableCache();
772. 		if (!$this->isCached('blocktopmenu.tpl', $smarty_cache_id))
773. 		{
774. 			$this->makeMenu();
775. 			$this->smarty->assign('MENU_SEARCH', Configuration::get('MOD_BLOCKTOPMENU_SEARCH'));
776. 			$this->smarty->assign('MENU', $this->_menu);
777. 			$this->smarty->assign('this_path', $this->_path);
778. 		}
779.

Blocktopmenu->hookDisplayTop - [line 417 - classes/Hook.php] - [1 Arguments]

411. 			{
412. 				$hook_args['altern'] = ++$altern;
413. 
414. 				// Call hook method
415. 				if ($hook_callable)
416. 					$display = $moduleInstance->{'hook'.$hook_name}($hook_args);
417. 				else if ($hook_retro_callable)
418. 					$display = $moduleInstance->{'hook'.$retro_hook_name}($hook_args);
419. 				// Live edit
420. 				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')))
421. 				{

HookCore::exec - [line 443 - classes/controller/FrontController.php] - [1 Arguments]

437. 			// Needed hooks are called in the tpl files.
438. 			if (!isset($this->context->cart))
439. 				$this->context->cart = new Cart();
440. 			$this->context->smarty->assign(array(
441. 				'HOOK_HEADER' => Hook::exec('displayHeader'),
442. 				'HOOK_TOP' => Hook::exec('displayTop'),
443. 				'HOOK_TOPOFTHETOP' => Hook::exec('displayTopOfTheTop'),
444. 				'HOOK_LEFT_COLUMN' => ($this->display_column_left ? Hook::exec('displayLeftColumn') : ''),
445. 				'HOOK_RIGHT_COLUMN' => ($this->display_column_right ? Hook::exec('displayRightColumn', array('cart' => $this->context->cart)) : ''),
446. 			));
447. 		}

Argument [0]
displayTop

FrontControllerCore->initContent - [line 183 - controllers/front/ProductController.php] - [0 Argument]

177. 	 * Assign template vars related to page content
178. 	 * @see FrontController::initContent()
179. 	 */
180. 	public function initContent()
181. 	{
182. 		parent::initContent();
183. 
184. 		if (!$this->errors)
185. 		{
186. 			// Assign to the template the id of the virtual product. "0" if the product is not downloadable.
187. 			$this->context->smarty->assign('virtual', ProductDownload::getIdFromIdProduct((int)$this->product->id));

ProductControllerCore->initContent - [line 167 - classes/controller/Controller.php] - [0 Argument]

161. 
162. 			if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
163. 				$this->initHeader();
164. 
165. 			if ($this->viewAccess())
166. 				$this->initContent();
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();

ControllerCore->run - [line 349 - classes/Dispatcher.php] - [0 Argument]

343. 			// Execute hook dispatcher
344. 			if (isset($params_hook_action_dispatcher))
345. 				Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
346. 
347. 			// Running controller
348. 			$controller->run();
349. 		}
350. 		catch (PrestaShopException $e)
351. 		{
352. 			$e->displayMessage();
353. 		}

DispatcherCore->dispatch - [line 28 - index.php] - [0 Argument]

22. *  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
23. *  International Registered Trademark & Property of PrestaShop SA
24. */
25. 
26. require(dirname(__FILE__).'/config/config.inc.php');
27. Dispatcher::getInstance()->dispatch();
28.