PHP5/SQL5 Upgrades

[newhall]

whatrevolution, can you show some decency and respect when you respond to so many of us on this forum? What I have seen from you in your replies this past week is a lot of insulting and unreasonable comments.

For someone who joined so recently and posts an average of 8 times a day one would think you would show some respect for the rest of the folks on this board who have a just as much experience as you and real businesses and a real life outside this forum.

Just a thought!

[whatrevolution]

Originally Posted by newhall

whatrevolution, can you show some decency and respect when you respond to so many of us on this forum?

Hrm, I meant no disprespect.

It is the thinking man's responsibility to restate the obvious.

[codesight]

Originally Posted by neerav

It should have been:

$HTTP_GET_VARS replace with $_GET

(without the ; at the end of $_GET)

You kept backups, right?

yes, the ; were just my way to say "next operation" and not to include it in the search/replace

a ; tells PHP that it's the end of the line so, with those in there, it's basically killing the script at the first line.

you could do a search/replace on each of those you did it on already to get rid of the semicolon, like

replace $_GET; with $_GET

etc...

[Wayne Sallee]

Originally Posted by neerav

It should have been:

$HTTP_GET_VARS replace with $_GET

(without the ; at the end of $_GET)

You kept backups, right?

I then took a copy of my backup files, and did them again but without the ";", but I got the same error.

Then I deleted the forum files on the server, and reloaded the backup files.

Now I get the following error:

phpBB : Critical Error 
 
Could not connect to the database

Yea I keep backups, except that I forgot to get a recent backup of the database (I still have an older backup) untill after the fact. Then I backed up a recent copy of the database.

I have a lot on my plate right now, and my brain is tired.


Wayne Sallee
Wayne@WayneSallee.com

[Wayne Sallee]

Would this be caused by the replaced files not having the proper permission settings?

Wayne Sallee
Wayne@WayneSallee.com

[neerav]

Or maybe the backup config file had an older database user/pass?

[riostyles]

Hello,
Reseller.
I had a lot of damages with the suexec move. Mostly with conflicts between htaccess and php.ini that we found out after work because unprepared. HG support was trying to help but not efficient enough. Had to hire external help for to correct about 20 of my client's sites.
This cost(ed) my a lot of anger, money and time. This said, I observe that most of my client's developers do not use php.ini or even do not know about. That's certainly not the best way but what can we do.

Coming back to mysql5, when I moved to HG I had almost two days troubles with the DBs because the mysql versions was not exactly the same. I had to set the connection collation to uft8_unicode_ci and the tables to latin_swedish_ci for to bring the outputs strait with accents and exotic signs.
What I read trough this thread let me preview some troubles.

PHP5: Is there a problem with the htaccess or php.ini settings? Already most of the directories are running PHP5.

Is there some sandbox or some task list for to prepare the upgrade.

Perhaps the problems encountered by support with the first servers moved can be shared for some with the corrections.

I just try to avoid to run in the wall and having a support overload with a brutal move of many servers/domains and client's sites down. Isn't managing also planing?

[netviro]

had my sites tested on PHP5 and MySQL5 environment.
I have handcoded sites and fortunately, everything works as expected.
No necessary adjustments or fixes needed. *wheew*

[Lincoln]

What's the latest on the update? There hasn't been any more news for about a week now, I mean zippo.

I've seen ex-wives give more love and respect than this.

[Wayne Sallee]

Could using

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;

have corrupted the database?

Wayne Sallee
Wayne@WayneSallee.com

[slapshotw]

Wayne-- that's just replacing PHP code, it shouldn't be touching a database. Have you tried deleting and recreating your database user, or connecting to that database from another app? Perhaps it's just the connection script that was broken.

[Wayne Sallee]

Ok I figured out what I did.

To make a long story short, I mistakenly modified the backup files, instead of a copy of the backup files.

Because of a number of mods made I don't want to try to start over, but need to restore the modified files.

I tried to reverse the

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;

but when it gets to code such as

$_POST; = $_POST;
$_GET; = $_GET;
$_SERVER; = $_SERVER;
$_COOKIE; = $_COOKIE;
$_ENV; = $_ENV;
$HTTP_POST_FILES = $_FILES;

it causes it to become

$HTTP_POST_VARS = $HTTP_POST_VARS
$HTTP_GET_VARS = $HTTP_GET_VARS
$HTTP_SERVER_VARS = $HTTP_SERVER_VARS
$HTTP_COOKIE_VARS = $HTTP_COOKIE_VARS
$HTTP_ENV_VARS = $HTTP_ENV_VARS
$HTTP_POST_FILES = $_FILES;

I assume that is supposed to be

$_POST; = $HTTP_POST_VARS

I'm wondering what else I will run into trying to reverse the bad code change.

Unfortunately this php upgrade has caught me when my mind is tired from so much other stuff going on at this time.

Wayne Sallee
Wayne@WayneSallee.com

[codesight]

All you need to replace is the $_POST; with $_POST (without the semi-colon)

so, basically, with the first replace you had a variable like $HTTP_POST_VARS['myvariable'] and it turned into $_POST;['myvariable']

once you replace it back, it'll be correct like $_POST['myvariable']

do that for $_GET, $_POST, $_SERVER, $_ENV, $_COOKIE

if you do a find/search first, you can see how many of them there are with the semi colon and look at their placement in the code

replacing the $_POST; shouldn't do anything adverse and there should be no lines of code that end with that, but if it does, that wouldn't be the end of the world either as it'll just complain about an expected semicolon

[vitavee]

Hello,

What about semi dedicated servers?

Are you also going to upgrade them and if yes when ?

If the answer is no, is it possible that I upgrade myself, I need mysql5.


Thanks,
Vita Vee

[SnapDaddy]

According to Matthew F. with HG support, the mini (semi) dedicated servers will NOT be upgraded at this time! This was stated last month, February.

Not sure for how long or if php5 is already on them.

[Denver Dave]

For new reseller hosting accounts, will they have MySQL 5+ ? I noticed that the specs page still says MySQL 4+

http://www.hostgator.com/resellers.shtml

[whatrevolution]

Originally Posted by Denver Dave

For new reseller hosting accounts, will they have MySQL 5+ ? I noticed that the specs page still says MySQL 4+

http://www.hostgator.com/resellers.shtml

Answered your own question.

[Denver Dave]

.... Okay ....

This discussion thread made it sound like the conversion to MySQL 5+ had been completed. Any idea when new reseller accounts can expect MySQL 5+

Be awhile or any day now? Obviously I have an application that requires 5+ or I would not be asking.

Originally Posted by Denver Dave

.... Okay ....

This discussion thread made it sound like the conversion to MySQL 5+ had been completed. Any idea when new reseller accounts can expect MySQL 5+

Be awhile or any day now? Obviously I have an application that requires 5+ or I would not be asking.

Email sales@hostgator.com and they can give you the answer.

[busy]

I went to chat support to ask about the upgrade process. Here's what I was told.

Justyn: They are doing the servers in order, and reseller servers will be after shared. Its going to be a while, my guess a month or so

The server I'm on is vanquish.websitewelcome.com so yours may come sooner of course. But I'm thinking "vanquish" is pretty close to the end of the alphabet so perhaps I'll be one of the last ones.

Anyways, I thought some of you would appreciate the information.

[Hadoken]

Hello,
Can we have an update of which server has been upgraded to php5 ? Please.

Thank you very much,
Best regards,

Hadoken

[regentronique]

Originally Posted by GatorDaveC

We will be using the latest version of 5.2.x, and yes when we are upgrading the servers. I'll post which servers are going to be upgraded each night. It will be around 10 servers a night or so at first.

Nothing was writen for more than 2 weeks, have you stopped to upgrade the servers?

[whatrevolution]

Originally Posted by regentronique

Nothing was writen for more than 2 weeks, have you stopped to upgrade the servers?

¯¯¯¯¯¯¯¯

[vaggelis]

no news ... good news

[whatrevolution]

Originally Posted by vaggelis

no news ... good news

I'd agree, except in light of what regentronique quoted.