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 'LIMIT 1' at line 6SELECT b.*,a.* FROM ps_cs_blog_post a
LEFT JOIN ps_cs_blog_post_lang b
ON (a.id_cs_blog_post= b.id_cs_blog_post AND b.id_shop = 1)
LEFT JOIN ps_cs_blog_post_shop c
ON (a.id_cs_blog_post= c.id_cs_blog_post)
WHERE (c.active=1) AND b.id_lang = 3 AND c.id_shop = 1 AND a.id_cs_blog_post = LIMIT 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 b.*,a.* FROM ps_cs_blog_post a LEFT JOIN ps_cs_blog_post_lang b ON (a.id_cs_blog_post= b.id_cs_blog_post AND b.id_shop = 1) LEFT JOIN ps_cs_blog_post_shop c ON (a.id_cs_blog_post= c.id_cs_blog_post) WHERE (c.active=1) AND b.id_lang = 3 AND c.id_shop = 1 AND a.id_cs_blog_post = LIMIT 1
685. $this->last_cached = true;
686. return $result;
687. }
688. }
689.
690. $this->result = $this->query($sql);
691. if (!$this->result) {
692. $result = false;
693. } else {
694. $result = $this->nextRow($this->result);
695. }
Argument [0] SELECT b.*,a.* FROM ps_cs_blog_post a LEFT JOIN ps_cs_blog_post_lang b ON (a.id_cs_blog_post= b.id_cs_blog_post AND b.id_shop = 1) LEFT JOIN ps_cs_blog_post_shop c ON (a.id_cs_blog_post= c.id_cs_blog_post) WHERE (c.active=1) AND b.id_lang = 3 AND c.id_shop = 1 AND a.id_cs_blog_post = LIMIT 1
219. LEFT JOIN '._DB_PREFIX_.'cs_blog_post_lang b
220. ON (a.id_cs_blog_post= b.id_cs_blog_post AND b.id_shop = '.$id_shop.')
221. LEFT JOIN '._DB_PREFIX_.'cs_blog_post_shop c
222. ON (a.id_cs_blog_post= c.id_cs_blog_post)
223. WHERE (c.active=1) AND b.id_lang = '.$id_lang.' AND c.id_shop = '.$id_shop.' AND a.id_cs_blog_post = '.$id_cs_blog_post.'';
224. $row = Db::getInstance()->getRow($sql);
225. if ($row)
226. {
227.
228. $date = new DateTime(''.$row['date_add'].'');
229.
Argument [0] SELECT b.*,a.* FROM ps_cs_blog_post a LEFT JOIN ps_cs_blog_post_lang b ON (a.id_cs_blog_post= b.id_cs_blog_post AND b.id_shop = 1) LEFT JOIN ps_cs_blog_post_shop c ON (a.id_cs_blog_post= c.id_cs_blog_post) WHERE (c.active=1) AND b.id_lang = 3 AND c.id_shop = 1 AND a.id_cs_blog_post = LIMIT 1
60. {
61. $id_lang = $this->context->language->id;
62. $id_shop = $this->context->shop->id;
63. /*get content detail post*/
64. $image_size = Configuration::get('CS_IMIPD_SHOW');
65. $post = $this->getPostById($image_size, $this->id_cs_blog_post, $id_lang, $id_shop);
66. $this->context->smarty->assign('csLink', $this->csLink);
67. $this->context->smarty->assign('capchatpath', __PS_BASE_URI__.'modules/csblog/');
68. $this->context->smarty->assign('cs_b_summary_character_count', Configuration::get('CS_B_SUMMARY_CHARACTER_COUNT'));
69. $link_main = Configuration::get('CS_MAIN_BLOG_URL');
70. if ($post != null)
Argument [0] large Argument [1] Argument [2] 3 Argument [3] 1
51. {
52. $this->csLink = new csLink();
53. $this->csTag = new CSBLTag();
54. $this->id_cs_blog_post = Tools::getValue('id_cs_blog_post');
55. parent::initContent();
56. $this->_display();
57. $this->setTemplate('post.tpl');
58. }
59. public function _display()
60. {
61. $id_lang = $this->context->language->id;
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();