You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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 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 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
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 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
677. public static function getCatName($id)
678. {
679. $id_lang = (int) Context::getContext()->language->id;
680. $sql = 'SELECT pl.name FROM ' . _DB_PREFIX_ . 'smart_blog_category_lang pl, ' . _DB_PREFIX_ . 'smart_blog_category p
681. WHERE pl.id_smart_blog_category=p.id_smart_blog_category AND p.id_smart_blog_category=' . $id . ' AND pl.id_lang = ' . $id_lang;
682. if (!$result = Db::getInstance()->executeS($sql))
683. return false;
684. return $result[0]['name'];
685. }
686.
687. 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
605. $result[$i]['meta_description'] = $post['meta_description'];
606. $result[$i]['content'] = $post['content'];
607. $result[$i]['meta_keyword'] = $post['meta_keyword'];
608. $result[$i]['id_category'] = $post['id_category'];
609. $result[$i]['link_rewrite'] = $post['link_rewrite'];
610. $result[$i]['cat_name'] = $BlogCategory->getCatName($post['id_category']);
611. $result[$i]['cat_link_rewrite'] = $BlogCategory->getCatLinkRewrite($post['id_category']);
612. $employee = new Employee($post['id_author']);
613.
614. $result[$i]['lastname'] = $employee->lastname;
615. $result[$i]['firstname'] = $employee->firstname;
Argument [0]
49. $limit = $posts_per_page;
50. if ((boolean) Tools::getValue('page')) {
51. $c = (int) Tools::getValue('page');
52. $limit_start = $posts_per_page * ($c - 1);
53. }
54. $result = SmartBlogPost::getArchiveResult($month, $year, $day, $limit_start, $limit);
55. $total = count($result);
56. $totalpages = ceil($total / $posts_per_page);
57.
58. $i = 0;
59. $to = array();
Argument [0] 4 Argument [1] 2022 Argument [2] Argument [3] 0 Argument [4] 5
276. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
277. $this->initHeader();
278. }
279.
280. if ($this->viewAccess()) {
281. $this->initContent();
282. } else {
283. $this->errors[] = $this->trans('Access denied.', array(), 'Admin.Notifications.Error');
284. }
285.
286. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {
504. if (isset($params_hook_action_dispatcher)) {
505. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
506. }
507.
508. // Running controller
509. $controller->run();
510.
511. // Execute hook dispatcher after
512. if (isset($params_hook_action_dispatcher)) {
513. Hook::exec('actionDispatcherAfter', $params_hook_action_dispatcher);
514. }
23. * @license https://opensource.org/licenses/OSL-3.0 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();