Back Office Problems

[websitebuilder]

Hello,

 

I started to have some issues today with my back office of Prestashop V1.6.0.8 using 1and1 as my hosting provider. It started by getting slower and slower, although the front site remained the same speed as it did before. 

 

Throughout the course of the day it has gotten so slow that now I wait over a minute for a page to load. I have disabled the non essential prestashop modules and the back office resumes its normal speed but the modules tab is really slow. Also, when I turn off all the none essential modules and go back to the modules tab it shows all the modules as not installed when they are.

 

Again, the front end appears to be working perfectly.

 

I really need some help on this as not sure whats gone wrong. Please can someone give me some quotes and timeframe for this?

 

Thanks

Chris

[PrestaHeroes USA]

you might be interested in this:

http://www.prestashop.com/forums/topic/329251-module-bozoom-prestashop-back-office-performance-for-15-16/

 

note: if there is some technical reason for slow bo, module may not help, but when you solve any technical issue, zoom zoom

 

good luck!

[websitebuilder]

I downloaded this ready to install after I the back office started to run so slow but now because I am having issues with the module tab in the back office it won't let me do that. I think there is a technical issue with the site.

 

I can't believe it, I have spent 4 months learning Prestashop and was about to launch in the next 2 weeks and now this has happened. Just hope I haven't lost everything.

[PrestaHeroes USA]

what is your exact ps version?

 

I will try to help for free while you await bid for help.

 

in config/defines.inc.php turn on debug profiling (set to true), then visit the slow page.  (turn off after capturing the stats (bottom of page)) as all visitor will generate stats.

define('_PS_DEBUG_PROFILING_', false);

this will give you valuable info timings

[websitebuilder]

I don't seem to get anything with reference to timings. Just the below and to be honest, the contents of this seems to change depending on what page I click on in the back office:

[PrestaShopDatabaseException]

MySQL server has gone away
 

		SELECT *		FROM `ps_quick_access` qa		LEFT JOIN `ps_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = 3)		ORDER BY `name` ASC

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]
• DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 65 - classes/QuickAccess.php] - [1 Arguments]
• QuickAccessCore::getQuickAccesses - [line 1529 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->initHeader - [line 177 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

[websitebuilder]

El Patron, can you recommend anyone who is a Prestanerd to look at this for me? I am reluctant to give just anyone access as I originally paid a company to build this for me and they totally messed me around so I am now a little cautious of who I allow access to the site

[PrestaHeroes USA]

well...seems everyone that replies to work here is ok, we don't hear any complaints...

 

we prefer that whomever replies only has 25% of total posts in job offers, which is nice...

 

if you want to reach out, I genrally recommend bellini13, here.  

[websitebuilder]

OMG, I think i have fixed it. Thanks for your help El Patron, really appreciate it.

[PrestaHeroes USA]

OMG, I think i have fixed it. Thanks for your help El Patron, really appreciate it.

 

what was it?  

[websitebuilder]

I did really know how but for some reason the modules tab didn't always load as it should, sometimes it would say a module isn't installed when it was. I refreshed the page a few times and managed to get the modules to load properly stating installed. I then started to delete the more recent modules and found it was a corrupt module in the end as now its working fine. 

[vekia]

what module generated these troubles for you? can you share module name, please?

[websitebuilder]

Im not sure that would be fair to the developer Vekia as I haven't given them chance to repair it yet. I can say it wasn't on the Prestashop website and that it was a module that allowed the admin to upload a file to the customers order in the back office that the customer could see in their my account section. 

 

Its a shame the module doesn't work as this was a key function for our website.

[FrenchMaster]

 

I don't seem to get anything with reference to timings. Just the below and to be honest, the contents of this seems to change depending on what page I click on in the back office:

[PrestaShopDatabaseException]

MySQL server has gone away

 

		SELECT *		FROM `ps_quick_access` qa		LEFT JOIN `ps_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = 3)		ORDER BY `name` ASC

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]
• DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 65 - classes/QuickAccess.php] - [1 Arguments]
• QuickAccessCore::getQuickAccesses - [line 1529 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->initHeader - [line 177 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

 

 

I have exactly the same message. It happens when I try to access to the stats... 

For me the stats don't work at all ! I cannot select month, day etc,,, it always shows the same month (the last one) 

 

Can you help ?