Can't create/write to file '/tmp/#sql-temptable-6716-109c06-7d0ec.MAI' (Errcode: 28 "No space left on device")
SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_cms_category` c
LEFT JOIN `ps_cms_category_lang` cl ON (c.`id_cms_category` = cl.`id_cms_category` AND `id_lang` = 1)
WHERE `id_parent` = 8
AND `active` = 1
GROUP BY c.`id_cms_category`
ORDER BY `name` 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.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `ps_cms_category` c LEFT JOIN `ps_cms_category_lang` cl ON (c.`id_cms_category` = cl.`id_cms_category` AND `id_lang` = 1) WHERE `id_parent` = 8 AND `active` = 1 GROUP BY c.`id_cms_category` ORDER BY `name` ASC
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.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `ps_cms_category` c LEFT JOIN `ps_cms_category_lang` cl ON (c.`id_cms_category` = cl.`id_cms_category` AND `id_lang` = 1) WHERE `id_parent` = 8 AND `active` = 1 GROUP BY c.`id_cms_category` ORDER BY `name` ASC
376. $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
377. SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
378. FROM `'._DB_PREFIX_.'cms_category` c
379. LEFT JOIN `'._DB_PREFIX_.'cms_category_lang` cl ON (c.`id_cms_category` = cl.`id_cms_category` AND `id_lang` = '.(int)$id_lang.')
380. WHERE `id_parent` = '.(int)$this->id.'
381. '.($active ? 'AND `active` = 1' : '').'
382. GROUP BY c.`id_cms_category`
383. ORDER BY `name` ASC');
384.
385. // Modify SQL result
386. foreach ($result as &$row) {
Argument [0] SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `ps_cms_category` c LEFT JOIN `ps_cms_category_lang` cl ON (c.`id_cms_category` = cl.`id_cms_category` AND `id_lang` = 1) WHERE `id_parent` = 8 AND `active` = 1 GROUP BY c.`id_cms_category` ORDER BY `name` ASC
127. }
128. } elseif ($this->assignCase == 2) {
129. $this->context->smarty->assign(array(
130. 'category' => $this->cms_category, //for backward compatibility
131. 'cms_category' => $this->cms_category,
132. 'sub_category' => $this->cms_category->getSubCategories($this->context->language->id),
133. 'cms_pages' => CMS::getCMSPages($this->context->language->id, (int)$this->cms_category->id, true, (int)$this->context->shop->id),
134. 'path' => ($this->cms_category->id !== 1) ? Tools::getPath($this->cms_category->id, $this->cms_category->name, false, 'CMS') : '',
135. 'body_classes' => array($this->php_self.'-'.$this->cms_category->id, $this->php_self.'-'.$this->cms_category->link_rewrite)
136. ));
137. }
Argument [0] 1
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();