Unknown column 'lbb.id_lofblogs_blocks' in 'on clause'SELECT lbbl.content as content, lbbl.title as title
FROM prsd_lofblogs_blocks lbb
LEFT JOIN prsd_lofblogs_blocks_lang lbbl ON (lbb.id_lofblogs_blocks = lbbl.id_lofblogs_blocks)
WHERE lbb.position='bottom' AND lbb.template = 'clean' AND lbb.published = 1 AND lbbl.id_lang = 1
at line 613 in file classes/db/Db.php
607. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
608. }
609. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
610. {
611. if ($sql)
612. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
613. throw new PrestaShopDatabaseException($this->getMsgError());
614. }
615. }
616.
617. /**
307. if ($sql instanceof DbQuery)
308. $sql = $sql->build();
309.
310. $this->result = $this->_query($sql);
311. if (_PS_DEBUG_SQL_)
312. $this->displayError($sql);
313. return $this->result;
314. }
315.
316. /**
317. * Execute an INSERT query
Argument [0] SELECT lbbl.content as content, lbbl.title as title FROM prsd_lofblogs_blocks lbb LEFT JOIN prsd_lofblogs_blocks_lang lbbl ON (lbb.id_lofblogs_blocks = lbbl.id_lofblogs_blocks) WHERE lbb.position='bottom' AND lbb.template = 'clean' AND lbb.published = 1 AND lbbl.id_lang = 1
482. {
483. $this->last_cached = true;
484. return $result;
485. }
486.
487. $this->result = $this->query($sql);
488. if (!$this->result)
489. return false;
490.
491. $this->last_cached = false;
492. if (!$array)
Argument [0] SELECT lbbl.content as content, lbbl.title as title FROM prsd_lofblogs_blocks lbb LEFT JOIN prsd_lofblogs_blocks_lang lbbl ON (lbb.id_lofblogs_blocks = lbbl.id_lofblogs_blocks) WHERE lbb.position='bottom' AND lbb.template = 'clean' AND lbb.published = 1 AND lbbl.id_lang = 1
46. FROM '._DB_PREFIX_.'lofblogs_blocks lbb
47. LEFT JOIN '._DB_PREFIX_.'lofblogs_blocks_lang lbbl ON (lbb.id_lofblogs_blocks = lbbl.id_lofblogs_blocks)
48. WHERE lbb.position='.lofContentHelper::sqlQuote($position)
49. .' AND lbb.template = '.lofContentHelper::sqlQuote($template)
50. .' AND lbb.published = 1 AND lbbl.id_lang = '.$this->lang;
51. return Db::getInstance()->executeS($query);
52. }
53.
54. public function getTranslationsFieldsChild() {
55. global $cookie;
56. parent::validateFieldsLang();
Argument [0] SELECT lbbl.content as content, lbbl.title as title FROM prsd_lofblogs_blocks lbb LEFT JOIN prsd_lofblogs_blocks_lang lbbl ON (lbb.id_lofblogs_blocks = lbbl.id_lofblogs_blocks) WHERE lbb.position='bottom' AND lbb.template = 'clean' AND lbb.published = 1 AND lbbl.id_lang = 1
796.
797. if (count($themeinfo['blocks'])) {
798. foreach ($themeinfo['blocks'] as $blockname) {
799. $blockname = trim(strtolower($blockname));
800. $html = '';
801. $position = $this->blocks->getContent($blockname, $this->theme);
802.
803. if (count($position)) {
804. $content = array();
805. foreach ($position as $block) {
806. $content[] = '<div class="lofblogs_custom_block"><h4>' . $block['title'] . '</h4><div class="lofblocks_content">' . $block['content'] . '</div></div>';
Argument [0] bottom Argument [1] clean
369. public function displayContent() {
370. parent::displayContent();
371. $this->context->smarty->assign('imgPrimaryUri', LOFCONTENT_IMAGES_URI);
372. $this->context->smarty->assign('galleryUri', LOFCONTENT_IMAGES_GALLERY_URI);
373. $this->context->smarty->assign('thumbUri', LOFCONTENT_IMAGES_THUMBS_URI);
374. $this->assignBlocks();
375.
376. switch ($this->view) {
377. case 'category':
378.
379. if ($this->format == 'normal') {
536. if ($this->template)
537. $this->context->smarty->assign('template', $this->context->smarty->fetch($this->template).$live_edit_content);
538. else // For retrocompatibility with 1.4 controller
539. {
540. ob_start();
541. $this->displayContent();
542. $template = ob_get_contents();
543. ob_clean();
544. $this->context->smarty->assign('template', $template.$live_edit_content);
545. }
546. $this->smartyOutputContent($layout);
179. $this->{'displayAjax'.$action}();
180. elseif (method_exists($this, 'displayAjax'))
181. $this->displayAjax();
182. }
183. else
184. $this->display();
185. }
186. else
187. {
188. $this->initCursedPage();
189. $this->smartyOutputContent($this->layout);
342. // Execute hook dispatcher
343. if (isset($params_hook_action_dispatcher))
344. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
345.
346. // Running controller
347. $controller->run();
348. }
349. catch (PrestaShopException $e)
350. {
351. $e->displayMessage();
352. }
22. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
23. * International Registered Trademark & Property of PrestaShop SA
24. */
25.
26. require(dirname(__FILE__).'/config/config.inc.php');
27. Dispatcher::getInstance()->dispatch();
28.