No announcement yet.

Problems at "access" table creation

  • Filter
  • Time
  • Show
Clear All
new posts

  • Problems at "access" table creation

    Please help!

    I have access to my database I can drop create etc using the php-myadmin software with no problems. It is a specified db address of

    rather than localhost so I set the config to reflect this. Vbulletin install finds and connects to the database no problem then gets stuck with the creation of the first table.

    It seems to create a table called "access" which if i check in php-myadmin does appear as created. However I get the error from vbulletin of...

    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: Saturday 27th of April 2002 03:46:37 PM
    Script: /~a1144349/boards/admin/install.php?step=4

    the fact that is connects to the dastabase and creates (in name at least) the table suggests my config details are correct.

    Suggestions please

  • #2

    I dropped the faulty access table and tried again this time choosing to "clear" the database.

    database cleared... fine
    table access created... fine
    altering table access... there is a problem.

    Database error in vBulletin Installer :

    Invalid SQL: ALTER TABLE access ADD UNIQUE (userid,forumid)
    mysql error: Access denied for user: 'a1144349[email protected]' to database 'a1144349'

    mysql error number: 1044

    Date: Saturday 27th of April 2002 04:22:36 PM
    Script: /~a1144349/boards/admin/install.php?step=4
    Last edited by CyberLeish; Sat 27 Apr '02, 7:33am.


    • #3
      What host are you using?

      If you are using vServers go into the install.php file and change the following line:

      PHP Code:
      $onvservers=0// set this to 1 if you're on Vservers and get disconnected after running an ALTER TABLE command 
      PHP Code:
      $onvservers=1// set this to 1 if you're on Vservers and get disconnected after running an ALTER TABLE command 
      Translations provided by Google.

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


      • #4
        I'm using

        will try the solution you suggest


        • #5
          Great I progressed to have all tables apparently created and altered but at the end of that step it reports...

          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: 1044

          Error description: Access denied for user: '[email protected]' to database 'a1144349'

          I'm going to continue it but not happy having that error in case it comes back to bite me once the boards are running - any suggestions what is going wrong now?


          • #6

            I had a similar error at about the same stage of Install and carried on, did you recieve any advice as to whether this will haunt you later.


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