[PrestaShopDatabaseException]

User 'prodigitdoliba' has exceeded the 'max_questions' resource (current value: 40000) SELECT *, ( IF ('2026-04-03 00:46:10' >= `from` AND '2026-04-03 00:46:10' = `from`) AND (`to` = '0000-00-00 00:00:00' OR '2026-04-03 00:46:10' 1, `from_quantity`, 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 *, ( IF ('2026-04-03 00:46:10' >= `from` AND '2026-04-03 00:46:10' <= `to`, 1, 0) +  IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 41, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
				FROM `ps_specific_price`
				WHERE `id_product` IN (0, 6473)
				AND `id_product_attribute` IN (0, 0)
				AND `id_shop` IN (0, 41)
				AND `id_currency` IN (0, 1)
				AND `id_country` IN (0, 8)
				AND `id_group` IN (0, 1)
				AND `id_customer` IN (0, 0)
				AND
				(
					(`from` = '0000-00-00 00:00:00' OR '2026-04-03 00:46:10' >= `from`)
					AND
					(`to` = '0000-00-00 00:00:00' OR '2026-04-03 00:46:10' <= `to`)
				)
				AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1)
				ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC 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 *, ( IF ('2026-04-03 00:46:10' >= `from` AND '2026-04-03 00:46:10' <= `to`, 1, 0) +  IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 41, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
				FROM `ps_specific_price`
				WHERE `id_product` IN (0, 6473)
				AND `id_product_attribute` IN (0, 0)
				AND `id_shop` IN (0, 41)
				AND `id_currency` IN (0, 1)
				AND `id_country` IN (0, 8)
				AND `id_group` IN (0, 1)
				AND `id_customer` IN (0, 0)
				AND
				(
					(`from` = '0000-00-00 00:00:00' OR '2026-04-03 00:46:10' >= `from`)
					AND
					(`to` = '0000-00-00 00:00:00' OR '2026-04-03 00:46:10' <= `to`)
				)
				AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1)
				ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1

DbCore->getRow - [line 232 - classes/SpecificPrice.php] - [1 Arguments]

226. 					AND
227. 					(`to` = \'0000-00-00 00:00:00\' OR \''.$now.'\' <= `to`)
228. 				)
229. 				AND id_cart IN (0, '.(int)$id_cart.')'.
230. 				(($real_quantity != 0 && !Configuration::get('PS_QTY_DISCOUNT_ON_COMBINATION')) ? ' AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,'.(int)$quantity.' ,'.(int)$real_quantity.')' : 'AND `from_quantity` <= '.(int)$real_quantity).'
231. 				ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC');
232. 		}
233. 		return self::$_specificPriceCache[$key];
234. 	}
235. 
236. 	public static function setPriorities($priorities)

Argument [0]

				SELECT *, ( IF ('2026-04-03 00:46:10' >= `from` AND '2026-04-03 00:46:10' <= `to`, 1, 0) +  IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 41, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
				FROM `ps_specific_price`
				WHERE `id_product` IN (0, 6473)
				AND `id_product_attribute` IN (0, 0)
				AND `id_shop` IN (0, 41)
				AND `id_currency` IN (0, 1)
				AND `id_country` IN (0, 8)
				AND `id_group` IN (0, 1)
				AND `id_customer` IN (0, 0)
				AND
				(
					(`from` = '0000-00-00 00:00:00' OR '2026-04-03 00:46:10' >= `from`)
					AND
					(`to` = '0000-00-00 00:00:00' OR '2026-04-03 00:46:10' <= `to`)
				)
				AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= IF(id_product_attribute=0,0 ,1)
				ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC

SpecificPriceCore::getSpecificPrice - [line 2573 - classes/Product.php] - [10 Arguments]

2567. 			$quantity,
2568. 			$id_product_attribute,
2569. 			$id_customer,
2570. 			$id_cart,
2571. 			$real_quantity
2572. 		);
2573. 
2574. 		if (isset(self::$_prices[$cache_id]))
2575. 			return self::$_prices[$cache_id];
2576. 
2577. 		// fetch price & attribute price

Argument [0]
6473
Argument [1]
41
Argument [2]
1
Argument [3]
8
Argument [4]
1
Argument [5]
0
Argument [6]

Argument [7]

Argument [8]

Argument [9]
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]
6473
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]
6473
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] => 6473
    [id_supplier] => 16
    [id_manufacturer] => 0
    [id_category_default] => 943
    [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] => 58.325000
    [wholesale_price] => 0.000000
    [unity] => 
    [unit_price_ratio] => 0.000000
    [additional_shipping_cost] => 0.00
    [reference] => 49-BLKMIST-1/2
    [supplier_reference] => 49-BLKMIST-1/2
    [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-04-02 14:25:22
    [date_upd] => 0000-00-00 00:00:00
    [advanced_stock_management] => 0
    [id_shop] => 41
    [id_product_attribute] => 
    [product_attribute_minimal_quantity] => 
    [description] => Le filtre CineBlack apporte une ambiance douce et cinématographique tout en préservant la profondeur des ombres. Doté d'un voile noir à demi-intensité, ce filtre crée un dégradé de hautes lumières onirique et atténue les contrastes numériques marqués, offrant ainsi un rendu cinématographique impeccable à vos photos et vidéos.

Caractéristiques
- Compatible avec les objectifs de 49 mm - Conçu pour se visser directement sur n'importe quel objectif doté d'une monture de filtre de 49 mm.
- Aspect cinématographique – Imite l’aspect des films Kodak Cine, notamment lorsqu’il est associé à nos préréglages inclus.
- Highlight Bloom + Shadow Depth - CineBlack adoucit les hautes lumières tout en préservant les ombres profondes.
- Force de diffusion équilibrée - La force 1/2 offre une diffusion de halo et de contraste plus importante que notre force 1/4 tout en conservant la profondeur des ombres.
- Optique de qualité professionnelle - Verre de la série Chroma avec revêtements anti-rayures, anti-reflets et anti-traces de doigts pour une utilisation immédiate.

    [description_short] => Le filtre CineBlack apporte une ambiance douce et cinématographique tout en préservant la profondeur des ombres.
    [available_now] => 
    [available_later] => 
    [link_rewrite] => filtre-cineblack-49mm
    [meta_description] => 
    [meta_keywords] => 
    [meta_title] => 
    [name] => Filtre CineBlack 49mm
    [id_image] => 13824
    [legend] => 
    [manufacturer_name] => 
    [category_default] => Cine Gold/Black/Flow
    [new] => 1
    [orderprice] => 58.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]
943
Argument [1]
5
Argument [2]
41
Argument [3]
19

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.