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 'OR s.showOnCat=1 OR s.showOnProd=1)
ORDER BY sl.name' at line 5
SELECT s.id_opartslideshow_slideshow,s.active,s.width,s.height,s.spw,s.sph,s.delay,s.sDelay,s.opacity,s.titleSpeed,s.effect,s.navigation,s.links,s.hoverpause,sl.name
FROM ps_opartslideshow_slideshow s
LEFT JOIN ps_opartslideshow_slideshow_lang sl ON (s.id_opartslideshow_slideshow=sl.id_opartslideshow_slideshow)
LEFT JOIN ps_opartslideshow_slideshow_product sp ON (s.id_opartslideshow_slideshow = sp.id_opartslideshow_slideshow) LEFT JOIN ps_opartslideshow_slideshow_category sc ON (s.id_opartslideshow_slideshow = sc.id_opartslideshow_slideshow)
WHERE s.active=1 AND hook="displayTop" AND sl.id_lang = 1 AND (sp.id_product=90 OR sc.id_category= OR s.showOnCat=1 OR s.showOnProd=1)
ORDER BY sl.name
at line 765 in file classes/db/Db.php
760. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
761. }
762. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
763. {
764. if ($sql)
765. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
766.
767. throw new PrestaShopDatabaseException($this->getMsgError());
768. }
769. }
770.
413. if ($this->connect())
414. $this->result = $this->_query($sql);
415. }
416.
417. if (_PS_DEBUG_SQL_)
418. $this->displayError($sql);
419.
420. return $this->result;
421. }
422.
423. /**
Argument [0] SELECT s.id_opartslideshow_slideshow,s.active,s.width,s.height,s.spw,s.sph,s.delay,s.sDelay,s.opacity,s.titleSpeed,s.effect,s.navigation,s.links,s.hoverpause,sl.name FROM ps_opartslideshow_slideshow s LEFT JOIN ps_opartslideshow_slideshow_lang sl ON (s.id_opartslideshow_slideshow=sl.id_opartslideshow_slideshow) LEFT JOIN ps_opartslideshow_slideshow_product sp ON (s.id_opartslideshow_slideshow = sp.id_opartslideshow_slideshow) LEFT JOIN ps_opartslideshow_slideshow_category sc ON (s.id_opartslideshow_slideshow = sc.id_opartslideshow_slideshow) WHERE s.active=1 AND hook="displayTop" AND sl.id_lang = 1 AND (sp.id_product=90 OR sc.id_category= OR s.showOnCat=1 OR s.showOnProd=1) ORDER BY sl.name
615. if (defined('_PS_MODE_DEV_') && _PS_MODE_DEV_)
616. throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');
617. return $this->execute($sql, $use_cache);
618. }
619.
620. $this->result = $this->query($sql);
621.
622. if (!$this->result)
623. $result = false;
624. else
625. {
Argument [0] SELECT s.id_opartslideshow_slideshow,s.active,s.width,s.height,s.spw,s.sph,s.delay,s.sDelay,s.opacity,s.titleSpeed,s.effect,s.navigation,s.links,s.hoverpause,sl.name FROM ps_opartslideshow_slideshow s LEFT JOIN ps_opartslideshow_slideshow_lang sl ON (s.id_opartslideshow_slideshow=sl.id_opartslideshow_slideshow) LEFT JOIN ps_opartslideshow_slideshow_product sp ON (s.id_opartslideshow_slideshow = sp.id_opartslideshow_slideshow) LEFT JOIN ps_opartslideshow_slideshow_category sc ON (s.id_opartslideshow_slideshow = sc.id_opartslideshow_slideshow) WHERE s.active=1 AND hook="displayTop" AND sl.id_lang = 1 AND (sp.id_product=90 OR sc.id_category= OR s.showOnCat=1 OR s.showOnProd=1) ORDER BY sl.name
254. WHERE s.active=1 AND hook="'.$hookName.'" AND sl.id_lang = '.(int)$this->context->language->id.$addToWhere.'
255. ORDER BY sl.name
256. ';
257.
258. //echo $sqlSlide."<br />";
259. if (!$results = Db::getInstance()->ExecuteS($sqlSlide))
260. return false;
261. $addToWhereImages="";
262. $slides=array();
263. foreach($results as $result) {
264. $slides[$result['id_opartslideshow_slideshow']]=$result;
Argument [0] SELECT s.id_opartslideshow_slideshow,s.active,s.width,s.height,s.spw,s.sph,s.delay,s.sDelay,s.opacity,s.titleSpeed,s.effect,s.navigation,s.links,s.hoverpause,sl.name FROM ps_opartslideshow_slideshow s LEFT JOIN ps_opartslideshow_slideshow_lang sl ON (s.id_opartslideshow_slideshow=sl.id_opartslideshow_slideshow) LEFT JOIN ps_opartslideshow_slideshow_product sp ON (s.id_opartslideshow_slideshow = sp.id_opartslideshow_slideshow) LEFT JOIN ps_opartslideshow_slideshow_category sc ON (s.id_opartslideshow_slideshow = sc.id_opartslideshow_slideshow) WHERE s.active=1 AND hook="displayTop" AND sl.id_lang = 1 AND (sp.id_product=90 OR sc.id_category= OR s.showOnCat=1 OR s.showOnProd=1) ORDER BY sl.name
305. return $this->display(__FILE__, $tplFile);
306. }
307.
308. public function hookDisplayTop()
309. {
310. if(!$this->prepareHook('displayTop'))
311. return false;
312. return $this->displayHook('slideshowTop.tpl');
313. }
314.
315. public function hookDisplayTopColumn()
Argument [0] displayTop
564. Module::$_log_modules_perfs_session = mt_rand();
565. }
566.
567. // Immediately return the result if we do not log performances
568. if (!Module::$_log_modules_perfs)
569. return $module->{$method}($params);
570.
571. // Store time and memory before and after hook call and save the result in the database
572. $time_start = microtime(true);
573. $memory_start = memory_get_usage(true);
574.
Argument [0]
519. if ($use_push && isset($moduleInstance->push_filename) && file_exists($moduleInstance->push_filename))
520. Tools::waitUntilFileIsModified($moduleInstance->push_filename, $moduleInstance->push_time_limit);
521.
522. // Call hook method
523. if ($hook_callable)
524. $display = Hook::coreCallHook($moduleInstance, 'hook'.$hook_name, $hook_args);
525. elseif ($hook_retro_callable)
526. $display = Hook::coreCallHook($moduleInstance, 'hook'.$retro_hook_name, $hook_args);
527.
528. // Live edit
529. if (!$array_return && $array['live_edit'] && Tools::isSubmit('live_edit') && Tools::getValue('ad')
Argument [0] Argument [1] hookdisplayTop Argument [2]
575. {
576. // These hooks aren't used for the mobile theme.
577. // Needed hooks are called in the tpl files.
578. $this->context->smarty->assign(array(
579. 'HOOK_HEADER' => Hook::exec('displayHeader'),
580. 'HOOK_TOP' => Hook::exec('displayTop'),
581. 'HOOK_LEFT_COLUMN' => ($this->display_column_left ? Hook::exec('displayLeftColumn') : ''),
582. 'HOOK_RIGHT_COLUMN' => ($this->display_column_right ? Hook::exec('displayRightColumn', array('cart' => $this->context->cart)) : ''),
583. ));
584. }
585. else
Argument [0] displayTop
175. * Assign template vars related to page content
176. * @see FrontController::initContent()
177. */
178. public function initContent()
179. {
180. parent::initContent();
181.
182. if (!$this->errors)
183. {
184. if (Pack::isPack((int)$this->product->id) && !Pack::isInStock((int)$this->product->id))
185. $this->product->quantity = 0;
175.
176. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
177. $this->initHeader();
178.
179. if ($this->viewAccess())
180. $this->initContent();
181. else
182. $this->errors[] = Tools::displayError('Access denied.');
183.
184. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className)))
185. $this->initFooter();
368. // Execute hook dispatcher
369. if (isset($params_hook_action_dispatcher))
370. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
371.
372. // Running controller
373. $controller->run();
374. }
375. catch (PrestaShopException $e)
376. {
377. $e->displayMessage();
378. }
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();