Solved

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

Posted on 2008-06-17
9
525 Views
Last Modified: 2013-11-18
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.
0
Comment
Question by:Colebert
  • 6
  • 2
9 Comments
 
LVL 18

Assisted Solution

by:Matthew Kelly
Matthew Kelly earned 200 total points
ID: 21810055
First, off, that sucks. From what I have read briefly:

http://htmlfixit.com/cgi-tutes/tutorial_Common_Web_dev_error_messages_and_what_they_mean.php#premature
http://httpd.apache.org/docs/1.3/misc/FAQ-F.html#premature-script-headers

You might want to check with your hosting provider to make sure they are not having other issues. Another possibility is the server is slow and non-responsive at times causing the script to be cut off...

Is there anything programatically common among the script files (such as they are all CRE pages etc)?

If it is happening in the admin panel is it something your hosting provider can see and look at (as most likely the admin panel is controlled by them?)

Can you revert back to PHP4 and no SSL to see if the problem is resolved?
0
 

Author Comment

by:Colebert
ID: 21838620
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.
0
 

Author Comment

by:Colebert
ID: 21838798
Actually, they didn't upgrade mySQL, they just didn't install the MySQLi extension.  I suspect this might be the root of the problem...
0
 

Author Comment

by:Colebert
ID: 21862146
Anyone?
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 29

Assisted Solution

by:fibo
fibo earned 300 total points
ID: 21864624
1 - If they have just added MySQLI without making any change to php, there are "no reason" why your programs might fail suddenly. You might however check with Network Solutions if they have some log information about your transactions.

2 - However, you mention that the logs complain about some script.
<<I see a lot of these "Premature end of script headers: index.php" with varying file names.>>
Could you paste some of these lines here? I would think that there are something like 20% chances that your site is a target for hack attempts, one side result of which will be the saturation of either your site or network solutions'
0
 

Author Comment

by:Colebert
ID: 21871704
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
0
 
LVL 29

Assisted Solution

by:fibo
fibo earned 300 total points
ID: 21872579
OK.
1 - IS MySQLi needed fro CRE-loaded? Since they removed it that might be a hint. I presume most of the other database uses are with MySQL and these should not be affected.

2 - Lines like "File does not exist: /htdocs/musing.htm" are puzzling.
Certainly page /musing.htm does exist, and finding its associated file in htdocs directory seems normal.
But the messages about headers do not mention htdocs.
Is that normal? Visting your site triggered no error message in my browser (but maybe in your logs).

3 - Wandering thru the forums.
-- the basic message and its cause is explained in http://httpd.apache.org/docs/1.3/misc/FAQ-F.html although this is not totally helpful; from what you said, you know that in some occasions some scripts (presumably Perl ones) are taking too long.
-- something more relevant might be found in http://forum.siteground.com/showthread.php?t=2099 where a cre-loaded user has a problem similar to yours and traces it back to his new theme. Did you change theme recently?
-- a fascinating thread is at http://forums.creloaded.com/Forums/viewtopic/t=14900/ with lots of possible tracks... but in the end the theme seems to be the critical problem, even if in their case the problem was triggered by google's robots [triggered an invisible problem, not 'created']
0
 

Author Comment

by:Colebert
ID: 21913005
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!
0
 

Accepted Solution

by:
Colebert earned 0 total points
ID: 21922601
I solved it, by downgrading my database to MySQL 4 (but ended up staying with PHP 5).  At the same time I also enabled persistent connections in the configuration file, which apparently I hadn't done before.

MySQLi is not enabled but so far I have gotten no errors in my log files!  Plus, the site appears to be working faster.

Thanks for your help guys, next time I will post a more specific question!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
If your site has a few sections that need to be secure when data is transmitted between the server and local computer, such as a /order/ section for ordering or /customer/ which contains customer data, etc it would of course be recommended to secure…
The viewer will learn how to dynamically set the form action using jQuery.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now