Link to home
Start Free TrialLog in
Avatar of Colebert
Colebert

asked on

Internal Server errors in Cre Loaded 6, SP13.1 after upgrading to PHP 5 & installing SSL

I have been running a CRE Loaded shopping cart since January, and everything was functioning until about a month ago when at around the same time my host upgraded to PHP5 and also installed an SSL certificate for me.

Now, I get sporadic internal server errors when accessing the site.  Sometimes it will load perfectly, other times I won't be able to access any pages within the shopping site.  It can happen on any page, whether in the shop or in the admin panel.  It has been getting much worse within the past 5 days.

The details:
URL:  www.lbvgallery.com/shop/
HOST: Network Solutions
CART: CRE Loaded 6.2 Standard, SP 13.1
MODS: Chemo's SEO URLs, dynamic Sitemap, gzip compression, GiftWrap
Server OS: Linux 2.6.22.10-NETSOL           
Database: MySQL 5.0.45
HTTP Server: Apache/2.2.8 (Unix) FrontPage/5.0.2.2635
PHP Version: 5.2.5-dev (Zend: 2.2.0)

When I look at my error logs, I see a lot of these "Premature end of script headers: index.php" with varying file names.

I really don't know how to proceed to diagnose this problem.  If someone could help me walk through the process I'd be eternally grateful!

Also, I'm not sure if this is related but my site is recognizing only three distinct IPS in AWStats and my CRE Loaded admin panel (the Who's Online function), despite having had around 600 unique visitors.  This also started when the SSL certificate was installed by Network Solutions.
SOLUTION
Avatar of Matthew Kelly
Matthew Kelly
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Colebert
Colebert

ASKER

Thanks for your reply!

After a few more days working on this:

-fiddling with permissions on the various related PHP files has done nothing
-Network Solutions claims no problems, and says that it is a problem with my site's programming not something that's their fault
-turning php error flags on didn't give me any errors
-I only seem to be able to get errors on our very slow work connection, not at home.

I did realize that Network Solutions upgraded mySQL recently, and now mySQLi is not available.  I need to look into this more.

As far as programatically common files, there are a lot.  Many, many files create the web that is a single page.
Actually, they didn't upgrade mySQL, they just didn't install the MySQLi extension.  I suspect this might be the root of the problem...
Anyone?
SOLUTION
Avatar of Bernard Savonet
Bernard Savonet
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If it was a hacking attempt wouldn't the errors come in bursts, or maybe the admin panel would be targeted? I haven't seen any errors show up in the log files from the admin panel (which is strange because I have generated errors while working in there lots of times!)

Here's a chunk of yesterday's log file:

[Tue Jun 24 06:20:53 2008][error] [client 205.178.182.174] Premature end of script headers: index.php
[Tue Jun 24 08:23:08 2008][error] [client 205.178.182.175] Premature end of script headers: rss.php
[Tue Jun 24 08:50:07 2008][error] [client 205.178.182.175] Premature end of script headers: rss.php
[Tue Jun 24 11:56:51 2008][error] [client 205.178.182.175] File does not exist: /htdocs/pages
[Tue Jun 24 12:50:17 2008][error] [client 205.178.182.175] Premature end of script headers: product_info.php
[Tue Jun 24 13:53:53 2008][error] [client 205.178.182.175] Premature end of script headers: product_info.php
[Tue Jun 24 14:14:38 2008][error] [client 205.178.182.174] Premature end of script headers: index.php, referer: http://www.lbvgallery.com/shop/index.php?manufacturers_id=13
[Tue Jun 24 15:34:39 2008][error] [client 205.178.182.174] File does not exist: /htdocs/labella_about.htm
[Tue Jun 24 15:42:36 2008][error] [client 205.178.182.174] File does not exist: /htdocs/musing.htm
[Tue Jun 24 16:19:31 2008][error] [client 205.178.182.174] Premature end of script headers: index.php, referer: http://www.lbvgallery.com/jewelry.htm
[Tue Jun 24 16:24:45 2008][error] [client 205.178.182.174] Premature end of script headers: index.php, referer: http://www.lbvgallery.com/
[Tue Jun 24 16:23:19 2008][error] [client 205.178.182.174] File does not exist: /htdocs/contactlbv.htm
[Tue Jun 24 16:32:23 2008][error] [client 205.178.182.175] Premature end of script headers: rss.php
[Tue Jun 24 16:36:09 2008][error] [client 205.178.182.175] Premature end of script headers: index.php
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I do believe MySQLi is necessary.  I've talked to my host several times about why they used to have it installed and now don't... their answer was that this extension is not available with PHP 5.
They're temporarily reverting me to PHP 4 & MySQL 4.  Unfortunately they're only supporting PHP 4 until the end of the month, which buys me a little more time to try to figure out what's going on.  However, I'm starting to think they have no clue what they're doing (not that I'm exactly an expert) since a simple google search shows that MySQLi is not PHP4 specific...

I've been combing the forums for both CRE Loaded and OS Commerce, and people seem to have their sites working fine with PHP 5 & MySQL 5!  Of course, there are some people with random isolated problems but a lot of people aren't having issues.

I think my next course of action (after they've reverted me) is to comb through the modifications I've made to see if I've screwed up code anywhere?  Otherwise, I'm going to chalk up these random errors to my host screwing with server configurations.  I really don't want to reinstall the whole cart, since I've put so much time into modifications!
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial