LBPC Posted October 14, 2014 Share Posted October 14, 2014 Hi all Desperately need your help. I've has lots of problems with my site not working with 1&1 (very slow, pages not loading fully, server time outs..) So I upgraded to another contract with them and its been working fine for about a month. Now the same problems are back. Can you guys pls have a look and tell me if the site is working at your end? It's the default theme. Is the home page image to the right, with the coloumn to the left? Can you add products to the basket? Is the basket showing "delivery: 3.90€" once it has a product? Error messages? http://tinyurl.com/o6ap6b8PrestaShop™ 1.6.0.9 From the BO - it loads quickly, I can see all my orders, but can't get into any of them. Nothing was changed since last nite and this morning. Nothing in the logs. Thankyou so much, I need to find out if the problem is a 1&1 server issue again or on the prestashop side. Link to comment Share on other sites More sharing options...
tuk66 Posted October 14, 2014 Share Posted October 14, 2014 I would use CCC (Combine, Compress and Cache) a CDN for images. The home page has 30 external Javascript scripts, 27 external stylesheets, a total of 95 components and a total weight of 2340.2K bytes. It is huge load for every shared hosting. 1 Link to comment Share on other sites More sharing options...
LBPC Posted October 14, 2014 Author Share Posted October 14, 2014 Hi, thaks for your reply. I turned on all the CCC options, hasn't helped unfortunately. Would that affect BO commandes anyway? It all worked fine last night... There is only about 60 images on the site, is a CDN necessary? So you believe the problem is at the prestashop side, not a server issue? Thanks for your help! Link to comment Share on other sites More sharing options...
tuk66 Posted October 14, 2014 Share Posted October 14, 2014 Your site is fast now. Forget CDN. Link to comment Share on other sites More sharing options...
El Patron Posted October 14, 2014 Share Posted October 14, 2014 On 10/14/2014 at 11:38 AM, LBPC said: Hi, thaks for your reply. I turned on all the CCC options, hasn't helped unfortunately. Would that affect BO commandes anyway? It all worked fine last night... There is only about 60 images on the site, is a CDN necessary? So you believe the problem is at the prestashop side, not a server issue? Thanks for your help! CCC did help. you are loading java bottom. when you have performance issues, clicking away at front office only offers a little info, i.e. ccc or not, java top or bottom... if you want to find slow area of page render then use PrestaShop debug profiling. config/defines.inc.php set this to true, collect information and set back to false ASAP as all visitors front and back will see this reporting. define('_PS_DEBUG_PROFILING_', false); 1 Link to comment Share on other sites More sharing options...
LBPC Posted October 14, 2014 Author Share Posted October 14, 2014 Yep, it loads a bit faster, but I'm still having the same problems, and now all images on the prodct pages don't apear. Link to comment Share on other sites More sharing options...
LBPC Posted October 14, 2014 Author Share Posted October 14, 2014 ok, i got this: Warning: DOMDocument::loadXML(): Empty string supplied as input in /homepages/27/d475612626/htdocs/modules/envoimoinscher/Env/WebService.php on line 436 Warning: DOMDocument::loadXML(): Empty string supplied as input in /homepages/27/d475612626/htdocs/modules/envoimoinscher/Env/WebService.php on line 436 Warning: DOMDocument::loadXML(): Empty string supplied as input in /homepages/27/d475612626/htdocs/modules/envoimoinscher/Env/WebService.php on line 436 Warning: DOMDocument::loadXML(): Empty string supplied as input in /homepages/27/d475612626/htdocs/modules/envoimoinscher/Env/WebService.php on line 436 Warning: DOMDocument::loadXML(): Empty string supplied as input in /homepages/27/d475612626/htdocs/modules/envoimoinscher/Env/WebService.php on line 436 Warning: PDO::query(): MySQL server has gone away in /homepages/27/d475612626/htdocs/classes/db/DbPDO.php on line 91 Warning: PDO::query(): Error reading result set's header in /homepages/27/d475612626/htdocs/classes/db/DbPDO.php on line 91 [PrestaShopDatabaseException] MySQL server has gone away SELECT * FROM `ps2_carrier` a LEFT JOIN `ps2_carrier_shop` `c` ON a.id_carrier = c.id_carrier AND c.id_shop = 1 WHERE (a.id_carrier = 119) LIMIT 1 at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, ' '.$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 547 - classes/db/Db.php] - [1 Arguments]DbCore->getRow - [line 217 - classes/ObjectModel.php] - [1 Arguments]ObjectModelCore->__construct - [line 167 - classes/Carrier.php] - [2 Arguments]CarrierCore->__construct - [line 558 - classes/Carrier.php] - [1 Arguments]CarrierCore::getCarriersForOrder - [line 1228 - classes/Carrier.php] - [3 Arguments]CarrierCore::getAvailableCarrierList - [line 1728 - classes/Cart.php] - [5 Arguments]CartCore->getPackageList - [line 1926 - classes/Cart.php]CartCore->getDeliveryOptionList - [line 2397 - classes/Cart.php] - [1 Arguments]CartCore->getDeliveryOption - [line 2465 - classes/Cart.php] - [3 Arguments]CartCore->getTotalShippingCost - [line 1361 - classes/Cart.php] - [2 Arguments]CartCore->getOrderTotal - [line 68 - modules/blockcart/blockcart.php] - [2 Arguments]BlockCart->assignContentVars - [line 185 - modules/blockcart/blockcart.php] - [1 Arguments]BlockCart->hookRightColumn - [line 235 - modules/blockcart/blockcart.php] - [1 Arguments]BlockCart->hookTop - [line 509 - classes/Hook.php] - [1 Arguments]HookCore::exec - [line 448 - classes/controller/FrontController.php] - [1 Arguments]FrontControllerCore->initContent - [line 37 - controllers/front/IndexController.php]IndexControllerCore->initContent - [line 180 - classes/controller/Controller.php]ControllerCore->run - [line 373 - classes/Dispatcher.php]DispatcherCore->dispatch - [line 28 - index.php] So it's the module envoimoinscher? Thanks for your help! Link to comment Share on other sites More sharing options...
El Patron Posted October 14, 2014 Share Posted October 14, 2014 MySQL server has gone away sort of says it all yes? I'd recontact my hosting with this piece of information. as for envoimoinscher, those are php warnings, that does not stop the script, i.e. compared to (error) which does, so if you do not see issue of this module not working properly it probably is nothing to worry about. Link to comment Share on other sites More sharing options...
LBPC Posted October 14, 2014 Author Share Posted October 14, 2014 On 10/14/2014 at 12:04 PM, El Patron said: MySQL server has gone away sort of says it all yes? I'd recontact my hosting with this piece of information. as for envoimoinscher, those are php warnings, that does not stop the script, i.e. compared to (error) which does, so if you do not see issue of this module not working properly it probably is nothing to worry about. Thankyou!!! 1&1 have blamed google, IE, my laptop, my iphone and my internet connection, now I've got 'em! Link to comment Share on other sites More sharing options...
El Patron Posted October 14, 2014 Share Posted October 14, 2014 On 10/14/2014 at 12:06 PM, LBPC said: Thankyou!!! 1&1 have blamed google, IE, my laptop, my iphone and my internet connection, now I've got 'em! getting proper debug will help, if you tell hosting or community you have issue, without facts, well we going to play the blame game..jajajaja now you have new tools that will allow you to provide better information. happy day, el 1 Link to comment Share on other sites More sharing options...
LBPC Posted October 14, 2014 Author Share Posted October 14, 2014 On 10/14/2014 at 12:09 PM, El Patron said: getting proper debug will help, if you tell hosting or community you have issue, without facts, well we going to play the blame game..jajajaja now you have new tools that will allow you to provide better information. happy day, el Thanks, I used your guide to turn it on too Link to comment Share on other sites More sharing options...
El Patron Posted October 14, 2014 Share Posted October 14, 2014 tip: ALWAYS turn off debug and debug profiling when completed testing. forgetting to do so can lead to unpredictable results. please let us know how you get this sorted out. Link to comment Share on other sites More sharing options...
bellini13 Posted October 14, 2014 Share Posted October 14, 2014 they will tell you that you have long running sql statements, and that too many database connections are being used, and ultimately put the blame back on you and the Prestashop software Link to comment Share on other sites More sharing options...
LBPC Posted October 14, 2014 Author Share Posted October 14, 2014 On 10/14/2014 at 12:50 PM, bellini13 said: they will tell you that you have long running sql statements, and that too many database connections are being used, and ultimately put the blame back on you and the Prestashop software O-kaaay.... you sound like you're speaking from experience. Did you have the same issue? How did you fix it? I went with 1&1 because the prestashop documentation listed them as a recommended hoster! Thanks. Link to comment Share on other sites More sharing options...
El Patron Posted October 14, 2014 Share Posted October 14, 2014 On 10/14/2014 at 1:25 PM, LBPC said: O-kaaay.... you sound like you're speaking from experience. Did you have the same issue? How did you fix it? I went with 1&1 because the prestashop documentation listed them as a recommended hoster! Thanks. we don't really know what they will tell you, so we can all sit around and braid each others hair until the next full moon. yes? 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