ilovekutchi.com Posted May 18, 2012 Share Posted May 18, 2012 Hello all. These last days I've been having serious problems wth my online shop since it frequently shows the "500 Internal server error" when I try to access any page on my website. I can see the frontoffice neither I can log in to the back office. It's an irregular issue since it is not always ocurring, for example now the site is working fine but few hours ago it wasn't. My site is hosted in one.com and, although I already had several issues with slow loading, now I'm really considering in changing host. A technician from one.com said the problem might be in the excessive number of modules, but I think I don't have that many modules. Many of the standard ones are not activated and I only have a few extra modules. However I must say that when I renamed the folder "modules" to "modules2" the website loaded (but of course the design was a big mess). The technician said that my site might often reache the limit of memory of my host server (68mb) so I should clean up some of the modules. Anyone with similar issues? Do you advise me to change host? Thanks Link to comment Share on other sites More sharing options...
Mike Kranzler Posted May 18, 2012 Share Posted May 18, 2012 Hi ilovekutchi, I would strongly recommend that you consider switching hosts. Personally, I prefer HostGator, but you can get a preferred rate for signing up through PrestaShop with any of the options listed at the bottom of the page here under "Choose a Hosting." -Mike Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted May 19, 2012 Author Share Posted May 19, 2012 I was considering the spanish host loading.es (my clients are mainly spanish) but it's not in your list. I see that HostGator is in US, maybe it's too far, but it offers "shared SSL". Does this work well with prestashop? Thanks Link to comment Share on other sites More sharing options...
helldog2004 Posted May 19, 2012 Share Posted May 19, 2012 I don't realy understand as I am using one.com aswell. But 68MB? is that even possible? I mean you get 5 gig for just 2 euro or something.. I have no problem at all using one.com and I do have a couple more of modules. Including 3 different websites on the same host.. Cheers Helldog! Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted May 19, 2012 Author Share Posted May 19, 2012 From what I could understand it's 68mb of something like RAM. I do have 5gb available, and I'm using 300mb of space. One of my modules might be asking too much from the server, I don't know... I'm afraid one.com is too cheap to be good for a complex site as prestashop. Extra modules I have (some might be standard, I don't rememeber): Facebook Like v1.1.2 PSS/Newsletter block subscribers v0.5 Menu v2.6.4 Pay on pickup v0.2 Featured Products on the homepage v0.9 Mail alerts v2.2 Customer Testimonials v1.3.2 (not anymore) Google Analytics v1.2 Link to comment Share on other sites More sharing options...
helldog2004 Posted May 19, 2012 Share Posted May 19, 2012 lots of them are standard: The modules I use extra are: - Bannermaker - easy menu - FAQ 1.4.3 - Homenewproducts - Idealcheckout for Prestashop 1.4 - News - Slidecaptcha - Asearch v1.2 - Footercustom v2.0 Cheers Helldog Link to comment Share on other sites More sharing options...
Mike Kranzler Posted May 21, 2012 Share Posted May 21, 2012 I was considering the spanish host loading.es (my clients are mainly spanish) but it's not in your list. I see that HostGator is in US, maybe it's too far, but it offers "shared SSL". Does this work well with prestashop? Thanks Hi ilovekutchi, You are welcome to use any hosting provider and it shouldn't have any effect on your customers, regardless of their location or language. I recommended HostGator because not only can you get a preferred rate for signing up through the link I posted above, but it also is very well set up to work with PrestaShop by default and their team is very knowledgeable about PrestaShop as a whole. -Mike Link to comment Share on other sites More sharing options...
VNguyen Posted May 21, 2012 Share Posted May 21, 2012 If you site is hosted at this path on your server: /home/aaaaa/public_html Then you can try to run following commands: chown -R aaaaa:aaaaa /home/aaaaa/public_html chmod -R 755 /home/aaaaa/public_html With "aaaaa" is the real value on your server. Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted May 31, 2012 Author Share Posted May 31, 2012 VNguyen, I don't understand for what that is for and how to do it. By the way, my website is down again at this moment (it was been frequently down these days). They at one.com said they already put my domain in one of their "high perfomance servers" with 80M of memory (!?) but it did not improve and they said to optimize/fix my website... I think the moment to change hosts is near... Link to comment Share on other sites More sharing options...
Mike Kranzler Posted May 31, 2012 Share Posted May 31, 2012 VNguyen, I don't understand for what that is for and how to do it. By the way, my website is down again at this moment (it was been frequently down these days). They at one.com said they already put my domain in one of their "high perfomance servers" with 80M of memory (!?) but it did not improve and they said to optimize/fix my website... I think the moment to change hosts is near... If you are continuing to have these sorts of issues, I would strongly suggest you consider switching hosts. Again, be sure to use the link I posted above to get the best rate from some of PrestaShop's preferred hosting providers! -Mike Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted May 31, 2012 Author Share Posted May 31, 2012 If you are continuing to have these sorts of issues, I would strongly suggest you consider switching hosts. Again, be sure to use the link I posted above to get the best rate from some of PrestaShop's preferred hosting providers! -Mike But I don't see a difference in prices if I use your link or go directly to hostgator.com Link to comment Share on other sites More sharing options...
Mike Kranzler Posted May 31, 2012 Share Posted May 31, 2012 But I don't see a difference in prices if I use your link or go directly to hostgator.com Strange, that normally isn't the case, but I'll look into it for you. However, you also do get preferred service by signing up through us. I personally recommend HostGator because their team knows PrestaShop better than most hosts in my experience, and by signing up using that link you'll be on the books as a PrestaShop user and they'll be able to give you assistance more efficiently. -Mike Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted May 31, 2012 Author Share Posted May 31, 2012 Hi ilovekutchi, You are welcome to use any hosting provider and it shouldn't have any effect on your customers, regardless of their location or language. I recommended HostGator because not only can you get a preferred rate for signing up through the link I posted above, but it also is very well set up to work with PrestaShop by default and their team is very knowledgeable about PrestaShop as a whole. -Mike My question about the spanish costumers was related to loading speed in Spain. I expect overseas transfer to be slower than by a host located in Spain. Or am I completely wrong?! Link to comment Share on other sites More sharing options...
Mike Kranzler Posted May 31, 2012 Share Posted May 31, 2012 My question about the spanish costumers was related to loading speed in Spain. I expect overseas transfer to be slower than by a host located in Spain. Or am I completely wrong?! If you're looking for the fastest load times in all languages, you may also want to look into CloudCache. I hope this helps. -Mike Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted June 2, 2012 Author Share Posted June 2, 2012 Help please (now about the topic of this post!) I got a specific answer from one.com technicians about the problems with the server. So: We checked your domain with our technicians and according to them, there was load on the database server yesterday but the domain was also having part in the cause for this. Lots of: UPDATE `ps_page_viewed` SET `counter` = `counter` 1 WHERE `id_date_range` = 688 AND `id_page` = 1102 queries to the database server causes slowness on your site. I'm not sure if this has been a series of DoS attacks, but they don't refer that. My belief is that the server is simply overloaded since we are getting more visits these months, but I must say it's only 100-500 visits/day... Do you have any clue on this? PS: I recently optimized the database tables with the moduleDelete connections/expired vouchers/carts and optimize all tables v1.6 , but this didn't solve the problem. Thanks. Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted June 12, 2012 Author Share Posted June 12, 2012 Help please (now about the topic of this post!) I got a specific answer from one.com technicians about the problems with the server. So: I'm not sure if this has been a series of DoS attacks, but they don't refer that. My belief is that the server is simply overloaded since we are getting more visits these months, but I must say it's only 100-500 visits/day... Do you have any clue on this? PS: I recently optimized the database tables with the moduleDelete connections/expired vouchers/carts and optimize all tables v1.6 , but this didn't solve the problem. Thanks. Any help on this? Thanks Link to comment Share on other sites More sharing options...
Mike Kranzler Posted June 12, 2012 Share Posted June 12, 2012 Any help on this? Thanks Unless you've done something to anger the internet hive mind, I wouldn't assume it's a DoS attack at all. It's likely just an issue of your server being overloaded and unable to handle the traffic. You may want to look into switching to one of PrestaShop's recommended hosting providers under "Choose a Host" at the bottom of the page here. -Mike Link to comment Share on other sites More sharing options...
El Patron Posted June 12, 2012 Share Posted June 12, 2012 If you are a Spain shop, and you decide to change, make sure you get a Spain IP address or that your URL is ccTLD i.e. yourdomain.es, else you will lose 'some unknown' ranking in your search organics. Link to comment Share on other sites More sharing options...
El Patron Posted June 12, 2012 Share Posted June 12, 2012 also, can you not look at your logs to see what the actual error(s) are. There is no guarantee that moving is going to fix your errors....if you get 500 errors on this server....you can pretty much be assured you are going to get them on any server. change your config/config.inc.php to display errors: @ini_set('display_errors', 'on'); Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted June 13, 2012 Author Share Posted June 13, 2012 Thank you, gracias. I already had the display errors on. No errors show up, the page just doesn't load when the server is not working. I might as well change to a spanish host (loading.es or cdmon), or else to hostgator. Haven't decided yet. @Mike: Can I clean up the following database tables, without compromising prestashop?: "*_guest" and "*_page_viewed". They are now very big and might be causing this issue on this weak server. Link to comment Share on other sites More sharing options...
Mike Kranzler Posted June 14, 2012 Share Posted June 14, 2012 Hi ilovekutchi.com, You can clear the ps_page_viewed table, but I wouldn't recommend clearing the ps_guest table. As always though, please make sure to back up your entire database first, just to be safe. I hope this helps. -Mike Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts