Announcement

Collapse
No announcement yet.

Help - Creating access table error

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

  • Help - Creating access table error

    Hi

    I have been trying to install my forum and i get the good old:

    Step 3) Creating Tables (Step 3 of 13)
    Step 3) Creating Tables

    Creating access table


    *

    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.
    here is the source code

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <title>vBulletin 3.0 Install Script Step 3) Creating Tables</title>
    <link rel="stylesheet" href="../cpstyles/vBulletin_3_Default/controlpanel.css" />
    <style type="text/css">
    #all {
    margin: 10px;
    }
    #all p, #all td, #all li, #all div {
    font-size: 11px;
    font-family: verdana, arial, helvetica, sans-serif;
    }
    </style>
    </head>
    <body style="margin:0px">
    <table cellpadding="4" cellspacing="0" border="0" width="100%" class="navbody" style="borderutset 2px">
    <tr>
    <td width="160"><img src="../cpstyles/vBulletin_3_Default/cp_logo.gif" alt="" title="vBulletin 3 &copy;2000 - 2004 Jelsoft Enterprises Ltd." /></td>
    <td style="padding-left:100px">
    <b>vBulletin 3.0 Install Script</b><br />
    (Please be patient as some parts may take some time)<br />
    <br />
    <b style="font-size:10pt;">Step 3) Creating Tables</b> (Step 3 of 13)</td>
    </tr>
    </table>
    <div id="all">
    <p style="font-size:10pt;"><b><u>Step 3) Creating Tables</u></b></p>
    <ul><li>Creating access table</li>
    <!--
    CREATE TABLE access (
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY userid (userid, forumid)
    )
    -->

    <html><head><title> Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
    <body></table></td></tr></table></form>
    <blockquote><p class="error">&nbsp;</p><p class="error"><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><p class="error">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 class="error">We apologise for any inconvenience.</p></blockquote>

    <!--
    Database error in vBulletin :

    Invalid SQL:
    CREATE TABLE access (
    userid INT UNSIGNED NOT NULL DEFAULT '0',
    forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY userid (userid, forumid)
    )

    mysql error: Table 'access' already exists

    mysql error number: 1050

    Date: Sunday 03rd of April 2005 09:07:59 PM
    Script: http://mbcbabes.com/forum/install/install.php?step=3
    Referer: http://mbcbabes.com/forum/install/install.php?step=2
    IP Address: 210.23.136.233
    -->

    </body></html>


    I have done everything right but i don't know what else to do. Any help will be appreciated.

    Cheers
    Diego

  • #2
    You can't 'install' and 'old' forum. The install script is designed to setup a brand new forum. Since you already have a database, it obviously gives that error.

    What exactly are you trying to do?
    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


    • #3
      Hi

      I havent installed an old forum..its the first time i am trying to install the forum. I have tried many times in the past couple of days to install it but i keep that error..even the first time i went through the install it gave me that error.

      Do i have to try a new database? As that one was only made last week..i am a tads confused as it seems like an easy procidure but it doesnt go past step 3.

      Thank You.

      Diego

      Comment


      • #4
        You are trying to install over an existing database. If you are sure this is a mistake, then choose the option to empty that database early in the installation problem.
        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


        • #5
          Hi

          Thanks for that I knew it would be something along those lines. Thank you heaps for the help. It all works now.

          Kind Regards

          Diego

          Comment

          Related Topics

          Collapse

          Working...
          X