Announcement

Collapse
No announcement yet.

Why can't I load new version?

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

  • Why can't I load new version?

    I am trying to install the 2.2 version but I am getting this error:

    Creating table access

    Altering access table

    There seems to have been a slight problem with the database.
    Please try again by pressing the refresh button in your browser.


    Why am I getting this error? Any ideas? The data base is an existing 1.1.6 db if that matters.

    thank you

  • #2
    okay these steps

    1. can you please enter your username on the form on this page http://www.vbulletin.com/members/forums.php - to do so you need your customer license info to access the form

    2. on error page, view source code by right clicking page and view code of the page and copy and paste the error message here
    :: 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


    • #3
      here it is

      <html>
      <!--
      --><HTML><HEAD>
      <link rel="stylesheet" href="../cp.css">
      <title>vBulletin 2.2.0 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.0 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: Table 'access' already exists

      mysql error number: 1050

      Date: Monday 05th of November 2001 07:54:19 PM
      Script: /forumnew/admin/install.php3?step=4
      Referer: http://www.dreamsuite.com/forumnew/a...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:">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


      • #4
        well i only only needed the error message
        <!-- 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: Table 'access' already exists

        mysql error number: 1050

        Date: Monday 05th of November 2001 07:54:19 PM
        Script: /forumnew/admin/install.php3?step=4
        Referer: http://www.dreamsuite.com/forumnew/...all.php3?step=3
        -->
        that suggests that you already have a table named access in the database?

        you are meant to run upgradeX.php scripts and not install as that is for new installations only
        :: 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


        • #5
          solution

          1. revert to your 1.1.6 database backup you should of done before upgrading

          2. read http://vbulletin.com/forum/showthrea...threadid=31953

          and follow upgrade instructions for 1.1.x versions which is
          Upgrade instructions:

          >From 1.1.x: and 2.0 betas and release candidates:
          Please email me at [email protected] for full information
          :: 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...
          X