You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND pl.id_lang = 1' at line 2SELECT pl.name FROM ps_smart_blog_category_lang pl, ps_smart_blog_category p
WHERE pl.id_smart_blog_category=p.id_smart_blog_category AND p.id_smart_blog_category= AND pl.id_lang = 1
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 pl.name FROM ps_smart_blog_category_lang pl, ps_smart_blog_category p WHERE pl.id_smart_blog_category=p.id_smart_blog_category AND p.id_smart_blog_category= AND pl.id_lang = 1
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 pl.name FROM ps_smart_blog_category_lang pl, ps_smart_blog_category p WHERE pl.id_smart_blog_category=p.id_smart_blog_category AND p.id_smart_blog_category= AND pl.id_lang = 1
675. public static function getCatName($id)
676. {
677. $id_lang = (int) Context::getContext()->language->id;
678. $sql = 'SELECT pl.name FROM ' . _DB_PREFIX_ . 'smart_blog_category_lang pl, ' . _DB_PREFIX_ . 'smart_blog_category p
679. WHERE pl.id_smart_blog_category=p.id_smart_blog_category AND p.id_smart_blog_category=' . $id . ' AND pl.id_lang = ' . $id_lang;
680. if (!$result = Db::getInstance()->executeS($sql))
681. return false;
682. return $result[0]['name'];
683. }
684.
685. public static function getCatLinkRewrite($id)
Argument [0] SELECT pl.name FROM ps_smart_blog_category_lang pl, ps_smart_blog_category p WHERE pl.id_smart_blog_category=p.id_smart_blog_category AND p.id_smart_blog_category= AND pl.id_lang = 1
584. $result[$i]['meta_description'] = $post['meta_description'];
585. $result[$i]['content'] = $post['content'];
586. $result[$i]['meta_keyword'] = $post['meta_keyword'];
587. $result[$i]['id_category'] = $post['id_category'];
588. $result[$i]['link_rewrite'] = $post['link_rewrite'];
589. $result[$i]['cat_name'] = $BlogCategory->getCatName($post['id_category']);
590. $result[$i]['cat_link_rewrite'] = $BlogCategory->getCatLinkRewrite($post['id_category']);
591. $employee = new Employee($post['id_author']);
592.
593. $result[$i]['lastname'] = $employee->lastname;
594. $result[$i]['firstname'] = $employee->firstname;
Argument [0]
48. $limit = $posts_per_page;
49. if ((boolean) Tools::getValue('page')) {
50. $c = (int) Tools::getValue('page');
51. $limit_start = $posts_per_page * ($c - 1);
52. }
53. $result = SmartBlogPost::getArchiveResult($month, $year, $limit_start, $limit);
54. $total = count($result);
55. $totalpages = ceil($total / $posts_per_page);
56.
57. $i = 0;
58. $to = array();
Argument [0] Argument [1] Argument [2] 0 Argument [3] 5
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();