Can't create/write to file '/tmp/#sql-temptable-6716-109ed9-40cc7.MAI' (Errcode: 28 "No space left on device")SELECT s.*, sl.`description`
FROM `ps_supplier` s
LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1
INNER JOIN ps_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE (s.`active` = 1) AND (s.id_supplier IN (2,335,336,337,338,339,341,342,343,344,345,346,348,351,352,353,354,357,358,360,361,363,364,365,366,367,370,371,372,374,375,376,377,378,381,382,383,384,385,386,388,389,390,391,392,393,395,396,397,399,400,401,402,404,405,406,408,410,411,413,414,416,417,418,419,420,422,423,424,425,426,427,428,429,430,432,433,434,435,437,439,440,441,442,443,444,448,450,451,452,453,456,457,458,459,460,462,463,464,465,466,467,470,473,475,476,478,481,482,484,486,488,491,492,493,495,497,498,499,502,503,504,505,507,508,509,510,516,518,520,521,522,523,524,527,615,617,618,619,620,623,624,626,627,628,630,631,633,636,638,640,641,653,655,664,667,668,670,671,673,675,684,687,690,691,701,702,703,707,709,711,716,717,718,719,720,723,725,731,733,753,756,760,772,798,804))
GROUP BY s.id_supplier
ORDER BY s.`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 s.*, sl.`description` FROM `ps_supplier` s LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN ps_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) AND (s.id_supplier IN (2,335,336,337,338,339,341,342,343,344,345,346,348,351,352,353,354,357,358,360,361,363,364,365,366,367,370,371,372,374,375,376,377,378,381,382,383,384,385,386,388,389,390,391,392,393,395,396,397,399,400,401,402,404,405,406,408,410,411,413,414,416,417,418,419,420,422,423,424,425,426,427,428,429,430,432,433,434,435,437,439,440,441,442,443,444,448,450,451,452,453,456,457,458,459,460,462,463,464,465,466,467,470,473,475,476,478,481,482,484,486,488,491,492,493,495,497,498,499,502,503,504,505,507,508,509,510,516,518,520,521,522,523,524,527,615,617,618,619,620,623,624,626,627,628,630,631,633,636,638,640,641,653,655,664,667,668,670,671,673,675,684,687,690,691,701,702,703,707,709,711,716,717,718,719,720,723,725,731,733,753,756,760,772,798,804)) GROUP BY s.id_supplier ORDER BY s.`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 s.*, sl.`description` FROM `ps_supplier` s LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN ps_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) AND (s.id_supplier IN (2,335,336,337,338,339,341,342,343,344,345,346,348,351,352,353,354,357,358,360,361,363,364,365,366,367,370,371,372,374,375,376,377,378,381,382,383,384,385,386,388,389,390,391,392,393,395,396,397,399,400,401,402,404,405,406,408,410,411,413,414,416,417,418,419,420,422,423,424,425,426,427,428,429,430,432,433,434,435,437,439,440,441,442,443,444,448,450,451,452,453,456,457,458,459,460,462,463,464,465,466,467,470,473,475,476,478,481,482,484,486,488,491,492,493,495,497,498,499,502,503,504,505,507,508,509,510,516,518,520,521,522,523,524,527,615,617,618,619,620,623,624,626,627,628,630,631,633,636,638,640,641,653,655,664,667,668,670,671,673,675,684,687,690,691,701,702,703,707,709,711,716,717,718,719,720,723,725,731,733,753,756,760,772,798,804)) GROUP BY s.id_supplier ORDER BY s.`name` ASC
24. }
25. $query->where('s.id_supplier IN (' . implode(',', $shown_suppliers) . ')');
26. $query->orderBy(' s.`name` ASC');
27. $query->limit($n, ($p - 1) * $n);
28. $query->groupBy('s.id_supplier');
29. $suppliers = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($query);
30. if ($suppliers === false) {
31. return false;
32. }
33. if ($get_nb_products) {
34. $sql_groups = '';
Argument [0] SELECT s.*, sl.`description` FROM `ps_supplier` s LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN ps_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) AND (s.id_supplier IN (2,335,336,337,338,339,341,342,343,344,345,346,348,351,352,353,354,357,358,360,361,363,364,365,366,367,370,371,372,374,375,376,377,378,381,382,383,384,385,386,388,389,390,391,392,393,395,396,397,399,400,401,402,404,405,406,408,410,411,413,414,416,417,418,419,420,422,423,424,425,426,427,428,429,430,432,433,434,435,437,439,440,441,442,443,444,448,450,451,452,453,456,457,458,459,460,462,463,464,465,466,467,470,473,475,476,478,481,482,484,486,488,491,492,493,495,497,498,499,502,503,504,505,507,508,509,510,516,518,520,521,522,523,524,527,615,617,618,619,620,623,624,626,627,628,630,631,633,636,638,640,641,653,655,664,667,668,670,671,673,675,684,687,690,691,701,702,703,707,709,711,716,717,718,719,720,723,725,731,733,753,756,760,772,798,804)) GROUP BY s.id_supplier ORDER BY s.`name` ASC
88. <div class="col-sm-12">
89. <h2 class="page-heading reveal"><?php echo smartyTranslate(array('s'=>"Our partners"),$_smarty_tpl);?>
90. </h2>
91. <div class="row">
92. <div class="col-xs-12">
93. <?php $_smarty_tpl->tpl_vars['suppliers'] = new Smarty_variable(Supplier::getSuppliers(), null, 0);?>
94. <?php $_smarty_tpl->_capture_stack[0][] = array('default', null, null); ob_start(); ?><?php echo shuffle($_smarty_tpl->tpl_vars['suppliers']->value);?>
95. <?php list($_capture_buffer, $_capture_assign, $_capture_append) = array_pop($_smarty_tpl->_capture_stack[0]);
96. if (!empty($_capture_buffer)) {
97. if (isset($_capture_assign)) $_smarty_tpl->assign($_capture_assign, ob_get_contents());
98. if (isset( $_capture_append)) $_smarty_tpl->append( $_capture_append, ob_get_contents());
183. }
184. array_unshift($_template->_capture_stack, array());
185. //
186. // render compiled template
187. //
188. $_template->properties['unifunc']($_template);
189. // any unclosed {capture} tags ?
190. if (isset($_template->_capture_stack[0][0])) {
191. $_template->capture_error();
192. }
193. array_shift($_template->_capture_stack);
Argument [0]
105. * {@inheritDoc}
106. */
107. public function fetch($template = null, $cache_id = null, $compile_id = null, $parent = null, $display = false, $merge_tpl_vars = true, $no_output_filter = false)
108. {
109. $this->check_compile_cache_invalidation();
110. return parent::fetch($template, $cache_id, $compile_id, $parent, $display, $merge_tpl_vars, $no_output_filter);
111. }
112.
113. /**
114. * {@inheritDoc}
115. */
Argument [0] /home/negdig20/public_html/themes/negoguide2020/index.tpl Argument [1] Argument [2] Argument [3] Argument [4] Argument [5] 1 Argument [6]
708. ));
709.
710. $layout = $this->getLayout();
711. if ($layout) {
712. if ($this->template) {
713. $template = $this->context->smarty->fetch($this->template);
714. } else {
715. // For retrocompatibility with 1.4 controller
716.
717. ob_start();
718. $this->displayContent();
Argument [0] /home/negdig20/public_html/themes/negoguide2020/index.tpl
204. $this->{'displayAjax'.$action}();
205. } elseif (method_exists($this, 'displayAjax')) {
206. $this->displayAjax();
207. }
208. } else {
209. $this->display();
210. }
211. } else {
212. $this->initCursedPage();
213. $this->smartyOutputContent($this->layout);
214. }
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();