PHP5/SQL5 Upgrades

[whatrevolution]

Originally Posted by Sam

I forgot to say, it is only in the X3 Skin

LOLOLOLOL...

I had a feeling you would say that. I do plan on requesting that upgrade.

[kompreszor]

Originally Posted by SneakyWho_am_i

I'm gator277.hostgator.com

It's nice to know I live in a good neighborhood :-)

I keep a LAMP at home with the latest and greatest updates just so I know in advance if something is going to break and yea.. I'm ready for Apache 2 PHP5 & MySQL5 too

[Wayne Sallee]

How do I do the following?

enable support for the deprecated HTTP_*_VARS arrays which is turned off by default in PHP 5

Wayne Sallee
Wayne@WayneSallee.com

[phpvs]

FWIW, the development environment on my Windows XP PC was set up last year to mirror the PHP and MySQL versions on Hostgator. I upgraded the PC to the current versions of PHP and MySQL yesterday, then tested my custom content management system on the PC.

I found there were two items I needed to add to my PC's php.ini file to suppress some error messages:

allow_call_time_pass_reference = On
date.timezone = 'America/Chicago'

With a dozens of client domains under my reseller account, I REALLY want to know as soon as the upgrade to PHP 5 takes place. I set up an hourly cron job that should send email after the upgrade occurs:

PHP Code:

/**
 * cron job implementation:
 * 
 * /usr/bin/php -q /home/USERNAME/public_html/mfg5util/cron/phpversion.php > /dev/null
 **/

$domain = 'domain.com';

$email = 'user@domain.com';

$name = 'Me';

$tmp = (int) phpversion();

if($tmp >= 5){

   $subj = $domain.' php version '.phpversion();

   $msg = $subj.' :: '.date('r');

   $hdr = "From: \"{$name}\" <{$email}>\r\n";
   $hdr .= "Return-Path: <{$email}>\r\n";
   $hdr .= "Errors-To: <{$email}>\r\n";
   $hdr .= "Reply-To: <{$email}>\r\n";
   $hdr .= "X-MSMail-Priority: Normal\r\n";
   $hdr .= "X-Mailer: PHP version ".phpversion()." on {$domain}\r\n";
   $hdr .= "MIME-Version: 1.0\r\n";
   $hdr .= "Content-type: text/plain; charset=\"utf-8\"\r\n";
   $hdr .= "X-Priority: 3\r\n";
   $hdr .= "X-Sender: <{$email}>";

   $sent = mail($email, $subj, $msg, $hdr);

}

exit; 


[phpvs]

Originally Posted by Wayne Sallee

How do I do the following?
enable support for the deprecated HTTP_*_VARS arrays which is turned off by default in PHP 5

Try this:

PHP Code:

if(isset($_GET)){
   $HTTP_GET_VARS = $_GET;
}
if(isset($_POST)){
    $HTTP_POST_VARS = $_POST;
}
if(isset($_ENV)){
    $HTTP_ENV_VARS = $_ENV;
}
if(isset($_SERVER)){
    $HTTP_SERVER_VARS = $_SERVER;
}
if(isset($_COOKIE)){
    $HTTP_COOKIE_VARS = $_COOKIE;
} 


[Wayne Sallee]

Originally Posted by phpvs

Try this:

PHP Code:

if(isset($_GET)){
   $HTTP_GET_VARS = $_GET;
}
if(isset($_POST)){
    $HTTP_POST_VARS = $_POST;
}
if(isset($_ENV)){
    $HTTP_ENV_VARS = $_ENV;
}
if(isset($_SERVER)){
    $HTTP_SERVER_VARS = $_SERVER;
}
if(isset($_COOKIE)){
    $HTTP_COOKIE_VARS = $_COOKIE;
} 


Thanks.
And that goes into php.ini ?

Wayne Sallee
Wayne@WayneSallee.com

[codesight]

The suggestion given to you would be in your .php files.

I'd suggest doing an extended search/replace to get rid of the deprecated variables.

That would be an easy replace. Obviously save a backup, but it should go just fine.

Those have been deprecated for a LONG... LONG... time, it's time to let them go!

[Wayne Sallee]

Originally Posted by codesight

The suggestion given to you would be in your .php files.

I'd suggest doing an extended search/replace to get rid of the deprecated variables.

That would be an easy replace. Obviously save a backup, but it should go just fine.

Those have been deprecated for a LONG... LONG... time, it's time to let them go!

What would I search for, and what would I replace it with?

Wayne Sallee
Wayne@WayneSallee.com

[codesight]

search for $HTTP_GET_VARS replace with $_GET;

search for $HTTP_POST_VARS replace with $_POST;

search for $HTTP_ENV_VARS replace with $_ENV;

search for $HTTP_SERVER_VARS replace with $_SERVER;

search for $HTTP_COOKIE_VARS replace with $_COOKIE;

[Wayne Sallee]

Originally Posted by codesight

search for $HTTP_GET_VARS replace with $_GET;

search for $HTTP_POST_VARS replace with $_POST;

search for $HTTP_ENV_VARS replace with $_ENV;

search for $HTTP_SERVER_VARS replace with $_SERVER;

search for $HTTP_COOKIE_VARS replace with $_COOKIE;

Thanks! That sounds easy enough.

Wayne Sallee
Wayne@WayneSallee.com

[fuzzfree]

I hope the settings of php.ini will be similar to PHP4 (register long arrays - for oscommerce etc).

Any special php.ini directive that may cause problems?? HG let us know! Thank you.

[Quads]

How do I get upgraded earlier than the March 8th date?

I'm happy to be upgraded anytime sooner, although I'm on a shared server (Gator164), so I may have to wait.

phpBB 3.0
Joomla
Wordpress

Bring on the upgrades!
(I'd be happy to see Apache2 rolled out as well)

[MadCat]

Have anyone from HG stuff ( Especially DaveC ) seen my last post :

http://forums.hostgator.com/showpost...&postcount=213

I'd like to get some responce on that...

[bfdexp]

I know everyone values their time and would appreciate a quick 5 minutes if someone has it. I know this code was written in 2002, PHP4, however can't see why it will not work w/ PHP5 upgrade. It is very simple and little coding. Any suggestions....

http://www.alistapart.com/articles/phpswitch/


In PHP4, it works like a charm. As soon as I switch the server to PHP5, it fails. When you click a link to change the style it does not work or seem to pass to the cookie. Thanks....

[Bkpie]

Seems everytime someone brings up oscommerce it is ignored by Hostgator. This tells me you better opt out use the temporary .htaccess fix and try some of the patches offered. If their was no problem with Osc they would have answered the requests. If you allow them to fix it and you have some 3rd party mods installed those could break or not it seems to be a secret. If you have an osc or oscmax site etc. start reading and learning the patches that are available since unless patched it will not run with register globals off.

[SnapDaddy]

For all of those who are running OSCommerce or flavors of OSCommerce (CRE Loaded, etc.), I found that the "Left Join" in the SQL quires will be an issue with MySQL5.

Here are a few resource links I found to help with OSCommerce and CRE Loaded. Read through them, the info is there. I haven't started this myself yet, but will start later today!

http://www.oscommerce.com/community/contributions,3727/
http://www.totalchoicehosting.com/fo...howtopic=33948
http://forums.creloaded.com/Forums/v...++'on.html
http://forums.creloaded.com/Forums/v...ic/t=9519.html

Hope this helps!

SnapDaddy

[SnapDaddy]

After reviewing the links I suggested, I found that this was the best resource:

http://www.totalchoicehosting.com/fo...howtopic=33948

I applied the fixes to my CRE Loaded 6.15 store. All seems to work now. However, I didn't need to mod the code in the admin/categories.php file, but you may for a OSCommerce store!

SnapDaddy

[fuzzfree]

If you update the Oscommerce installation with every upgrade, you will have no problems - it runs fine on MySQL5, PHP5 and with register_globals off - but if you have added various mods then it's another story.

[whatrevolution]

Originally Posted by Bkpie

Seems everytime someone brings up oscommerce it is ignored by Hostgator.

Originally Posted by Bkpie

If their was no problem with Osc they would have answered the requests.

HostGator staff involved with this project might be busy actually working on the project. Personally, I didn't notice them ignore osCommerce. I noticed them ignore everyone since a few days after this announcement thread began. I don't think they are interested in ninnying over details, and are busy preparing to do this job.

That doesn't mean a few of them don't read this thread and consider its relevant information, though.

Originally Posted by fuzzfree

If you update the Oscommerce installation with every upgrade, you will have no problems - it runs fine on MySQL5, PHP5 and with register_globals off - but if you have added various mods then it's another story.

Yes sir.

This scheduled system upgrade, from announcement, has included all popular cPanel/Fantastico software. OS Commerce is in our Fantastico library, of course, so they've likely included it in their test machines. Their test systems would be nothing other than their usual Shared/Reseller build, installed to intranet-only boxes.

Originally Posted by Quads

How do I get upgraded earlier than the March 8th date?

I'm happy to be upgraded anytime sooner, although I'm on a shared server (Gator164), so I may have to wait.

I don't think it would make sense to HostGator to honor requests for early upgrade of an entire server machine, by one of the few hundred account holders on that machine.

[regentronique]

It as been 17 days without any update from GatorDaveC on the final form of the PHP5/MySql5 upgrade. Now that we have just a week before it is done, it would be quite helpfull to know about any last minute changes BEFORE the upgrade is done!

[kmaw]

Originally Posted by amlink

The phrase "about March 8th" or around "March 8th" doesn't tell me much. I need to know exactly. I'm doing the upgrades now but it may take until the 10th to finish them.

DAVEC said he would post a list of servers each day that he would be doing that evening... once the upgrade starts.

You're on rondo Since the servers are being done in alphabetical order after the shared servers, you'll probably be toward the end of the month.

[whatrevolution]

Originally Posted by regentronique

It as been 17 days without any update from GatorDaveC on the final form of the PHP5/MySql5 upgrade.

I have to agree. This is the week I expect some more information, too.

Originally Posted by amlink

I sure wish that Hostgator would post a list of servers that are going to be upgraded with when each server is going to be upgraded.

The phrase "about March 8th" or around "March 8th" doesn't tell me much.

Originally Posted by kmaw

DAVEC said he would post a list of servers each day that he would be doing that evening... once the upgrade starts.

You're on rondo Since the servers are being done in alphabetical order after the shared servers, you'll probably be toward the end of the month.

Also, DaveC said in this thread that Shared servers will be done in numeric then alphabetical order, at a rate of hopefully 10 servers per day. We can use elementary math to estimate, and reason to know that you will never know "exactly" when your turn is. You can't, because they can't. Can not. Not will not, but can not.

Can not.



When you see "scheduled down time" notices occasionally on some website or another, you can assume that those who posted it are making an educated guess, or are so involved in the reason for down time that they know when they intend to shut down or otherwise potentially break their own server.

[slapshotw]

Originally Posted by amlink

Maybe it would be better to just opt out.

Opting out *will not* affect your site's move to php5/mysql 5. It only determines whether or not hostgator process will look for common php scripts/programs in your account and fix anything known to not work with php5.

There is no dual mysql 4/mysql 5 environment on the server's like php4/php5.

[whatrevolution]

Originally Posted by amlink

I hope I don't sound too stupid here.

You're asking questions... that's step one to not sounding stupid.

Originally Posted by amlink

What is the upgrade process for MYSQL5?

I linked to that a few pages ago in this thread.

Originally Posted by amlink

We are having the software developers of the ecommerce software upgrade the software so it's compatible with MYSQL5.

There is not a LOT of work involved in that. Don't let them convince you that there is. It is, of course, subjective to the complexity of the code, but I wouldn't expect knowledgeable programmers working in their own system to have problems with this.

Originally Posted by amlink

I hostgator going to backup our database during the upgrade to MYSQL5?

Yes.

Originally Posted by amlink

We backup weekly, but I don't know how this is going to help since we have new data entered into the database daily.

It's good practice, but HostGator should be doing a backup of the entire data for each MySQL server before they upgrade it. Otherwise, they will break at least one and have a few hundred customers rip-roaring pissed off. They seem smarter than that.

Originally Posted by amlink

I guess I just don't understand the "BIG PICTURE" here with the upgrading to MYSQL5.

The big picture is simple. MySQL 5 is MySQL 4, with a few years of internal changes and many more improvements. The changes in query syntax and behavior is intentionally limited so that upgrades like this are not torture, they're only challenging to the point of requiring real systems administrators of MySQL servers, and real programmers who pay attention to their textbooks to do them.

Programmers honestly have no excuse for being behind in this move. The market has no patience for the problems, like these, which their inattentiveness brings. Don't encourage them by paying them boatloads now that it's nearly too late. Move on to greener pastures.

Anyone panicking about this, first calm down. Then, if you want free software, change to new free software because your old free software was HACKED YEARS AGO. Then, if you're buying commercial software and paying programmers already, go find a company who isn't ripping you off, leading you by your nose through technology upgrades in this way which would make Microsoft blush.

Moving data from one system's database (eCommerce) to another (OSCommerce) is what programmers do. Like I said, if you're already paying, pay for what you need AND want. Control market demand with your bank account.

Originally Posted by amlink

If we get have our software developers take it to a test site for testing with the new MYSQL5 (which we are going to do), when do we actually put the live data back on line?

When both the HostGator and test servers work.

Originally Posted by amlink

What kind of downtime is there going to be? Maybe it would be better to just opt out.

You can not opt-out of the upgrade. Read OP (opening post).

[Jordanlw]

Well Said WR,
Hope this should clear some issues up with customers.
Although I would recommend opting out since any popular script will be automatically configured to work with PHP5 & MySQl5 and anything popular should already work with MySQL5 & PHP5.
Thats just my opinion.