Can't create/write to file '/tmp/#sql-temptable-6716-107b3d-3fc98.MAI' (Errcode: 28 "No space left on device")
SELECT c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 12)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 12
LEFT JOIN `ps_category_product` cp on cp.`id_category` = c.`id_category`
LEFT JOIN `ps_product_shop` ps on ps.`id_product` = cp.`id_product`
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1 AND `id_lang` = 1
AND (c.`id_category` < 3 OR ps.`active` = 1)
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
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 c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 12)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 12
LEFT JOIN `ps_category_product` cp on cp.`id_category` = c.`id_category`
LEFT JOIN `ps_product_shop` ps on ps.`id_product` = cp.`id_product`
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright`
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 c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 12)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 12
LEFT JOIN `ps_category_product` cp on cp.`id_category` = c.`id_category`
LEFT JOIN `ps_product_shop` ps on ps.`id_product` = cp.`id_product`
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright`
33. '.($active ? ' AND c.`active` = 1' : '').'
34. '.(isset($groups) && Group::isFeatureActive() ? ' AND cg.`id_group` IN ('.implode(',', $groups).')' : '').'
35. '.(!$id_lang || (isset($groups) && Group::isFeatureActive()) ? ' GROUP BY c.`id_category`' : '').'
36. '.($sql_sort != '' ? $sql_sort : ' ORDER BY c.`level_depth` ASC').'
37. '.($sql_sort == '' && $use_shop_restriction ? ', category_shop.`position` ASC' : '').'
38. '.($sql_limit != '' ? $sql_limit : '')
39. );
40.
41. $categories = array();
42. $buff = array();
43.
Argument [0]
SELECT c.*, cl.*
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 12)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 12
LEFT JOIN `ps_category_product` cp on cp.`id_category` = c.`id_category`
LEFT JOIN `ps_product_shop` ps on ps.`id_product` = cp.`id_product`
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright`
132. }
133. preg_match($this->pattern, $item, $value);
134. $id = (int)substr($item, strlen($value[1]), strlen($item));
135. switch (substr($item, 0, strlen($value[1]))) {
136. case 'CAT':
137. $this->_menu .= $this->generateCategoriesMenu(Category::getNestedCategories($id, $id_lang, false, $this->user_groups));
138. break;
139. case 'PRD':
140. $selected = ($this->page_name == 'product' && (Tools::getValue('id_product') == $id)) ? ' class="sfHover"' : '';
141. $product = new Product((int)$id, true, (int)$id_lang);
142. if (!is_null($product->id)) {
Argument [0]
2
Argument [1]
1
Argument [2]
Argument [3]
Array
(
[0] => 1
)
725. $this->user_groups = ($this->context->customer->isLogged() ?
726. $this->context->customer->getGroups() : array(Configuration::get('PS_UNIDENTIFIED_GROUP')));
727. $this->page_name = Dispatcher::getInstance()->getController();
728. if (!$this->isCached('blocktopmenu.tpl', $this->getCacheId())) {
729. if (Tools::isEmpty($this->_menu)) {
730. $this->makeMenu();
731. }
732.
733. $shop_id = (int)$this->context->shop->id;
734. $shop_group_id = Shop::getGroupFromShop($shop_id);
735.
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] hookdisplayTop Argument [2]
575. if (!$this->useMobileTheme()) {
576. // These hooks aren't used for the mobile theme.
577. // Needed hooks are called in the tpl files.
578. $this->context->smarty->assign(array(
579. 'HOOK_HEADER' => Hook::exec('displayHeader'),
580. 'HOOK_TOP' => Hook::exec('displayTop'),
581. 'HOOK_LEFT_COLUMN' => ($this->display_column_left ? Hook::exec('displayLeftColumn') : ''),
582. 'HOOK_RIGHT_COLUMN' => ($this->display_column_right ? Hook::exec('displayRightColumn', array('cart' => $this->context->cart)) : ''),
583. ));
584. } else {
585. $this->context->smarty->assign('HOOK_MOBILE_HEADER', Hook::exec('displayMobileHeader'));
Argument [0] displayTop
20.
21. parent::init();
22. }
23.
24. public function initContent(){
25. parent::initContent();
26. $this->context->smarty->assign(array(
27. 'HOOK_SEARCHOS' => Hook::exec('HookSearchos'),
28. 'HOOK_BOTTOMCAT' => Hook::exec('HookBottomCat')
29. ));
30.
167. * Assign template vars related to page content
168. * @see FrontController::initContent()
169. */
170. public function initContent()
171. {
172. parent::initContent();
173.
174. if (!$this->errors) {
175. if (Pack::isPack((int)$this->product->id) && !Pack::isInStock((int)$this->product->id)) {
176. $this->product->quantity = 0;
177. }
17. parent::init();
18. }
19. }
20.
21. public function initContent() {
22. parent::initContent();
23.
24. if (!$this->product->active) {
25. // afichage de tous les produits liés, même en brouillon pour aperçu plateforme
26. $accessories = $this->product->getAccessories($this->context->language->id, false);
27. $this->context->smarty->assign('accessories', $accessories);
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))) {
362. if (isset($params_hook_action_dispatcher)) {
363. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
364. }
365.
366. // Running controller
367. $controller->run();
368. } catch (PrestaShopException $e) {
369. $e->displayMessage();
370. }
371. }
372.
23. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
24. * International Registered Trademark & Property of PrestaShop SA
25. */
26.
27. require(dirname(__FILE__).'/config/config.inc.php');
28. Dispatcher::getInstance()->dispatch();