Web Hosting Forum | Lunarpages
News: November 3, 2008 - Enter Your URL in to WIN the November Site of the Month Award!
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
November 23, 2008, 12:24:15 AM


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: Mysql 5 issue - my link directories stopped working  (Read 832 times)
lcools
Space Explorer
***
Offline Offline

Posts: 8


« on: March 17, 2007, 09:58:30 AM »

Since Monday's upgrade to msql5 on Aaryn, my three link directories have not been working. I can access and make changes to admin and I'm not getting emails from link partners but when one tries to access the directory via a browser, they get a blank page and are prompted to save or download, or worse, they get an automatic download!

I know this is an aaryn/lunarpages issue because I have the same directories on two other hosts. This is a huge problem...I don't want people forced to download files. I am mysql illiterate...I've posted on the directory forum but it's a tiny forum with no similar issues reported, and the software developer was not expecting issues with mysql 5.

I would really appreciate any help as far as where to start.

One of the directories is at ectory
http://www.earringsagogo.com/links/directory

http://www.earringsagogo.com/links/directory/index.html used to work but it's getting a 404

The file downloaded starts like this:

<?

$runroot = 0;

error_reporting(E_ALL ^ E_NOTICE);

ignore_user_abort(0);

require("settings.php");

import_request_variables("cgp");

if ($mysqlserver) {

   $link = mysql_connect($mysqlserver, $mysqllogin, $mysqlpassword);
   mysql_select_db($mysqldb);

}

$uri = str_replace($_SERVER["SCRIPT_NAME"], "", $_SERVER["REQUEST_URI"]);
$base = $_SERVER["SCRIPT_NAME"];

if ($runroot) $base = "";

$addlink = "<a href=\"$base/add.$pext\">Add Your Site</a>";

$searchbox = '<form action="'.$base.'/search.'.$pext.'" method="post" style="margin: 0px; display: inline"><input type="text" name="query" size="20"> <input type="submit" value="Search"></form>';

function getindex($cat) {


Thanks for any help!
Leila
Logged
Lupine1647
Berserker Poster
*****
Offline Offline

Posts: 10868


« Reply #1 on: March 17, 2007, 10:00:08 AM »

This issue isn't actually related to MySQL but seems like something went wrong with PHP. Please submit a support ticket to our support department at support@lunarpages.com and one of our technicians will look into the issue.

Thanks.
Logged
MrPhil
Quantum Encyclopedia Writer
*****
Offline Offline

Posts: 3483



« Reply #2 on: March 17, 2007, 01:12:53 PM »

This issue isn't actually related to MySQL but seems like something went wrong with PHP.

Could be. While you're waiting for support to get back to you, go in and change all the PHP code starts from the "shortcut tag" <? to the "long form tag" <?php. I've seen shortcut tags cause trouble. If that doesn't do it, we'll look at it some more.
Logged

lcools
Space Explorer
***
Offline Offline

Posts: 8


« Reply #3 on: March 17, 2007, 06:25:08 PM »

(I'm not sure how I ended up in this category?)

Thanks to both of you for your help.
The response from support was about bad coding in the .htaccess file and that I should come here for help...so i don't know if the two are related.

I will try to edit the php...i'm guessing that you mean any files in my link directory folder ending in php. if that's the case, I think i can do that. Hope it helps.
Logged
MrPhil
Quantum Encyclopedia Writer
*****
Offline Offline

Posts: 3483



« Reply #4 on: March 17, 2007, 06:56:08 PM »


When I go to http://www.earringsagogo.com/links/directory I get notified that it's an "application/x-httpd-php", which I've never seen for a PHP file. According to your next URL, "directory" should be an ordinary directory, that contains the index.html file. Something may be very badly screwed up in your system configuration and/or .htaccess file, which is telling the server that "directory" is some sort of file and not a directory. If changing your *.php files from <? to <?php doesn't cure the problem, please post the contents of all your .htaccess files (after scrubbing out account names, passwords, and anything sensitive). Is earringsagogo.com your primary domain or an add-on domain?

By the way, did they upgrade from PHP 4 to PHP 5 at the same time as the MySQL upgrade? PHP 5 has some incompatibilities with PHP 4 code.
Logged

lcools
Space Explorer
***
Offline Offline

Posts: 8


« Reply #5 on: March 18, 2007, 07:01:02 AM »

Thanks Dr. Phil. You are right about the htaccess file.
It said:
<files directory>
ForceType application/x-httpd-php
</files>
and with instruction from support I changed it to
<files directory>
ForceType x-httpd-php
</files>
I don't know much about any of this. With your help I have learned a bit more. Wish I knew why the htaccess files got messed up...my host is still on php 4 btw.
Thank so much for your help. It seems to be okay now.
Leila
Logged
lcools
Space Explorer
***
Offline Offline

Posts: 8


« Reply #6 on: March 18, 2007, 07:02:17 AM »

Oh, do you suggest I update the php codes for good measure, or wait to see if problems arise?
Leila
Logged
MrPhil
Quantum Encyclopedia Writer
*****
Offline Offline

Posts: 3483



« Reply #7 on: March 18, 2007, 07:34:57 AM »

Is directory a file or is it a directory (folder)? In a previous append you were using it as a folder (with index.html in it). In that case, I don't understand why you insist on having this ForceType designation for it. You normally wouldn't have that for a folder.

If things seem to be working now, there's no rush to fix the PHP short tags, though I would get around to doing that at some point just to forestall future problems.
Logged

lcools
Space Explorer
***
Offline Offline

Posts: 8


« Reply #8 on: March 18, 2007, 10:21:24 AM »


It seems to be a file. I can access the directory with www.site.com/links/directory but at Earringsagogo I use index.html within the php cart - otherwise I seem to have session id problems resulting in 404s.
 
Is directory a file or is it a directory (folder)? In a previous append you were using it as a folder (with index.html in it). In that case, I don't understand why you insist on having this ForceType designation for it. You normally wouldn't have that for a folder.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.6 | SMF © 2006-2008, Simple Machines LLC

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM