Can't create/write to file '/tmp/#sql_485_0.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 = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 29 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1 AND `id_lang` = 2
AND c.`active` = 1
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
at line 769 in file classes/db/Db.php
764. if ($webservice_call && $errno) {
765. $dbg = debug_backtrace();
766. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
768. if ($sql) {
769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
770. }
771.
772. throw new PrestaShopDatabaseException($this->getMsgError());
773. }
774. }
380. $this->result = $this->_query($sql);
381. }
382. }
383.
384. if (_PS_DEBUG_SQL_) {
385. $this->displayError($sql);
386. }
387.
388. return $this->result;
389. }
390.
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 = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 29 AND c.`nleft` >= c2.`nleft` AND c.`nright`
608. }
609.
610. return $this->execute($sql, $use_cache);
611. }
612.
613. $this->result = $this->query($sql);
614.
615. if (!$this->result) {
616. $result = false;
617. } else {
618. 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 = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 29 AND c.`nleft` >= c2.`nleft` AND c.`nright`
778. ' . ($active ? ' AND c.`active` = 1' : '') . '
779. ' . (isset($groups) && Group::isFeatureActive() ? ' AND cg.`id_group` IN (' . implode(',', array_map('intval', $groups)) . ')' : '') . '
780. ' . (!$idLang || (isset($groups) && Group::isFeatureActive()) ? ' GROUP BY c.`id_category`' : '') . '
781. ' . ($orderBy != '' ? $orderBy : ' ORDER BY c.`level_depth` ASC') . '
782. ' . ($orderBy == '' && $useShopRestriction ? ', category_shop.`position` ASC' : '') . '
783. ' . ($limit != '' ? $limit : '')
784. );
785.
786. $categories = array();
787. $buff = array();
788.
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 = 1)
LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 29 AND c.`nleft` >= c2.`nleft` AND c.`nright`
504. $sql_filter = '';
505. $cat_list = $this->getCategoriesSelected();
506. if (!empty($cat_list)) {
507. $sql_filter = 'AND c.id_category IN (' . implode(array_map('intval', $cat_list), ',') . ')';
508. }
509. $category_data = Category::getNestedCategories($category_inc, $this->lang, true, null, true, $sql_filter);
510.
511. $this->buildCatalog($category_data, $category_inc, 0);
512. }
513.
514. public function buildCatalog($catalogList, $category, $level)
Argument [0] 29 Argument [1] 2 Argument [2] 1 Argument [3] Argument [4] 1 Argument [5]
453. }
454.
455. $this->activeSheet->getColumnDimension('A')->setWidth(80);
456. ++$this->line_key;
457. if (!empty($cat) && is_numeric($cat) && Category::categoryExists($cat)) {
458. $this->createExcelDoc($cat);
459. } else {
460. $this->createExcelDoc();
461. }
462.
463. if ($this->showCopyright) {
Argument [0] 29
222. }
223.
224. if (!$cachmode) {
225. $filename = $this->getFilename($id_category);
226. if (!Configuration::get('TERRAEXCEL_CACHE_MODE')) {
227. $php_excel = $this->createExcel($id_category);
228. $object_writer = new PHPExcel_Writer_Excel5($php_excel);
229. $filename = $this->getFilename($id_category);
230.
231. header('Content-Type: application/vnd.ms-excel');
232. header('Content-Disposition: attachment;filename="' . $filename . '.xls"');
Argument [0] 29
49.
50. $id_currency = Tools::getValue('id_currency', null);
51. if (Tools::getValue('getCsv') == 1) {
52. $uploader->getCsv($id_category, null, null, null, $id_currency);
53. } else {
54. $uploader->upload($id_category, null, null, null, $id_currency);
55. }
56. }
57. }
Argument [0] 29 Argument [1] Argument [2] Argument [3] Argument [4] 1
35. {
36. $category_id = (int)Tools::getValue('category_id');
37. if ((bool)$category_id == false) {
38. $this->_upload();
39. } else if ((bool)$category_id == true) {
40. $this->_upload($category_id);
41. }
42. }
43.
44. protected function _upload($id_category = null)
45. {
Argument [0] 29
510. if (isset($params_hook_action_dispatcher)) {
511. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
512. }
513.
514. // Running controller
515. $controller->run();
516.
517. // Execute hook dispatcher after
518. if (isset($params_hook_action_dispatcher)) {
519. Hook::exec('actionDispatcherAfter', $params_hook_action_dispatcher);
520. }
27. * @license https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
28. * International Registered Trademark & Property of PrestaShop SA
29. */
30.
31. require dirname(__FILE__).'/config/config.inc.php';
32. Dispatcher::getInstance()->dispatch();