grafixweb Posted November 11, 2014 Share Posted November 11, 2014 Oggi mi sono ritrovato questo problema.. e non so come uscirne HELP !!!! [PrestaShopDatabaseException] INSERT command denied to user 'grafixwe79139'@'217.64.195.223' for table 'ps_ebay_configuration' REPLACE INTO `ps_ebay_configuration` (`id_ebay_profile`, `name`, `value`) VALUES ('1', 'EBAY_ORDER_LAST_UPDATE', '2014-11-11T10:42:11.000Z') at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);630. }631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))632. {633. if ($sql)634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');635. throw new PrestaShopDatabaseException($this->getMsgError());636. }637. }638. 639. /** DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]319. if ($sql instanceof DbQuery)320. $sql = $sql->build();321. 322. $this->result = $this->_query($sql);323. if (_PS_DEBUG_SQL_)324. $this->displayError($sql);325. return $this->result;326. }327. 328. /**329. * Execute an INSERT query Argument [0]REPLACE INTO `ps_ebay_configuration` (`id_ebay_profile`, `name`, `value`) VALUES ('1', 'EBAY_ORDER_LAST_UPDATE', '2014-11-11T10:42:11.000Z') DbCore->query - [line 609 - classes/db/Db.php] - [1 Arguments]603. {604. if ($sql instanceof DbQuery)605. $sql = $sql->build();606. 607. $this->result = false;608. $result = $this->query($sql);609. if ($use_cache && $this->is_cache_enabled)610. Cache::getInstance()->deleteQuery($sql);611. if (_PS_DEBUG_SQL_)612. $this->displayError($sql);613. return $result; Argument [0]REPLACE INTO `ps_ebay_configuration` (`id_ebay_profile`, `name`, `value`) VALUES ('1', 'EBAY_ORDER_LAST_UPDATE', '2014-11-11T10:42:11.000Z') DbCore->q - [line 390 - classes/db/Db.php] - [2 Arguments]384. $keys_stringified = implode(', ', $keys);385. $values_stringified[] = '('.implode(', ', $values).')';386. }387. 388. $sql = $insert_keyword.' INTO `'.$table.'` ('.$keys_stringified.') VALUES '.implode(', ', $values_stringified);389. return (bool)$this->q($sql, $use_cache);390. }391. 392. /**393. * @param string $table Table name without prefix394. * @param array $data Data to insert as associative array. If $data is a list of arrays, multiple insert will be done Argument [0]REPLACE INTO `ps_ebay_configuration` (`id_ebay_profile`, `name`, `value`) VALUES ('1', 'EBAY_ORDER_LAST_UPDATE', '2014-11-11T10:42:11.000Z')Argument [1]1 DbCore->insert - [line 145 - modules/ebay/classes/EbayProfile.php] - [5 Arguments]139. 'value' => pSQL($value, $html)140. ); 141. 142. 143. if (version_compare(_PS_VERSION_, '1.5', '>'))144. $res = Db::getInstance()->insert('ebay_configuration', $data, false, true, Db::REPLACE);145. else146. {147. if ($this->hasConfiguration(pSQL($name)))148. $res = Db::getInstance()->autoExecute(_DB_PREFIX_.'ebay_configuration', array('value' => pSQL($value, $html)), 'UPDATE', '`id_ebay_profile` = '.(int)$this->id. ' AND `name` = \''.pSQL($name).'\'');149. else Argument [0]ebay_configurationArgument [1]Array( [id_ebay_profile] => 1 [name] => EBAY_ORDER_LAST_UPDATE [value] => 2014-11-11T10:42:11.000Z)Argument [2]Argument [3]1Argument [4]3 EbayProfile->setConfiguration - [line 626 - modules/ebay/ebay.php] - [2 Arguments]620. $current_date = date('Y-m-d\TH:i:s').'.000Z';621. 622. $orders = $this->_getEbayLastOrders($current_date);623. 624. // we set the new last update date after retrieving the last orders625. $this->ebay_profile->setConfiguration('EBAY_ORDER_LAST_UPDATE', $current_date);626. 627. if ($orders)628. $this->importOrders($orders);629. }630. Argument [0]EBAY_ORDER_LAST_UPDATEArgument [1]2014-11-11T10:42:11.000Z Ebay->hookHeader - [line 509 - classes/Hook.php] - [1 Arguments]503. 504. // Call hook method505. if ($hook_callable)506. $display = $moduleInstance->{'hook'.$hook_name}($hook_args);507. elseif ($hook_retro_callable)508. $display = $moduleInstance->{'hook'.$retro_hook_name}($hook_args);509. // Live edit510. 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')))511. {512. $live_edit = true;513. $output .= self::wrapLiveEdit($display, $moduleInstance, $array['id_hook']); Argument [0] HookCore::exec - [line 447 - classes/controller/FrontController.php] - [1 Arguments]441. if (!$this->useMobileTheme())442. {443. // These hooks aren't used for the mobile theme.444. // Needed hooks are called in the tpl files.445. $this->context->smarty->assign(array(446. 'HOOK_HEADER' => Hook::exec('displayHeader'),447. 'HOOK_TOP' => Hook::exec('displayTop'),448. 'HOOK_LEFT_COLUMN' => ($this->display_column_left ? Hook::exec('displayLeftColumn') : ''),449. 'HOOK_RIGHT_COLUMN' => ($this->display_column_right ? Hook::exec('displayRightColumn', array('cart' => $this->context->cart)) : ''),450. ));451. } Argument [0]displayHeader FrontControllerCore->initContent - [line 104 - controllers/front/CategoryController.php]98. }99. }100. 101. public function initContent()102. {103. parent::initContent();104. 105. $this->setTemplate(_PS_THEME_DIR_.'category.tpl');106. 107. if (!$this->customer_access)108. return; CategoryControllerCore->initContent - [line 180 - classes/controller/Controller.php]174. 175. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))176. $this->initHeader();177. 178. if ($this->viewAccess())179. $this->initContent();180. else181. $this->errors[] = Tools::displayError('Access denied.');182. 183. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className)))184. $this->initFooter(); ControllerCore->run - [line 373 - classes/Dispatcher.php]367. // Execute hook dispatcher368. if (isset($params_hook_action_dispatcher))369. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);370. 371. // Running controller372. $controller->run();373. }374. catch (PrestaShopException $e)375. {376. $e->displayMessage();377. } DispatcherCore->dispatch - [line 28 - index.php] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now