Jump to content

PrestaShopDatabaseException


grafixweb
 Share

Recommended Posts

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]

post-797023-0-86937600-1415699164_thumb.jpg

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More