Disk full (/tmp/#sql-temptable-18d-c7514-a10b8.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br /><br /><pre>
SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `ps_category` c
INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 5
AND nleft >= 2 AND nright <= 411
AND c.id_category IN (
SELECT id_category
FROM `ps_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC</pre>
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.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` = 2 AND nright
608. || stripos($sql, 'dumpfile') !== false
609. ) {
610. throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');
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.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` = 2 AND nright
161. AND c.id_category IN (
162. SELECT id_category
163. FROM `' . _DB_PREFIX_ . 'category_group`
164. WHERE `id_group` IN (' . implode(', ', Customer::getGroupsStatic((int) $this->context->customer->id)) . ')
165. )
166. ORDER BY `level_depth` ASC, ' . (Configuration::get('BLOCK_CATEG_SORT') ? 'cl.`name`' : 'cs.`position`') . ' ' . (Configuration::get('BLOCK_CATEG_SORT_WAY') ? 'DESC' : 'ASC'));
167. foreach ($result as &$row) {
168. $resultParents[$row['id_parent']][] = &$row;
169. $resultIds[$row['id_category']] = &$row;
170. }
171.
Argument [0] SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` = 2 AND nright
345. } elseif (Configuration::get('BLOCK_CATEG_ROOT_CATEGORY') == static::CATEGORY_ROOT_CURRENT_PARENT && !$category->is_root_category && !$category->getSubCategories($category->id, true)) {
346. $category = new Category($category->id_parent, $this->context->language->id);
347. }
348.
349. return [
350. 'categories' => $this->getCategories($category),
351. 'currentCategory' => $category->id,
352. ];
353. }
354. }
Argument [0] Category Object ( [id] => 2 [id_category] => 2 [name] => Accueil [active] => 1 [position] => 0 [description] => [id_parent] => 1 [id_category_default] => [level_depth] => 1 [nleft] => 2 [nright] => 411 [link_rewrite] => accueil [meta_title] => [meta_keywords] => [meta_description] => [date_add] => 2022-05-20 16:12:03 [date_upd] => 2022-05-20 16:12:03 [is_root_category] => 1 [id_shop_default] => 1 [groupBox] => [doNotRegenerateNTree] => [id_image] => [webserviceParameters:protected] => Array ( [objectsNodeName] => categories [hidden_fields] => Array ( [0] => nleft [1] => nright [2] => groupBox ) [fields] => Array ( [id_parent] => Array ( [xlink_resource] => categories ) [level_depth] => Array ( [setter] => ) [nb_products_recursive] => Array ( [getter] => getWsNbProductsRecursive [setter] => ) ) [associations] => Array ( [categories] => Array ( [getter] => getChildrenWs [resource] => category ) [products] => Array ( [getter] => getProductsWs [resource] => product ) ) ) [id_lang:protected] => 1 [id_shop:protected] => 1 [id_shop_list] => Array ( ) [get_shop_from_context:protected] => 1 [table:protected] => category [identifier:protected] => id_category [fieldsRequired:protected] => Array ( [0] => active ) [fieldsSize:protected] => Array ( ) [fieldsValidate:protected] => Array ( [nleft] => isUnsignedInt [nright] => isUnsignedInt [level_depth] => isUnsignedInt [active] => isBool [id_parent] => isUnsignedInt [id_shop_default] => isUnsignedId [is_root_category] => isBool [date_add] => isDate [date_upd] => isDate ) [fieldsRequiredLang:protected] => Array ( [0] => name [1] => link_rewrite ) [fieldsSizeLang:protected] => Array ( [name] => 128 [link_rewrite] => 128 [meta_title] => 255 [meta_description] => 512 [meta_keywords] => 255 ) [fieldsValidateLang:protected] => Array ( [name] => isCatalogName [link_rewrite] => isLinkRewrite [description] => isCleanHtml [meta_title] => isGenericName [meta_description] => isGenericName [meta_keywords] => isGenericName ) [tables:protected] => Array ( ) [image_dir:protected] => /home/www/img/c/ [image_format:protected] => jpg [translator:protected] => [def:protected] => Array ( [table] => category [primary] => id_category [multilang] => 1 [multilang_shop] => 1 [fields] => Array ( [nleft] => Array ( [type] => 1 [validate] => isUnsignedInt ) [nright] => Array ( [type] => 1 [validate] => isUnsignedInt ) [level_depth] => Array ( [type] => 1 [validate] => isUnsignedInt ) [active] => Array ( [type] => 2 [validate] => isBool [required] => 1 ) [id_parent] => Array ( [type] => 1 [validate] => isUnsignedInt ) [id_shop_default] => Array ( [type] => 1 [validate] => isUnsignedId ) [is_root_category] => Array ( [type] => 2 [validate] => isBool ) [position] => Array ( [type] => 1 ) [date_add] => Array ( [type] => 5 [validate] => isDate ) [date_upd] => Array ( [type] => 5 [validate] => isDate ) [name] => Array ( [type] => 3 [lang] => 1 [validate] => isCatalogName [required] => 1 [size] => 128 ) [link_rewrite] => Array ( [type] => 3 [lang] => 1 [validate] => isLinkRewrite [required] => 1 [size] => 128 [ws_modifier] => Array ( [http_method] => 2 [modifier] => modifierWsLinkRewrite ) ) [description] => Array ( [type] => 6 [lang] => 1 [validate] => isCleanHtml ) [meta_title] => Array ( [type] => 3 [lang] => 1 [validate] => isGenericName [size] => 255 ) [meta_description] => Array ( [type] => 3 [lang] => 1 [validate] => isGenericName [size] => 512 ) [meta_keywords] => Array ( [type] => 3 [lang] => 1 [validate] => isGenericName [size] => 255 ) ) [classname] => Category [associations] => Array ( [l] => Array ( [type] => 2 [field] => id_category [foreign_field] => id_category ) ) ) [update_fields:protected] => [force_id] => )
325. }
326.
327. public function renderWidget($hookName = null, array $configuration = [])
328. {
329. $this->setLastVisitedCategory();
330. $this->smarty->assign($this->getWidgetVariables($hookName, $configuration));
331.
332. return $this->fetch('module:ps_categorytree/views/templates/hook/ps_categorytree.tpl');
333. }
334.
335. public function getWidgetVariables($hookName = null, array $configuration = [])
Argument [0] displayLeftColumn Argument [1]