Disk full (/tmp/#sql_4e08_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-03-19 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
LEFT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category`
AND c.nleft >= 13 AND c.nright <= 14)
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE c.id_category > 0
AND product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product ORDER BY cp.`position` ASC
LIMIT 0,12
at line 791 in file classes/db/Db.php
786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790. if ($sql) {
791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792. }
793.
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }
420. $this->result = $this->_query($sql);
421. }
422. }
423.
424. if (_PS_DEBUG_SQL_) {
425. $this->displayError($sql);
426. }
427.
428. return $this->result;
429. }
430.
Argument [0] SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-03-19 00:00:00", INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 13 AND c.nright 0 AND product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product ORDER BY cp.`position` ASC LIMIT 0,12
638. throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');
639. }
640. return $this->execute($sql, $use_cache);
641. }
642.
643. $this->result = $this->query($sql);
644.
645. if (!$this->result) {
646. $result = false;
647. } else {
648. if (!$array) {
Argument [0] SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-03-19 00:00:00", INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 13 AND c.nright 0 AND product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product ORDER BY cp.`position` ASC LIMIT 0,12
40. $instanceMaster = _PS_USE_SQL_SLAVE_;
41. if (!$useCache) {
42. $instanceMaster = true;
43. }
44. if ($type == 1) {
45. $result = Db::getInstance($instanceMaster)->ExecuteS($query, $useArray, $useCache);
46. } elseif ($type == 2) {
47. $result = Db::getInstance($instanceMaster)->getRow($query, $useCache);
48. } elseif ($type == 3) {
49. $result = Db::getInstance($instanceMaster)->getValue($query, $useCache);
50. } elseif ($type == 4) {
Argument [0] SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-03-19 00:00:00", INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 13 AND c.nright 0 AND product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product ORDER BY cp.`position` ASC LIMIT 0,12 Argument [1] 1 Argument [2] 1
4122. $sql .= ' ORDER BY RAND() LIMIT '.(int)$random_number_products;
4123. } else {
4124. $sql .= ' ORDER BY '.(!empty($order_by_prefix) ? $order_by_prefix.'.' : '').'`'.bqSQL($order_by).'` '.pSQL($order_way).'
4125. LIMIT '.(((int)$p - 1) * (int)$n).','.(int)$n;
4126. }
4127. $result = As4SearchEngineDb::query($sql);
4128. if (!$result) {
4129. return array();
4130. }
4131. if ($order_by == 'orderprice') {
4132. Tools::orderbyPrice($result, $order_way);
Argument [0] SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-03-19 00:00:00", INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 13 AND c.nright 0 AND product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product ORDER BY cp.`position` ASC LIMIT 0,12
3979. }
3980. if ($continue) {
3981. $params['hookExecuted'] = true;
3982. $params['nbProducts'] = $this->getCategoryProducts(null, null, null, $this->context->controller->orderBy, $this->context->controller->orderWay, true);
3983. $this->context->controller->pagination((int)$params['nbProducts']);
3984. $params['catProducts'] = $this->getCategoryProducts((int)$this->context->language->id, (int)$this->context->controller->p, (int)$this->context->controller->n, $this->context->controller->orderBy, $this->context->controller->orderWay);
3985. }
3986. }
3987. }
3988. private static $displayBeforeBodyClosingTagContent = '';
3989. public function hookDisplayBeforeBodyClosingTag($params)
Argument [0] 1 Argument [1] 1 Argument [2] 12 Argument [3] position Argument [4] asc
586. }
587. }
588.
589. // Immediately return the result if we do not log performances
590. if (!Module::$_log_modules_perfs) {
591. return $module->{$method}($params);
592. }
593.
594. // Store time and memory before and after hook call and save the result in the database
595. $time_start = microtime(true);
596. $memory_start = memory_get_usage(true);
Argument [0]
541. Tools::waitUntilFileIsModified($moduleInstance->push_filename, $moduleInstance->push_time_limit);
542. }
543.
544. // Call hook method
545. if ($hook_callable) {
546. $display = Hook::coreCallHook($moduleInstance, 'hook'.$hook_name, $hook_args);
547. } elseif ($hook_retro_callable) {
548. $display = Hook::coreCallHook($moduleInstance, 'hook'.$retro_hook_name, $hook_args);
549. }
550.
551. // Live edit
Argument [0] Argument [1] hookactionProductListOverride Argument [2]
164. * version: 3.17
165. */
166. private static function exec_16($hook_name, $hook_args = array(), $id_module = null, $array_return = false, $check_exceptions = true, $use_push = false, $id_shop = null)
167. {
168. if (Tools::getIsset('ajax') || strcmp('moduleRoutes', $hook_name) == 0 || !self::_isPageCacheActive()) {
169. return parent::exec($hook_name, $hook_args, $id_module, $array_return, $check_exceptions, $use_push = false, $id_shop = null);
170. }
171.
172. static $disable_non_native_modules = null;
173. if ($disable_non_native_modules === null)
174. $disable_non_native_modules = (bool)Configuration::get('PS_DISABLE_NON_NATIVE_MODULE');
Argument [0] actionProductListOverride Argument [1] Array ( [nbProducts] => 105 [catProducts] => [hookExecuted] => 1 ) Argument [2] Argument [3] Argument [4] 1 Argument [5] Argument [6]
44. * version: 3.17
45. */
46. public static function exec($hook_name, $hook_args = array(), $id_module = null, $array_return = false, $check_exceptions = true, $use_push = false, $id_shop = null)
47. {
48. if (Tools::version_compare(_PS_VERSION_,'1.6','>')) {
49. return self::exec_16($hook_name, $hook_args, $id_module, $array_return, $check_exceptions, $use_push, $id_shop);
50. } else {
51. return self::exec_15($hook_name, $hook_args, $id_module, $array_return, $check_exceptions);
52. }
53. }
54.
Argument [0] actionProductListOverride Argument [1] Array ( [nbProducts] => 105 [catProducts] => [hookExecuted] => 1 ) Argument [2] Argument [3] Argument [4] 1 Argument [5] Argument [6]
211. $hook_executed = false;
212. Hook::exec('actionProductListOverride', array(
213. 'nbProducts' => &$this->nbProducts,
214. 'catProducts' => &$this->cat_products,
215. 'hookExecuted' => &$hook_executed,
216. ));
217.
218. // The hook was not executed, standard working
219. if (!$hook_executed) {
220. $this->context->smarty->assign('categoryNameComplement', '');
221. $this->nbProducts = $this->category->getProducts(null, null, null, $this->orderBy, $this->orderWay, true);
Argument [0] actionProductListOverride Argument [1] Array ( [nbProducts] => 105 [catProducts] => [hookExecuted] => 1 )
139. // Product sort must be called before assignProductList()
140. $this->productSort();
141.
142. $this->assignScenes();
143. $this->assignSubcategories();
144. $this->assignProductList();
145.
146. $this->context->smarty->assign(array(
147. 'category' => $this->category,
148. 'description_short' => Tools::truncateString($this->category->description, 350),
149. 'products' => (isset($this->cat_products) && $this->cat_products) ? $this->cat_products : null,
184. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
185. $this->initHeader();
186. }
187.
188. if ($this->viewAccess()) {
189. $this->initContent();
190. } else {
191. $this->errors[] = Tools::displayError('Access denied.');
192. }
193.
194. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {
385. $controller = Controller::getController($controller_class);
386.
387. if (isset($params_hook_action_dispatcher))
388. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
389.
390. $controller->run();
391.
392. if ($this->_isPageCacheActive())
393. {
394. PageCache::displayStats(false, $pre_display_html);
395. }
119. * date: 2017-02-07 23:04:58
120. * version: 3.17
121. */
122. public function dispatch() {
123. if (Tools::version_compare(_PS_VERSION_,'1.6','>')) {
124. $this->dispatch_16();
125. } else {
126. $this->dispatch_15();
127. }
128. }
129.
28. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
29. * International Registered Trademark & Property of PrestaShop SA
30. */
31.
32. require(dirname(__FILE__).'/config/config.inc.php');
33. Dispatcher::getInstance()->dispatch();
34. ini_set('display_errors', 1);