Announcement

Collapse
No announcement yet.

Trouble installing Vbulletin 2.2.9

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Trouble installing Vbulletin 2.2.9

    Hello, all. 1st off I'm very new to this, but I'm giving installation a shot. I get to step 3 or so, at which point it is going to create the database and the page reads like this....

    Creating table access



    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.


    ***the "technical staff" is highlighted and is basically [email protected]

    Any help would be greatly appreciated.

  • #2
    In step two, you do get the message "Connecting to Database ..." AND "Successful!!" ?

    Comment


    • #3
      It seems like you already ran the install script once. If there's nothing else in your database that you need, use the option to empty it out.

      If that doesn't fix the problem, view the source of the page when you get the error and post the full error message here. I can almost guarantee it's saying your 'access' table already exists, though.

      Comment


      • #4
        Originally posted by Cary
        It seems like you already ran the install script once. If there's nothing else in your database that you need, use the option to empty it out.

        If that doesn't fix the problem, view the source of the page when you get the error and post the full error message here. I can almost guarantee it's saying your 'access' table already exists, though.
        Thanks for your quick responses!! Yes it says that the database already exists. I tried using the option to empty it out with no luck. Heres the source info. I'll post it all since I'm not sure if you want just the error code or all of the info...

        <html>
        <!--
        --><HTML><HEAD>
        <link rel="stylesheet" href="../cp.css">
        <title>vBulletin 2.2.9 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.9 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: Wednesday 29th of January 2003 04:34:54 PM
        Script: /forums/admin/install.php?step=4
        Referer: http://www.myswebsite.net/forums/adm...all.php?step=3 (Edited by eliasp)
        -->

        </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


        • #5
          Originally posted by xiphoid
          In step two, you do get the message "Connecting to Database ..." AND "Successful!!" ?
          Thanks for your response too. Yes it did. Sorry, I don't know anything yet, but I WILL learn and eventually help others here on this board. That is what I like about vbulletin, you get help/infor then you help others later.

          Comment


          • #6
            Originally posted by eliasp
            <!-- 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: Wednesday 29th of January 2003 04:34:54 PM
            Script: /forums/admin/install.php?step=4
            Referer: http://www.myswebsite.net/forums/adm...all.php?step=3 (Edited by eliasp) -->
            Did you enter a database name in config.php?
            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


            • #7
              Originally posted by Steve Machol
              Did you enter a database name in config.php?
              No. I aslo have tried it with a database name and get a different error. I'm trying different things, but still need help.

              Comment


              • #8
                What's the error you are getting now. Note that you need to enter the correct settings in config.php.
                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


                • #9
                  You need to do this:

                  Get the EXISTING database name, with accompaning databasename - username and password and the HOST to the database server (in most cases localhost). Open up config.php.new and enter those details which your hosting provider should give you. Save the file as config.php and upload it to your server in the admin/ directory overwriting the file there (if any). Then run admin/install.php again and don't enter the details just check if they don't have spelling errors and continue to step to, empty the database and continue with on screen installation instructions. Read carefully. So you don't make stupid errors or anything (I am good at making those when software I new to me). If you have an error, post that exact error here and we can inform you what the error means and how you could likely correct it.

                  Comment


                  • #10
                    Originally posted by Steve Machol
                    What's the error you are getting now. Note that you need to enter the correct settings in config.php.
                    Attempting to attach to database...

                    Connect failed: unexpected error from the database.

                    Error number: 1044

                    Error description: Access denied for user: '@qbert.vosn.net' to database 'anglernet'

                    Please ensure that the database and server is correctly configured and try again.

                    Comment


                    • #11
                      Do I need to create the database first? I though I didn't. I'm thinking of just doing a deleting my whole /forums/ folder and redwriting the files to the server to see if that helps. I've tried adding my database through my website control panel along with usernames and passwords with no luck also. Thanks for your help. I just want to get the ball rolling. I'm gonna re-read the instructions, again,, to see if I'm missing somethiing.

                      Comment


                      • #12
                        Thanks all for your help but I finally figured it out, thanks to you guys. It appears that in my existing database, if my username was say "eliasp" for some reason in my config file I had to put "forumname_eliasp". I was putting just eliasp. Same thing for my database name. You guys might know why, I'm just glad I'm up and running. Now the fun begins!!

                        Comment

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