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 ex_opartslideshow_slideshow s
LEFT JOIN ex_opartslideshow_slideshow_lang sl ON (s.id_opartslideshow_slideshow=sl.id_opartslideshow_slideshow)
LEFT JOIN ex_opartslideshow_slideshow_product sp ON (s.id_opartslideshow_slideshow = sp.id_opartslideshow_slideshow) LEFT JOIN ex_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=564 OR sc.id_category= OR s.showOnCat=1 OR s.showOnProd=1)
ORDER BY sl.name
at line 646 in file classes/db/Db.php
641. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642. }
643. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644. {
645. if ($sql)
646. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647. throw new PrestaShopDatabaseException($this->getMsgError());
648. }
649. }
650.
651. /**
335. if ($this->connect())
336. $this->result = $this->_query($sql);
337. }
338.
339. if (_PS_DEBUG_SQL_)
340. $this->displayError($sql);
341. return $this->result;
342. }
343.
344. /**
345. * Execute an INSERT query
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 ex_opartslideshow_slideshow s LEFT JOIN ex_opartslideshow_slideshow_lang sl ON (s.id_opartslideshow_slideshow=sl.id_opartslideshow_slideshow) LEFT JOIN ex_opartslideshow_slideshow_product sp ON (s.id_opartslideshow_slideshow = sp.id_opartslideshow_slideshow) LEFT JOIN ex_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=564 OR sc.id_category= OR s.showOnCat=1 OR s.showOnProd=1) ORDER BY sl.name
511. {
512. $this->last_cached = true;
513. return $result;
514. }
515.
516. $this->result = $this->query($sql);
517.
518. if (!$this->result)
519. $result = false;
520. else
521. {
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 ex_opartslideshow_slideshow s LEFT JOIN ex_opartslideshow_slideshow_lang sl ON (s.id_opartslideshow_slideshow=sl.id_opartslideshow_slideshow) LEFT JOIN ex_opartslideshow_slideshow_product sp ON (s.id_opartslideshow_slideshow = sp.id_opartslideshow_slideshow) LEFT JOIN ex_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=564 OR sc.id_category= OR s.showOnCat=1 OR s.showOnProd=1) ORDER BY sl.name
253. WHERE s.active=1 AND hook="'.$hookName.'" AND sl.id_lang = '.(int)$this->context->language->id.$addToWhere.'
254. ORDER BY sl.name
255. ';
256.
257. //echo $sqlSlide."<br />";
258. if (!$results = Db::getInstance()->ExecuteS($sqlSlide))
259. return false;
260. $addToWhereImages="";
261. $slides=array();
262. foreach($results as $result) {
263. $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 ex_opartslideshow_slideshow s LEFT JOIN ex_opartslideshow_slideshow_lang sl ON (s.id_opartslideshow_slideshow=sl.id_opartslideshow_slideshow) LEFT JOIN ex_opartslideshow_slideshow_product sp ON (s.id_opartslideshow_slideshow = sp.id_opartslideshow_slideshow) LEFT JOIN ex_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=564 OR sc.id_category= OR s.showOnCat=1 OR s.showOnProd=1) ORDER BY sl.name
304. return $this->display(__FILE__, $tplFile);
305. }
306.
307. public function hookDisplayTop()
308. {
309. if(!$this->prepareHook('displayTop'))
310. return false;
311. return $this->displayHook('slideshowTop.tpl');
312. }
313.
314. public function hookDisplayOpartSlideshowHook()
Argument [0] displayTop
505. if ($use_push && isset($moduleInstance->push_filename) && file_exists($moduleInstance->push_filename))
506. Tools::waitUntilFileIsModified($moduleInstance->push_filename, $moduleInstance->push_time_limit);
507.
508. // Call hook method
509. if ($hook_callable)
510. $display = $moduleInstance->{'hook'.$hook_name}($hook_args);
511. elseif ($hook_retro_callable)
512. $display = $moduleInstance->{'hook'.$retro_hook_name}($hook_args);
513. // Live edit
514. if (!$array_return && $array['live_edit'] && Tools::isSubmit('live_edit') && Tools::getValue('ad') && Tools::getValue('liveToken') == Tools::getAdminToken('AdminModulesPositions'.(int)Tab::getIdFromClassName('AdminModulesPositions').(int)Tools::getValue('id_employee')))
515. {
Argument [0]
452. {
453. // These hooks aren't used for the mobile theme.
454. // Needed hooks are called in the tpl files.
455. $this->context->smarty->assign(array(
456. 'HOOK_HEADER' => Hook::exec('displayHeader'),
457. 'HOOK_TOP' => Hook::exec('displayTop'),
458. 'HOOK_LEFT_COLUMN' => ($this->display_column_left ? Hook::exec('displayLeftColumn') : ''),
459. 'HOOK_RIGHT_COLUMN' => ($this->display_column_right ? Hook::exec('displayRightColumn', array('cart' => $this->context->cart)) : ''),
460. ));
461. }
462. else
Argument [0] displayTop
172. * Assign template vars related to page content
173. * @see FrontController::initContent()
174. */
175. public function initContent()
176. {
177. parent::initContent();
178.
179. if (!$this->errors)
180. {
181. if (Pack::isPack((int)$this->product->id) && !Pack::isInStock((int)$this->product->id))
182. $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();