Truncated incorrect DECIMAL value: '' UPDATE ps_sfkseoschema SET `sfk_rating_value` = '5', `sfk_star_count` = '5' WHERE sfk_rating_value > 5;
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] UPDATE ps_sfkseoschema SET `sfk_rating_value` = '5', `sfk_star_count` = '5' WHERE sfk_rating_value > 5;
596. {
597. if ($sql instanceof DbQuery) {
598. $sql = $sql->build();
599. }
600.
601. $this->result = $this->query($sql);
602. if ($use_cache && $this->is_cache_enabled) {
603. Cache::getInstance()->deleteQuery($sql);
604. }
605.
606. return (bool)$this->result;
Argument [0] UPDATE ps_sfkseoschema SET `sfk_rating_value` = '5', `sfk_star_count` = '5' WHERE sfk_rating_value > 5;
1209. }
1210. */
1211.
1212. // this code to update default values for the rating value more than 50 in numbers
1213. $sqlrs = " UPDATE " . _DB_PREFIX_ . "sfkseoschema SET `sfk_rating_value` = '5', `sfk_star_count` = '5' WHERE sfk_rating_value > 5;";
1214. Db::getInstance()->Execute($sqlrs);
1215.
1216. $this->context->smarty->assign('SFK_DESCRIPTION', $sfk_description);
1217.
1218. // Get the default country ID
1219. $defaultCountryId = Configuration::get('PS_COUNTRY_DEFAULT');
Argument [0] UPDATE ps_sfkseoschema SET `sfk_rating_value` = '5', `sfk_star_count` = '5' WHERE sfk_rating_value > 5;
586. }
587. }
588.
589. // Immediately return the result if we do not log performances
590. if (!Module::$_log_modules_perfs) {
591. return $module->{$method}($params);
592. }
593.
594. // Store time and memory before and after hook call and save the result in the database
595. $time_start = microtime(true);
596. $memory_start = memory_get_usage(true);
Argument [0]
541. Tools::waitUntilFileIsModified($moduleInstance->push_filename, $moduleInstance->push_time_limit);
542. }
543.
544. // Call hook method
545. if ($hook_callable) {
546. $display = Hook::coreCallHook($moduleInstance, 'hook'.$hook_name, $hook_args);
547. } elseif ($hook_retro_callable) {
548. $display = Hook::coreCallHook($moduleInstance, 'hook'.$retro_hook_name, $hook_args);
549. }
550.
551. // Live edit
Argument [0] Argument [1] hookdisplayHeader Argument [2]
236. * version: 9.0.4
237. */
238. private static function exec_16($hook_name, $hook_args = array(), $id_module = null, $array_return = false, $check_exceptions = true, $use_push = false, $id_shop = null)
239. {
240. if (Tools::getIsset('ajax') || strcmp('moduleRoutes', $hook_name) == 0 || !self::_isPageCacheActive()) {
241. return parent::exec($hook_name, $hook_args, $id_module, $array_return, $check_exceptions, $use_push = false, $id_shop = null);
242. }
243. static $disable_non_native_modules = null;
244. if ($disable_non_native_modules === null)
245. $disable_non_native_modules = (bool)Configuration::get('PS_DISABLE_NON_NATIVE_MODULE');
246. if (($id_module && !is_numeric($id_module)) || !Validate::isHookName($hook_name))
Argument [0] displayHeader Argument [1] Argument [2] Argument [3] Argument [4] 1 Argument [5] Argument [6]
137. * version: 9.0.4
138. */
139. public static function exec($hook_name, $hook_args = array(), $id_module = null, $array_return = false, $check_exceptions = true, $use_push = false, $id_shop = null)
140. {
141. if (Tools::version_compare(_PS_VERSION_,'1.6','>=')) {
142. return self::exec_16($hook_name, $hook_args, $id_module, $array_return, $check_exceptions, $use_push, $id_shop);
143. } else {
144. return self::exec_15($hook_name, $hook_args, $id_module, $array_return, $check_exceptions);
145. }
146. }
147. /*
Argument [0] displayHeader Argument [1] Array ( ) Argument [2] Argument [3] Argument [4] 1 Argument [5] Argument [6]
574.
575. if (!$this->useMobileTheme()) {
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. } else {
Argument [0] displayHeader
38. * Assign template vars related to page content
39. * @see FrontController::initContent()
40. */
41. public function initContent()
42. {
43. parent::initContent();
44.
45. $this->productSort();
46. $nbProducts = Product::getPricesDrop($this->context->language->id, null, null, true);
47. $this->pagination($nbProducts);
48.
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))) {
666. try
667. {
668. $controller = Controller::getController($controller_class);
669. if (isset($params_hook_action_dispatcher))
670. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
671. $controller->run();
672. if ($this->_isPageCacheActive())
673. {
674. $pagecacheInstance = Module::getInstanceByName('pagecache');
675. if ($pagecacheInstance) {
676. $pagecacheInstance->hookActionDispatcherAfter();
441. * date: 2024-03-29 09:54:39
442. * version: 9.0.4
443. */
444. public function dispatch() {
445. if (Tools::version_compare(_PS_VERSION_,'1.6','>=')) {
446. $this->dispatch_16();
447. } else {
448. $this->dispatch_15();
449. }
450. }
451. /*
57. }
58. }
59. // ~~end-pagecacheultimate~~ Do not remove this comment, pagecache will update it automatically
60.
61. require(dirname(__FILE__).'/config/config.inc.php');
62. Dispatcher::getInstance()->dispatch();