Cannot install or upgrade:- VServers

[dunefreak]

This is the reason I left VServers. I had not had any problems with them until vB. The vB team should not have to write a special version just because one host decides to run a custom version of a program. If you leave VServers, make sure you tell them exactly why you left. Maybe they could find a workaround for this, after all, they are the ones who have broken from the norm, not vB.

[smacwill]

Originally posted by tubedogg
[ Edit - Between the time I hit "reply" and I finished writing this, smacwill edited his post and changed the meaning entirely. Therefore, this is not directed at him, but I'm leaving it because it's such a beautiful post. ]

I got carried away on the Enter key.... Sorry

I'm also was a developer (Visual Basic.... Yuk) and I know what it's like to try and support everything out there. I was just trying to get the point across that nowhere did it say that vB supported every configuration and I also wanted to point out that it specifically DID state to check with your host about versions first. I also took exception to the statement:

" As this is now a known issue a simple VSERVERS.READ.ME file "

It's not the developers responsibility to read every READ.ME out there, but the users to bring it to the attention to the developers. If the vB Developers wouldn't have responded and said "tuff" then I could see getting ticked off, but, they did and tried one work around and are working on another. That was pretty impressive in my book and has given me more faith in my purchase.

Skip......

[Mike Sullivan]

Does 2.0.1 work?

If it doesn't I'll have a yell at a Vservers rep because, AFAIK, the reason they did this sounds valid, but it really isn't because MySQL does it itself, without modification.

[chris frolic]

hmph. just tried installing 2.0.1 and was given the same problem.

Is there anything I need to change besides

$onvservers=1;

in the install.php ?

I've also tried

$usepconnect = 0;

on both 0 and 1.


thanks for the help trying to deal with this problem

[chris frolic]

has anyone else tried this? any luck?

[chris frolic]

What happened to all the vserver customers? no reponses? Is it working? Mine is still doing the same thing.

[chris frolic]

ok, well I've spent probably 10 hours over the last couple of nights trying to get it to work on vservers with no luck.

the code you added for vservers does indeed work as it should (i added a few echo commands to let me know what was happening as it installed), but for some reason I'm still getting strange errors.

I even added a couple of lines to just before the query command gets run to force the database shut and re-open it again before EVERY SINGLE command and I still get errors.

I was able to get a freshly installed 2.0.1 running with minor kludges, but I've concluded that upgrading from 1.1.6 is just flat out impossible on vservers.

[Mike Sullivan]

Can you email Vservers and ask their reasoning behind making this incompatibility? I think someone posted way back why they did it, but I'm not sure what it was (and I want to see what they say this time).

[chris frolic]

Eureka!

I think I've solved the problem!

I added a short delay after the database is closed and before it is reopened again.

With a few lines of code added, a fresh install worked perfectly and it looks like I've successfully upgraded my test board. (although it did get disconnected two times, and I had to manually enter the mysql commands to finish that step it was on).

I'm going to attempt upgrading my live board now, wish me luck!

If everything goes well I'll post exactly what changes I made.

[chris frolic]

I DID IT!!!!!!

I can't tell you how many hours I spent on this since 2.0 was first released.

As I stated above, there seemed to be a timing issue with database opening/closing. What's even weirder is once I made the changes to the Vserver loop I would still get disconnected at random times during the install, so I ended up forcing the database closed and then reopened (with a delay) for EVERY single query.

You'll have to excuse the kludginess of this fix, since I haven't done any programming myself since taking Pascal in highschool over 10 years ago. but it worked for me, and now I'm running 2.0.1!!! yipeeeee!!! I'm sure someone could find a way to polish this up and do some more tests with it, but I am glad to put this to rest .

Thanks to the vB guys on here for getting the ball rolling with the VServers fix in the first place. This BS is definitely not your fault, but I certainly appreciate you guys not telling me (and other customers) tough ****.


replace this in your install or upgrade1.php:

function doqueries () {
  global $DB_site,$query,$explain,$onvservers;

  while (list($key,$val)=each($query)) {
    echo "<p>$explain[$key]</p>\n";
    echo "<!-- ".htmlspecialchars($val)." -->\n\n";
    flush();
    if ($onvservers==1 and substr($val, 0, 5)=="ALTER") {
      $DB_site->reporterror=0;
    }
    // closing the database
    @mysql_close();
    // here's the delay
    $timewaster=0;
      while ($timewaster<500000) {
        $timewaster=$timewaster+1;
    }
    //  opening the database
      $DB_site->connect();

    $DB_site->query($val);
    if ($onvservers==1 and substr($val, 0, 5)=="ALTER") {
      $DB_site->link_id=0;
// closing the database
      @mysql_close();
// another delay
    $timewaster=0;
      while ($timewaster<500000) {
        $timewaster=$timewaster+1;
    }
// opening the database
      $DB_site->connect();
      $DB_site->reporterror=1;
    }
  }

  unset ($query);
  unset ($explain);
} 

[Mike Sullivan]

Just a quick code suggestion.

I'd change your loops:

    $timewaster=0;
      while ($timewaster<500000) {
        $timewaster=$timewaster+1;
    }

To something more elegant. Like sleep(2);

http://www.php.net/manual/en/function.sleep.php

[buda]

Vservers

I read through all the posts. It seems that version 2.01 solved the Vservers error. But on clean install, after just purchasing this., I recieve ..

Creating table usergroup

Creating table user title

Creating table word

Altering word table

The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.

The errors were:

Error number: 2006

Error description: MySQL server has gone away

Next step -->

What did i miss, why is this not working?

[Dr. Rick]

Vservers errors

Follow the instructions found here:

http://www.vbulletin.com/forum/showthread.php?threadid=22527

while you go through the instructions, you will still get this error....I ignored it

Be sure to edit your mysql commands immediately after you get this error, before moving onto the next step.