Vbulletin Installation

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • salzahrani
    New Member
    • Apr 2002
    • 5

    Vbulletin Installation

    Dear all,

    Here are the messages that I have received when I tried to install VB on my web server (www.sspaa.org):

    Step one:
    Welcome to vBulletin Version 2.2.5. Running this script will do a clean install of vBulletin onto your server.

    Click here to continue with the next step -->

    step two:

    Please confirm the details below:
    Database server type: mysql
    Database server hostname / IP address: localhost
    Database username:
    Database password:
    Database name:
    Technical email: [email protected]
    Only continue to the next step if those details are correct. If they are not, please edit your config.php3 file and reupload it. The next step will test database connectivity.
    Next step -->

    step 3:

    Attempting to attach to database...
    Connection succeeded! The database already exists.
    Click here to continue -->

    If you would like to continue and to erase ALL tables from your database, click the button below. This will unconditionally erase the entire contents of your MySQL database, INCLUDING any non-vBulletin data!

    I choosed "click here to continue..."

    Step 4:

    There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.
    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
    We apologise for any inconvenience.

    Need your help
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74167

    #2
    Run it again and view the source code of the page. Post that source code here.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • salzahrani
      New Member
      • Apr 2002
      • 5

      #3
      Here is the Source Code:

      <html>
      <!--
      --><HTML><HEAD>
      <link rel="stylesheet" href="../cp.css">
      <title>vBulletin 2.2.5 Install script</title>
      <script language="JavaScript">
      <!--
      function areyousure() {
      if (confirm("You are about to clear ALL data from your database,\nincluding non-vBulletin data.\n\nAre you SURE?")) {
      if (confirm("You have chosen to clear your ENTIRE MySQL database.\nvBulletin and Jelsoft Enterprises Ltd. can hold no responsibility\nfor any loss of data incurred as a result of performing this action.\n\nDo you agree to these terms?")) {
      return true;
      } else {
      return false;
      }
      } else {
      return false;
      }
      }
      -->
      </script>
      </HEAD>
      <BODY>
      <table width="100%" bgcolor="#3F3849" cellpadding="2" cellspacing="0" border="0"><tr><td>
      <table width="100%" bgcolor="#524A5A" cellpadding="3" cellspacing="0" border="0"><tr>
      <td><a href="http://vbulletin.com/forum" target="_blank"><img src="cp_logo.gif" width="160" height="49" border="0" alt="Click here to visit the vBulletin support forums"></a></td>
      <td width="100%" align="center">
      <p><font size="2" color="#F7DE00"><b>vBulletin 2.2.5 Install Script</b></font></p>
      <p><font size="1" color="#F7DE00"><b>(Note: Please be patient as some parts of this may take some time.)</b></font></p>
      </td></tr></table></td></tr></table>
      <br>
      <P>Attempting to attach to database...</p><p>Connection succeeded! The database already exists.</p><p><a href="install.php3?step=4">Click here to continue --&gt;</a></p><p>&nbsp;</p><p>&nbsp;</p><form action="install.php3" method="get" onSubmit="return areyousure();">
      <input type="hidden" name="step" value="4"><input type="hidden" name="reset" value="1">
      <table cellpadding="10" cellspacing="0" border="0" bgcolor="red" align="center" width="75%"><tr><td>
      <table cellpadding="4" cellspacing="0" border="0" bgcolor="#CCCCCC"><tr><td align="center">
      If you would like to continue <b>and</b> to erase <b>ALL</b> tables from your database, click the button below.
      This will unconditionally erase the entire contents of your MySQL database,
      <b>INCLUDING</b> any non-vBulletin data!
      <p><input type="submit" value="EMPTY YOUR DATABASE" style="background-color:red;color:white;font-weight:bold;font-size:12px"></p>
      </td></tr></table></td></tr></table></form></body><!--
      -->
      </html>

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Wayne meant to post the contents of the page where you got the 'There seems to have been a slight problem with the database' error. There's no such error in the source you posted.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • salzahrani
          New Member
          • Apr 2002
          • 5

          #5
          Sorry about that, Here is the code for the error page:

          <html>
          <!--
          --><HTML><HEAD>
          <link rel="stylesheet" href="../cp.css">
          <title>vBulletin 2.2.5 Install script</title>
          <script language="JavaScript">
          <!--
          function areyousure() {
          if (confirm("You are about to clear ALL data from your database,\nincluding non-vBulletin data.\n\nAre you SURE?")) {
          if (confirm("You have chosen to clear your ENTIRE MySQL database.\nvBulletin and Jelsoft Enterprises Ltd. can hold no responsibility\nfor any loss of data incurred as a result of performing this action.\n\nDo you agree to these terms?")) {
          return true;
          } else {
          return false;
          }
          } else {
          return false;
          }
          }
          -->
          </script>
          </HEAD>
          <BODY>
          <table width="100%" bgcolor="#3F3849" cellpadding="2" cellspacing="0" border="0"><tr><td>
          <table width="100%" bgcolor="#524A5A" cellpadding="3" cellspacing="0" border="0"><tr>
          <td><a href="http://vbulletin.com/forum" target="_blank"><img src="cp_logo.gif" width="160" height="49" border="0" alt="Click here to visit the vBulletin support forums"></a></td>
          <td width="100%" align="center">
          <p><font size="2" color="#F7DE00"><b>vBulletin 2.2.5 Install Script</b></font></p>
          <p><font size="1" color="#F7DE00"><b>(Note: Please be patient as some parts of this may take some time.)</b></font></p>
          </td></tr></table></td></tr></table>
          <br>
          <p>Creating table access</p>
          <!-- CREATE TABLE access (
          userid int(10) unsigned DEFAULT '0' NOT NULL,
          forumid smallint(5) unsigned DEFAULT '0' NOT NULL,
          accessmask smallint(5) unsigned DEFAULT '0' NOT NULL
          ) -->

          <html><head><title> Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

          <!-- Database error in vBulletin Installer :

          Invalid SQL: CREATE TABLE access (
          userid int(10) unsigned DEFAULT '0' NOT NULL,
          forumid smallint(5) unsigned DEFAULT '0' NOT NULL,
          accessmask smallint(5) unsigned DEFAULT '0' NOT NULL
          )
          mysql error: No Database Selected

          mysql error number: 1046

          Date: Friday 19th of April 2002 06:28:27 PM
          Script: /apache/htdocs/upload/admin/install.php3?step=4
          Referer: http://www.sspaa.org/apache/htdocs/u...ll.php3?step=3
          -->

          </table></td></tr></table></form>
          <blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the database.</b><br>
          Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:[email protected]
          ">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>

          Comment

          • George L
            Former vBulletin Support
            • May 2000
            • 32996
            • 3.8.x

            #6
            <!-- Database error in vBulletin Installer :

            Invalid SQL: CREATE TABLE access (
            userid int(10) unsigned DEFAULT '0' NOT NULL,
            forumid smallint(5) unsigned DEFAULT '0' NOT NULL,
            accessmask smallint(5) unsigned DEFAULT '0' NOT NULL
            )
            mysql error: No Database Selected

            mysql error number: 1046

            Date: Friday 19th of April 2002 06:28:27 PM
            Script: /apache/htdocs/upload/admin/install.php3?step=4
            Referer: http://www.sspaa.org/apache/htdocs/...all.php3?step=3
            -->
            did you specify a database name in your config.php ?
            :: Always Back Up Forum Database + Attachments BEFORE upgrading !
            :: Nginx SPDY SSL - World Flags Demo [video results]
            :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

            Comment

            • salzahrani
              New Member
              • Apr 2002
              • 5

              #7
              Yes, a databse name was specified in the config.php file.

              Review the previouse posts and you will see it there.

              Thanks.

              Comment

              • DirectPixel
                Senior Member
                • Jan 2002
                • 4703
                • 3.5.x

                #8
                Maybe try reuploading a brand-new copy of the install.php file?

                It seems the script might be missing the line mysql_select_db.
                :)

                Comment

                • salzahrani
                  New Member
                  • Apr 2002
                  • 5

                  #9
                  I have tried that but still getting the same error.

                  Comment

                  • George L
                    Former vBulletin Support
                    • May 2000
                    • 32996
                    • 3.8.x

                    #10
                    Originally posted by salzahrani
                    I have tried that but still getting the same error.
                    i run step 2 and noticed you dont have any value set for

                    Database username:

                    Database password:

                    Database name: database

                    so i suggest

                    1. you empty your vb database to start all over again the installation

                    2. in config.php set

                    Database username: yourmysqlusername

                    Database password: yourmysqlpassword

                    Database name: yourmysqldatabasename

                    3. now run install.php
                    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                    :: Nginx SPDY SSL - World Flags Demo [video results]
                    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                    Comment

                    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                    Working...