Back office slow with many ERRORS PS 1.6.0.11

[ScenaS]

Hallo everyone, from september my web site backoffice don't work well.

each page require over 40 sec to open and are incomplete

I read many solutions about "back office slow" but i can't apply to my website because i can't:

 

- uninstall module  (try but then http 500 error)

- disable or enable friendly url (...http 500 error)

- disable 3d part modules and override  (http 500 error)

- see order or client page (not valid Query sql .... MYSQL server has gone away)

and more.....

 

in file explorer my .htaccess file is empty

 

i read in some forums that problem can be open connection (many empty cart or abandoned shopping cart)

How can i clear them in DB??

 

i don't install any modules or updates from 3 months and i don't know where is the problem.

thank you

Luca

[rocky]

Have you tried editing config/defines.inc.php and changing the value of _PS_MODE_DEV_ from false to true to see what error message comes up? That should give us a hint.

[ScenaS]

 

Have you tried editing config/defines.inc.php and changing the value of _PS_MODE_DEV_ from false to true to see what error message comes up? That should give us a hint.

 

thank you for the answer.

Here debug result

  [PrestaShopDatabaseException]

MySQL server has gone away

 

UPDATE `pre7148_configuration` SET `value` = '1476797090',`date_upd` = '2016-10-18 15:24:50' WHERE `name` = 'IWFRAME_LAST_UPDATE_CHECK' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1

at line 639 in file classes/db/Db.php

 

634. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);635. 		}636. 		elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))637. 		{638. 			if ($sql)639. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');640. 			throw new PrestaShopDatabaseException($this->getMsgError());641. 		}642. 	}643. 644. 	/**

• DbCore->displayError - [line 333 - classes/db/Db.php] - [1 Arguments]

  328. 		if ($sql instanceof DbQuery)329. 			$sql = $sql->build();330. 331. 		$this->result = $this->_query($sql);332. 		if (_PS_DEBUG_SQL_)333. 			$this->displayError($sql);334. 		return $this->result;335. 	}336. 337. 	/**338. 	 * Execute an INSERT query

  Argument [0]UPDATE `pre7148_configuration` SET `value` = '1476797090',`date_upd` = '2016-10-18 15:24:50' WHERE `name` = 'IWFRAME_LAST_UPDATE_CHECK' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1

• DbCore->query - [line 613 - classes/db/Db.php] - [1 Arguments]

  608. 	{609. 		if ($sql instanceof DbQuery)610. 			$sql = $sql->build();611. 612. 		$this->result = false;613. 		$result = $this->query($sql);614. 		if ($use_cache && $this->is_cache_enabled)615. 			Cache::getInstance()->deleteQuery($sql);616. 		if (_PS_DEBUG_SQL_)617. 			$this->displayError($sql);618. 		return $result;

  Argument [0]UPDATE `pre7148_configuration` SET `value` = '1476797090',`date_upd` = '2016-10-18 15:24:50' WHERE `name` = 'IWFRAME_LAST_UPDATE_CHECK' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1

• DbCore->q - [line 435 - classes/db/Db.php] - [2 Arguments]

  430. 		$sql = rtrim($sql, ',');431. 		if ($where)432. 			$sql .= ' WHERE '.$where;433. 		if ($limit)434. 			$sql .= ' LIMIT '.(int)$limit;435. 		return (bool)$this->q($sql, $use_cache);436. 	}437. 438. 	/**439. 	 * Execute a DELETE query440. 	 *

  Argument [0]UPDATE `pre7148_configuration` SET `value` = '1476797090',`date_upd` = '2016-10-18 15:24:50' WHERE `name` = 'IWFRAME_LAST_UPDATE_CHECK' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0) LIMIT 1Argument [1]1

• DbCore->update - [line 362 - classes/Configuration.php] - [5 Arguments]

  357. 				{358. 					// Update config not linked to lang359. 					$result &= Db::getInstance()->update(self::$definition['table'], array(360. 						'value' => pSQL($value, $html),361. 						'date_upd' => date('Y-m-d H:i:s'),362. 					), '`name` = \''.pSQL($key).'\''.Configuration::sqlRestriction($id_shop_group, $id_shop), 1, true);363. 				}364. 				else365. 				{366. 					// Update multi lang367. 					$sql = 'UPDATE `'._DB_PREFIX_.bqSQL(self::$definition['table']).'_lang` cl

  Argument [0]configurationArgument [1]Array(    [value] => 1476797090    [date_upd] => 2016-10-18 15:24:50)Argument [2]`name` = 'IWFRAME_LAST_UPDATE_CHECK' AND (id_shop_group IS NULL OR id_shop_group = 0) AND (id_shop IS NULL OR id_shop = 0)Argument [3]1Argument [4]1

• ConfigurationCore::updateValue - [line 1248 - modules/inixframe/InixModule.php] - [2 Arguments]

  1243. 			}1244. 			$own_modules = $this->getOurModules();1245. 			$response    = $this->client->checkUpdate( $own_modules );1246. 1247. 			if($response === false){1248. 				Configuration::updateValue( 'IWFRAME_LAST_UPDATE_CHECK', time() );1249. 				$this->errors[] = $this->l('Unable to connect to the update service');1250. 			} elseif ( $this->client->getStatus() == 'ok' ) {1251. 				Configuration::updateValue( 'IWFRAME_LAST_UPDATE_CHECK', time() );1252. 				Configuration::updateValue( 'IWFRAME_REMOTE_DATA', json_encode( $response ) );1253. 

  Argument [0]IWFRAME_LAST_UPDATE_CHECKArgument [1]1476797090

• Inix2Module->updateCheck - [line 118 - modules/inixframe/inixframe.php]

  113. 114. 115. 116. 	public function hookDisplayBackOfficeHeader() {117. 		if($this->shouldCheckForUpdate())118. 			$this->updateCheck();119. 120. 	}121. 122. 	public function displayAjaxFetch() {123. 		$this->json = true;

• inixframe->hookDisplayBackOfficeHeader - [line 510 - classes/Hook.php] - [1 Arguments]

  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 method509. 				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 edit514. 				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]

• HookCore::exec - [line 2438 - classes/controller/AdminController.php] - [2 Arguments]

  2433. 			'host_mode' => defined('_PS_HOST_MODE_') ? 1 : 0,2434. 			'stock_management' => (int)Configuration::get('PS_STOCK_MANAGEMENT')2435. 		));2436. 2437. 		if ($this->display_header)2438. 			$this->context->smarty->assign('displayBackOfficeHeader', Hook::exec('displayBackOfficeHeader', array()));2439. 2440. 		$this->context->smarty->assign(array(2441. 			'displayBackOfficeTop' => Hook::exec('displayBackOfficeTop', array()),2442. 			'submit_form_ajax' => (int)Tools::getValue('submitFormAjax')2443. 		));

  Argument [0]displayBackOfficeHeaderArgument [1]Array()

• AdminControllerCore->init - [line 163 - classes/controller/Controller.php]

  158. 	/**159. 	 * Start controller process (this method shouldn't be overriden !)160. 	 */161. 	public function run()162. 	{163. 		$this->init();164. 		if ($this->checkAccess())165. 		{166. 			// setMedia MUST be called before postProcess167. 			if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))168. 				$this->setMedia();

• ControllerCore->run - [line 374 - classes/Dispatcher.php]

  369. 			// Execute hook dispatcher370. 			if (isset($params_hook_action_dispatcher))371. 				Hook::exec('actionDispatcher', $params_hook_action_dispatcher);372. 373. 			// Running controller374. 			$controller->run();375. 		}376. 		catch (PrestaShopException $e)377. 		{378. 			$e->displayMessage();379. 		}

• DispatcherCore->dispatch - [line 54 - admin/index.php]

[rocky]

Now you know it's the inixframe module that's causing the problem. Try renaming modules/inixframe to something like modules/inixframe_disabled and see if that fixes the problem.

[ScenaS]

oh.... you are a genius!! now work very well!

But now inixframe module is disable.... What i need to do??? i reinstall it? its important?

thank you very much

[ScenaS]

ops... after some minutes PS create again folder /modules/inixframe and problem appears again..... how i can fix???

[rocky]

Sorry, I'm not familiar with that module. It's not part of PrestaShop's core. You should contact the author of the module.

[ScenaS]

Module Name "Presta APPS Dashboard". its a secondary module of COD FEE by Presta Apps

i remove both modules (deleted folders under /modules/ and from db table prefix_module and prefix_module_shop)

Now work well!

SOLVED