[PrestaShopDatabaseException]

User 'prodigitdoliba' has exceeded the 'max_questions' resource (current value: 40000)SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6455) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0) 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 SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6455) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0)
 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 SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6455) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0)
 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 SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 6455) AND (id_product_attribute = 0) AND (id_shop_group = 1) AND (id_shop = 0)

Argument [1]
1

DbCore->getValue - [line 353 - classes/stock/StockAvailable.php] - [1 Arguments]

347. 			$query->where('id_product = '.(int)$id_product);
348. 
349. 		$query->where('id_product_attribute = '.(int)$id_product_attribute);
350. 		$query = StockAvailable::addSqlShopRestriction($query, $id_shop);
351. 
352. 		return (int)Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
353. 	}
354. 
355. 	/**
356. 	 * Upgrades total_quantity_available after having saved
357. 	 * @see ObjectModel::add()

Argument [0]
DbQuery Object
(
    [query:protected] => Array
        (
            [select] => Array
                (
                    [0] => SUM(quantity)
                )

            [from] => `ps_stock_available`
            [join] => Array
                (
                )

            [where] => Array
                (
                    [0] => id_product = 6455
                    [1] => id_product_attribute = 0
                    [2] => id_shop_group = 1
                    [3] => id_shop = 0
                )

            [group] => Array
                (
                )

            [having] => Array
                (
                )

            [order] => Array
                (
                )

            [limit] => Array
                (
                    [offset] => 0
                    [limit] => 0
                )

        )

)

StockAvailableCore::getQuantityAvailableByProduct - [line 2853 - classes/Product.php] - [2 Arguments]

2847. 			if (!Pack::isInStock((int)$id_product))
2848. 				return 0;
2849. 		}
2850. 
2851. 		// @since 1.5.0
2852. 		return (StockAvailable::getQuantityAvailableByProduct($id_product, $id_product_attribute));
2853. 	}
2854. 
2855. 	/**
2856. 	 * Create JOIN query with 'stock_available' table
2857. 	 *

Argument [0]
6455
Argument [1]

ProductCore::getQuantity - [line 3761 - classes/Product.php] - [1 Arguments]

3755. 				(int)$row['id_product'],
3756. 				0,
3757. 				isset($row['cache_is_pack']) ? $row['cache_is_pack'] : null
3758. 			);
3759. 		else
3760. 			$row['quantity'] = Product::getQuantity((int)$row['id_product']);
3761. 
3762. 		$row['id_image'] = Product::defineProductImage($row, $id_lang);
3763. 		$row['features'] = Product::getFrontFeaturesStatic((int)$id_lang, $row['id_product']);
3764. 
3765. 		$row['attachments'] = array();

Argument [0]
6455

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] => 6455
    [id_supplier] => 16
    [id_manufacturer] => 0
    [id_category_default] => 949
    [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] => 74.991667
    [wholesale_price] => 0.000000
    [unity] => 
    [unit_price_ratio] => 0.000000
    [additional_shipping_cost] => 0.00
    [reference] => 49-PORTRA
    [supplier_reference] => 49-PORTRA
    [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:05:24
    [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 Portra reproduit fidèlement le profil colorimétrique du classique PORTRA 400. Ce verre offre un rendu doux et naturel, typique du style Portra, dès la sortie de l'appareil. Il combine une teinte personnalisée, un diffuseur blanc et un polariseur chroma, créant ainsi des hautes lumières chaudes, des tons chair naturels et atténuant les reflets indésirables.

Caractéristiques
- Une palette de couleurs chaudes et neutres,  inspirée du film Portra 400.
- Les teints sont naturels et doux au toucher , les reflets sont chauds plutôt qu'agressifs, et les contours numériques disparaissent sans aplatir la composition.
- Diffusion subtile de brume blanche (1/4)  spécialement conçue pour atténuer les hautes lumières et obtenir un aspect cinématographique.
- Polariseur Chroma intégré  - réduit les reflets pour augmenter la profondeur et la séparation des couleurs.
- Trois effets optiques :  moins de temps passé en étalonnage, une plus grande cohérence entre les prises de vue et un rendu reproductible dès la sortie de la caméra.
    [description_short] => Le filtre Portra reproduit fidèlement le profil colorimétrique du classique PORTRA 400.
    [available_now] => 
    [available_later] => 
    [link_rewrite] => filtre-portra-49-mm
    [meta_description] => 
    [meta_keywords] => 
    [meta_title] => 
    [name] => Filtre Portra 49 mm
    [id_image] => 13806
    [legend] => 
    [manufacturer_name] => 
    [category_default] => Porta
    [new] => 1
    [orderprice] => 74.991667
)

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

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.