INSERT command denied to user 'vsppieceses'@'10.6.20.2' for table 'ps_guest'INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
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] INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
581. {
582. if ($sql instanceof DbQuery)
583. $sql = $sql->build();
584.
585. $this->result = false;
586. $result = $this->query($sql);
587. if ($use_cache && $this->is_cache_enabled)
588. Cache::getInstance()->deleteQuery($sql);
589. if (_PS_DEBUG_SQL_)
590. $this->displayError($sql);
591. return $result;
Argument [0] INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')
372. $keys_stringified = implode(', ', $keys);
373. $values_stringified[] = '('.implode(', ', $values).')';
374. }
375.
376. $sql = $insert_keyword.' INTO `'.$table.'` ('.$keys_stringified.') VALUES '.implode(', ', $values_stringified);
377. return (bool)$this->q($sql, $use_cache);
378. }
379.
380. /**
381. * @param string $table Table name without prefix
382. * @param array $data Data to insert as associative array. If $data is a list of arrays, multiple insert will be done
Argument [0] INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0') Argument [1] 1
449. // Database insertion
450. if (isset($this->id) && !Tools::getValue('forceIDs'))
451. unset($this->id);
452. if (Shop::checkIdShopDefault($this->def['table']))
453. $this->id_shop_default = min($id_shop_list);
454. if (!$result = ObjectModel::$db->insert($this->def['table'], $this->getFields(), $null_values))
455. return false;
456.
457. // Get object id in database
458. $this->id = ObjectModel::$db->Insert_ID();
459.
Argument [0] guest Argument [1] Array ( [id_operating_system] => 0 [id_web_browser] => 0 [id_customer] => 0 [javascript] => 0 [screen_resolution_x] => 0 [screen_resolution_y] => 0 [screen_color] => 0 [sun_java] => 0 [adobe_flash] => 0 [adobe_director] => 0 [apple_quicktime] => 0 [real_player] => 0 [windows_media] => 0 [accept_language] => [mobile_theme] => 0 ) Argument [2]
411. * @param bool $autodate
412. * @return boolean Insertion result
413. */
414. public function save($null_values = false, $autodate = true)
415. {
416. return (int)$this->id > 0 ? $this->update($null_values) : $this->add($autodate, $null_values);
417. }
418.
419. /**
420. * Add current object to database
421. *
Argument [0] 1 Argument [1]
182.
183. public static function setNewGuest($cookie)
184. {
185. $guest = new Guest(isset($cookie->id_customer) ? Guest::getFromCustomer((int)($cookie->id_customer)) : null);
186. $guest->userAgent();
187. $guest->save();
188. $cookie->id_guest = (int)($guest->id);
189. }
190. }
96. public function hookFooter($params)
97. {
98. $html = '';
99. if (!isset($params['cookie']->id_guest))
100. {
101. Guest::setNewGuest($params['cookie']);
102.
103. if (Configuration::get('PS_STATSDATA_PLUGINS'))
104. {
105. // Ajax request sending browser information
106. $token = sha1($params['cookie']->id_guest._COOKIE_KEY_);
Argument [0] Cookie Object ( [_content:protected] => Array ( [date_add] => 2024-03-28 21:44:06 [id_lang] => 5 [id_currency] => 1 ) [_name:protected] => 46d50b4ce9bc921e80127f1faec137f8 [_expire:protected] => 1713386646 [_domain:protected] => vsppieces.fr [_path:protected] => / [_cipherTool:protected] => Rijndael Object ( [_key:protected] => Y6CxguLqV5C9qYYYBActLbKFOPnCZkYB [_iv:protected] => £ì&Á#~-z °ú™ ) [_modified:protected] => 1 [_allow_writing:protected] => 1 [_salt:protected] => eqiL5a03 [_standalone:protected] => )
453.
454. // Call hook method
455. if ($hook_callable)
456. $display = $moduleInstance->{'hook'.$hook_name}($hook_args);
457. else if ($hook_retro_callable)
458. $display = $moduleInstance->{'hook'.$retro_hook_name}($hook_args);
459. // Live edit
460. 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')))
461. {
462. $live_edit = true;
463. $output .= self::wrapLiveEdit($display, $moduleInstance, $array['id_hook']);
Argument [0] Array ( [cookie] => Cookie Object ( [_content:protected] => Array ( [date_add] => 2024-03-28 21:44:06 [id_lang] => 5 [id_currency] => 1 ) [_name:protected] => 46d50b4ce9bc921e80127f1faec137f8 [_expire:protected] => 1713386646 [_domain:protected] => vsppieces.fr [_path:protected] => / [_cipherTool:protected] => Rijndael Object ( [_key:protected] => Y6CxguLqV5C9qYYYBActLbKFOPnCZkYB [_iv:protected] => £ì&Á#~-z °ú™ ) [_modified:protected] => 1 [_allow_writing:protected] => 1 [_salt:protected] => eqiL5a03 [_standalone:protected] => ) [cart] => Cart Object ( [id] => [id_shop_group] => 1 [id_shop] => 1 [id_address_delivery] => 0 [id_address_invoice] => 0 [id_currency] => 1 [id_customer] => [id_guest] => 0 [id_lang] => 5 [recyclable] => 0 [gift] => 0 [gift_message] => [mobile_theme] => [date_add] => [secure_key] => [id_carrier] => 0 [date_upd] => [checkedTos] => [pictures] => [textFields] => [delivery_option] => [allow_seperated_package] => [_products:protected] => [_taxCalculationMethod:protected] => 0 [webserviceParameters:protected] => Array ( [fields] => Array ( [id_address_delivery] => Array ( [xlink_resource] => addresses ) [id_address_invoice] => Array ( [xlink_resource] => addresses ) [id_currency] => Array ( [xlink_resource] => currencies ) [id_customer] => Array ( [xlink_resource] => customers ) [id_guest] => Array ( [xlink_resource] => guests ) [id_lang] => Array ( [xlink_resource] => languages ) ) [associations] => Array ( [cart_rows] => Array ( [resource] => cart_row [virtual_entity] => 1 [fields] => Array ( [id_product] => Array ( [required] => 1 [xlink_resource] => products ) [id_product_attribute] => Array ( [required] => 1 [xlink_resource] => combinations ) [id_address_delivery] => Array ( [required] => 1 [xlink_resource] => addresses ) [quantity] => Array ( [required] => 1 ) ) ) ) ) [id_shop_list] => [get_shop_from_context:protected] => 1 [table:protected] => cart [identifier:protected] => id_cart [fieldsRequired:protected] => Array ( [0] => id_currency [1] => id_lang ) [fieldsSize:protected] => Array ( [secure_key] => 32 ) [fieldsValidate:protected] => Array ( [id_shop_group] => isUnsignedId [id_shop] => isUnsignedId [id_address_delivery] => isUnsignedId [id_address_invoice] => isUnsignedId [id_carrier] => isUnsignedId [id_currency] => isUnsignedId [id_customer] => isUnsignedId [id_guest] => isUnsignedId [id_lang] => isUnsignedId [recyclable] => isBool [gift] => isBool [gift_message] => isMessage [mobile_theme] => isBool [allow_seperated_package] => isBool [date_add] => isDateFormat [date_upd] => isDateFormat ) [fieldsRequiredLang:protected] => Array ( ) [fieldsSizeLang:protected] => Array ( ) [fieldsValidateLang:protected] => Array ( ) [tables:protected] => Array ( ) [image_dir:protected] => [image_format:protected] => jpg [def:protected] => Array ( [table] => cart [primary] => id_cart [fields] => Array ( [id_shop_group] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_shop] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_address_delivery] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_address_invoice] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_carrier] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_currency] => Array ( [type] => 1 [validate] => isUnsignedId [required] => 1 ) [id_customer] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_guest] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_lang] => Array ( [type] => 1 [validate] => isUnsignedId [required] => 1 ) [recyclable] => Array ( [type] => 2 [validate] => isBool ) [gift] => Array ( [type] => 2 [validate] => isBool ) [gift_message] => Array ( [type] => 3 [validate] => isMessage ) [mobile_theme] => Array ( [type] => 2 [validate] => isBool ) [delivery_option] => Array ( [type] => 3 ) [secure_key] => Array ( [type] => 3 [size] => 32 ) [allow_seperated_package] => Array ( [type] => 2 [validate] => isBool ) [date_add] => Array ( [type] => 5 [validate] => isDateFormat ) [date_upd] => Array ( [type] => 5 [validate] => isDateFormat ) ) [classname] => Cart ) [update_fields:protected] => ) [altern] => 2 )
759. }
760.
761. public function initFooter()
762. {
763. $this->context->smarty->assign(array(
764. 'HOOK_FOOTER' => Hook::exec('displayFooter'),
765. 'conditions' => Configuration::get('PS_CONDITIONS'),
766. 'id_cgv' => Configuration::get('PS_CONDITIONS_CMS_ID'),
767. 'PS_SHOP_NAME' => Configuration::get('PS_SHOP_NAME'),
768. 'PS_ALLOW_MOBILE_DEVICE' => isset($_SERVER['HTTP_USER_AGENT']) && (bool)Configuration::get('PS_ALLOW_MOBILE_DEVICE') && @filemtime(_PS_THEME_MOBILE_DIR_)
769. ));
Argument [0] displayFooter
166. $this->initContent();
167. else
168. $this->errors[] = Tools::displayError('Access denied.');
169.
170. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className)))
171. $this->initFooter();
172.
173. // default behavior for ajax process is to use $_POST[action] or $_GET[action]
174. // then using displayAjax[action]
175. if ($this->ajax)
176. {
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.