[PrestaShopDatabaseException]

User 'prodigitdoliba' has exceeded the 'max_questions' resource (current value: 40000) SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6425 AND `id_group` = 1 LIMIT 1
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 `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = 6425 AND `id_group` = 1 LIMIT 1

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

515. 		{
516. 			$this->last_cached = true;
517. 			return $result;
518. 		}
519. 
520. 		$this->result = $this->query($sql);
521. 		if (!$this->result)
522. 			return false;
523. 
524. 		$this->last_cached = false;
525. 		$result = $this->nextRow($this->result);

Argument [0]

			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = 6425 AND `id_group` = 1 LIMIT 1

DbCore->getRow - [line 544 - classes/db/Db.php] - [2 Arguments]

538. 	public function getValue($sql, $use_cache = true)
539. 	{
540. 		if ($sql instanceof DbQuery)
541. 			$sql = $sql->build();
542. 
543. 		if (!$result = $this->getRow($sql, $use_cache))
544. 			return false;
545. 		return array_shift($result);
546. 	}
547. 
548. 	/**

Argument [0]

			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = 6425 AND `id_group` = 1
Argument [1]
1

DbCore->getValue - [line 139 - classes/GroupReduction.php] - [1 Arguments]

133. 	{
134. 		if (!isset(self::$reduction_cache[$id_product.'-'.$id_group]))
135. 			self::$reduction_cache[$id_product.'-'.$id_group] = Db::getInstance()->getValue('
136. 			SELECT `reduction`
137. 			FROM `'._DB_PREFIX_.'product_group_reduction_cache`
138. 			WHERE `id_product` = '.(int)$id_product.' AND `id_group` = '.(int)$id_group);
139. 		return self::$reduction_cache[$id_product.'-'.$id_group];
140. 	}
141. 
142. 	public static function doesExist($id_group, $id_category)
143. 	{

Argument [0]

			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = 6425 AND `id_group` = 1

GroupReductionCore::getValueForProduct - [line 2670 - classes/Product.php] - [2 Arguments]

2664. 			$price -= $reduc;
2665. 
2666. 		// Group reduction
2667. 		if ($use_group_reduction)
2668. 		{
2669. 			if ($reduction_from_category = (float)GroupReduction::getValueForProduct($id_product, $id_group))
2670. 				$price -= $price * $reduction_from_category;
2671. 			else // apply group reduction if there is no group reduction for this category
2672. 				$price *= ((100 - Group::getReductionByIdGroup($id_group)) / 100);
2673. 		}
2674.

Argument [0]
6425
Argument [1]
1

ProductCore::priceCalculation - [line 2515 - classes/Product.php] - [20 Arguments]

2509. 			$use_group_reduction,
2510. 			$id_customer,
2511. 			$use_customer_price,
2512. 			$id_cart, 
2513. 			$quantity
2514. 		);
2515. 	}
2516. 
2517. 	/**
2518. 	* Price calculation / Get product price
2519. 	*

Argument [0]
41
Argument [1]
6425
Argument [2]

Argument [3]
8
Argument [4]
0
Argument [5]
0
Argument [6]
1
Argument [7]
1
Argument [8]
0
Argument [9]

Argument [10]
6
Argument [11]

Argument [12]
1
Argument [13]
1
Argument [14]

Argument [15]
1
Argument [16]

Argument [17]
1
Argument [18]

Argument [19]
1

ProductCore::getPriceStatic - [line 3683 - classes/Product.php] - [4 Arguments]

3677. 		$row['price_tax_exc'] = Product::getPriceStatic(
3678. 			(int)$row['id_product'],
3679. 			false,
3680. 			((isset($row['id_product_attribute']) && !empty($row['id_product_attribute'])) ? (int)$row['id_product_attribute'] : null),
3681. 			(self::$_taxCalculationMethod == PS_TAX_EXC ? 2 : 6)
3682. 		);
3683. 
3684. 		if (self::$_taxCalculationMethod == PS_TAX_EXC)
3685. 		{
3686. 			$row['price_tax_exc'] = Tools::ps_round($row['price_tax_exc'], 2);
3687. 			$row['price'] = Product::getPriceStatic(

Argument [0]
6425
Argument [1]

Argument [2]

Argument [3]
6

ProductCore::getProductProperties - [line 3811 - classes/Product.php] - [2 Arguments]

3805. 	{
3806. 		$results_array = array();
3807. 
3808. 		if (is_array($query_result))
3809. 			foreach ($query_result as $row)
3810. 				if ($row2 = Product::getProductProperties($id_lang, $row))
3811. 					$results_array[] = $row2;
3812. 
3813. 		return $results_array;
3814. 	}
3815.

Argument [0]
5
Argument [1]
Array
(
    [id_product] => 6425
    [id_supplier] => 16
    [id_manufacturer] => 0
    [id_category_default] => 940
    [id_shop_default] => 41
    [id_tax_rules_group] => 1
    [on_sale] => 0
    [online_only] => 0
    [ean13] => 
    [upc] => 
    [ecotax] => 0.000000
    [quantity] => 0
    [minimal_quantity] => 1
    [price] => 83.325000
    [wholesale_price] => 0.000000
    [unity] => 
    [unit_price_ratio] => 0.000000
    [additional_shipping_cost] => 0.00
    [reference] => 135-GLDMST-49mm
    [supplier_reference] => 135-GLDMST-49mm
    [location] => 
    [width] => 0.000000
    [height] => 0.000000
    [depth] => 0.000000
    [weight] => 0.100000
    [out_of_stock] => 2
    [quantity_discount] => 0
    [customizable] => 0
    [uploadable_files] => 0
    [text_fields] => 0
    [active] => 1
    [redirect_type] => 
    [id_product_redirected] => 0
    [available_for_order] => 1
    [available_date] => 0000-00-00
    [condition] => new
    [show_price] => 1
    [indexed] => 1
    [visibility] => both
    [cache_is_pack] => 0
    [cache_has_attachments] => 0
    [is_virtual] => 0
    [cache_default_attribute] => 0
    [date_add] => 2026-03-13 16:09:58
    [date_upd] => 0000-00-00 00:00:00
    [advanced_stock_management] => 0
    [id_shop] => 41
    [id_product_attribute] => 
    [product_attribute_minimal_quantity] => 
    [description] => Caractéristiques
Filtre Chroma CP pour une réduction classique des reflets et des rendus à contraste élevé
Black Mist crée un aspect de pellicule Kodak Portra
La brume dorée crée un effet de pellicule Kodak Gold.
Comprend une boîte de pellicule rétro pour ranger le filtre
Verre Chroma moderne au design rétro
    [description_short] => Les filtres de la série 135 de Pete allient style rétro et technologie moderne pour les créateurs de films et de contenus numériques. Le filtre Chroma CP renforce le contraste, tandis que les filtres Gold et Mist ajoutent chaleur et douceur. Capturez sans effort une esthétique cinématographique et vintage grâce à cette collection polyvalente.
    [available_now] => 
    [available_later] => 
    [link_rewrite] => mckinnon-135-series-gold-mist-49mm
    [meta_description] => 
    [meta_keywords] => 
    [meta_title] => 
    [name] => McKinnon 135 Series Gold Mist / 49mm
    [id_image] => 13784
    [legend] => 
    [manufacturer_name] => 
    [category_default] => 135 Series
    [new] => 0
    [orderprice] => 83.325000
)

ProductCore::getProductsProperties - [line 685 - classes/Category.php] - [2 Arguments]

679. 
680. 		if (!$result)
681. 			return array();
682. 
683. 		/* Modify SQL result */
684. 		return Product::getProductsProperties($id_lang, $result);
685. 	}
686. 
687. 	/**
688. 	  * Return main categories
689. 	  *

CategoryCore->getProducts - [line 684 - modules/blocktopmenu/blocktopmenu.php] - [3 Arguments]

678. 			else
679. 			{
680. 
681. 				if((int)$id_shop != 2 && (int)$id_shop != 6 && (int)$id_shop != 7 && (int)$id_shop != 17  && (int)$id_shop != 18 && (int)$id_shop != 19 && (int)$id_shop != 20   ) //SEVENOAK [6] OPTECHUSA [5] MEIKE [14] 
682. 				{
683. 					$products = $category->getProducts((int)$id_lang, 1,100000); 
684. 
685. 					if(count($products))
686. 					{
687. 						$this->_menu .= '<ul>';
688.

Argument [0]
5
Argument [1]
1
Argument [2]
100000

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]
940
Argument [1]
5
Argument [2]
41
Argument [3]
16

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]
795
Argument [1]

Argument [2]

Argument [3]
3

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.