guitarplayer Posted December 31, 2008 Share Posted December 31, 2008 Hello everyone,I recently started building a new site using Prestashop under a new site folder directory while in construction, but yesterday I had the "500 Internal Server Error" appear and it also appears on my current site, one which I haven't edited in a few days which was built with a different e-commerce solution ?If anyone can help it would be much appreciated.I have access to the sever log files, if this can be of help?Below is a response I got from my hosting company,"This suggests a scripting error where connections are being left open too long and subsequent connections time out.Pleae check your scripting to make sure you are not doing anything during the query.There are no faults with the web server or database server. Had there been an issue we would be able to replicate this issue and would have thousands of calls about that server. I have tested both servers and they work fine."Best regards,JH. Link to comment Share on other sites More sharing options...
TropischBruin Posted December 31, 2008 Share Posted December 31, 2008 This error means that one of the scripts used on that server is causing a problem.The reason could be that there is something wrong with the server as you say that multiple sites using differend scripts are having this problem.Have a look at your server-error logs and check the time that error occured, maybe it will show what is the problem. Link to comment Share on other sites More sharing options...
guitarplayer Posted December 31, 2008 Author Share Posted December 31, 2008 Thanks for the response, one of the errors which occurs on the list 100's of times is the last product I added. It states the error below ;heyjoemusique.com: [31/Dec/2008:13:46:37 +0000] 213.171.218.173 - - "GET /prestashop/product.php?id_product=40 HTTP/1.0" 500 535 "-" "-"but I don't understand it! I have already deleted this product from the database to see if that would fix it, but it hasn't.Any thoughts? Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2008 Share Posted December 31, 2008 Check with your host if they did not re-compile apache recently... Link to comment Share on other sites More sharing options...
guitarplayer Posted December 31, 2008 Author Share Posted December 31, 2008 thanks for the help,I have just e-mailed them so should have a reply soon.The last thing I remember doing before I got the 500 error was turning on the RSS Feeds modules, could this of caused anything? Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2008 Share Posted December 31, 2008 NO, 500 error is a internal server error... Link to comment Share on other sites More sharing options...
guitarplayer Posted December 31, 2008 Author Share Posted December 31, 2008 Hi TakeDat,What do you think it could be? I haven't really modified any files.Could it be old Google Analytics scripts from my current e-commerce store/site (which will be changed for the site i'm building soon) affecting the database? Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2008 Share Posted December 31, 2008 As I started, its a server side issue and only your host can fix it... Link to comment Share on other sites More sharing options...
guitarplayer Posted January 2, 2009 Author Share Posted January 2, 2009 Ok, below is the reply I got from my hoster, after asking if Apache had been re-complied recently ;"The server settings have not been changed. I have checked the URLs and I am receiving an Internal Server Error which generally indicates an issue with the script or .htaccess files. Whilst we can't offer scripting support, I can check the error logs (located in the logfiles folder) if you can provide your FTP password." Link to comment Share on other sites More sharing options...
Guest Posted January 2, 2009 Share Posted January 2, 2009 So, did you check logs or ask your host to check it for you? Link to comment Share on other sites More sharing options...
guitarplayer Posted January 2, 2009 Author Share Posted January 2, 2009 Hi Takedat,I have just asked and waiting for a reply.The strange thing though is if it is a scripting error how come it effects all my subdirectories that have different mysql databases (like my 3 testing e-commerce sites)? Link to comment Share on other sites More sharing options...
Guest Posted January 2, 2009 Share Posted January 2, 2009 Hi Takedat,I have just asked and waiting for a reply.The strange thing though is if it is a scripting error how come it effects all my subdirectories that have different mysql databases (like my 3 testing e-commerce sites)? Whithout logs details can't tell about it, but feel free to get a free test drive with us... PS.: Instant activation and do not require domain name, we can provide you a free sub-dom... Link to comment Share on other sites More sharing options...
spott Posted January 2, 2009 Share Posted January 2, 2009 Delete .htaccess files.You can get even these errors, when You have wrong/old/ .htaccess file in main directory and some script is in subdirectory. Once I uploaded one script with .htaccess directly to my server /home/username folder, not to the /home/username/htdocs (webserver folder) and I get everywhere these strange errors. Link to comment Share on other sites More sharing options...
guitarplayer Posted January 2, 2009 Author Share Posted January 2, 2009 Hi Spott,just tried it, but it didn't have any effect, thanks anyway. Link to comment Share on other sites More sharing options...
Paul C Posted January 2, 2009 Share Posted January 2, 2009 I would support the theory that you have a .htaccess file somewhere that's causing the error, most likely in the site root directory of your server. 500 is a catch-all and indicates a misconfiguration; if the apache you're using is a shared one (with virtual sites or some such config) then every site would experience the problem. Have you also made any changes to your php config (editing a php.ini file)? Can you view plain html files or images on your server, or do you get this error regardless of the files you're accessing?Paul Link to comment Share on other sites More sharing options...
guitarplayer Posted January 2, 2009 Author Share Posted January 2, 2009 Hi Paul,I can still view .html files like this www.heyjoemusique.com/index.html which was uploaded just to tell customers we are updating the site, but as soon as we try to go on a part of the site which requires a mysql database we get the 500? Should I do a search and delete all of the .htaccess files from the server? do we even need the .htaccess files? I have tried this a few hours ago and it did nothing. Link to comment Share on other sites More sharing options...
Paul C Posted January 2, 2009 Share Posted January 2, 2009 Hmm if that's the case then i'm not sure that the problem lies with a .htaccess issue, but unless you're using the friendly urls functionality on your sites, then it's safe to rename any you find to .htaccess.disabled and that will eliminate them from the equation.If it's php files that are causing the problem, then I suspect that your php configuration is messed up, but it could be mysql; haven't seen a 500 error from a mysql problem but it's possible.try creating a file containing: <?php phpinfo(); ?> save it as php_info.php in your site root and then try and open it with your browser. It should give you lots of details on your php configuration. If there's a problem with the php config then this too will give a 500 error....Paul Link to comment Share on other sites More sharing options...
guitarplayer Posted January 2, 2009 Author Share Posted January 2, 2009 Hi Paul,This too gives the 500 error http://www.heyjoemusique.com/php_info.phpDo you think any of the files located here could be the cause ? http://www.heyjoemusique.com/prestashop/config/Thanks Link to comment Share on other sites More sharing options...
Paul C Posted January 2, 2009 Share Posted January 2, 2009 Not if multiple sites on your server are affected and that very simple script fails. The problem isn't related to PrestaShop but the way you have your server configured.Are there any php.ini files in your account? Have these been added/changed? Have you searched for the .htaccess files and renamed them? Note that some FTP servers are configured to hide files that are pre-fixed with a dot (they're regarded as system files). If your FTP client supports it, then look for the option to display such hidden files (in FileZilla it's a menu option Server->Force showing hidden files).Paul Link to comment Share on other sites More sharing options...
guitarplayer Posted January 2, 2009 Author Share Posted January 2, 2009 Hi Paul,My hoster has now stated the below message ;"There is a known resource issue with mysql4 which is causing intermittent connectivity problems. We are looking to resolve this as soon as possible and I apologise for the inconvience."So maybe it is not the files, I will report back with more info when I get it.Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts